Limitations

Rule functions used to navigate dimensions and extract information about elements have some limitations when working with hierarchies.

You can use these functions with no limitations:

DE.TYPE
DE.PARENTSCOUNT

You can use these functions can be used when the referenced dimension has a single hierarchy.

DE.COUNT
DE.INDEX
DIMIX
DIM.TOPLEVEL
DIMSIZ

You can use these functions when both elements belong to the same hierarchy. If the child is a base element, the hierarchy reference is ignored.

DE.WEIGHT
DE.ISCHILD
DE.ISDESCENDANT

You can use these functions on a dimension level. For example, if a dimension has more than one hierarchy, DE.PREV() called on an element belonging to a certain hierarchy returns an element belonging to a different hierarchy.

HCLOSINGPERIOD
HOPENINGPERIOD
CLOSINGPERIOD
OPENINGPERIOD
DE.HSIBLING
DE.NEXT
DE.PREV
DE.SIBLING
DE.PARENTNAME
DE.LEAFCHILDRENCOUNT
DE.LEAFDESCENDANTSCOUNT
DE.LEVEL
DE.CHILDNAME
DE.CHILDRENCOUNT
DE.DESCENDANTSCOUNT
DE.NAME
DE.FIRST
DE.INDEX