Question Re: Data Locking in Technology Q&A

Data Locking

119ms — Mon, 25 Sep 2023 13:12:50 GMT

Hi all,

I need to write the amounts on the Total column (the parent in my hierarchy), and it should be spread only on Top-down adj (bottom-up adj has been locked in the model with data locking). But when I write some numbers, the following error appears:

This does not happen if I already have some values on Top-down adj. In this case data locking works properly.

Is it mandatory to have some values on the column Top-down adj to make it work?

Otherwise, do you have any suggestions or an alternative solution?

Thank you,

Martina

Re: Data Locking

vishalakshmi — Mon, 25 Sep 2023 19:31:59 GMT

Hello Martina,

It's not mandatory to have some values in the Top-down adjustment column for data locking to work. Data locking should function independently of whether there are existing values in the Top-down adjustment column.

First, ensure that you have the correct data locking settings configured for your model. Check if you've set up the data locking rules properly, especially for the Total column.
Review your hierarchy settings to ensure that the hierarchy is correctly defined, and there are no issues with the parent-child relationships.
Verify if the data you're trying to input into the Total column adheres to any constraints or business rules that might have been defined in the model.
Ensure that your SAC instance is up-to-date. Sometimes, issues like these are addressed in newer releases or updates.

Alternate solutions:

Implement data validation rules in SAC to ensure that the data entered in the Total column adheres to your business rules and constraints.
Double-check your data model and hierarchies to ensure there are no inconsistencies or issues in the way data is structured.

Can you check the below links:

https://userapps.support.sap.com/sap/support/knowledge/en/2853893

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/24c7eb623b4249c0ae1d78150a429f09.html

Thanks,

Lakshmi.

Re: Data Locking

119ms — Tue, 26 Sep 2023 07:21:04 GMT

Hi,

this is how I set my data locking. Is it correct?

Re: Data Locking

N1kh1l — Tue, 26 Sep 2023 11:54:07 GMT

119ms

How is your model disaggregation behavior set to ? It should be set to be based on data locking

Once this is enabled in model preference, please check the planning properties of the table in designer view

This is how it should behave.

Please see below for more details.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/89f07ff7386840f3950bde8f3afa1e6b.html

Br.

Nikhil

Re: Data Locking

119ms — Tue, 26 Sep 2023 12:36:12 GMT

Hi,

yes, all these options are enabled. But it's not working.

Thank you