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.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book