Symptom
- When creating a table with calculated measures and dimensions in an SAC story, enabling "Show Total" for the dimension result in the total for the calculated measure displaying as blank.
- The totals for the calculated measure also display as blank when previewing the Analytic Model in SAP Datasphere.
- A calculated measure was created in the Analytic Model, referencing other dimensions. For example:
CASE
WHEN <Dimension 1>=<value 1> THEN <measure 1>
WHEN <Dimension 1>=<value 2> THEN <measure 2>
ELSE <measure 1>+ <measure 2>
END - The Semantic Type of the measures used in the formula is "Amount with Currency".
Environment
- SAP Datasphere
- SAP Analytic Cloud
Reproducing the Issue
- Open the problem Analytic Model with calculated measures in SAP Datasphere.
A calculated measure was created in the Analytic Model, referencing other dimensions. For example:
CASE
The Semantic Type of the measure used in the formula is "Amount with Currency".
WHEN <Dimension 1>=<value 1> THEN <measure 1>
WHEN <Dimension 1>=<value 2> THEN <measure 2>
ELSE <measure 1>+ <measure 2>
END - Preview the model.
- Select dimension <dimension 1>" and the calculated measures.
- Right click on the dimension header cell and choose Totals-> Show Totals.
=> Observe that the total value of the calculated measures would not appear
Cause
The calculation references to other dimensions. To have it work properly even if the dimensions are then not present in the drill these dimensions should be added as exception aggregation dimensions.
Resolution
Add the dimensions that the calculation references as exception aggregation dimensions.
Keywords
dwc, dsp, wrong, unexpected, missing, lost , KBA , DS-MD-AM , Analytic Model , LOD-ANA-DES , Story Design & Visualizations , Problem
Product
Attachments
Pasted image.png |