Tm1 Function Elcomp Rule - Detailed Analysis
ELCOMPN returns the number of elements of the consolidation. Works in ELEMENTISCOMPONENT determines if the element is child of a consolidation or not. ELEMENTPARENT returns the parent of an element in the 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 ELEMENTCOMPONENT returns the name of child of a consolidated element. Works in
CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. Works in ELEMENTCOMPONENTCOUNT returns the number of components of the consolidation. Works in ELISANC determines if an element is ancestor of another element or not. Works in ELEMENTTYPE returns element type information of an element in the dimension. Works in ELEMENTATTRN returns the numeric attribute value of the specified element of a dimension. Works in HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.
ELPARN returns the number of parents of an element. Works in ELLEV returns the level of an element within a dimension. Works in LONG returns the length of the string. Works in CELLVALUEN returns the numeric value of the specified element in a specified cube. Works in CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in
Photo Gallery
