Rule Functions

TM1 Function for Rules – CELLVALUES

Available In

Rules

Definition

​CELLVALUES returns the string value of the specified element in a specified cube.

Syntax

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

Cube = Cube name

Element1 = Element name within the dimension.

Element2 = Element name within the dimension. 

Video Demo

Use CellValueS function to retrieve the string value from cube and apply it in the rule to populate the Comment measure in the Product Scorecard cube.