Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
TammyPowlas
Active Contributor

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.

Related Links:

SAP Help for Analysis Office 1.3:

http://help.sap.com/boaoffice13

See the SAP Hana Development Center for access to SAP Hana Developer licenses:

http://scn.sap.com/community/developer-center/hana

8 Comments
Labels in this area