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.
SAP Knowledge Base Article - Preview