Analysis for Office Connections to BW system without installing SAP Logon / SAP GUI
It is possible now to configure Analysis for Office connections to the backend BW system without the need for the installation of the SAP GUI / SAP Logon. With the release of AFO 2.8 SP4 it is possible to read the SAPUILandscape.xml file locally or on a remote server without the installation of the SAP GUI.
Since SAP GUI 7.4 the old .ini files which held connection details to SAP systems used by the SAP GUI and the AFO were replaced with a new file called the SAPUILandscape.xml.
By default, once you upgrade your SAP GUI, your client machine will automatically use this file and this is set by a registry key called LandscapeFormatEnabled.
However, if you do not have SAP GUI installed, then your Analysis for Office will always look for the old .ini file. As this is outdated, we must set 2 things on the Client machine for the new SAPUILandscape.xml file to be read by Analysis for Office.
The 2 considerations needed on the client machine:
- The Registry Key LandscapeFormatEnabled must be set
- The environment variable SAPLOGON_LSXML_FILE pointing to our XML file
- We must open the Registry Editor and create the registry key as a DWORD Entry in the exact location : Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SAP\SAPLogon
The Entry must be named LandscapeFormatEnabled and it must be set to 1.
2. We must set the in the System Environment Variables, the variable SAPLOGON_LSXML_FILE and this points to location of the SAPUILandscape.xml file. This can be locally on the client machine or a remote server location:
Once this is set and the client machine restarted, the Analysis for Office will read the XML file we set in the environment variable.
This can be used for Single Sign On scenarios but there must be a SNC product installed on the Client Machine also such as Secure Login Client.