Skip to Content

Analysis Office Excel Issue with HANA Calculation View(with Hierarchy)

Hello Experts,

I want to consume HANA Hierarchy in BOBJ Reporting tools. I am unbale to find the Hierachy in Analysis Office 2.2 and 2.3 version.

Environment: SAP HANA SP10, Revision 102.4 -> HANA Calculation View with Hierarchy

SAP Analysis Office Excel 2.2 SP03 or 2.3

Steps:

I have created a simple HANA Calculation view with a Hierarchy(parent child/level hierarchy). I am trying to consume this

HANA view with Hierarchy in BOBJ Reporting tools. I am able to see the Hierarchy in Excel MDX and Lumira Reporting tool .

However in Analysis Office, it is not showing. Even the Hierarchy button is also grayed out.

Note: i have checked the SAP analysis Office official user guide version 2.2 and version 2.3 , but there is no mention of

any such configuration steps. Please help.

Regards,

Anuj

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jun 10, 2016 at 11:26 AM

    Please review the last reply on this thread https://scn.sap.com/thread/3818685 to see if it helps you

    I also recommend you review the SAP notes - here is one of interest: https://launchpad.support.sap.com/#/notes/2312856/E

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2016 at 03:17 PM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.