CellValueN function for IBM Planning Analytics (TM1)
CellValueN returns the numeric value of the specified element in a specified cube.
In this video, CellValueN is used to retrieve data from Value to TestN in the Product Scorecard cube.
Where can the CellValueN function be used?
Rules
Which TM1 Server version is the CellValueN function available for?
Version 11 and 12
What is the syntax for CellValueN?
CellValueN(Cube, element1, element2…..)
- Cube = Cube name
- Element1, Element 2 = Element name within each dimension from the cube
Relevant Functions
- CellValueN = Returns the numeric value of the specified element in a specified cube
- CellValueS = Returns a string attribute for a specified cube