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.