TI Functions

TM1 Function for TI – ​CellIncrementN

Available In

TurboIntegrator

Definition

CellIncrementN increases a numeric value by a value.

Syntax

CellIncrementN(Value, Cube, e1, e2 [,…en])

Value = a numeric value by which the existing cell value to be increased.

Value can be any number by itself or a number derived via a formula or a number retrieved from another cube such as assumptions cube etc

Cube = Cube Name to update the data

e1,e2….en = Dimension element names determining the data point within the cube to be retrieved. The sequence of the element arguments should match to the order of the dimension in the cube.

Note:

  • Principle element name or Alias can be used as the argument to the function
  • If using hierarchies, dimension name should be mentioned along with the element name like HierarchyName:ElementName
Video Demo

From the Product Scorecard cube using the view, Accessories, increment the value by 500. Product Scorecard dimension order:

  1. Version
  2. Year
  3. Quarter
  4. Product Type
  5. Product Scorecard
  6. Product Scorecard Measure