SAP Knowledge Base Article - Public

2942558 - No data is available for the chart to render error occurs when using a live model with some null values in SAP Analytics Cloud (SAC)

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

  1.  Create a chart using a dimension and measures containing some null 
  2.  Do a ranking eitehr top or bottom
  3.  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

  1. 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
  2. In the SAC model, in the measure section, you can add a new formula as IF(ISNULL([Measure] ) , 0,[Measure] )
  3. 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 , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0