Media Summary: ELEMENTISCOMPONENT determines if the element is child of a consolidation or not. CELLVALUES returns the string value of the specified element in a specified cube. Works in ELEMENTINDEX returns the index number of an element within a dimension. Works in
Tm1 Function Elcompn Rule - Detailed Analysis & Overview
ELEMENTISCOMPONENT determines if the element is child of a consolidation or not. CELLVALUES returns the string value of the specified element in a specified cube. Works in ELEMENTINDEX returns the index number of an element within a 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 CONSOLIDATEDAVG returns the average value in a consolidation. Works in
ELPARN returns the number of parents of an element. Works in ELEMENTPARENT returns the parent of an element in the dimension. 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 ELEMENTCOMPONENT returns the name of child of a consolidated element. Works in ELLEV returns the level of an element within a dimension. Works in
CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in CELLVALUEN returns the numeric value of the specified element in a specified cube. Works in ELWEIGHT returns the weight of a child element. Works in CONSOLIDATEDMAX returns the maximum value in a consolidation. Works in
