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
- Apply the 'Dimension to Measure' calculation type to a hierarchical dimension property.
- Note: "No Exception Aggregation Type" or "Exception Aggregation Dimensions" are set.
- 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