SAP Knowledge Base Article - Public

3784528 - Workbook Permissions removed for some users after the July upgrade

Symptom

Before the July update, users with just Create & Read permissions for the Add-in Workbook, could create Excel Workbooks, go to Workbook > Preferences & change Workbook Permissions to: All users have designer rights.

This option has been removed after the upgrade.

Environment

SAP Analytics Cloud 1.0;

Reproducing the Issue

  • A user with only Create + Read permissions for the Add-in Workbook login to SAC add-in.
  • Click Workbook in the Ribbon.
  • -> Preferences.
  • He finds that the Workbook Permissions is no longer there.

Cause

There is a bug fix in July's upgrade:

- Title: Workbook permissions dropdown should be visible only to DESIGNER in preferences tab
- Detail: This addresses the visibility of the workbook permissions dropdown in the preferences tab. The dropdown is now restricted to users with the DESIGNER role. Previously, it could appear for other roles as well.

Regarding what is DESIGNER role, refer to the SAC Online help :

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD_OFFICE/2b73edbc8f8f4189a36bc7a2e038185c/9e5d840a4be94cb0a4ff9ddb174a08f9.html?q=designer

Resolution

The change was due to a bug fix. The current behavior is by design. You can grant the users DESIGNER role.

Keywords

KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem

Product

SAP Analytics Cloud 1.0