SAP Knowledge Base Article - Public

3688262 - It is not possible to open reports saved in workspaces using the sac excel add-in

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

  1. Open Microsoft Excel and ensure the SAC Add-In is installed and active.
  2. Log in to the SAC Add-In using valid credentials.
  3. Click on "Open" within the SAC Add-In to load an existing report.
  4. Confirm that the dialog only displays reports stored under "My Files".
  5. 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