Symptom
The setting OperatorContainsPattern of Analysis Office can be used to define whether the operators Contains Pattern (CP) and Does Not Contain Pattern (!CP) should be enabled for filtering and prompting.
When setting the OperatorContainsPattern to TRUE, the operators CP and !CP are only available when calling the filter dialog from the variable screen, but they are not available when calling the filter dialog of a range selection directly from the crosstab or from the Design Panel.
Read more...
Environment
SAP Analysis for Microsoft Office
Product
Keywords
add to filter, by range, filter by range, cp, !cp , KBA , BI-RA-AO-XLA , Excel Addin , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.