Symptom
The following behavior occurs in SAP Analytics Cloud for Planning (SAC):
- Data Locking is active. However, in the table of the story it looks like Data Locking status of the cell is open.
- If user tries to plan data, an error message pops up: "Data cannot be changed because they refer to one or more elements that lie outside the planning area of this version" and the locked data are shown.
Environment
SAP Analytics Cloud 1.0
Reproducing the Issue
- Open the story
- Try to enter data in a cell
- Error message pops up : "Data cannot be changed because they refer to one or more elements that lie outside the planning area of this version"
- The locked data are shown.
- From the model, check the data locking status and notice that it's locked
Cause
The issue is caused by the fact that attributes of the dimension are present on the axes.
Data Locking is not able currently to display locks and set the input enablement on the cells when the attributes of some of the driving dimensions are on the axes.
Although locks are not shown and input enablement not set, a validation of the locks will be checked on publish as well as on data entry such that no locked cells will be changed.
If a LOCKED cell is being edited the change will be rejected and error shown as indicated.
Resolution
Creating calculated dimensions in the story with the formula :
[d/dimension].[p/dimension attribute]
These dimensions can be added to the axes and once the dimension properties are removed from the axes the locks can be shown and the input enablement will work as expected.
Keywords
Data locking, locked cell, planning area, dimension attribute , KBA , LOD-ANA-PL-DLK , Data Locking , Problem
SAP Knowledge Base Article - Public