3449842 - Operators CP and !CP are only available when calling the filter dialog from the variable screen

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.

SAP Analysis for Microsoft Office

This is the intended behavior and it is working as designed.

As described in chapter "To filter data by member", the operators CP and !CP are only available when calling the filter dialog from the prompts dialog.

• SAP Note 2203192 - Availability of Selection options Contains Pattern / Excludes Pattern in Prompts Dialog
• SAP Note 3347620 - Filter Dialog - Support of Contains Operators in Range View

add to filter, by range, filter by range, cp, !cp, wildcard , KBA , BI-RA-AO-XLA , Excel Addin , Problem