TM1Info function for IBM Planning Analytics (TM1)

TM1Info returns information on the TM1 client. This function is valid only in Planning Analytics for Microsoft Excel and in Planning Analytics websheets. It is not supported in IBM TM1 Perspectives.

In this video, TM1Info will be used to get information about the TM1 client.

Where can the TM1Info function be used?

Excel

Which TM1 Server version is the TM1Info function available for?

Version 11 and 12

What is the syntax for TM1Info?

TM1Info(Property Name)

Property Name can be one of the following:
- clientversion – Returns the full client version number
- clientversionmajor – Returns the Major client version number
- clientversionminor – returns the minor client version number
- clientversionpatch – Returns the fix pack and hotfix number
- client – Returns the name of the client

Relevant Functions

TM1GlobalSandbox = Returns the active sandbox for the user
TM1Info = Returns information on the TM1 client
TM1PrimaryDBName = Returns the primary TM1 server name the user is authenticated in
TM1User = Returns the user logged in
TM1Val = A hierarchy-aware formula that reads, writes, or clears a cell which works with TM1 Web and IBM Planning Analytics for Excel