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 it.

Syntax of CellPutN

The syntax is CellPutN (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

An example is CellPutN (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.

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

2 Responses to "CellPutN TM1 Function: Use and Syntax"

Log in to post a comment.