Page 1 of 1

Input view immune from changes made in TI?

Posted: Mon Mar 25, 2013 12:29 pm
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?

Re: Input view immune from changes made in TI?

Posted: Mon Mar 25, 2013 11:22 pm
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.

Re: Input view immune from changes made in TI?

Posted: Tue Mar 26, 2013 8:25 am
by John Hammond
Thanks David. That answer fits with my experience.