TM1Val function for IBM Planning Analytics (TM1)

Where can the TM1Val function be used?

Excel

Which TM1 Server version is the TM1Val function available for?

Version 11 and 12

What is the syntax for TM1Val?

TM1Val(Datasource URI, Server, Cube, Mode, WriteValue, Cube Intersection)

• Datasource URI: Host that points to the datasource URI
• Server: Server Name
• Cube: Cube Name
• Mode: 0 = Read, 1 = Write, 2 = Clear
• WriteValue: Value to send when the Mode is set to 1
• Cube Intersection: [Dimension].[Hierarchy].[Element]
  If there are no dimensions, the default hierarchy and default member for each dimension in that cube will be used

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