SAP Knowledge Base Article - Public

3778019 - Consolidation Unit Elimination related leaf values not showing as part of Hierarchy

Symptom

A hierarchy leaf disappears when the hierarchy is active for Dimension 'Consolidation unit elimination member' (created from S/4 HANA CDS view I_CNSLDTNUNITFORELIMHIERNODE)

When it is set to Flat Presentation all the leaves appear.

Environment

  • SAP Datasphere

Reproducing the Issue

  1. Open Analytical preview.
  2. Add 'Consolidation unit elimination member' to rows
  3. Click on (...)  > Hierarchy > Select Hierarchy > Select hierarchy from drilldown
  4. See that some leaves do not appear inside the hierarchy

Cause

In the CDS view I_CNSLDTNUNITFORELIMHIERNODE some members, like the elimination members, have node type = '$' instead of 'L'.

Resolution

Create a calculated column with below formula:

CASE WHEN "NodeType" IN ('L', '$') THEN 'L' ELSE "NodeType” END

And use this in the Hierarchy Directory settings.

Keywords

KBA , DS-MD-AM , Analytic Model , Problem

Product

SAP Datasphere all versions