TI Functions

TM1 Function for TI – ​CellIsUpdateable

Available In

TurboIntegrator

Definition

CellIsUpdateable checks whether a cube cell can be written to. If the cell can be written to, the function returns 1, otherwise a 0 is returned.​

Syntax

CellIsUpdateable(Cube, e1, e2 [,…en])​

​Cube = Cube Name to write the value to​

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: This function helps you in avoiding the cells that are rule driven when updating values from a TI

Video Demo

Load data to the Product Scorecard cube. CellIsUpdateable will be used to avoid cells that can’t be written to.