Hierarchize

Analysis Services

Analysis Services

Hierarchize

Orders the members of a set in a hierarchy.

Syntax

Hierarchize(«Set»[, POST])

Remarks

This function orders the members of «Set» in a hierarchy. Unless the POST keyword is used, members in a level are sorted in their natural order, which is the default ordering of the members along a dimension when no other sort conditions are specified. The POST keyword uses a post-natural order for the sorting of members in a level. Hierarchize will always retain duplicates.

Example

This example

Hierarchize(SampleSet)

returns the set in natural order. The hierarchized dataset follows (assuming that the natural order for the data source is alphabetical):

France
Nice
Paris
UK
London
USA
California
LA
Buffalo
NYC