Hierarchize (MDX)
Return the members of the set sorted according to their natural order in their hierarchy.
Parameters
Name | Type | Cardinality | Default value |
set-expression | one | ||
POST | zero-one |
Return
set
Description
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
Examples
Special Examples (errors, null, ...)
XMLA Properties
Find here the value of the XMLA properties when not specified otherwise.