Page 1 of 1
Update Sandbox with process
Posted: Tue Mar 24, 2015 3:17 am
by wang_chris
We have 2 cubes (ex, source cube and target cube), there is a process to deal with data in source cube then write into target cube.
Now, client make assumption in sandbox of source cube, how can we run the process on this particular sandbox level, and allow the client to see result in same sandbox of target cube?
Regards,
Chris
Re: Update Sandbox with process
Posted: Tue Mar 24, 2015 1:03 pm
by TrevorGoss
Hello Chris
how can we run the process on this particular sandbox level, and allow the client to see result in same sandbox of target cube?
One possible way of achieving this would be to run TI procsses after events have occured within Applications Web. For example, you can create a situation in which a TI is called after an end user commits some data.
A TI process could react to that commit event and transfer data from one Cube with a certian view to another one. you can use SandBox functions within TI to work with your sandboxes.
http://www-01.ibm.com/support/knowledge ... xFunctions
The link above is a link to the Sandbox functions.
This idea will only work with TM1 10.1 and upwards.
Trev
Re: Update Sandbox with process
Posted: Tue Mar 24, 2015 1:10 pm
by declanr
Last time I checked a "non admin" user running a TI process would always use the current sandbox version by default and an admin user however would always default to the base data; unless they use the "set sandbox" TI guff.
Re: Update Sandbox with process
Posted: Tue Mar 24, 2015 2:45 pm
by TrevorGoss
Hello Declan
unless they use the "set sandbox" TI guff.
Would you stay away from the sandbox functions then? I have never really used them for anything important.
Re: Update Sandbox with process
Posted: Tue Mar 24, 2015 8:43 pm
by declanr
TrevorGoss wrote:Hello Declan
unless they use the "set sandbox" TI guff.
Would you stay away from the sandbox functions then? I have never really used them for anything important.
It's not that as such; the functions are there for a reason - if they fit your requirement you use them but if my memory is correct and a process automatically picks up the current sandbox for a non admin user then the OP's question of moving data within a sandbox via TI is just answered via the standard functionality - and no extra work is always the best choice.
Re: Update Sandbox with process
Posted: Thu Mar 26, 2015 9:53 am
by TrevorGoss
It's not that as such; the functions are there for a reason - if they fit your requirement you use them but if my memory is correct and a process automatically picks up the current sandbox for a non admin user then the OP's question of moving data within a sandbox via TI is just answered via the standard functionality - and no extra work is always the best choice.
Indeed, thanks for the response.