Page 1 of 1
Sandbox and TI
Posted: Thu Mar 08, 2012 12:37 pm
by harrytm1
Hi all,
My users are asking the following scenario. He is using Sandbox to simulate some changes in Cube A, and has not committed the changes to base yet.
He now wants to trigger a TI to update another cube with respect to the data that he had just updated in Cube A in Sandbox.
Will then TI be applied to the sandbox version of the other cube with respect to the changes in Cube A that have not been committed to base? Or the TI will ONLY update data in base, not in Sandbox. Hence, it does not take into account of changes in Cube A's sandbox at all.
Look forward to your reply. Many thanks!
Harry
Re: Sandbox and TI
Posted: Thu Mar 08, 2012 1:30 pm
by tomok
harrytm1 wrote:Hi all,
My users are asking the following scenario. He is using Sandbox to simulate some changes in Cube A, and has not committed the changes to base yet.
He now wants to trigger a TI to update another cube with respect to the data that he had just updated in Cube A in Sandbox.
Will then TI be applied to the sandbox version of the other cube with respect to the changes in Cube A that have not been committed to base? Or the TI will ONLY update data in base, not in Sandbox. Hence, it does not take into account of changes in Cube A's sandbox at all.
Look forward to your reply. Many thanks!
Harry
Sandoxes are private to each user and, AFAIK, can not be accessed by a TI script. He'll have to commit those changes before you can do anything with them, server-side.
Re: Sandbox and TI
Posted: Mon Mar 12, 2012 2:47 am
by Andy Key
You can use ServerActiveSandboxGet/Set and Get/SetUseActiveSandboxProperty to make your TIs run on the active sandbox rather than the Base data.
Re: Sandbox and TI
Posted: Tue Sep 24, 2013 1:14 pm
by java_to_tm1
Be careful how you test this though.
In 10.1 (and in 9.5), TI processes when triggered from TM1 Web by an admin user, will always use Base Data.
TI processes when triggered from TM1 Web / Perspective by non-admin user, will default to using current sandbox, unless you explicitly set it to work with Base Data (Andy's comment above).
Interesting why TM1 does that.
Re: Sandbox and TI
Posted: Wed Sep 25, 2013 7:02 pm
by mvaspal
In Server Explorer, if you right click on the TI, you can select 'Use Active Sandbox' which will load data from and to the active sandbox.
But the ViewZeroOut function on the prolog tab ignores this setting; we found that data was cleared from the BASE version on the Prolog but loaded to the sandbox on the Data tab. So we needed an explicit 'SetUseActiveSandboxProperty' function before the ViewZeroOut in the code (v10.1.1 FP1)