SAP Knowledge Base Article - Public

2794699 - Unable to see more than 5 hierarchy levels in "Set Drillstate" dialog of SAP Analytics Cloud (SAC)

Symptom

Unable to see more than 5 drill levels in a hierarchy in the "Set Drillstate" dialog based on BW Live or S/4HANA Live connections in SAP Analytics Cloud (SAC)

  • When drilling down on a dimension based on a hierarchy with 5 or more drill levels, only 5 drill levels are shown in the "Set Drillstate" dialog

Environment

  • SAP Analytics Cloud 2019.8.9, 2020.8.15

Reproducing the Issue

  1. Log in to SAP Analytics Cloud
  2. Create a story using a BW Live or S/4HANA Live Data Connection with a hierarchy that contains 5+ drill levels
  3. Attempt to drill down on a dimension
  4. Observe that only 5 drill levels are shown in the "Set Drillstate" dialog

Drillstate.png

Cause

This issue is currently behavior by design. Currently the maximum amount of drill levels that can be viewed through "Set Drillstate" dialog from a BW Live or S/4HANA Live data source is 5.

For further reference, please see the SAP Analytics Cloud Support Matrix for Live Connectivity to SAP NetWeaver BW

Resolution

The drill level up to 5 is currently by design. User can directly go to any level in hierarchy between 1 and 5. However, if the hierarchy is defined deeper than 5 levels, you can always click in the table to drill down further. This behavior is the same for BW and S/4HANA data sources.

The "Set Drillstate" option/dialog represents an easy way to drill directly to a lower level instead of doing step by step drill. However, it is not a limitation, and you can use deep hierarchies with >5 levels by clicking in the table to drill down further.

See Also

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

Keywords

Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, drilldown, drill, down, hierarchy, drill state, drillstate, deep hierarchy, hierarchy with more than 5 levels, cannot see more than 5 levels in "Set Drillstate" dialog, set drillstate , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predicitive , Problem

Product

SAP Analytics Cloud 1.0