Excel Functions
TM1 Function – TM1GLOBALSANDBOX
Available In
Excel
Definition
TM1GLOBALSANDBOX returns the active sandbox for the user.
Syntax
TM1GLOBALSANDBOX(TM1ServerName)
TM1ServerName = Name of the TM1 Server
Example
Get the active sandbox from the AdventureWorks TM1 Server.
Use TM1PRIMARYDBNAME() to get the TM1 Server name. Alternatively, you could type the name manually.
Rename the cell reference to pServer.
This will allow the worksheet to dynamically obtain the TM1 Server.
Add the function TM1GLOBALSANDBOX(pServer)
e.g. TM1GLOBALSANDBOX(“AdventureWorks)
The active sandbox returned is [base].