CellIncrementN TM1 Function: Use and Syntax

CellIncrementN inserts a number into a specific intersection of a cube, adding onto any value that is already there. It does not overwrite that value, rather it increases it

Syntax of CellIncrementN

The syntax is CellIncrementN (Number, Cube, element1, element2, elementn ); where

  • 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

Usage of CellIncrementN

An example is CellIncrementN (50000, Employees, ‘2014’, ‘Jan’,’001′, ‘Salary’); which 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.

Importantly, if there is already a value, say 25,000 in this intersection, the CellIncrementN will add 50,000 onto this, making the new value at this intersection 75,000.

CellIncrementN can be used in TM1 Turbo Integrator Processes only

If you need to have the value loaded and OVERWRITE an existing intersection, please see CellPutN.

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. Bookmark the permalink.

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

Log in to post a comment.