Symptom
- Navigating to a hierarchy level by clicking chart members displays data correctly.
- Selecting the same hierarchy level via Action Menu → Drill → Select Level 6 returns $0 values.
- In some cases, the drill menu presents only up to Level 5 even when deeper levels exist.
Environment
SAP Analytics Cloud
Reproducing the Issue
- Open a story with a chart that uses a multi-level hierarchy.
- From the chart Action Menu, choose Drill, then Select Level 5 (or deeper).
- Observe that the chart returns $0 values at the selected level.
- Instead, drill down by clicking chart members to reach the same level.
- Observe that the chart displays data correctly when drilled by clicking.
Cause
- As per the SAP Help Guide, this is by-design behavior.
- In some scenarios, SAP Analytics Cloud cannot determine the complete hierarchy depth when retrieving data.
- Therefore, the Drill menu is designed to display up to Level 5, and deeper hierarchy levels are intended to be accessed through further hierarchy expansion rather than direct level selection.
Resolution
For hierarchies containing more than five levels:
- Use the Drill menu to navigate to Level 5.
- Continue navigating deeper levels by manually expanding the remaining hierarchy nodes within the chart or table.
- Alternatively, use interactive drill-down directly on hierarchy members where applicable.
Reference:
SAP Help Portal - Work with Hierarchies in Tables and Charts
https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/28c534f0c97c4a609e4644d512d7eb0b.html
Relevant Help Guide Statement: "If you have more than five levels, you can use the drill menu to expand your hierarchy to Level 5 and then use the expand arrows to expand the remaining levels."
See Also
- Work with Hierarchies in Charts
- Expanding and Drilling Hierarchy Levels (SAP BW specifics)
- About Chart Action Menu Options
- Drill depth limitations and recommended workflow
- Note 3425381 - InA: Virtual root node support for level offset
- Note 3443291 - InA: hierarchy node level offset check and time series support
- How to collect a HAR file and Console Log file in SAP Analytics Cloud (2280022)
Keywords
SAP Analytics Cloud, SAC, hierarchy, action menu, drill, select level, level 5, level 6, zero values, marimekko, include parent levels, deep hierarchy, chart drilling, parent context, hierarchy depth , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem
SAP Knowledge Base Article - Public