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

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

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

• SAP NetWeaver
• SAP Business Warehouse
• SAP BW/4HANA
• SAP S/4HANA

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; 

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"; 

This would be an enhancement request: 

KBA: 2424376 - How to create an enhancement request for SAP Analytics Cloud?

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.

Have a question? Ask it here and let our amazing SAP community help!

Your feedback is important to help us improve our knowledge base.

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