TM1Info function for IBM Planning Analytics (TM1)

Where can the TM1Info function be used?

Which TM1 Server version is the TM1Info function available for?

What is the syntax for TM1Info?

• 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