SAP Knowledge Base Article - Public

3136817 - Hierarchies Not Displaying Correctly in the Excel Add-In


When opening a report using the Excel Add-In, you cannot expand and collapse all hierarchies. You can just expand and collapse hierarchies by 8 levels, but the report should display more.


  • SAP Cloud for Customer
  • SAP Business ByDesign 

Reproducing the Issue

  1. Go to Business Analytics work center.
  2. Go to Design Reports work center view.
  3. Search and open any report.
  4. You can see it has 10 levels of hierarchy to be expanded or collapsed. 
  1. Go to Microsoft Excel.
  2. Go to Excel Add-In tab.
  3. Insert the report.
  4. You can just expand and collapse hierarchies by 8 levels. 


The analytical Excel Plug-In reuses the existing grouping functionality of the Microsoft Excel. As the Microsoft Excel only supports 8 levels of hierarchy, the Excel Add-In also supports only 8 levels.


If you need to use collapse and expand options for more than 8 levels, we recommend you to access the report directly within your system. When using Excel Add-In, it will just allow you to collapse and expand by 8 levels of hierarchy.

See Also

For SAP Cloud for Customer: Work with Reports and Plans in Microsoft Excel

For SAP Business ByDesign: Working with Reports and Plans in Microsoft Excel


collapse, excel hierarchy, hierarchy report, excel add in, expand excel, hierarchy level, report hierarchy, hierarchy excel , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To


SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions