KNOWLEDGE BASE

When using SAP BW Landscape XML files, the Select connection drop-down list is empty


Published: 12 Mar 2019
Last Modified Date: 01 Dec 2019

Issue

When using SAP BW Landscape XML files, the Select connection drop-down list is empty, though all connections display as expected in SAP Logon.

Environment

  • Tableau Desktop
  • SAP NetWeaver Business Warehouse

Resolution

Option 1
  1. Save the SAPUILandscape.xml and SAPUILandscapeGlobal.xml files to the following default location: "C:\Users\<username>\AppData\Roaming\SAP\Common"

Option 2
  1. For SAPUILandscape.xml files, ensure the file location is specified in one of the following registry locations (ordered in the priority in which Tableau checks each location):
  • HKEY_CURRENT_USER\Software\SAP\SAPLogon\Options\PathConfigFilesLocal 
  • HKEY_LOCAL_MACHINE\Software\Wow6432Node\SAP\SAPLogon\Options\PathConfigFilesLocal 
NOTE: The location of the file can be updated by opening the SAP GUI Configuration client and changing the file path specified in SAP Logon Options > Local Configuration Files, or by editing the registry manually.


Option 3 
  1. Backup current settings. Use caution when editing the Registry manually and check with the relevant IT team before carrying out any changes. It is also strongly advised to make a backup of the current settings before doing so.
  2. For SAPUILandscapeGlobal.xml files, ensure the file location is specified in one of the following registry locations (ordered in the priority in which Tableau checks each location):
  • HKEY_CURRENT_USER\Software\SAP\SAPLogon\Options\LandscapeFileOnServer
  • HKEY_LOCAL_MACHINE\...\LandscapeFileOnServer
  • HKEY_LOCAL_MACHINE\...\CoreLandscapeFileOnServer
  • HKEY_CURRENT_USER\...\CoreLandscapeFileOnServer
  • HKEY_CURRENT_USER\...\PathConfigFilesLocal
  • HKEY_LOCAL_MACHINE\...\PathConfigFilesLocal
NOTE: The location of the file can be updated by opening the SAP GUI Configuration client and changing the file path specified in SAP Logon Options > Local Configuration Files, or by editing the registry manually.

Cause

Landscape XML files must be located in \AppData\Roaming\SAP\Common, or the location specified in one of the registry variables above. If Tableau is unable to locate the XML file in one of the above locations, this can result in either blank or incomplete SAP BW connection information in Tableau Desktop.

Additional Information

  • The \AppData\Roaming\SAP\Common folder will always be checked after all registry variables have been checked. 
  • Take note of the order in which Tableau checks the registry variables and \SAP\Common folder. The highest priority location overrides all others.
  • Note that the environment variable SAPLOGON_LSXML_FILE is not supported by Tableau Desktop.



Discuss this article... Feedback Forum
Did this article resolve the issue?