Input view immune from changes made in TI?

Post Reply
John Hammond
Community Contributor
Posts: 295
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Input view immune from changes made in TI?

Post by John Hammond »

Does Tm1 construct the entire view prior to loading it to a TI or does it construct it from the cube bit by bit.?

In the second case you would expect changes made in the TI to show in the data in the view and you would lose keys that you had zeroed out.

Did some tests which suggest that case 1 pre-build is the case but you can never be sure.

Does any kind soul have a definitive answer?
David Usherwood
Site Admin
Posts: 1454
Joined: Wed May 28, 2008 9:09 am

Re: Input view immune from changes made in TI?

Post by David Usherwood »

I'm not a big locking specialist (I focus on modelling oriented apps where locks typically get in the way) but I believe that the server locks the cube while the view is being built to preserve consistency. Behaviour is different with 9.5.2+ if PI is used but the consistency point still matters.
John Hammond
Community Contributor
Posts: 295
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: Input view immune from changes made in TI?

Post by John Hammond »

Thanks David. That answer fits with my experience.
Post Reply