Return to: Calculated Member Builder Function List
Orders the members of a set in a hierarchy.
Hierarchize(«Set»)
Orders the members of «Set» in a hierarchy. Members in a level are sorted in their natural order, the default ordering of the members along a dimension when no other sort conditions are specified. Hierarchize will always retain duplicates.
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 |