Skip to Content

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:

/wp-content/uploads/2012/07/1fig_122373.png

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

/wp-content/uploads/2012/07/2fig_122374.png

Figure 2: Source: SAP

Figure 2 shows the steps to define the SAP Hana connection in BI4, using the IDT

/wp-content/uploads/2012/07/3fig_122378.png

Figure 3: Source: SAP

Figures 3-5 shows connecting via the Local ODBC driver

/wp-content/uploads/2012/07/4fig_122379.png

Figure 4: Source: SAP

/wp-content/uploads/2012/07/5fig_122380.png

Figure 5: Source: SAP

SAP Analysis Office started supporting Hana in version 1.2 and could access analytic and calculation views

/wp-content/uploads/2012/07/6fig_122381.png

Figure 6: Source: SAP

New in Analysis Office 1.3 is the support of hierarchies, prompts, and password change with SAP Hana.

/wp-content/uploads/2012/07/7fig_122382.png

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.

/wp-content/uploads/2012/07/8fig_122383.png

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.

/wp-content/uploads/2012/07/9fig_122384.png

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

/wp-content/uploads/2012/07/10fig_122385.png

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

To report this post you need to login first.

8 Comments

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

  1. Mikhail Budilov

    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.

    (0) 
    1. Tammy Powlas 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?

      Tammy

      (0) 
      1. Mikhail Budilov

        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.

        (0) 
  2. Janakiraman V

    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.

    Jana

     

    (0) 
    1. Tammy Powlas 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.

      Thanks,

      Tammy

      (0) 
  3. Chong Chen

    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.

    SCN2.PNG

    SCN.PNG

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

    Thanks.

    (0) 

Leave a Reply