TM1Val function for IBM Planning Analytics (TM1)

Where can the TM1Val function be used?

Which TM1 Server version is the TM1Val function available for?

What is the syntax for TM1Val?

• 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