Symptom
After adding a new member in the table, the locked cells turn to showing as unlocked (Open state). But when users start to publishing data on these "unlocked" cells, an error occurs:
Sorry, we could not update the member values with your data entries. The restriction is due to data locking. For more information, see our troubleshooting page.
Environment
SAP Analytics Cloud Version 2024.8.8.
Reproducing the Issue
- Open a planning story.
- Select a combination that has the Locked state.
- Click to add members in the table.
- After the member is added, the Locked state is changed to Open.
- Try to enter and publish the value.
- The error occurs: Sorry, we could not update the member values with your data entries. The restriction is due to data locking. For more information, see our troubleshooting page.
Cause
The default lock state defined for the underlying model is Open. (Check via Model Preferences -> Access and Privacy.)
So the new members added to the table will get the default state, namely Open.
With both Locked and Open members, in the story, the Mixed state is shown.
Mixed state will display as editable because we have a mechanism to distribute the values to the members that are Open.
Resolution
- Use the default lock state Locked for Data Locking
- This would mean that all new members coming in with master data updates will get the default lock state Locked
- This would mean that all new members coming in with master data updates will get the default lock state Locked
- Remove other dimensions and leave Date & Version as driving dimensions.
- This option is appropriate only if your locks are driving by date and versions alone, and you always have the same lock state for all other dimension members.
- Under this option, both default lock states Open and Locked could be used.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud > Learning > Data Connections
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
edit, change, locking state, data entry, update members, publish error, data locks, data locking, locking data. , KBA , LOD-ANA-PL-DLK , Data Locking , Problem