Hierarchies

Hierarchies are predefined sequences of indexed dimensions that make it easier to assemble common cube constructs. For example a hierarchy called "Location" could be defined, which sequences the three Indexes "Country" "State" "City". Another common choice is a hierarchy "YMD" to define the sequence Year, Month, Day.

When a hierarchy is dropped, it will be expanded into the constituent indexed dimensions. A hierarchy can only be dropped over the Row or Column axis - it cannot be used as a Filter.

Each hierarchy must have a unique name, which must not clash with either another Index or another Hierarchy. When editing, only the none-blank items are used, so you may safely set a choice in the middle to blank, without having to move those below up to take its place.