Symptom
SAP Analytics Cloud (SAC) for Planning users assigned as data lock owners to a slice of data seem to be capable of changing the status from "Locked" to "Open" or "Restricted", even if parent dimension members which include that slice of data are still set to "Locked". Once the data lock owner has changed the status to "Open" or "Restricted", they are then able to change the data, even if that causes the the overall value at the parent level to change as well.
Environment
- SAP Analytics Cloud (Enterprise)
Reproducing the Issue
Cause
This is a behavior by design of the product with some limitations.
Resolution
Below some of the aspects of the data locking functionality:
1. Locks states on non-leaf (parent) nodes are inferred based on the locks states of their children.
That means:
- The lock state of the DAN_OPS for example is summed up based on the lock states of DAN_GLOBAL, GRPBAL_MED and AMERICAS. In the similar way the locks state of AMERICAS is based on the lock states on its children
- If all the children of a node have the same lock state, the parent node has exactly the same lock state.
- If the children have different lock states, the parent will have a so called MIXED states (also marked as read-only in the story for the data entry)
2. Changing/Setting a lock state on the parent node will push down the locks to the children, where they will be persisted.
- Similarly, changing a lock state on the lower levels will have an impact on the higher levels. That is, we do not have locks for the higher level nodes independent of the locks from the levels underneath.
We have designed it in this way as you all your data as stored at the leaf levels and aggregated up the hierarchies. Essentially it would make no sense to have node being LOCKED while one or more of their children are OPEN: if you would edit such a open child, the data would be aggregated upwards anyway and the value of the "LOCKED" parent would change anyway.
If you are looking for a mechanism that would aim to force the user to edit only on lower levels than you should consider Data Access Control or Value Locks.
With respect to the ownership, this is meant to:
1. Allow the users to edit data for slices marked s RESTRICTED (which becomes for owners and managers essentially OPEN)
2. Offer restrictive permissions with respect to who can change a lock state. That is:
- An owner of a slice can change the lock state in direction OPEN -> RESTRICTED -> LOCKED but not in the other direction
- A manager can change the lock state in both directions
It is important to note:
1. An owner of a node becomes a manager of all children.
2. If you set an owner of a non-leaf node:
- the user will become a manager of the children, meaning that the user is allowed to change locks freely
- as it can change locks freely for the children and the lock state of the parent is inferred based on the locks of the children, it essentially means that the user can change locks freely for the owned node as well. So owners of non-leaf nodes become essentially managers of those nodes, while owners of leaf nodes stay just owners of these nodes.
And this is why the user can set the locks states back to open. As the user owns non-leaf node implicitly becomes a manager , hence the user can change the locks state to OPEN. We are currently working to extend this feature and provide a more restrictive handling of such cases but this is still in inception phase and not yet on any roadmap.
See Also
- How to setup an E2E planning process with SAP Analytics Cloud
- Set Up Data Locking
- 2988274 - The users with Admin role cannot publish their changes to public versions when the data region is locked
- 2424376 - How to create an enhancement request for SAP Analytics Cloud?
- 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?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using SAP for Me, Google or Bing:
- https://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
- https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.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 Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
SAP Cloud for Planning , sc4p , c4p , cforp , cloudforplanning , Cloud for Analytics , Cloud4Analytics , CloudforAnalytics , Cloud 4 Planning , BOC , SAPBusinessObjectsCloud , BusinessObjectsCloud , BOBJcloud , BOCloud. , SAC , SAP AC , Cloud-Analytics , CloudAnalytics , SAPCloudAnalytics , by design , limitation , DL, Data Locking, leaf, parent, status, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software epm, business intelligence, , KBA , LOD-ANA-PL-DLK , Data Locking , Problem