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