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
- Create an Analytical model
- 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
- 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
Keywords
Calculated Measure, Analytical Model, analytical model, preview, dimension , KBA , DS-MD-AM , Analytic Model , Problem