About Dimensions with Multiple Hierarchies

Dimensions can contain multiple hierarchies.

For example, time dimensions often have one hierarchy for the calendar year, and another hierarchy for the fiscal year.

Note:

Dimensions with multiple hierarchies must always end with the same leaf table.

The image shows a dimension with multiple hierarchies in the Business Model and Mapping layer of the Oracle BI Administration Tool.