CELLVALUEN returns the numeric value of the specified element in a specified cube.
Where can the CELLVALUEN function be used?
Rules
What is the CELLVALUEN function?
CELLVALUEN returns the numeric value of the specified element in a specified cube.
What is the syntax for CELLVALUEN?
CellValueN(Cube, element1, element2…..);
Cube = Cube name
Element1 = Element name within the dimension.
Element2 = Element name within the dimension.
A demonstration on how to use CELLVALUEN
Use CellValueN to retrieve data from Value to TestN 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