Exploring TM1 - a Chartertech Company
Search
Close this search box.

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

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

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.

  • 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 *