TM1 Function for TI, 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.

What is the CellIsUpdateable function?

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.

Where can the CellIsUpdateable function be used?

TurboIntegrator

What is the syntax for CellIsUpdateable?

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

A demonstration on how to use CellIsUpdateable

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