Exploring TM1 - a Chartertech Company
Close this search box.

CellGetN TM1 Function: How to Use and Syntax

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 );


  • 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

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.

  • This field is for validation purposes and should be left unchanged.

Post Sections

Related Posts

John Vaughan

John Vaughan

John is a CPA, MBA and has been a Performance Management consultant for over 25 years. He is the founder of ExploringTM1 and highly regarded for his experience combining financial management with corporate planning, reporting and analysis. He lives in Sydney with his wife, two of his three children, their cat, Freckles, a bunch of chooks and some fish. John is a sports nut, who played rugby until he was 40, started playing football at 54 and loves being outdoors.

Leave a Reply

Your email address will not be published. Required fields are marked *