TM1 Function for Rules, CELLVALUEN
CELLVALUEN returns the numeric value of the specified element in a specified cube.
Where can the CELLVALUEN function be used?
Rules
What is the CELLVALUEN function?
CELLVALUEN returns the numeric value of the specified element in a specified cube.
What is the syntax for CELLVALUEN?
CellValueN(Cube, element1, element2…..);
Cube = Cube name
Element1 = Element name within the dimension.
Element2 = Element name within the dimension.
A demonstration on how to use CELLVALUEN
Use CellValueN to retrieve data from Value to TestN in the Product Scorecard cube.