Hierarchize (MDX)

Return the members of the set sorted according to their natural order in their hierarchy.


Name Type Cardinality Default value
  set-expression  one   
  POST  zero-one   




Return the members sorted in the set according to their hierarchy natural order.

In the 'natural' order children are positioned after their parents. The position of the children is defined during the creation of the hierarchy. This 'natural' position cannot be changed in an MDX query. The rank function should be used to sort members using another criteria.

If the POST flag is specified than children will be positioned before their parents.

See Also

Rank Children Members


Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.