TI Functions

TM1 Function for TI – ​CellGetN

Available In

TurboIntegrator

Definition

CellGetN retrieves a numeric value from a cube cell.

Syntax

CellGetN(Cube, e1, e2 [,…en])

Cube = Cube Name to retrieve the data from

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

Use CellGetN to retrieve a value from the Product Scorecard cube.