TM1 Forum

Hi there

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

Regards
Chris

When you say holds, do you means locks?

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

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:

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

Thx very much!!!
Will give it a try

Regards
Chris

Wim Gielis wrote: ↑Wed Dec 12, 2018 11:05 pm I guess that Tom is confusing holds and locks.

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

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.