Skip to Content
avatar image
Former Member

Hierarchy Not working for Analysis for Office

Hi All,

For the past 2 hours i have been struggling to figure out how hierarchy is working for one HANA view and the same hierarchy is not working with another view in Analysis for Office.

For Ex:- Hierarchy is working for Cost view in AFO but the same Hierarchy is not working for the sales view in AFO.

Current Working Environment:-

Analysis for Office :- 2.1 Version.

Connection Type :- HANA HTTP Connection.

HANA:- 1.0 SP9

I`m attaching the screen shot for the following Error.

Please advise accordingly.

Thanks and Regards

Karthik Kumar C V

Hierarchy AFO.JPG (40.0 kB)
Hierarchy AFO.JPG (40.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 28, 2015 at 10:48 AM

    Could you try this again with Analysis Office SP2?

    Add comment
    10|10000 characters needed characters exceeded

    • All,

      to add what we have seen:

      - The issue is in creating a virtual hierarchy, but rather a drill down by another characteristic

      - the "virtual hierarchy" issue is not ALWAYS an issue

      - Some characteristics allow adding drill down to hierarchy, others don't

      - Changing the display options for the offending characteristic (text/key/both) sometimes fixes the issue (we need both, so still an issue for us)

      We are going to to submit a note to SAP if the latest patch doesn't resolve



  • Nov 10, 2015 at 11:07 PM


    Any update on this?  I am receiving the same error with the same versions.  One thing I was able to do was run within MDX version in Microsoft Excel independently but not within Analysis for Office. Let me know and thanks.

    Tim Korba

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2016 at 03:03 PM

    Yes, I would also appreciate an update if possible. I'm encountering the same "Caught Exception" message as posted above. Upgrading to Analysis for Office 2.2.4 did not help.

    Add comment
    10|10000 characters needed characters exceeded