Symptom
A story widget (chart or table) displays no data even though the Restricted Measure is defined with valid restrictions and Constant Selection is enabled.
Environment
- SAP Analytics Cloud
- Story Design & Visualizations
Reproducing the Issue
- Create a story and insert a chart or table.
- Ensure the model has booked data for some but not all member combinations across dimensions.
- Create a Restricted Measure on a measure, restricted on two or more dimensions, with Constant Selection enabled on one of the restricted dimensions.
- Add a filter on the dimension where Constant Selection is enabled.
- Select a member in the story filter that has no booked data at the intersection of the other restricted dimension.
- Observe that the widget displays no data.
Example
Consider the following booked data:
|
Measure |
Version |
Date |
Data available |
|
Amount |
Actual |
2026 |
Yes |
|
Amount |
Actual |
2027 |
Yes |
|
Amount |
Forecast |
2026 |
Yes |
|
Amount |
Forecast |
2027 |
No |
- A Restricted Measure is created on Amount restricted to Version = Actual and Date = 2027, with Constant Selection enabled on Version. A story filter is set to Version = Forecast.
- Since Forecast has no booked data for Date = 2027, the widget shows no data even though Actual + 2027 has data.
Cause
- This is a by-design behavior.
- Constant Selection causes the RM calculation to ignore the filter during value computation if it is unbooked. However, the filter is still applied when determining which members appear on the widget axes (rows/columns).
Resolution
- Ensure booked data exists for the member selected in the filter at the restricted intersection.
- Enable Unbooked on dimension.
See Also
- KBA 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- KBA 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
- KBA 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- SAP Analytics Cloud Connection Guide
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support
Your feedback is important to help us improve our knowledge base.
Keywords
empty widget, blank chart, empty table, unbooked member filter, show unbooked data, axis suppression, constant selection behavior, restricted measure behavior, filter context, sparse data scenario, story filter impact, data not visible , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-DES-CAL , SAC Story Calculations , Problem
SAP Knowledge Base Article - Public