SAP Knowledge Base Article - Public

3041852 - Data locking owner able to unlock and edit data even when parent locked in SAP Analytics Cloud


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.


  • SAP Analytics Cloud (Enterprise)

Reproducing the Issue


This is a behavior by design of the product with some limitations.


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

Your feedback is important to help us improve our knowledge base.


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,, 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


SAP Analytics Cloud 1.0