Holds via a Ti

Post Reply
chewza
Posts: 146
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Holds via a Ti

Post by chewza »

Hi there

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

Regards
Chris
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Holds via a Ti

Post by jim wood »

When you say holds, do you means locks?
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
chewza
Posts: 146
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Re: Holds via a Ti

Post by 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
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Holds via a Ti

Post by 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');
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Holds via a Ti

Post by 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
Last edited by Wim Gielis on Fri Mar 01, 2019 6:17 am, edited 1 time in total.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
chewza
Posts: 146
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Re: Holds via a Ti

Post by chewza »

Thx very much!!!
Will give it a try

Regards
Chris
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Holds via a Ti

Post by jim wood »

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.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Holds via a Ti

Post by 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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply