SAP Knowledge Base Article - Public

3319562 - Missing options in Technical Configuration

Symptom

After configuration files are manually changed by administrator.

In SAP Analysis for Office, Technical Configuration, "Ao" or "Cof" options are missing.

 When using standard AO .config files, options are available.

Environment

SAP Analysis for Office

Reproducing the Issue

1. Open AO
2. Go to: File > Analysis > Customize Analysis > Options > Technical Configuration
3. Confirm options are missing in "Filter by configuration file prefix"

AO Trace (recorded based on steps of KBA 2129389 - Analysis 2.x log / Trace Files) contains the following message or similar:

Name cannot begin with the ' ' character, hexadecimal value 0x20. Line XXX, position YYY.

Cause

Mistakes in the customized code, .config file contains a syntax error.

e.g.

Instead of <!--default: value="True" --> (correct)

is <default: value="True" --> (incorrect)

Resolution

Cof options missing:

1. Go to: %programdata%\SAP\Cof\Cof_app.config

2. Find line and position specified in error message of AO_Trace 

3. Find the syntax error

4. Correct the file

Ao options missing:

1. Go to:  %programdata%\SAP\Cof\Ao_app.config

2. Find line and position specified in error message of AO_Trace 

3. Find the syntax error

4. Correct the file

 

See Also

2129389 - Analysis 2.x log / Trace Files

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

3326654 - Analysis Office configuration setting not taking effect

Keywords

technical configuration, missing, Ao, Cof, options , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions