Configuring Data Locking
Data locking lets you specify areas of model data that cannot be changed by planning operations or by importing data from files or data sources.
Prerequisites
- Data Locking must be enabled in the model preferences. For more information, see Model Preferences.
- You must have the appropriate permissions to configure data locking. For example, users with the Modeler role are granted these permissions. If you are a data lock owner, you can open the Data Locking page and change the state of locks that you own with the Planner Reporter role. For more information, see Permissions.
Context
You configure data locks in a grid layout, by choosing driving dimensions and setting combinations of their members as locked, open, or restricted.
In a story, locked and restricted cells for public versions appear as read-only, and cannot be changed by data entry or other planning operations.
Optionally, you can also delegate ownership of the data locks on members of a dimension. Data locking owners can change the state of the locks that they own. As well, restricted data is treated as open data for its data locking owners.
-
They can make changes to restricted data.
-
They can set locks to a more restrictive state, for example, Open to Restricted, or Restricted to Locked.
-
For members that are children or descendants of the member that they own, they become data locking managers. They can open restricted or locked data that they manage. For example, as the data locking owner for Footwear in EMEA, you become the data locking manager for Sneakers in Germany. You can't change the overall value for Footwear in EMEA once it's locked, but you can unlock different products and countries to change the distribution of that value.
If you're using data locking frequently in your planning processes, you can create a data locking task in the calendar to establish a schedule and coordinate with data locking owners. See Creating Data Locking Tasks for details.
For example, if your organization is carrying out a forecast across different regions for 2018 Q4, this feature allows you to lock all the model data for regular users, and grant permission only to regional managers to update their own region’s data for the Forecast version in 2018 Q4. For a detailed workflow based on this example, see Example: Applying Data Locks to a Regional Forecast.
-
Data locks do not apply to users with the Admin role, or the user who created the model. These users can always publish their changes to public versions, even if they affect locked data.
-
Users with the appropriate permissions can also configure data locks in a story. To do so, select a table that shows the relevant data and choose . For more information, see Table Menu Options on Story Pages.
-
Users working with a table in a story can also apply value locks, which are a separate feature from data locks. For more information, see About Value Lock Management.
Procedure
Results
The data locks that you configured are applied to the model data in stories.
For the dimensions that have data locking ownership enabled, the Data Locking Owner column is added in the Modeler. You can add data lock owners for each member by adding their IDs in this column.