SAP Knowledge Base Article - Public

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


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


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.



This is caused by COM API (application programming interface)


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



    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":


         <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.


See Also

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


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


SAP Analysis for Microsoft Office all versions