Skip to Content

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

/wp-content/uploads/2013/03/1revfig_200046.png

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.

/wp-content/uploads/2013/03/2fig_200029.png

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.

/wp-content/uploads/2013/03/3afig_200036.png

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.

/wp-content/uploads/2013/03/4afig_200037.png

Figure 4: Source: SAP

Figure 4 shows the new methodology to build semantic layer.

/wp-content/uploads/2013/03/5afig_200038.png

Figure 5: Source: SAP

Figure 5 shows the new Hana business layer.

/wp-content/uploads/2013/03/6fig_200039.png

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.

/wp-content/uploads/2013/03/7fig_200040.png

Figure 7: Source: SAP

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

/wp-content/uploads/2013/03/8fig_200041.png

Figure 8: Source: SAP

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

/wp-content/uploads/2013/03/9fig_200042.png

Figure 9: Source: SAP

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

/wp-content/uploads/2013/03/10fig_200043.png

Figure 10: Source: SAP

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

/wp-content/uploads/2013/03/11fig_200044.png

Figure 11: Source: SAP

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

/wp-content/uploads/2013/03/12fig_200045.png

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.

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply