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.
