Tm1 Function Undefinedcellvalue Rule

Summary

UNDEF returns the undefined value. Works in ISUNDEFINEDCELLVALUE compares the argument value with default numeric cube value and returns 1 if the cell value is equal ... CELLVALUES returns the string value of the specified element in a specified cube. Works in ISUND returns 1 if the argument value is undefined. Works in CELLVALUEN returns the numeric value of the specified element in a specified cube. Works in UNDEFVALS changes the default value for the cube from zero to a special undefined value. Works in ATTRN returns the numeric attribute for a specified element of a dimension. Works in ELEMENTFIRST returns the first element of a specified dimension. Works in DB retrieve a value from a cube cell. Works in ELEMENTPARENT returns the parent of an element in the dimension. Works in ELEMENTCOMPONENT returns the name of child of a consolidated element. Works in TM1Val is a hierarchy-aware formula that reads, writes, or clears a cell which works with SUBNM returns an element from a dimension set. If the optional alias parameter is included, the