Skip to Content
Author's profile photo Tammy Powlas

What is new in the Semantic Layer and the Information Design Tool BI4.1 – Part 3 – SAP Hana

This is part 3 of an ASUG webcast covering what is new with the Semantic Layer BI4.1 and the Information Design Tool. 

Pierpaolo Vezzosi provided this ASUG webcast earlier this month.  Part 1 is here

Part 2 is here


Figure 1: Source: SAP

Figure 1 shows SAP Hana BI4 access.  BI4 can access SAP Hana, creating an SQL universe; you had to write a SQL workaround to access Hana variables.


Figure 2: Source: SAP

Figure 2 shows direct dimensional access to Hana views in BI4.1 without the need for a universe (Crystal for Enterprise, Web Intelligence after 4.1 SP1), using MDX, taking advantage of multi-dimensional functionality of Hana.


Figure 3: Source: SAP

Figure 3 shows the direct dimensional access features without the universe as you do your modeling in the SAP Hana Studio.  It shows the query panel with the dimensional selection.


Figure 4: Source: SAP

Figure 4 shows the new methodology to build semantic layer.


Figure 5: Source: SAP

Figure 5 shows the new Hana business layer.


Figure 6: Source: SAP

Figure 6 shows the ability to migrate a universe from a third party to Hana system  – which parts are manual versus automated.


Figure 7: Source: SAP

Figure 7 shows the button in the Information Design Tool called “migrate to Hana”


Figure 8: Source: SAP

Figure 8 shows how the system analyzes the universe and the changes made to Hana


Figure 9: Source: SAP

Figure 9 shows the ability to migrate the reports from the old universe.


Figure 10: Source: SAP

Figure 10 shows only the information models to be used for consumption


Figure 11: Source: SAP

Figure 11 shows the variables are detected in the viewed and exposed as prompts in the query.


Figure 12: Source: SAP

Figure 12 shows that you might want to hide some columns in Hana and also hide in IDT.

Part 5 will cover SDK, question & answer, and more.

Meet Pierpaolo in person at ASUG Annual Conference where he will hold a session on the ASUG Semantic Layer Influence Council.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hello - I encourage you to create a new discussion for this question

      Author's profile photo Taro Ozaki
      Taro Ozaki

      OK. deleted my comment.