TM1 Function for Rules, CELLVALUEN

CELLVALUEN returns the numeric value of the specified element in a specified cube.

Available In

Rules

Definition

CELLVALUEN returns the numeric value of the specified element in a specified cube.

Syntax

ellValueN(Cube, element1, element2…..);

Cube = Cube name

Element1 = Element name within the dimension.

Element2 = Element name within the dimension. 

Video Demo

Use CellValueN to retrieve data from Value to TestN in the Product Scorecard cube.