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 :
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
SAP Knowledge Base Article - Public