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.