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

Which TM1 Server version is this function available for?

Version 11 and 12

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.