3807986 - Cascading Filter Effect Shows Members with No Data in SAP Analytics Cloud Stories (SAC)

In an SAP Analytics Cloud story with dimension filters with the Cascading Effect option enabled still display member values that have no corresponding data, even after preceding filter selections have been made.

Specifically:

• A story using a dimension hierarchy shows all members of a subsequent filter (including those with no data) even when Cascading is enabled.
• After applying a filter on one dimension, a dependent dimension filter still lists members for which no data exists for the current filter selection.

SAP Analytics Cloud 2026.15.6

1. Open a story that has multiple dimension filters with Cascading Effect enabled.
2. Navigate to the relevant story page.
3. Click See More Filters.
4. Navigate to a dimension filter that depends on another filter upstream (e.g. a child dimension filter).
5. By default, all filter values are selected.
6. Deselect all values and select a limited subset of members (e.g. Member A, Member B).
7. Observe that no data is displayed in the table after making these selections.
8. However, the dependent dimension filter still contains values that do not have corresponding data for the selected criteria.
9. Switch the story to Edit Mode and confirm that the Cascading Effect option is enabled for the filters.

The behaviour is working as designed.

The Cascading Effect for input controls (story filters) is functioning correctly: filter values are cascaded as selections are made in other filters. However, a perceived mismatch between the filter list and the visible table data arises due to the following:

• SAP Analytics Cloud tables have a Zero Suppression and Null Suppression feature. When these suppression options are enabled on a table, rows or columns with zero or null values are hidden from the table display.

No configuration change is required to fix the cascading filter behaviour since it is working correctly.

To verify and confirm the root cause, disable the Zero/Null Suppression setting on the affected table:

1. Select the table in the story.
2. Go to the table's Builder or Styling panel.
3. Locate the Zero Suppression and Null Suppression settings and turn them OFF.
4. Observe that the table now shows the same member values as the dimension input control.

This confirms that the filter cascading is correct, and the apparent discrepancy is caused entirely by the table's suppression settings.

If zero/null suppression in input controls is a business requirement, this is currently not supported as a standard feature. Users who require this functionality should submit an enhancement request by following the instructions in:

KBA 2424376 — How to submit an enhancement request for SAP Analytics Cloud 

• 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.

SAP Analytics Cloud, SAC, story filter, input control, cascading effect, cascading filter, dimension filter, hierarchy filter, zero suppression, null suppression, filter values, no data, members not filtered, Import connection, cascading not working , KBA , LOD-ANA-DES-OFLTR , SAP Analytics Cloud Optimized view mode filtering , Problem