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
- Log in SAP Analytics Cloud from SAP Analytics Cloud, add-in for Microsoft Office in Excel.
- Click Add Table > Select Data Source.
- "SAP BW" is not listed.
Cause
- The existing BW connection uses Direct type.
- "To use these models with the add-in, the connections to the SAP BW system must be created as live data connections of type Tunnel in your SAP Analytics Cloud."(SAC Add-in help)
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
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