3610498 - Total values for calculated measures created in SAP Datasphere Analytical Model shows "-"

• 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".

• SAP Datasphere
• SAP Analytic Cloud

1. 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
   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 measure used in the formula is "Amount with Currency".
2. Preview the model.
3. Select dimension <dimension 1>" and the calculated measures.
4. Right click on the dimension header cell and choose Totals-> Show Totals.
   => Observe that the total value of the calculated measures would not appear

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.

Add the dimensions that the calculation references as exception aggregation dimensions.

 

dwc, dsp, wrong, unexpected, missing, lost  , KBA , DS-MD-AM , Analytic Model , LOD-ANA-DES , Story Design & Visualizations , Problem