At last week’s ASUG webcast on SAP BusinessObjects Analysis Office 1.3 (now in ramp-up) updates for SAP Hana support with Analysis Office 1.3 were reviewed. Since then I have received several questions so a summary of this part of the webcast is reviewed below:
Figure 1: Source: SAP
Figure 1 shows you can use the BI Platform from BusinessObjects or use the ODBC driver
Procedures are different with 64 bit – is the Office version 32 bit or 64 bit and then you have to choose the right version of the ODBC driver
Figure 2: Source: SAP
Figure 2 shows the steps to define the SAP Hana connection in BI4, using the IDT
Figure 3: Source: SAP
Figures 3-5 shows connecting via the Local ODBC driver
Figure 4: Source: SAP
Figure 5: Source: SAP
SAP Analysis Office started supporting Hana in version 1.2 and could access analytic and calculation views
Figure 6: Source: SAP
New in Analysis Office 1.3 is the support of hierarchies, prompts, and password change with SAP Hana.
Figure 7: Source: SAP
Figure 7 shows variables in SAP Hana and the properties you specify, that are reflected in Analysis Office – e.g. mandatory or multiple variables.
Figure 8: Source: SAP
Figure 8 shows how the SAP Hana settings impact Analysis Office prompts screen
Ranges, single value, interval, multiple entries are shown above in Figure 8.
Figure 9: Source: SAP
Figure 9 shows hierarchies in SAP Hana
You can open the Analytic view; opening the logical view allows you to select the hierarchies
Figure 10: Source: SAP
Hana supports 2 types of hierarchies. One is the Level hierarchy where you specify several characteristics in Hana and a specific order – such as Continent, Country, City ID in Figure 10.
Another type is the parent child – one dimension ID and for each ID you have a Parent ID – shown in the right of Figure 10 where manager ID is the parent.
SAP Help for Analysis Office 1.3:
See the SAP Hana Development Center for access to SAP Hana Developer licenses: