Excel Functions

TM1 Function – TM1PRIMARYDBNAME

Available In

Excel

Definition

Returns the primary TM1 server name the user is authenticated in. Use this function to easily migrate reports between TM1 Servers.

This function is valid only in Planning Analytics for Microsoft Excel and in Planning Analytics websheets. It is not supported in IBM® TM1® Perspectives.

Syntax

TM1PRIMARYDBNAME()

It doesn’t accept any arguments

Example

Use TM1PRIMARYDBNAME to obtain the TM1 server name.

In Excel:

TM1PRIMARYDBNAME() returns AdventureWorks.


Video Demo