CellValueN

CellValueN returns the numeric value of the specified elements in a cube. This function is valid only in rules. Use of this function in a TurboIntegrator process will result in an error. Use of this function in a TurboIntegrator process will result in an error.

For dimensions not among the element parameters, coordinates are retrieved from the rule target (the cell being retrieved and triggering rule evaluation). The function behavior is analogous to the intra-cube reference expression (e.g. [ 'Measures':'Count' ] ), as used in the formula component of a rule .

The element parameters may be specified in any order, and for CellValueN, multiple elements from the same dimension (but different hierarchies of the dimension) may be specified. Since the elements list is not required to be in cube dimension order, it is necessary to dimension-qualify all element parameters. Element parameters from multi-hierarchy dimensions must also be hierarchy-qualified.

Syntax

CellValueN(cube, element1,..., elementN);

Argument	Description
cube	Name of the cube.
elementN	Element name that defines the cell. A minimum of one element must be specified.

Example

CellValueS('ForecastCube', 'Products':'ProductsByChannel':'Channel2', 'Measures':'Count');

This example returns the numeric value of the specified cell. The Products dimension has multiple hierarchies while the Measures dimension has one hierarchy.

The intra-cube reference is restricted to literal parameters, while CellValueN is not. This behavior is analogous to the DB() rules function. The element parameters may be specified using string-valued expressions. For example, the previous Products element parameter could be specified as:

'Products' : 'ProductsByChannel' : AttrS( … )

Unlike DB() and the intra-cube reference expression, CellValueN element parameters must be either dimension-qualified, or dimension and hierarchy qualified.