TM1 Forum

Hi all,

I am having trouble with getting the TI process to use a user’s active sandbox data.

Consider the following case.
I have a TI process where SetUseActiveSandboxProperty(1) is activated. The TI process is triggered from PAW, where the users sandbox is selected. The TI process does not recognise the selected sandbox in PAW as the active sandbox. I checked this with ServerActiveSandboxGet(). For now I can only hardcode that the sandbox must be used via ServerActiveSandboxSet('BU adjustments').

Basically my question is, how can a user set their active sandbox? Selecting it in PAW is not working.

In PAW when you select a sandbox, you are selecting it for a widget rather than the whole session.
You can have it also apply to other widgets by using the Synchronization settings.
But I don't think Process Buttons in PAW have synchronization options that are capable of syncing sandboxes.

If the above is the case, there will be a few workarounds you could try but I would recommend raising it as missing functionality to IBM.

1 workaround - You could use a Websheet which is synced for sandboxes and have the action button in there.

Thanks for the quick response, I will raise a suggestion with IBM for syncing sandboxes on process buttons.

About the workaround.
How do I publish a Websheet with an action button? When published .xlsx files are not shown in the application folder. Also, when selecting the sandbox in excel it is the same as for the workspace. It is not set for the whole session.

They need to be saved as XLSM to include buttons nowadays... I think it is supposed to prompt you to save as XLSM first when you try and publish.

declanr wrote: ↑Wed Jun 23, 2021 10:09 am They need to be saved as XLSM to include buttons nowadays... I think it is supposed to prompt you to save as XLSM first when you try and publish.

Apologies, I meant xlsm.
xlsm files are not shown in the application folder in paw.
And I do not think this workaround will work, sinse pax has the same issue.

Hi,

Sandbox Synchronization for Action Buttons will be implemented in 2021 Q4: https://bigblue.aha.io/published/30f7b7 ... 10d?page=4

fstuyck wrote: ↑Wed Jun 23, 2021 11:39 am Apologies, I meant xlsm.
xlsm files are not shown in the application folder in paw.
And I do not think this workaround will work, sinse pax has the same issue.

When you publish from within PAX you need to make sure to tick "make public" etc but any XLSM file should definitely show up in PAW if you successfully publish it. You need to make sure that PAW is configured to point towards your TM1 Web server so that it can actually render the websheet, but even if not configured you can still drag in websheets - they just render as a white page.

In terms of getting it to work I did a very small basic test with a single TI in a websheet, set to change a single cell and with the active sandbox property set.
On a PAW sheet I have a cubeview (exploration), set to sync sandboxes.
And the websheet, also set to sync sandboxes.

In the cubeview I created a sandbox. Then ran the TI process and it updated the value in the cube against the sandbox - showing in blue.

Hi,

Thanks for the clear explanation.

However, published .XLSM files are not being shown in the workspace. (they are public).

fstuyck wrote: ↑Mon Jun 28, 2021 7:47 am Hi,

Thanks for the clear explanation.

However, published .XLSM files are not being shown in the workspace. (they are public).

I *think* that blue arrow symbol you have is for when it has been published with "add file as a reference" selected.
If you try it without ticking that, they should show in PAW.