SAP Knowledge Base Article - Public

3153226 - Data Locking from SAC Planning Calendar not available for Excel Add-in


Executing a Data Locking Task in the Planning Calendar locks the respective cells/dimensions in the Story/Model for Data entry.  

This works correctly when using SAC UI, all relevant cells have their values greyed out and locked. 
This does not seem to work in the XLS Add-in, where values can be entered in cells corresponding to locked data regions and directly published to the Model from the "restricted cells/dimensions".


SAP Analytics Cloud


The lock should be enforced and publish should be restricted as long as the user is not an Admin, because an Admin user can bypass the publish.

In SAC Add-In if you enable Planning Area based on Data Locks, then even the process data should block preliminary entry. 


Please ensure that the user is not ADMIN, as per Standard Application Roles - SAP Help Portal

See Also

Standard Application Roles - SAP Help Portal


KBA , LOD-ANA-PL , Planning , Product Enhancement


SAP Analytics Cloud 1.0