TM1Val function for IBM Planning Analytics (TM1)
TM1Val is a hierarchy-aware formula that reads, writes, or clears a cell, and it works with TM1 Web and IBM Planning Analytics for Excel.
In this video, TM1Val will be used to read, clear and write to a cell at the lowest cell level and consolidate.
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