ServerSandboxListCountGet function for IBM Planning Analytics (TM1)
ServerSandboxListCountGet returns the number of sandboxes a user has.
In this video, ServerSandboxListCountGet will be used to return the number of sandboxes the user has.
Where can the ServerSandboxListCountGet function be used?
TurboIntegrator
Which TM1 Server version is the ServerSandboxListCountGet function available for?
Version 11 and 12
What is the syntax for ServerSandboxListCountGet?
ServerSandboxListCountGet(Username)
- UserName = Optional parameter with a user’s name to check if the sandbox exists. If blank, TM1 will check the user who is running the process. When not blank, this parameter only works if an Admin, DataAdmin or the given user is running the process. If not, TM1 will return an error.
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