Tm1 Function Cellvalues Rule

CELLVALUES

CELLVALUEN returns the numeric value of the specified element in a specified cube. Works in

FEEDSTRINGS enables feeding of string cells. Works in

UNDEFINEDCELLVALUE returns the default numeric cube value. Works in

ELEMENTISCOMPONENT determines if the element is child of a consolidation or not.

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

CONSOLIDATEDAVG returns the average value in a consolidation. Works in

ELISANC determines if an element is ancestor of another element or not. Works in

ATTRN returns the numeric attribute for a specified element of a dimension. Works in

DB retrieve a value from a cube cell. Works in

TIMST Returns a formatted date/time in a string format. Works in

CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in

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

ELEMENTISPARENT determines if an element is parent of another element or not. Works in

STET cancels the effect of

DIMIX returns the index of the dimension's element Works in

DIMENSIONATTRS returns a string attribute for a specified dimension. Works in

ELEMENTCOMPONENTCOUNT returns the number of components of the consolidation. Works in

ATTRS returns the string attribute for a specified element of a dimension. Works in