SAP Knowledge Base Article - Public

3479697 - Excluding Members Functionality affects Table Custom Sorting

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

The issue is Currently under investigation by Development

Resolution

The issue is Currently under investigation by Development

Keywords

KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0