Does Analysis for MS office HTTP connection supports HANA Hierarchies?

[former_member428197]

I defined level hierarchy in HANA Calc view.

In the Analysis office i created http connection to the HANA system.

I dont see the hierarchies in analysis when i opened the calc view which has hierarchy.

Does the HTTP connection supports HANA hierarchies.If so, are there any settings to show the HANA hierarchies in the excel.

We are on

HANA Vesrion 2.0 SP4 REV 48

Analysis for MS office 2.8 SP7

Thanks Srini

[shivakrishnaj]

Hi Srini,
Please check AllowleavesviewHierarchicalSelector is unchecked.
Make it checked & recheck your issue.
To enable setting
File-->Analysis--> Customize Analysis-->Technical configuration

Thanks & Regards,
Shiva

[former_member428197]

Thanks Shiva, I check the AllowleavesviewHierarchicalSelector in analysis and it is checked.

What can be the issue, why i'm not seeing the hierarchies in MS office analysis.