SAP Knowledge Base Article - Public

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

Symptom

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".

Environment

SAP Analytics Cloud

Cause

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. 

Resolution

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

See Also

Standard Application Roles - SAP Help Portal

Keywords

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

Product

SAP Analytics Cloud 1.0