Skip to Content

Are level based hierarchies defined in HANA (SP12) supported in Analysis office 2.4?

Hello All,

Request your help to let me know if anyone tried using Level based hierarchies defined in HANA SP12 and if it is working in Analysis office 2.4?

Regards,
Krishna Tangudu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 25, 2017 at 07:00 AM

    Hi Krishna,

    Yes, that's possible.

    Our hana is at:

    1.00.122.08.1490178281 (fa/hana1sp12)

    and Office analysis is at 2.4 (2.4.2.67902)

    We had some issues with Analysis with a lower Hana version. You need at last the above mentioned version.

    We run both, level based and as well parent - child hierarchies.

    regards

    Greg

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks for the update. We have the same version and office analysis is at 2.4
      I created a level based hierarchy in HANA but the model when opened in Analysis office is not showing the hierarchy whereas it is showing up in Excel connected via MDX to HANA.

      Did you face this situation earlier?

      Regards,
      Krishna Tangudu

  • avatar image
    Former Member
    Aug 25, 2017 at 04:39 PM

    Hi Krishna,

    SAP has introduced a host of new functionalities primarily focused on improving the planning and consolidation experience using Analysis for Office solution.

    Yes it will work for office 2.4 and you can check this blog. This might help you https://blogs.sap.com/2016/12/01/analysis-for-office-2.4-enhancements-special-focus-on-planning-and-consolidation/

    Add comment
    10|10000 characters needed characters exceeded