SAP Knowledge Base Article - Public

3839060 - Widgets show no data when filter selects a member with no booked data in SAP Analytics Cloud (SAC)

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

  1. Create a story and insert a chart or table.
  2. Ensure the model has booked data for some but not all member combinations across dimensions.
  3. Create a Restricted Measure on a measure, restricted on two or more dimensions, with Constant Selection enabled on one of the restricted dimensions.
  4. Add a filter on the dimension where Constant Selection is enabled.
  5. Select a member in the story filter that has no booked data at the intersection of the other restricted dimension.
  6. 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

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

Product

SAP Analytics Cloud 1.0