Exploring TM1 - a Chartertech Company
Close this search box.

CellPutN TM1 Function: Use and Syntax

CellPutN inserts a number into a specific intersection of a cube and replaces the contents of that intersection. It does not incrementally add to the value already there, rather it replaces (or overwrites) it.

Syntax of CellPutN

The syntax is:

CellPutN (Number, Cube, element1, element2, elementn );


  • Number is the string you want to insert into a cube
  • cube is the cube you insert the string into
  • element1 is an element from the first dimension of the target cube
  • element2 is an element from the second dimension of the target cube
  • elementn are the elements from subsequent dimensions in order of the target cube


An example is:

CellPutN (50000, 'Employees', '2014', 'Jan','001', 'Salary');

This will insert the value 50,000 into 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

If you need to have the value loaded and ADD TO an existing intersection, please see CellIncrementN.

If you need to have a string loaded to a TM1 cube, please use CellPutS.

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

Post Sections

Related Posts

Leave a Reply

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

Log In