2083067 - How to maintain settings for Analysis Office 2.x

Symptom

You want to maintain registry settings for Analysis Office 2.x in a client PC.

Environment

SAP Business Objects Analysis, edition for Microsoft Office 2.x

Cause

As of Analysis Office 2.0, the settings are maintained in the file system and not in the registry. The Analysis specific settings are stored in the file system.

For Analysis Office versions until 2.4, you can only maintain settings in the file system of the client PC.

For Analysis Office versions 2.5 and newer, you can modify settings directly in Analysis Office besides maintaining settings directly in file system.

Resolution

In Analysis Office versions 2.5 and newer:

You can modify settings directly in Analysis Office. The dialog can be opened in the backstage area under:

File -> Analysis -> Customize Analysis -> Technical Configuration

customize Analysis.jpg

After changing the values in Analysis Office, the changes are executed immediately. The changed values will be available in the Technical Configuration dialog and in the corresponding setting file on user level.

technical information.JPG

Besides modifying settings directly in Analysis Office, settings can be maintained in file system.

As the Administrator, you can maintain the settings at machine level in two files: Ao_app.config and Cof_app.config.
```
The files are located in the file system under %PROGRAMDATA%\Sap\Cof.
```

administrator level setting.jpg

As a user, you can change the settings from user level in two files: Ao_user_roaming.config and Cof_user_roaming.config.
```
The files are located in the file system under %APPDATA%\Sap\Cof.
```

user setting.jpg

These files are created automatically if you change a setting in the settings dialog. You can also create the files manually.

Increase Indent

The Administrator can define whether a user should be able to change a setting locally.

Navigate to the folder %PROGRAMDATA%\Sap\Cof and open Ao_app.config file.
Each setting has a configuration level defined in the configSections area. The default level is UserRoaming, which means that user can change the setting locally. In this case, if the same setting exists in both Ao_app.config and Ao_user_roaming.config, the value in Ao_user_roaming.config will overwrite the one in Ao_app.config.
```
 <configSections>
```
```
...
```
```
<section name="PreferredPlatform" type="Int32" configurationLevel="UserRoaming" />
```
```
...
```
```
</configSections>
```
If Administrator change the configuration level for one setting to PerMachine, this setting can no longer be changed by a user locally. The value of this setting from Ao_app.config is used in any cases. Value of respective settings from Ao_user_roaming.config is ignored.
```
 <configSections>
```
```
...
```
```
<section name="PreferredPlatform" type="Int32" configurationLevel="PerMachine" />
```
```
...
```
```
</configSections>
```

Examples: how to maintain Analsyis Office settings at administrator level

ResultSetSizeLimit

Navigate to the folder %PROGRAMDATA%\Sap\Cof and open Ao_app.config file.

Search and find the entry for ResultSetSizeLimit.

<!--default of 'ResultSetSizeLimit': value="500000" -->    (This is Comment Line)

<ResultSetSizeLimit />             (The default value for this setting is empty. It means this setting will use the default value 500000 for maximum number of cells.)

You can set the parameter to -1 so that the ResultSetSizeLimit setting uses the values defined in the BW system.
```

```
```
<ResultSetSizeLimit value="-1" />
```
Or you can set the the parameter to a specific number to define the maximum number of cells with this value.
```

```
```
<ResultSetSizeLimit value="1000000" />
```
Save the Ao_app.config file

OperatorContainsPattern

Navigate to the folder %PROGRAMDATA%\Sap\Cof and open Ao_app.config file.
Search and find the entry for OperatorContainsPattern. The default value is false. This means that the contains pattern operator could not be used for prompting.
```
 
```
```
 <OperatorContainsPattern />
```

To enable the contains pattern operator for prompting, you can set the parameter value to True.

 <!--default of 'OperatorContainsPattern': value="False" -->

 <OperatorContainsPattern value="True" />

Save the Ao_app.config file

ShowApplyNumberFormatsToggleButton

Navigate to the folder %PROGRAMDATA%\Sap\Cof and open Ao_app.config file.
Search the entry for ShowApplyNumberFormatsToggleButton. But this entry does not exist in this file. You need to register this entry in the Ao_app.config file in the <configSections> part first.
```
<configSections>
```
```
...
```
```
<section name="ShowApplyNumberFormatsToggleButton" type="Boolean" configurationLevel="UserRoaming" />
```
```
...
```
```
</configSections>
```
Add entry for ShowApplyNumberFormatsToggleButton before the last line of Ao_app.config file (which is line just above entry </configuration>). The default value is false. This means the "Apply Number Format" checkbox is not available in the design panel.
```

```
```
<ShowApplyNumberFormatsToggleButton />
```

If you change the parameter value to True, the "Apply Number Format" checkbox is displayed in the design panel.

<!--default of 'ShowApplyNumberFormatsToggleButton': value="False" -->

<ShowApplyNumberFormatsToggleButton value="True" />

Save the Ao_app.config file

Examples: how to maintain Analsyis Office settings at user level

ResultSetSizeLimit

Navigate to the folder %PROGRAMDATA%\Sap\Cof and open Ao_app.config file.
Search the entry for ResultSetSizeLimit and check the configuration level defined in the configSections area. Ensure the configuration level is "UserRoaming" which means that user can change the setting ResultSetSizeLimit locally in Ao_user_roaming.config and the value of ResultSetSizeLimit in Ao_user_roaming.config file will overwrite the one in Ao_app.config file.
```
<configSections>
```
```
...
```
```
<section name="ResultSetSizeLimit" type="Int32" configurationLevel="UserRoaming" />
```
```
...
```
```
</configSections>
```
Navigate to the folder %APPDATA%\Sap\Cof and open Ao_user_roaming.config file.
Add entry for ResultSetSizeLimit in Ao_user_roaming.config file if the setting is not already available in the file or change the exsiting parameter value of ResultSetSizeLimit.
You can set ResultSetSizeLimit with the parameter value to -1 in Ao_user_roaming.config file so that the ResultSetSizeLimit setting uses the values defined in the BW system.

<ResultSetSizeLimit value="-1" />

Or you can set ResultSetSizeLimit with the parameter value to a specific number to define the maximum number of cells with this value.

<ResultSetSizeLimit value="1000000" />

Save the Ao_user_roaming.config file

When scheduling Analysis Office workbooks, settings maintained in AO_BiPrecalculation.config will be used instead of using settings in Ao_app.config and Ao_user_roaming.config on client. The file „AO_BiPrecalculation.config“ can be found in Analysis Precalculation installation folder of the scheduling server, for example:
```
[Drive]:\Program Files (x86)\SAP BusinessObjects\Analysis Precalculation
```

You can find more information about the AO settings in chapter Settings in the Analysis Office Administrator Guide.

Keywords

Analysis Office, settings, registry, registry setting, AO, file system, resultsetsizelimit, containspattern, wildcard, number format , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-BICS , BI consumer services , BI-RA-AO-CON , Please use component BI-RA-AO-XLA , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , How To

Product

SAP Analysis for Microsoft Office 2.8