CellValueS

CellValueS returns the string value of the specified element(s) in a cube. This function is valid only in rules. 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 on formula portion of a rule statement.

The element parameters may be specified in any order, and for CellValueS, 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

CellValueS(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':'Location');

This example returns the string 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 CellValueS 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, CellValueS element parameters must be either dimension-qualified, or dimension and hierarchy qualified.