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
Sandbox and TI
-
harrytm1
- Regular Participant
- Posts: 226
- Joined: Thu Apr 02, 2009 2:51 pm
- OLAP Product: IBM Planning Analytics
- Version: Latest version
- Excel Version: 2003 to 2019
Sandbox and TI
Planning Analytics latest version, including Cloud
-
tomok
- MVP
- Posts: 2836
- 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: Sandbox and TI
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.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
-
Andy Key
- MVP
- Posts: 352
- Joined: Wed May 14, 2008 1:37 pm
- OLAP Product: TM1
- Version: 2.5 to PA
- Excel Version: Lots
- Location: Sydney
- Contact:
Re: Sandbox and TI
You can use ServerActiveSandboxGet/Set and Get/SetUseActiveSandboxProperty to make your TIs run on the active sandbox rather than the Base data.
Andy Key
-
java_to_tm1
- Posts: 33
- Joined: Mon Sep 23, 2013 3:24 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: Excel 2010
Re: Sandbox and TI
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.
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.
The Java_to_TM1 Convert
TM1 Version 10.1, 10.2, Cognos Insight 10.1, 10.2
Local: Windows 7 Professional, Excel 2007
Server: Windows Server 2008 64-bit
p.s. I have a healthy disregard for Performance Muddler.
TM1 Version 10.1, 10.2, Cognos Insight 10.1, 10.2
Local: Windows 7 Professional, Excel 2007
Server: Windows Server 2008 64-bit
p.s. I have a healthy disregard for Performance Muddler.
-
mvaspal
- Community Contributor
- Posts: 341
- Joined: Wed Nov 03, 2010 9:16 pm
- OLAP Product: tm1
- Version: 10 2 2 - 2.0.5
- Excel Version: From 2007 to 2013
- Location: Earth
Re: Sandbox and TI
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)
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)