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.


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.

Description of GUID-36D61851-B553-425D-9EAE-E12CDE26DBF5-default.gif follows
Description of the illustration GUID-36D61851-B553-425D-9EAE-E12CDE26DBF5-default.gif