CellGetS TM1 Function: 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 ‘GetCellS’ – that just won’t work!

Syntax of CellGetS

The syntax is CellGetS (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 CellGetS (Employees, ‘2014’, ‘Jan’,’001′, ‘Job Title’); which 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.

To retrieve the value of a number, please use the CellGetN function.

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.
This entry was posted in TI Functions and tagged CellGetN, CellGetS, DB. Bookmark the permalink.

One Response to "CellGetS TM1 Function: Use and Syntax"

Log in to post a comment.