3105370 - Using and troubleshooting SAC Live Data Connections in Analysis Office

This document contains information about the usage and troubleshooting of SAC Live Data connections in Analysis Office.

SAP Analysis for Microsoft Office

Refer to chapter "Defining system connections to SAP Analytics Cloud" in Analysis Office documentation.

Analysis Office supports SAC Live Data connections.

Live Data connection means that you're directly connected to a system via your SAP Analytics Cloud. The following live data connections, objects and connection types are supported in Analysis:

• SAP HANA to access SAP HANA views (Type: Direct Connection)
• SAP BW to access SAP BW objects (Type: Direct Connection)
• SAP BW/4HANA to access SAP BW/4HANA objects (Type: Direct Connection)
• SAP BPC to access SAP BPC objects (Type: Direct Connection)
• SAP S/4HANA to access SAP S/4HANA ABAP CDS views (Type: Direct Connection)

Please note that the Tunnel connection type is currently not supported.

In case of a BW Live Connection, check if a Live Model can be created using the same connection. If not, refer to KBA 3449055.

For all live data connections, besides SAP HANA, you need to activate https://<bw_host_url>:<port>/sap/bw/analysis/ on the connected BW system. You can do this in transaction SICF by following steps below:

1. Log in to BW system in SAP GUI (SAP Logon);
2. Execute transaction SICF;
3. Enter DEFAULT_HOST for "Virtual Host" and "/sap/bw/analysis/" for "Service Path" and Execute:
   
   
   
   
4. Right-click on "Analysis" and then "Activate Service":
   
   
   
   
5. Once activated, test it by right-clicking on "Analysis" and clicking on "Test Service":
   
   
   
   
6. This should open the default browser and once logged in the BW system, the launcher file with extension ".sapaox" should be downloaded. If this is not the case, there is a problem in server side.
   
   

For BW live data connections, the following ICF services need to be maintained in the transaction SICF:

• /sap/bw/ina/ao/capabilities
• /sap/bw/ina/ao/catalogs

For SAP HANA connections, the following InA packages need to be maintained:

• /sap/bc/ina/service/v2/
• /sap/bc/ina/service/v2/GetServerInfo
• /sap/bc/ina/service/v2/GetResponse (POST)

Note that the configuration steps should be done on SAP NetWeaver ABAP Application Server (AS) and SAP Analytics Cloud tenant before creating the connections in Analysis Office.

For more information on the required system versions, please see the SAP Analytics Cloud help for System Requirements and Prerequisites at Data Connectivity - Live.

Note that your SAP Analytics Cloud user needs to be assigned to a role with Read permission for Connection in your SAP Analytics Cloud to enable the logon from Analysis Office.

Analysis Office will use the host and port configured in SAC side for the Live Data connection.

For example:

In order to access the Live Data connection in the example above, Analysis Office will use the URL https://mybwhost.com:443/sap/bw/analysis?sap-client=100. Therefore, the URL must be working in browser without any error.

IMPORTANT: The port maintained in SAC Live Connection settings above must be the same port configured in SMICM transaction for HTTPS. The SAP KBA 1636435 can help to change the port in SMICM transaction.

In case the URL works in browser, but does not work in Analysis Office, open a support case by selecting the component BI-RA-AO-XLA. Provide the AO traces described in SAP Note 2129389 and Fiddler trace described in SAP KBA 2385888.

How to check the AO trace

1. Record the AO trace by following the instructions of SAP Note 2129389;
2. Open the AO_Trace_*.glf file in a text editor;
3. Check the point of time in which the error occurs;
• If the error occurs while (or before) downloading the launcher from the Live Data connection, the issue might be related to SAC Live Connection definition / Configuration of SICF / BW Http handler authentication, etc.
• If AO could successfully download the launcher from the Live Data connection and the error occurs while establishing the typical direct RFC connection to BW, the issue is not related to the Live Data connection. It might be related to PC or BW SNC/SSO configuration. This could occur while - and can be reproduced by - launching via RAAOE or checking a direct connection to BW as well and should be diagnosed as a standard BW issue.

Single Sign-On (SSO)

For SSO authentication, the SAML for the SAP BW needs to be configured. More information in SAP Help Portal page Backend Single Sign-On.

2890173 - Analysis Office Live BW Connection Error - 403 - Forbidden

KBA , BI-RA-AO-XLA , Excel Addin , How To