IsUndefinedCellValue function for IBM Planning Analytics (TM1)

IsUndefinedCellValue compares the argument value with the default numeric cube value and returns 1 if the cell value equals the cube’s default value.

In this video, IsUndefinedCellValue is used to multiply the Sales Quota Budget values from January by the Monthly Growth in the Sales Assumption cube.

Where can the IsUndefinedCellValue function be used?

Rules and TurboIntegrator

Which TM1 Server version is the IsUndefinedCellValue function available for?

Version 11 and 12

What is the syntax for IsUndefinedCellValue?

IsUndefinedCellValue(Value)

Value = A numeric value

Relevant Functions

DB = Retrieve a value from a cube cell
IsLeaf = Determines if an element is a leaf element or not
IsUndefinedCellValue = Compares the argument value with the default numeric cube value and returns 1 if the cell value is equal to the cube’s default value
Undef = Returns the undefined value
UndefinedCellValue = Returns the default numeric cube value
UndefVals = Changes the default value for the cube from zero to a special undefined value