TM1 Function for Rules, CELLVALUES

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

Where can the CELLVALUES function be used?

Rules

Which TM1 Server version is this function available for?

Version 11 and 12

What is the CELLVALUES function?

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

What is the syntax for CELLVALUES?

CellValueS(Cube, element1, element2…..);​
​Cube = Cube name​
Element1 = Element name within the dimension.​
Element2 = Element name within the dimension. 

A demonstration on how to use CELLVALUES

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.