Allow users to add new dimension values to a cube sheet
This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.
Question
I have gotten recent requests from budget owners (not admins) to have the ability to create dimension values on a Cube sheet. What user profile should I use to enable that safely?
Answer
This can be accomplished via a permission in the user's role and through an additional option on the Cube sheet. You can create a unique role to assign to any Standard users who need this permission.
There is a permission called "Edit Dimension on Sheet." This box must be checked.
On the Cube sheet, the "Edit dimension on sheet" box must also be checked.
A dimension on a modeled sheet can also be made editable by following the above steps.