Auto expand hierarchy in AO report

[hardikaggarwal]

There is a report which has account hierarchy. The requirement is when we open the report in Analysis for Office, some nodes must expand to level 2, some to level 4 etc. automatically. Is there any inbuilt solution/VBA Solution/Enhancement for this problem?
We are using BW/4HANA.

[john_hawk]

Hi Hardik,

I think you are using the wrong tool. Check the display settings of the InfoObject upon which the hierarchy is built. In addition to displaying the hierarchy, you should also be able to select the level displayed..

John Hawk