Data locking in measures

[Ganjos]

Hi,

I’m working on a project where I need to lock three specific measures. My model consists of two dimensions and four measures, but I want to ensure that no one can edit three of those measures.

Is there a way to lock these specific measures? What approach should I take to solve this?

Thanks in advance,

GAnjos

[William_Yu1 · Accepted solution]

You can configure and use SAC data lock feature to lock 3 measures. please check this help page for details:

 https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/e07d46e950794d5a928a9...

[Ganjos · Accepted solution]

Thanks for the reply. Do you have any example? I can only see this working through driving dimensions, but I just want to lock 3 and leave one open for editing.

[William_Yu1 · Accepted solution]

I'm not sure what example you need, but you can just add measure as locking dimension in data locking configuration screen, and then you shuld be able to lock 3 measures as part of standard functionality.

[Ganjos · Accepted solution]

Sorry, I'm kinda new to SAC. I didn’t notice the measures in the last line; I only saw dimensions and assumed it was only for dimensions. Thanks for your answer!

[david_ings]

Hello,

If it's front end changes you want to prevent, then you can use a styling rule to set some of the measures to "read only", while allowing others to be editable.

David

[Ganjos]

Thanks for the reply,

[Ganjos]

Thanks for the reply, but if it's about 1000 lines of data, there must be a way to lock them.