TM1 Forum

Hi,

I want some advice on how to refer to a sandbox in excel.

We have lots of users updating TM1(to the base) from excel.
We they create Sandboxes, is there are a way to reference the sandbox name and update values via excel.

I created a view in Tm1 and a couple of sandboxes for the same view. And then too a slice to excel.
When I update the sandbox cell it updates what ever is open is TM1, or the base.
There is no reference in the DBRW/DBSS formulas to refer to the Sandbox.

Could anyone please advice, if you know a way of updating Sandboxes or refering the sandbox name via excel.

Thanks in advance.

I haven't tried it myself, but it looks like using the TI command ServerActiveSandBoxSet via an Action Button would do what you want.