3772626 - Scripting help to lock particular cells in a table

- Data locking on specific cells in a table based on dimension values is required.

- User wants to lock the data based on condition.

SAP Analytics Cloud

1. Check the value of dimension if it is 1 lock month April.
2. If it is 2 lock month May.

For managing Data Locks in SAP Analytics Cloud, the two most relevant standard options for your scenario would be:

1. Multi Action
   You can use a “Data Locking” step inside a Multi Action to open, restrict, or lock specific data regions as part of an automated process flow.

2. Data Locking APIs 
    Data Locking APIs can be used to control lock states dynamically depending on the business logic .

These are the supported approaches for Data Lock management.

For more information you can refer to the following:

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/3eb77b325e264c4386d2a19a83d1c737.html#using-the-getdatalocking-api

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/169d66dc8a914fd4b792e3d3b91b9aa0.html#adding-a-data-locking-step

 

Additional information:
KBA 3658930 - Checkpoints: Data Locking in SAP Analytics Cloud (SAC)

KBA , LOD-ANA-PL-DE , Data Entry and Mass Data Entry , Problem

SAP Analytics Cloud 1.0