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. CUBEATTRN returns a numeric attribute for a specified cube. 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 HIERARCHYCOUNT returns the number of hierarchies in the supplied dimension. Works in TIMST Returns a formatted date/time in a string format. Works in DB retrieve a value from a cube cell. Works in ELEMENTCOMPONENT returns the name of child of a consolidated element. Works in HierarchyElementPrincipalName returns the principal name of an element given an alias or the element name itself. Works in ... ELEMENTATTRS returns the string attribute value of the specified element of a dimension. Works in