Holds via a Ti

[chewza]

Hi there

Does anyone know if it is possible to do holds via a Ti?

Regards
Chris

[jim wood]

When you say holds, do you means locks?

[chewza]

Hi

So if you are in Perspectives/Architect, you can right click a consolidated value, and do Holds - eg hold leaf, hold consolidated.
Want to be able to do some of this via a Ti.

Regards
Chris

[tomok]

Of course you can do this via TI. You just need to CELLPUTS the name of the ID to hold the lock to the }ElementProperties cube, like this:

Code: Select all

CUBELOCKOVERRIDE(1);
CELLPUTS('admin', sPropertiesCube, pElement, 'LOCK');

[Wim Gielis]

Hello,

I guess that Tom is confusing holds and locks.

A hold can be applied through TI by placing a 'C' or 'H' in the relevant control cube.
TM1 creates a control cube for any cube where holds are applied.
When holds are released that cube is cleared, but not thrown away.

When a hold is applied, TM1 writes a 'C' or 'H' in the relevant cell of the control cube.
'C' for holding a consolidated value, 'H' for holding a leaf value.

Therefore, doing a simple CellPutS of 'C' or 'H' should be enough.
However, the control cube should exist first in order to do that. You will want to make sure that this is the case, if not, do a CubeCreate action with the needed dimensions.

I invite you to do a couple of holds manually, and see what cubes are created and how they are populated. Cubes will start with }Hold_
and will contain the original cube name (of course) but also the name of the user applying the hold.
It could be possible that you need to loop over Hold cubes to inspect whether a certain application cube has values that are held constant - also looking at who is holding the lock.

More information: http://www.tm1forum.com/viewtopic.php?t=3659

[chewza]

Thx very much!!!
Will give it a try

Regards
Chris

[jim wood]

I guess that Tom is confusing holds and locks.

Which is why I asked instead of being presumptuous and going straight to it.

[tomok]

Yes, I can confirm that I thought the user was talking about a lock and not a hold, which is why I gave that example. My mistake. I wasn't being presumptuous, just guilty of not paying complete attention to the user's question.