Tm1 Function Hierarchyn Rule

Summary

HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string. HIERARCHYCOUNT returns the number of hierarchies in the supplied dimension. Works in ELEMENTPARENT returns the parent of an element in the dimension. Works in ELEMENTFIRST returns the first element of a specified dimension. Works in ATTRN returns the numeric attribute for a specified element of a dimension. Works in ELEMENTCOMPONENT returns the name of child of a consolidated element. Works in ELEMENTCOMPONENTCOUNT returns the number of components of the consolidation. Works in ELEMENTISPARENT determines if an element is parent of another element or not. Works in DB retrieve a value from a cube cell. Works in ELEMENTISCOMPONENT determines if the element is child of a consolidation or not.