SAP Knowledge Base Article - Preview

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


Read more...

Environment

  • SAP Datasphere
  • SAP Analytic Cloud

Product

SAP Analytics Cloud 1.0 ; SAP Datasphere 1.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.