TM1 Function for Rules, ISUNDEFINEDCELLVALUE

ISUNDEFINEDCELLVALUE compares the argument value with default numeric cube value and returns 1 if the cell value is equal to cube’s default value. 

Where can the ISUNDEFINEDCELLVALUE function be used?

Rules and TurboIntegrator

What is the ISUNDEFINEDCELLVALUE function?

ISUNDEFINEDCELLVALUE compares the argument value with default numeric cube value and returns 1 if the cell value is equal to cube’s default value. 

What is the syntax for ISUNDEFINEDCELLVALUE?

ISUNDEFINEDCELLVALUE(value).​
Value = A numeric value.

A demonstration on how to use ISUNDEFINEDCELLVALUE

Use ISUNDEFINEDCELLVALUE function to compare numeric value with the cube’s default value and apply it in the cube rule to populate results in the Product Scorecard cube.