SAP Knowledge Base Article - Public

3296404 - Dimension hierarchy cannot be expanded in SAP Analytics Cloud (SAC)

Symptom

  • Dimension cannot be displayed in hierarchical view when using Chart widget.
  • When clicking on "Add dimension" for instance in the Builder panel, the dimension does not have any expand option to see the lower levels.
  • The same can be displayed properly when using Table widget.

Environment

  • SAP Analytics Cloud (Enterprise) 2022.21.17
  • SAP DataSphere with Live Data Connection

Reproducing the Issue

  1. Logon to SAC.
  2. Open or create a new story based DWC dataset.
  3. Add a Chart and a Table widget to the story. 
  4. Notice that when you click on "Add dimension" for the Chart widget, the dimension (hierarchy) cannot be expanded to show the other levels. 
  5. The same works fine for the Table widget.

Cause

This is a product limitation

Resolution

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

association, hierarchy, design, expand, collapse, level, not, appear, display , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Datasphere all versions