CellGetS TM1 Function: How to Use and Syntax
CellGetS gets a string 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 ‘CellGetN‘ (which retrieves numbers) – that just won’t work with strings!
Syntax of CellGetS
The syntax is:
CellGetS (Cube, element1, element2, elementn );
- 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
An example is:
CellGetS (Employees, ‘2014’, ‘Jan’,’001′, ‘Job Title’);
This will retrieve the string “Boss” from the Employees cube at the intersection of 2014 in the Year dimension, ‘Jan’ in the Month dimension, ‘001’ in a List100 dimension and ”Job Title’ in the Measures-Staff dimension.
This function can be used in TM1 Turbo Integrator Processes only.
Also, don’t get it around the wrong way and enter “GetCellS”! It won’t work!
To retrieve the value of a number, please use the CellGetN function.