How to Setup Data Locking?

1. In SpotlightXL, navigate to the Model >Model Administration > Data Locking.
2. Select the model that you want to lock. You will see the dimensions listed as column headings.
3. Use the drop-down under each dimension column to select the member(s) that you want to lock. If you select a parent-level member, all leaf level members under that parent will be locked, but the parent-level members will not be locked.
4. Click Save.

The following example locks all data in member combinations that include any leaf members in the Month-1 - PY-1 hierarchy in the Time dimension.

The following example locks all data in member combinations that include any leaf members in the Month-1 - PY-1 hierarchy in the Time dimension and locks all data in member combinations that include Actual in the Scenario dimension.

The following example locks all data in member combinations that include any leaf members in the Month-1 - PY-1 hierarchy in the Time dimension and Actual in the Scenario dimension.