Tm1 Function Hierarchycount Rule

Summary

HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string. HIERARCHYN returns the name of the hierarchy at a specified position. Works in ELEMENTCOUNT returns the number of components of the consolidated element. Works in ELEMENTPARENTCOUNT returns the number of parents of an element in the dimension. Works in ELEMENTFIRST returns the first element of a specified dimension. Works in ELEMENTISPARENT determines if an element is parent of another element or not. Works in ELEMENTCOMPONENT returns the name of child of a consolidated element. Works in ELEMENTPARENT returns the parent of an element in the dimension. Works in DB retrieve a value from a cube cell. Works in ELEMENTTYPE returns element type information of an element in the dimension. Works in CONSOLIDATEDMAX returns the maximum value in a consolidation. Works in ELEMENTISCOMPONENT determines if the element is child of a consolidation or not.