Media Summary: CELLVALUES returns the string value of the specified element in a specified cube. Works in ISUNDEFINEDCELLVALUE compares the argument value with default numeric cube value and returns 1 if the cell value is equal ... UNDEFVALS changes the default value for the cube from zero to a special undefined value. Works in
Tm1 Function Undefinedcellvalue Rule - Detailed Analysis & Overview
CELLVALUES returns the string value of the specified element in a specified cube. Works in ISUNDEFINEDCELLVALUE compares the argument value with default numeric cube value and returns 1 if the cell value is equal ... UNDEFVALS changes the default value for the cube from zero to a special undefined value. Works in UNDEF returns the undefined value. 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
DB retrieve a value from a cube cell. Works in CUBEATTRN returns a numeric attribute for a specified cube. Works in CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. Works in HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string. TIMVL returns a formatted date/time in a string format. Works in TIMST Returns a formatted date/time in a string format. Works in
ATTRN returns the numeric attribute for a specified element of a dimension. Works in CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in DIMENSIONATTRS returns a string attribute for a specified dimension. Works in ELEMENTINDEX returns the index number of an element within a dimension. Works in CONSOLIDATEDAVG returns the average value in a consolidation. Works in ELEMENTTYPE returns element type information of an element in the dimension. Works in
