Analysis Office Variable Operator Contains Pattern

Analysis Office Prompt without Pattern
Analysis Office Prompt without Pattern

Since Analysis Office 2.0 the administrative settings are moved from the registry to the file system. These settings are now maintained in a XML file. As in my article “Analysis Office 2.2 SP2” mentioned the Ao_app.config is repeatedly expanded and sometimes there are new commands available.

 

In this context the admin guide is always very useful. On this Topic there is also a SAP Note 1920589. To use “Contains Pattern” as it is described in the Analysis Office Help under “Syntax for Entering Values”, it must be activated in the Ao_user_roaming.config file.

Analysis Office User Guide
Analysis Office User Guide

The file is located in the user folder AppData\Roaming\SAP\Cof\ (%AppData%\SAP\Cof\).

Appdata\Roaming\SAP\Cof
Appdata\Roaming\SAP\Cof

In this file you have to add the parameter <OperatorContainsPattern value="True" />.

Ao_user_roaming.config OperatorContainsPattern
Ao_user_roaming.config OperatorContainsPattern

If you now use a variable, which supports pattern, your variables prompt should look like this.

Analysis Office Prompt with Pattern
Analysis Office Prompt with Pattern

Note: Until Analysis Office 2.3 ContainsPattern only works if your variable is in Characteristic Restrictions. If your variable is in Default Values, you don't see the ContainsPattern option.

 

The problem is described in the SCN.

Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
29,99 € 1
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
39,99 € 1

Write a comment

Comments: 0