SAP Knowledge Base Article - Public

3511880 - Error occurs when connecting SAP BW or SAP S/4HANA Tunnel type Live connection in SAC add-in for Microsoft Excel

Symptom

In SAC add-in for Microsoft Excel, error occurs when connecting a SAP BW or SAP S/4HANA Tunnel type Live connection.
---
An error occurred while loading the data sources of system <systemname>. Therefore, no data sources can be shown. 
---


When trying to insert any model using same live connection, then following error is displayed.
----
 An error occurred while inserting <modelname>. 
----


Issue only occurs in SAC add-in for Microsoft Excel, there is no issue connecting the same connection in SAC in browser.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental".

Environment

  • SAP Analytics Cloud, add-in for Microsoft Excel
  • SAP Analytics Cloud

Reproducing the Issue

  1. In SAC add-in for Microsoft Excel, sign in to SAC tenant.
  2. Click 'Add Table' button.
  3. In 'Select Data Source' screen, select a SAP BW or SAP S/4HANA live connection of type Tunnel.
  4. Following error occurs, user cannot connect the tunnel live connection.
    ---
    An error occurred while loading the data sources of system <systemname>. Therefore, no data sources can be shown. 
    ---

Cause

In SAC add-in for Microsoft Excel, there is no manual login screen by default. Therefore the used Tunnel live connection must have a valid user and password saved.
When the used Tunnel live connection does not have user and password info saved, this issue occurs.

Resolution

  1. In SAC, open the edit screen of the corresponding Tunnel live connection.
  2. Input valid user and password, and ensure check box 'Save this credential for all users on this system' is checked.
  3. Click 'OK' button to resave the connection.

Keywords

SAC addin for Excel, SAC addin for Microsoft Office, SAP Analytics Cloud, BW live connection, S4HANA live connection, S/4HANA live connection , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem

Product

SAP Analytics Cloud all versions ; SAP Analytics Cloud, add-in for Microsoft Office all versions