ServerActiveSandboxSet function for IBM Planning Analytics (TM1)
ServerActiveSandboxSet sets an existing sandbox as active for the user.
In this video, ServerActiveSandboxSet will be used to set an active sandbox for the user.
Where can the ServerActiveSandboxSet function be used?
TurboIntegrator
Which TM1 Server version is the ServerActiveSandboxSet function available for?
Version 11 and 12
What is the syntax for ServerActiveSandboxSet?
ServerActiveSandboxSet(SandboxName)
- SandboxName = Name of the sandbox to be set as active for the user. If blank, TM1 clears the active sandbox, returning the user to the TM1 database. If the sandbox does not exist, TM1 will return an error.
- Note
- As chores run in a special user context, so TM1 will always return an error when this function is executed by a chore.
- Sandboxes are a private space for users to work and insert values. These values are stored separately from the TM1 database.
- To use the values of an Active Sandbox during the TI execution, you can use the function SetUseActiveSandboxProperty(PropertyValue) with 1 as a parameter.
- A subset will continue ‘active’ after the process execution.
- Note
Relevant Functions
- GetUseActiveSandboxProperty = Returns a value that identifies if the process has read/write access to the base or active sandbox for the user
- ServerActiveSandboxGet = Returns the name of the active sandbox for the user
- ServerActiveSandboxSet = Sets an existing sandbox as active for the user
- ServerSandboxClone = Creates a sandbox that is a copy of an existing one
- ServerSandboxCreate = Creates a new Sandbox for the user
- ServerSandboxDiscardAllChanges = Discards all changes for a given sandbox owned by the user who executed the process
- ServerSandboxesDelete = Delete user sandboxes from the TM1 server (Admin use only)
- ServerSandboxExists = Checks if a sandbox exists for a user
- ServerSandboxGet = Returns the name of a user sandbox using an index
- ServerSandboxListCountGet = Returns the number of sandboxes a user has
- ServerSandboxMerge = Merges a source sandbox into a target sandbox for the user who executed the process
- SetUseActiveSandboxProperty = Set whether the process reads/writes cube data to the base or active sandbox for the user