CellIsUpdateable

CellIsUpdateable determines whether a cube cell can be written to. The function returns 1 if the cell can be written to, otherwise it returns 0.

This function is valid in TM1® TurboIntegrator processes only.

Syntax

CellIsUpdateable(Cube, e1, e2 [,...en]);

Argument

Description

Cube

The name of the cube to which you want to write a value.

e1,...en

Dimension element names that define the cell to which you want to write a value.

Arguments e1 through en are sequence-sensitive. e1 must be an element from the first dimension of the cube, e2 must be an element from the second dimension, and so on. These arguments can also be the names of aliases for dimension elements or TurboIntegrator variables.

Example

CellIsUpdateable ('y2ksales', 'Actual', 'Argentina','S Series 1.8L Sedan', 'Sales', 'Jan');

This example determines if the cell defined by the elements Actual, Argentina, S Series 1.8L Sedan, Sales, and Jan in the y2ksales cube can be written to. If the cell can receive a value, the function returns 1, otherwise it returns 0.