Symptom
- In a story table applying a local table filter with the member "#" (Not Assigned) causes the filter to disappear after saving and reloading the story.
- Selecting any other member value keeps the filter persisted and applied.
- The behavior is reproducible on a new story and limited to table local filters; chart filters on certain time dimensions may still work.
- No error message is displayed.
Environment
- SAP Analytics Cloud
Reproducing the Issue
- Create or open a story
- Add a table and apply a local table filter on a dimension by selecting the member "#" (Not Assigned).
- Save the story.
- Reload the story.
- Observe that the local table filter with "#" is no longer present; the filter persists if a different member is selected.
Cause
A regression in the filter validation logic treats the "#" (Not Assigned) member, which uses an empty technical key for its caption, as an invalid local table filter and removes it upon save/reload.
Resolution
Product Engineering is currently investigating a solution.
See Also
Keywords
SAC, SAP Analytics Cloud, BPC Embedded, BW live connection, live model, table filter, local table filter, not assigned, unassigned, hash member, # member, filter disappears, input-ready query, planning, regression , KBA , LOD-ANA-TAB-FIL , Local Table Filters (excluding story & page filters) , Problem
Product
SAP Analytics Cloud all versions
SAP Knowledge Base Article - Public