Update Sandbox with process

[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

[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

[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.

[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.

[declanr]

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.

[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.