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

[TammyPowlas]

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.