Tm1 Function Capit Rule

CAPIT

CELLVALUES returns the string value of the specified element in a specified cube. Works in

FEEDERS flag

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

CUBEATTRN returns a numeric attribute for a specified cube. Works in

CONSOLIDATEDAVG returns the average value in a consolidation. Works in

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

DATES returns the date in a string yy-dd-mm or yyyy-dd-mm format. Works in

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

CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. Works in

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

UNDEF returns the undefined value. Works in

HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.

ELEMENTTYPE returns element type information of an element in the dimension. Works in

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

DB retrieve a value from a cube cell. Works in

EXP returns the natural anti-log of a number. Works in

CONSOLIDATEDCOUNT returns the number of values in a consolidation. Works in

ELCOMPN returns the number of elements of the consolidation. Works in