Skip to Content
Author's profile photo Tammy Powlas

What is New with Web Intelligence BI4.1 – Part 3 – Data Source Enhancements

Part 1 is here.  Part 2 covers core capabilities

Gregory Botticchio and Sylvain Riboud provided this ASUG webcast

The usual legal disclaimer applies that planned improvements are subject to change.


Developer Support

Core Capabilities Enhancements

Data Source Support Enhancements

Desktop Intelligence to Web Intelligence

The first part summarizes core capabilities and then moves to Data Source Enhancements


Figure 1: Source: SAP

Figure 1 shows the globalization enhancements including right to left support for the Middle East market.


Figure 2: Source: SAP

Figure 2 shows a summary of core capability enhancements

Data Source Support Enhancements


Figure 3: Source: SAP

Figure 3 shows continued investment for BW and Hana and ERP universes


Figure 4: Source: SAP

Figure 4 reviews the enhancements with the hierarchy node variable

BI4.1 with BW730 will have additional enhancements  as there is a new API in BW730 and provides better support for BEx queries


Figure 5, Source: SAP

Figure 5 shows the hierarchy node variable in action going to level 3


Figure 6: Source: SAP

Figure 6 shows the member selection based on variables.


Figure 7: Source: SAP

Figure 7 shows how the level selection works and helps performance.


Figure 8: Source: SAP

Mandatory variable selection works


Figure 9: Source: SAP

Query stripping is in BI4.1 is available for relational universes including HANA; before only available OLAP datasources such as BEx queries

First you need to activate it at the universe level in the Information Design Tool.


Figure 10: Source: SAP

Figure 10 shows activating query stripping at the document level and query level.


Figure 11: Source: SAP

BI4.1 covers ERP universe optional prompts


Part 4 will cover Desktop Intelligence to Web Intelligence, stability improvements and some question & answer.

Gregory provided the following links during the webcast:

Customer Connect for Web Intelligence

Register for BI4.1 Hands on Training – includes Web Intelligence (ASUG Annual Conference Pre-Conference Session)

Also, somewhat related, tomorrow ASUG has a webcast on What is New in the Semantic Layer BI4.1

BI4.1 covers ERP universe optional prompts

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Aditya Tanak
      Aditya Tanak

      Nice information . . . hope it doesn't have as many bugs as there are in 4.0 😥

      Author's profile photo Former Member
      Former Member

      Thanks for this. Do you know if the issues that have been experienced when working with XI3.1 over SQL Server 2008 via OLEDB have been sorted out?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Mark - thank you for reading and commenting.

      I haven't been on XI 3.1 for a while so please post this question in the discussion area.


      Author's profile photo Former Member
      Former Member

      Sorry Tammy, let me rephrase the question. In XI3.1 there were problems connecting to a SQL Server 2008 database via OLEDB when using Windows AD authentication. Is this still the case on BO4.1 or has that bug been squashed?



      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hello Mark - please post this as a discussion question in the discussion space here[thread]

      Thank you