TI Functions

TM1 Function for TI – ​CellIsUpdateable

Available In



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.


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.