SAP Knowledge Base Article - Public

2687867 - No data available in Chart - Online Report Designer

Symptom

  • A chart component in ORD displays the message "No data available. Please change your selection"
  • In Edit Query > Show Table View mode you can see data properly
  • In Edit Formatting > Preview the error message "The query must specify a dimension on the columns" is displayed

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

Environment

SuccessFactors Workforce Analytics (ANA) - All versions

Reproducing the Issue

  1. Create a chart component in ORD
  2. Select a measure and a row in Design View
  3. Click on Show Table view to see a preview of the data
    edit query no column.png
    edit query preview no column.png

  4. Run the Chart and see the message
    no data.png

Cause

The Chart component must specify a dimension (field) on the columns

Resolution

  1. Edit the query of the chart component
  2. You can either add another field to the Columns section 
    edit query column and row.png
    preview.png
  3. Or click on Swap values with Rows i.e. move the field from Rows to Columns
    swap.pngedit query no row.png
    preview with column only.png

See Also

2286593 - "No data available please change the scope" Showing in Reports

Keywords

chart component ORD message No data available Please change your selection The query must specify a dimension on the columns Online Report Designer , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , How To

Product

SAP SuccessFactors Workforce Analytics all versions