SAP Knowledge Base Article - Public

3604416 - "SAP BW" option is not available in "Select Data Source" in SAP Analytics Cloud (SAC) Add-in for Microsoft office

Symptom

  • Add Table > Select Data Source does not show option for SAP BW in SAP Analytics Cloud (SAC) Add-In for MS Office. 
  • BW live connection exists in SAP Analytics Cloud. A story is created successfully using the model with the underlying the BW live connection.

Environment

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

Reproducing the Issue

  1. Log in SAP Analytics Cloud from SAP Analytics Cloud, add-in for Microsoft Office in Excel.
  2. Click Add Table > Select Data Source. 
  3. "SAP BW" is not listed. 

Cause

Resolution

To set up a BW live connection Tunnel type, carefully follow each step in Live Data Connection to SAP BW Using a Tunnel Connection

  1. Prerequisites
  2. Enable InA on your ABAP Application Server
  3. Configure Cloud Connector Tunnel Connection

Setting up a live connection above requires working with the SAP Analytics Cloud system owner and different IT and application stakeholders within your organization.

See Also

Keywords

SAP Analytics Cloud, SAC Add-In, MS Office, SAP BW, live models, connection type, tunnel connection, live data connection, access issue. , 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