Skip to Content
Author's profile photo Tammy Powlas

SAP BusinessObjects Analysis Office 1.3 – Updates for SAP Hana Support

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:

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

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Tammy,

      Good post.

      Is there any news about support BO Universes in A-Office?

      It will be really usefull thing,  because now we haven't any Excell base client for BO BI.

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Mikhail - I have not heard any specifics re: A-Office against universes

      Live Office is an Excel based add-in that can go against universes - have you tried that?


      Author's profile photo Former Member
      Former Member

      Life-Office is not bad. Pretty and integrate with MS Office.

      But Life-Office work with BO BI by web services and doesn't support BW and HANA Sources. And LIfe-Office work only with unv (old-type) universes.

      Seems to be SAP doesn't want to invest to LIfe-Office.

      So it's very cool if A-Office can support BO BI universes - that's new possibilities for us.

      Author's profile photo Former Member
      Former Member

      Create idea about this

      Please vote anyone who agree,

      Author's profile photo Former Member
      Former Member

      Hi Tammy,

      Thanks for the post.It is really useful to satisfy our client requirement.

      Have couple of queries related to Heirachies in HANA.

      1. Is there any way that we can consume the heirarchy in BO universe which is created in Attribute view (by using new level heirarchy option) ? It will be great, if we can get the heirarchy data into webi through universe.

      2.I am able to see the Hierarchies tab in Attribute view along with Datafoundation tab. But I am getting only the data foundation tab in Attribute view.FYI.. we are using the version

      Version: 1.0.35

      Build id: 201207231758 (365038).

      It would be great help to get these queries resolved.

      Thanks in advance.



      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Jana - thank you for commenting

      I am not using Hana right now so I recommend you post these as questions on the discussion forum.



      Author's profile photo Former Member
      Former Member

      Hi, Tammy.

      I am studying on how to connect to HANA views at AO, and I have some questions needing your help after reading your post.

      I have two environments (one for client and one for our own company), in one environment, we are using AO1.4, and the other as AO2.0.

      For AO2.0, I read a post about connecting by platform (HANA Http), but the configuration (changes at server) is not available before I ask Admin team for help. So I changed to testing on AO1.4.

      For AO1.4, I followed the steps according to this post.I succeeded to connect the HANA since I logged on successfully and gained the folders. However I failed to open the views and failed to display the report. The message is as the second pic below.



      Do you know what's wrong with it, or do you have any other suggestions or options?


      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hello Chong - please create a discussion thread for this after you have searched.  I am not using HANA today myself.