CellGetS

CellGetS retrieves a value from a string cube cell.

This function is valid in TM1® TurboIntegrator processes only.

Syntax

CellGetS(Cube, e1, e2 [,...en]);

Argument	Description
Cube	The name of the cube from which you want to retrieve a value.
e1,...en	Dimension element names that define the intersection of the cube containing the value to be retrieved. Arguments e1 through en are sequence-sensitive. e1 must be an element from the first dimension of the cube, e2 must be an element from the second dimension, and so on. These arguments can also be the names of aliases for dimension elements or TurboIntegrator variables.

Argument

Description

Cube

The name of the cube from which you want to retrieve a value.

e1,...en

Dimension element names that define the intersection of the cube containing the value to be retrieved.

Arguments e1 through en are sequence-sensitive. e1 must be an element from the first dimension of the cube, e2 must be an element from the second dimension, and so on. These arguments can also be the names of aliases for dimension elements or TurboIntegrator variables.

See the note at CellGetN concerning IF logic with this function.

Example

CellGetS('Personnel', 'Rep', 'Europe', 'Product');

This example retrieves the string value at the intersection of the Rep, Europe, and Product elements in the Personnel cube.