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].


Video Demo