TI Unlock

Post Reply
Tiger
Posts: 11
Joined: Wed Oct 14, 2009 10:44 pm
OLAP Product: TM1
Version: 9.0
Excel Version: 2003

TI Unlock

Post by Tiger »

Hi,

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

Thanks in advance.
lotsaram
MVP
Posts: 3702
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: TI Unlock

Post by lotsaram »

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.
Tiger
Posts: 11
Joined: Wed Oct 14, 2009 10:44 pm
OLAP Product: TM1
Version: 9.0
Excel Version: 2003

Re: TI Unlock

Post by Tiger »

Thanks for your reply lotsaram.

any example scripts for the API calls?

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