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

SAP Logon is configured to read the connections from SAPUILandscape.xml file. One of the following happens:

1. The connections are available in SAP Logon but for Analysis for Office is blank.
2. The connections are available in SAP Logon but Analysis for Office crashes on the screen where it should show the available BW systems.
3. The connections are available in SAP Logon but Analysis for Office is not showing any BW system available in SAPUILandscape.xml file.

The entries below can be seen in AO traces:
-----------------------------------------------
General .NET Exception:
The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Runtime.InteropServices.CustomMarshalers.EnumeratorViewOfEnumVariant.MoveNext()
at com.sap.ip.bi.pioneer.common.connectivity.SAPUILandscape.ComApiUsage.CoSapUiLandscapeServiceComApi.CreateOpenTreeNodes()
at com.sap.ip.bi.pioneer.common.connectivity.SAPUILandscape.ComApiUsage.CoSapUiLandscapeServiceComApi.CreateOpenTreeNodesHierarchical()
at com.sap.ip.bi.pioneer.controls.opendialogs.browsingmodel.CnSapLogonBrowsingModel.GetTopLevelNodes()
at com.sap.ip.bi.pioneer.controls.opendialogs.CnOpenTreeControl.Initialize()
at com.sap.ip.bi.pioneer.controls.opendialogs.CnOpenConnectionsControl.RefreshTree(FilterState iFilterState)
at com.sap.ip.bi.pioneer.controls.opendialogs.CnOpenConnectionsControl.<ControlLoadHandler>b__59_0()
at com.sap.ip.bi.pioneer.controls.utils.UserActionProcessor.DoUserAction(UserActionDelegate iDelegate, CoUseWaitCursorEnum iWaitCursor, ISupportDialogResultSettable iSupportDialogResult)
-----------------------------------------------

SAP Analysis for Microsoft Office (previously SAP BusinessObjects Analysis, edition for Microsoft Office)

1. Make sure SAP Logon is reading the systems from SAPUILandscape.xml file. This can be checked in SAP Logon options as shown below:
   
   
   
   
2. Confirm that the systems are available in SAP Logon:
   
   
   
   
3. Start Analysis Office;
4. Try to insert a data source or open a workbook from Netweaver;
5. a. Confirm that Analysis for Office crashes and forces the user to exit Excel
   b. Confirm that the BW systems available in SAPUILandscape.xml file are not in the list.
   
   

In AO 2.7 and previous versions, Analysis Office was using the API of SAP Logon to read the connections from the SAPUILandscape.xml file and this was causing some issues, like the ones described in this note.

In order to solve the issue, the setting UseSapUILandscapeComApi can be set to FALSE in AO configuration files. In this case AO will not use the API from SAP Logon but its own parsing logic.

The setting can be changed via Excel File > Analysis > Customize Analysis > Technical Configuration:

Make sure the setting UseSapUILandscapeComApi is unchecked:

In case the issue still remains, please make sure you are using the latest release of Analysis for Office.

Check note 1518359 - SAP BusinessObjects Analysis Office & BIP Add On Release schedule

See SAP Knowledge Base Article 2083067 for more details about how to maintain the settings in AO.

connections, systems, sap logon, entries, entry, bw, system, connection, empty, list, freeze, crash, blank , KBA , BI-RA-AO-XLA , Excel Addin , BC-FES-GUI , SAP GUI for Windows , BW-SYS-GUI , BW Frontend and GUI , BI-RA-AO-CON , Please use component BI-RA-AO-XLA , Problem