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.