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:
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.
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
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.
Create idea about this
https://cw.sdn.sap.com/cw/ideas/12207
Please vote anyone who agree,
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
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
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?
Thanks.
Hello Chong – please create a discussion thread for this after you have searched. I am not using HANA today myself.
Tammy