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

[former_member182302]

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

[Former Member]

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-...

[former_member256353]

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

[former_member182302]

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