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.
User's active sandbox
-
- Posts: 18
- Joined: Thu Sep 03, 2020 1:59 pm
- OLAP Product: TM1
- Version: 2.0
- Excel Version: office 365
User's active sandbox
- Attachments
-
- Sandbox.png (3.89 KiB) Viewed 5990 times
-
- MVP
- Posts: 1817
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: User's active sandbox
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.
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.
Declan Rodger
-
- Posts: 18
- Joined: Thu Sep 03, 2020 1:59 pm
- OLAP Product: TM1
- Version: 2.0
- Excel Version: office 365
Re: User's active sandbox
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.
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.
- Attachments
-
- Sandbox websheet.png (5.84 KiB) Viewed 5979 times
-
- MVP
- Posts: 1817
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: User's active sandbox
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.
Declan Rodger
-
- Posts: 18
- Joined: Thu Sep 03, 2020 1:59 pm
- OLAP Product: TM1
- Version: 2.0
- Excel Version: office 365
Re: User's active sandbox
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.
- Elessar
- Community Contributor
- Posts: 358
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: User's active sandbox
Hi,
Sandbox Synchronization for Action Buttons will be implemented in 2021 Q4: https://bigblue.aha.io/published/30f7b7 ... 10d?page=4
Sandbox Synchronization for Action Buttons will be implemented in 2021 Q4: https://bigblue.aha.io/published/30f7b7 ... 10d?page=4
-
- MVP
- Posts: 1817
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: User's active sandbox
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.
- Attachments
-
- Screenshot 2021-06-23 173958.jpg (73.57 KiB) Viewed 5952 times
Declan Rodger
-
- Posts: 18
- Joined: Thu Sep 03, 2020 1:59 pm
- OLAP Product: TM1
- Version: 2.0
- Excel Version: office 365
Re: User's active sandbox
Hi,
Thanks for the clear explanation.
However, published .XLSM files are not being shown in the workspace. (they are public).
Thanks for the clear explanation.
However, published .XLSM files are not being shown in the workspace. (they are public).
- Attachments
-
- PAW applications.png (4.3 KiB) Viewed 5727 times
-
- PAX files.png (37.33 KiB) Viewed 5727 times
-
- MVP
- Posts: 1817
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: User's active sandbox
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.
Declan Rodger