TM1 9.1 Locks cases

Post Reply
Posts: 6
Joined: Mon May 19, 2008 8:57 pm
OLAP Product: TM1
Version: 9.4 FP2
Excel Version: 2003
Location: France, Paris

TM1 9.1 Locks cases

Post by Viet » Mon May 19, 2008 9:02 pm

Hi everyone,

I am glad to take part of this forum as I can see that interesting discussions are going on here.

I would like to know if anyone has a complete document about locks versus events in TM1 version 9.1: what is locked and when?

Thanks a lot.


User avatar
Mike Cowie
Site Admin
Posts: 444
Joined: Sun May 11, 2008 7:07 pm
OLAP Product: TM1, MSAS
Version: Anything thru 11.x
Excel Version: 2003 - 2016
Location: Alabama, USA

Re: TM1 9.1 Locks cases

Post by Mike Cowie » Mon May 19, 2008 9:20 pm

Hi Viet,

I'm not sure I'm clear about what you're asking.

Are you asking under what events the TM1 Server applies locks to objects? I don't think there is a good document out there, but maybe someone else has compiled one on their own. The 9.1 documentation may give some bits and pieces, but because Applix/Cognos has supposedly changed the locking model significantly in 9.1 (not that I've heard of it really looking that much different from other recent releases). It seems like it may be a moving target, by which I mean they may continue adjusting it and, thus, any detailed documentation may not be relevant from one service pack to another.

In general, it has seemed to me in the past that the following things will apply a server-type lock:
* Updating a value in a cube (very brief, but a lock does get applied)
* Saving TM1 Rules
* Saving TM1 Dimensions (fairly brief unless very large)
* Running TI processes that update dimensions/data and don't adjust the locking through the various locking/batch update functions to control that
* Replication/Synchronization

I probably missed something, but that's the general idea. The 9.1 locking I think may have become a little more granular whereby it supposedly locks objects more precisely (i.e., a cube vs. the entire server), but I have yet to test/see that proven out. Hopefully someone else can help you further, but this might give you some general guidance.


Post Reply