Hi,
Is there a way to programmatically unlock an element via TI or other?
Thanks in advance.
TI Unlock
-
- 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
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.
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.
-
- Posts: 11
- Joined: Wed Oct 14, 2009 10:44 pm
- OLAP Product: TM1
- Version: 9.0
- Excel Version: 2003
Re: TI Unlock
Thanks for your reply lotsaram.
any example scripts for the API calls?
Stability is quite important so I wont be trying your second suggestion.
any example scripts for the API calls?
Stability is quite important so I wont be trying your second suggestion.