SAP Knowledge Base Article - Public

3537766 - Calculated Measures Created in Analytical Model based on Dimensions requires the Dimensions to be included in the Model to show the Calculated Values

Symptom

Created a Calculated measure in the Analytical Model with an underlying dimension. Preview the Analytical model and the Calculated measure comes up empty with no data. Include the dimension the calculation is based on and you see the data come up 

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 

Environment

SAP Datasphere

Reproducing the Issue

  1. Create an Analytical model
  2. Create a Calculated Measure with a dimension in the Analytical model. For example there is a case statement like case when TAXTARIFFCODE >=1 then 10 end
  3. When previewing data the calculated measure will be empty till the dimension TAXTARIFFCODE is included in the Analytical model

Resolution

This is a limitation currently in Datasphere and customers need to include the dimensions used in the calculated measure

See Also

Creating an Analytical Model

Keywords

Calculated Measure, Analytical Model, analytical model, preview, dimension , KBA , DS-MD-AM , Analytic Model , Problem

Product

SAP Datasphere 1.0