Media Summary: UNDEFVALS changes the default value for the cube from zero to a special FEEDSTRINGS enables feeding of string cells. Works in ISUNDEFINEDCELLVALUE compares the argument value with default numeric cube value and returns 1 if the cell value is equal聽...
Tm1 Function Undef Rule - Detailed Analysis & Overview
UNDEFVALS changes the default value for the cube from zero to a special FEEDSTRINGS enables feeding of string cells. Works in ISUNDEFINEDCELLVALUE compares the argument value with default numeric cube value and returns 1 if the cell value is equal聽... TIMST Returns a formatted date/time in a string format. Works in DIMENSIONATTRS returns a string attribute for a specified dimension. Works in CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in
CELLVALUES returns the string value of the specified element in a specified cube. Works in CUBEATTRN returns a numeric attribute for a specified cube. Works in HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string. DB retrieve a value from a cube cell. Works in CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. Works in ELEMENTTYPE returns element type information of an element in the dimension. Works in
ATTRS returns the string attribute for a specified element of a dimension. Works in ELEMENTATTRN returns the numeric attribute value of the specified element of a dimension. Works in DATES returns the date in a string yy-dd-mm or yyyy-dd-mm format. Works in CONSOLIDATECHILDREN forces consolidate value to be calculated by summing immediate children. Works in ATTRN returns the numeric attribute for a specified element of a dimension. Works in
