CellGetN gets a number from a specific intersection of a cube from within a Turbo Integrator process. It can be used as in a similar way to a DB function in a TM1 Rule. Also, don’t confuse it with ‘CellGetS‘ (which retrieves strings) – that just won’t work with numbers!
Syntax of CellGetN
The syntax is:
CellGetN (Cube, element1, element2, elementn );
Where
- cube is the cube you want to get a number from
- element1 is an element from the first dimension of the source cube
- element2 is an element from the second dimension of the source cube
- elementn are the elements from subsequent dimensions, in order, of the source cube
Usage
An example is
CellGetN (Employees, ‘2014’, ‘Jan’,’001′, ‘Salary’);
This will retrieve the number 50,000 from the Employees cube at the intersection of 2014 in the Year dimension, ‘Jan’ in the Month dimension, ‘001’ in a List100 dimension and ”Salary’ in the Measures-Staff dimension.
This function can be used in TM1 Turbo Integrator Processes only.
Note also that it is NOT GetCellN – that won’t work!
Finally, to retrieve the value of a string, please use the CellGetS function.