SAP Knowledge Base Article - Public

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

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

  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

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

SAP Analytics Cloud 1.0 ; SAP Datasphere 1.0

Attachments

Pasted image.png