SAP Knowledge Base Article - Public

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.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

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.
  3. Set flag to 'Allow caching of server configuration files'.
  4. Apply the settings and reopen SAP Logon.
    1. GUISettings1.jpg
  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.
    1. AOsystems.jpg

Cause

This is caused by the COM API (application programming interface)

Resolution

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

    1. [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SAP\SAPLogon]
    2. "LandscapeFormatEnabled"=dword:00000001

    3. This forces SAP Logon to use .xml files instead of .ini (all previously defined SAP systems will be placed to .xml file).
    4. For more details refer to the following Support Content page: BI-RA-AO-CON Connection and Authentication.

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

    1. c:\ProgramData\SAP\Cof\Ao_app.config
    2. <UseSapUILandscapeComApi value="False"/>

    3. This forces AO to use its own parsing logic to read the list of systems. Check KBA 2083067 for information on how to maintain settings in AO.

  3. Make sure that 'Allow caching of server configuration files' flag is set.
    1.  GUISettings2.jpg

See Also

KBA 2518955 - Analysis for Office does not show the BW systems or crashes at the BW system selection

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