Lock dimensions in Planning Analytics Workspace

You can now lock dimensions in Planning Analytics Workspace.

A user must have either Admin or Lock privilege for a dimension to lock the dimension.

When a user locks a dimension, only those users who have Admin rights for that dimension can modify the dimension. Even the user who locks the dimension cannot modify it, unless they have Admin rights for that dimension.

When a dimension is locked, options are disabled for these actions:
  • Add members to any of the hierarchies in the dimension
  • Remove members from any of the hierarchies in the dimension
  • Create a hierarchy in the dimension
  • Delete a hierarchy in the dimension

Users can create, delete, or update subsets under any locked dimension.

To lock a dimension, right-click the dimension on the Databases tree in either a book or a modeling workbench, then click Lock dimension. A lock icon Dimension icon with a lock image superimposed to indicate that the dimension is locked on the dimension name indicates that the dimension is locked.

A lock icon on the header of the new experience dimension editor also indicates that the dimension is locked.

Locked dimension header

If a dimension is locked while it is open in the new experience dimension editor, you must refresh the dimension editor to see the lock icon.

To unlock a dimension, right-click the dimension on the Databases tree in either a book or a modeling workbench, then click Unlock dimension.