Symptom
When using some null values in a measure and doing a ranking base on the associated dimension
the error No data is available for the chart to render will happen.
Environment
- 2020.8.15 and Higher
Reproducing the Issue
- Create a chart using a dimension and measures containing some null
- Do a ranking eitehr top or bottom
- The error No data is available for the chart to render will happen
Cause
some of the dimension values are associated with some null values for the measure selected
Resolution
you can fix the issue at 3 levels
- In the source system for example Hana you can create a a new calculation measure using a formula to set to 0 when the value is null
- In the SAC model, in the measure section, you can add a new formula as IF(ISNULL([Measure] ) , 0,[Measure] )
- In the Story, you can also create a new measure with the formula IF(ISNULL([Measure] ) , 0,[Measure] )
As you do remove the null values from the measure then you can do the appropriate ranking
Keywords
SAC, no data, chart, null values , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem
Product
SAP Analytics Cloud 1.0