SAP Knowledge Base Article - Public

3474476 - "Could not load range for start and end date as there are no booked values in your model" error message while using a range filter in SAP Analytics Cloud (SAC)

Symptom

  • After using a range filter the following error occurs: "Could not load range for start and end date as there are no booked values in your model" 
  • The same filter works in SAP Datasphere without an error

Environment

  • SAP Analytics Cloud (Enterprise) 2024.8.10
  • SAP DataSphere
  • Live Data Connection

Reproducing the Issue

  1. Log into SAC
  2. Open the affected story
  3. Open the filter bar
  4. Select a range filter
  5. Observe the following error message: "Could not load range for start and end date as there are no booked values in your model"

Cause

The dimension contains invalid date values. ("0001-01-03", "0006-09-15")

Resolution

Please follow the resolution mentioned in this KBA: 3471750 - Error "could not load range for start and end date as there are no booked values in your model" when setting a filter on the Time dimension (Range) in SAP Analytics Cloud (SAC)

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAC, DataSphere, DWC, Range filter, Filter, range, error , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0