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
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.