TM1 Forum

Hi,

Is there a way to programmatically unlock an element via TI or other?

Thanks in advance.

You can programatically lock/unlock a cube with TI by writing to }CubeProperties

As I am guessing you have discovered you can programatically lock an element by writing to the }ElementProperties_Dimension cube but you cannot programatically UNLOCK the same element once that element is locked since the dimension is used in the element properties cube!

Potentially you could programatically unlock an element via API with a custom application but I haven't ever tried this and API security calls have historically tended to be somewhat unreliable.

Another (untried) approach might be to create a replica dimension and custom control "element properties" cube holding entered statuses (lock, reserve, hold, etc) and then write a rule in the element properties cube itself. Warning on this one - I'm not sure what this might do in terms of stability etc but if you try it and it works please post back to the forum.

Thanks for your reply lotsaram.

any example scripts for the API calls?

Stability is quite important so I wont be trying your second suggestion.