Skip Headers

Oracle9i OLAP User's Guide
Release 2 (

Part Number A95295-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page Go to next page
View PDF

Parent-Child Dimensions

A parent-child dimension table is one in which the hierarchical relationships are defined by a parent column and a child column. Since the hierarchy is defined by the relationship between the values within two columns, a parent-child dimension is sometimes referred to as having a value-based hierarchy.

Figure 25-1, "Sample Parent-Child Dimension Table Columns" illustrates the relationships between the values in the child and parent columns. A description column, which is an attribute of the child, is also included.

Figure 25-1 Sample Parent-Child Dimension Table Columns

-------------   -----------    -------------
World                          World
USA             World          United States of America
Northeast       USA            North East Region 
Southeast       USA            South East Region 
MA              Northeast      Massachusetts
Boston          MA             Boston, MA 
Burlington      MA             Burlington, MA 
NY              Northeast      New York State
New York City   NY             New York, NY
GA              Southeast      Georgia
Atlanta         GA             Atlanta,GA
Canada          World          Canada

If you choose to create OLAP Catalog metadata to represent a parent-child dimension, set the solved_code for the hierarchy to SOLVED,VALUE_BASED, as described in Chapter 20, "CWM2_OLAP_HIERARCHY".


You can create OLAP Catalog metadata to represent value-based hierarchies, but this type of hierarchy is not accessible to applications that use the OLAP API.