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.