Symptom
- The SAP Analytics Cloud Excel Add-in does not allow opening reports saved in Workspaces, limiting access to reports to "My Files" only.
- Is there any ability to use the SAP Analytics Cloud Workspace with the SAP Analytics Cloud Excel Add-in?
Environment
SAP Analytics Cloud, add-in for Microsoft Office
Reproducing the Issue
- Open Microsoft Excel and ensure the SAC Add-In is installed and active.
- Log in to the SAC Add-In using valid credentials.
- Click on "Open" within the SAC Add-In to load an existing report.
- Confirm that the dialog only displays reports stored under "My Files".
- Attempt to locate and open a report that is saved in a Workspace and this is not possible.
Cause
- The current functionality for the SAP Analytics Cloud Excel Add-in is to only use either the local machine or a network share/one drive location for the SAC reports to be stored into and accessed from.
- Reference the 'Save and open workbooks' section within the SAP Analytics Cloud Excel Add-in online help.
"Save and open a workbook locally
You can use the Microsoft Excel functionality to save a workbook locally or on a public server, for example, Microsoft OneDrive."
Resolution
- The functionality for the SAP Analytics Cloud Excel Add-in to use the SAP Analytics Cloud workspace for the management of the SAC Excel Add-in reports does not exist.
- If this functionality is desired an enhancement request should be submitted to raise the visibility of this functionality to the SAP Analytics Cloud Excel Add-in Product Group so that this can be considered for a future release of the SAP Analytics Cloud Excel Add-in.
- See the KBA '3079294 - Enhancement Request for SAP Analytics Cloud, add-in for Microsoft Office' for information on submitting an enhancement request.
See Also
Refer to: Save and open workbooks
Keywords
sac add-in, sac excel add-in, workspaces, my files, report access, shared reports, sac tenant, sac workspace, sac reporting, sac collaboration, sac governance, sac planning, sac implementation, sac limitations, sac documentation, sac security settings , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem
Product
SAP Analytics Cloud all versions
SAP Knowledge Base Article - Public