Showing results for 
Search instead for 
Did you mean: 

Hierarchy which is expandable and collapsable is not reflecting when saved as workbook.

Former Member
0 Kudos

Hi All

I know Webi, and I'm new to this tool. Today i created a Analysis workbook with Hierarchy(parent,child nodes) at Row Section and Month at Column Section. And i'm able to expand and collapse at design time.

I saved the Excel and closed it. When i open again it is not having Collapse and Expand feature on Parent Nodes of Hierarchy.  (Filter By Memeber.. is also not available after saving it.)

Please help me.


Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Parthiban,

Couple of things you should check.

  • If you double click on an excel file that was created in AO it will only open excel and not load the addon. This can be changed if you look in the manual
  • If you open AO first and then open your file refresh your query. This behavior can also be changed on the components tab of the work book

Answers (0)