SAP Knowledge Base Article - Public

3281086 - Exclude Filter does not work when there is linked dimensions based on BW Live Connection

Symptom

When you have linked dimensions, the exclude filter does not work properly. 

You can have two scenarios.

Scenario 1: 
You have Dimension A (from Model 1) linked to Dimension B (from Model 2) and an Exclude Page Filter set on dimension A.
For the scenario 1 the Exclude filter works, but you can see the following warning: 
"Excluding members may not be supported when linking with a model using SAP BW"

Scenario 2: You have Dimension A (from Model 1) linked to Dimension B (from Model 2) and an Exlude Page Filter set on dimension C.
For the scenario 2 you can also see the warning above, but the filter does not work and the error below is shown: 
ExceptionClass:"CX_BICS_INA_EXECUTION_ERROR"
MessageClass:""
Number:0
OlapMessageClass:0
Text:"Error during execution CL_BICS_INA_COMMONS APPLY_FILTERS ERROR: FILTER TOO COMPLEX"
Type:2

Environment

SAP Analytics Cloud

Reproducing the Issue

Scenario 1: 
1 - Link 2 dimensions;
2 - Set an Exclude Page filter on the linked dimensions;

Scenario 2: 
1 - Link 2 dimensions;
2 - Set an exclude Page filter on an unliked dimension; 

Cause

Scenario 1: 
This is just a warning and the filter works. 

Scenario 2: 
The filter works as following: 
1 - You have the filter in dimension A being propagated to dimension B;
2 - If you set an exclude filter on an unliked dimension (dimension C) it creates an undirect filter which will have to be propagated to dimension B;
3 - This is a complex filter structure that is generated for exclude filters that often fails to process on the BW server and is a known limitation;
4 - Therefore you have the message "Error during execution CL_BICS_INA_COMMONS APPLY_FILTERS ERROR: FILTER TOO COMPLEX"; 

Resolution

This would be an enhacement request

Possible workaround:
A possible workaround is to set the exclude filter on a widget level instead of page level, in this way you do not create any complex logic.

Keywords

SAC, BW, Live, Connection, Filter, Exclude, Dimensions, Linked, Analysis, Analytics, Cloud , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , Problem

Product

SAP Analytics Cloud all versions