2474847 - SAP systems missing in AO when XML server configuration file is defined

Symptom

"Show connections" dialog does not display the list of systems from the server configuration file, even if they are visibile in SAP Logon.

Environment

SAP Analysis for Microsoft Office

Reproducing the Issue

1. Open SAP Logon and navigate to Sap Logon Options -> Server Configuration Files.
2. Define own XML Configuration File on Server as per below screenshot.
3. Set flag to "Alow caching of server configuration files".
4. Apply the settings and reopen SAP Logon.

5. Start Analysis for Office
6. Click on "Insert Data Source" or use "Open workbook from platform" option
7. The list of SAP systems is not displayed (If local systems are defined, then only local systems are in the list) as per below screenshot.

Cause

This is caused by COM API (application programming interface)

Resolution

1. Open regedit.exe. Navigate to the path and define the parameter as below:

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SAP\SAPLogon]

"LandscapeFormatEnabled"=dword:00000001

This forces SAP Logon to use .xml files instead of .ini (all previously defined SAP systems will be placed to .xml file).

For more details please refer to the following WIKI page: BI-RA-AO-CON Connection and Authentication

2. Navigate to the path and set the parameter as below to "False":

c:\ProgramData\SAP\Cof\Ao_app.config

<UseSapUILandscapeComApi value="False"/>

This forces AO to use its own parsing logic to read the list of systems. Please check SAP Knowledge Based Article 2083067 for information on how to maintain settings in AO.

3. Make sure that "Alow caching of server configuration files" flag is set.

Keywords

Open Dialog, SAP GUI, SAP Logon, SAPUILandscape.xml, SAPUILandscapeGlobal.xml, LandscapeFileOnServer, Hana, Connection, Analysis, Office , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-PPA , Please use component BI-RA-AO-XLA , Problem

Product

SAP Analysis for Microsoft Office all versions