SAP Knowledge Base Article - Public

3404881 - Calculation 'Dimension to Measure' Does Not Work on Hierarchical Data in SAP Analytics Cloud (SAC)

Symptom

  • "Dimension to Measure" calculation type does not aggregate successfully when applied to hierarchical dimension property.
  • Non-leaf values will not be aggregated.

Environment

  • SAP Analytics Cloud 2023.21

Reproducing the Issue

  1. Apply the 'Dimension to Measure' calculation type to a hierarchical dimension property.
    • Note: "No Exception Aggregation Type" or "Exception Aggregation Dimensions" are set. 
  2. Notice: values associated with non-leaf members will not be aggregated into the calculation.

Cause

  • This issue is currently under investigation by development.

Resolution

  • This issue is currently under investigation by development.

Workaround

  • Set row dimensions hierarchy configuration to "Flat Presentation".

See Also

Keywords

dimension to measure, dimension to account, calculated dimension, convert, calculated column, function, type , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , Problem

Product

SAP Analytics Cloud 1.0