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 |