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