<< Click to Display Table of Contents >>

Hierarchies

Top Previous Next

In a Data Warehousing environment, hierarchies are used to show which levels make up higher levels within the dimension. In the example below, from the Oracle sample schema SH, the PROMO_ROLLUP hierarchy identifies the level PROMO as a "child" of SUBCATEGORY, and SUBCATEGORY as a child of CATEGORY.

frmDimensions_Hierarchies

 

For more information about the role of hierarchies and levels in dimensions, see the syntax of the CREATE DIMENSION statement for your version of Oracle.