SAP Knowledge Base Article - Public

3543363 - Value of hierarchy node is no the same as summing up its leaves

Symptom

In one analytic model, the value of nodes are not the same as summing up its leaves.

Environment

SAP Datasphere

Reproducing the Issue

Preview an Analytic mode, apply an hierarchy. When expanding the nodes and summing up the values of the leaves, you may notice that the total does not match the value of the node. 

Cause

This is working as expected

Resolution

The calculated measures of hierarchy are not aggregated, but computed at each level. Base measures are aggregated based on their aggregation type, such as SUM. This applies to both hierarchies and totals.

Keywords

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

Product

SAP Datasphere all versions