TI Functions

TM1 Function for TI – ​CellGetS

Available In

TurboIntegrator

Definition

CellGetS retrieves a string value from a cube cell.

Syntax

CellGetS(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 CellGetS to retrieve a string from the Product Scorecard cube.