Symptom
In one analytic model, the value of nodes are not the same as summing up its leaves.
Environment
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