|Oracle9i OLAP User's Guide
Release 2 (9.2)
Part Number A95295-01
CWM2_OLAP_HIERARCHY , 3 of 13
CWM2_OLAP_HIERARCHY package contains procedures that establish hierarchy entities for dimensions within the OLAP 2 Catalog.
When you create an OLAP metadata entity, you are simply adding a row to an OLAP Catalog table that identifies all the entities of that type. Creating a hierarchy does not fully define it, nor does it involve any mapping to warehouse dimension tables.
The parent dimension must already exist in the OLAP 2 Catalog before you can create hierarchies for it.
Creating hierarchies is one of the first steps in creating the OLAP metadata for a dimension. Once you have created the hierarchies, you will need to call procedures in the following packages to fully define the dimension's metadata: