SAP Knowledge Base Article - Public

3838626 - SAC - Datasphere Live Connection: Action Menu Drill to Hierarchy Levels Beyond Level 5 Returns $0 Values While Chart Drill-Down Works Correctly

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

  1. Open a story with a chart that uses a multi-level hierarchy.
  2. From the chart Action Menu, choose Drill, then Select Level 5 (or deeper).
  3. Observe that the chart returns $0 values at the selected level.
  4. Instead, drill down by clicking chart members to reach the same level.
  5. 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:

  1. Use the Drill menu to navigate to Level 5.
  2. Continue navigating deeper levels by manually expanding the remaining hierarchy nodes within the chart or table.
  3. 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

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

Product

SAP Analytics Cloud 1.0