fbpx

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

Rank Children Members

Examples

Special Examples (errors, null, ...)

XMLA Properties

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