Symptom
We have noticed an issue when using the new functionality to exclude members from a dimension filter (select "All Members" and then deselect the members that you want to exclude). Table options are being affected, losing the capability of adding a Custom Order for a dimension, or showing the options of a Calculated Account.
Environment
SAP ANALYTICS CLOUD
Reproducing the Issue
Create a new story ODE
Insert a table based on a Model
In Table Builder > Filters > select Measures > Uncheck Units and check Volume. Click OK
Delete Version filter (now you should see some data in the table)
Now, in the table, Right-click Dimension > select Sort Options > Add Custom Order > Observe Edit Member Order Dialog opens
Cancel the order dialog
Click Insert page Filter > Dimensions > Version > select All Versions. Click Settings and set to Single Selection and OK
Still, in the table, Right-click Dimension > select Sort Options > Add Custom Order > Observe Edit Member Order Dialog opens
Cancel the Order Dialog
Right -Click the Version Filter > edit filter > uncheck couple of boxes (Exclude Members). Click OK
Now, in the table, Right-click KPI > select Sort Options > Add Custom Order > Observe Edit Member Order Dialog is NOT Opening
Also in Console log for the filter it shows all values selected for Single Selection filter - incorrect
Cause
Product code limitation
Resolution
The issue got fixed now and works properly
Keywords
KBA , LOD-ANA-DES , Story Design & Visualizations , Problem