SAP Knowledge Base Article - Public

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

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.

Environment

SAP Analysis for Microsoft Office

Cause

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

Resolution

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.

See Also

  • 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

Keywords

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

Product

SAP Analysis for Microsoft Office all versions