Symptom
- Columns in the table were locked to prevent end users from making changes, while other columns were left open and editable.
- When a user attempts to lock a cell in an editable column, the locking functionality fails, and the entered data gets distributed to all cells, including the locked ones.
Environment
SAP ANALYTICS CLOUD
Cause
Users cannot apply or change data locks in SAP Analytics Cloud (SAC) when Data Locking is not properly configured, required driving dimensions are missing, the user lacks a Planning license, or permissions/ownership for data locking are insufficient.
Resolution
- Enable Data Locking – In the planning model settings.
- Configure Driving Dimensions – Define dimensions controlling lock evaluation .
- Configure Ownership(Optional) – Enable Data Locking Ownership and assign owners if needed.
- Verify User License – Ensure Planning Standard or Professional license.
- Check Permissions – Confirm ownership assignment or Update permission for data locking.
- Manage Locks in Story – Use “Manage Data Locks” once configuration and permissions are set.
See Also
Configuring Data Locking | SAP Help Portal
3229615 - Users with the data locking maintain permission of the data locking cannot change the state of data locks in SAP Analytics Cloud for Planning (SAC) - SAP for Me
Keywords
SAP Analytics Cloud, SAC, Data Locking, Data Lock Ownership, Planning Model, Manage Data Locks, Lock State, SAC Planning Permissions, SAC License , KBA , LOD-ANA-PL-DLK , Data Locking , How To
SAP Knowledge Base Article - Public