Media Summary: ELCOMPN returns the number of elements of the consolidation. Works in ELEMENTISCOMPONENT determines if the element is child of a consolidation or not. CONSOLIDATEDAVG returns the average value in a consolidation. Works in
Tm1 Function Elcomp Rule - Detailed Analysis & Overview
ELCOMPN returns the number of elements of the consolidation. Works in ELEMENTISCOMPONENT determines if the element is child of a consolidation or not. CONSOLIDATEDAVG returns the average value in a consolidation. 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 NOW returns the current Time in a serial number format. Works in
CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in ELEMENTCOMPONENTCOUNT returns the number of components of the consolidation. Works in ELEMENTCOMPONENT returns the name of child of a consolidated element. Works in CONSOLIDATEDMAX returns the maximum value in a consolidation. Works in ELEMENTPARENT returns the parent of an element in the dimension. Works in DATES returns the date in a string yy-dd-mm or yyyy-dd-mm format. Works in
ELEMENTATTRN returns the numeric attribute value of the specified element of a dimension. Works in ELEMENTTYPE returns element type information of an element in the dimension. Works in ELISANC determines if an element is ancestor of another element or not. Works in HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string. ELLEV returns the level of an element within a dimension. Works in
