The parent-child relationships of attributes are used to organize the hierarchy. For example, in a Sales Personnel dimension, the hierarchy is organized under the parent-child relationships shown in Table 3.
Table 3. Recursive Hierarchy Deployment
Parent Attribute | Child Attribute |
|---|
North America | United States of America |
United States of America | California |
California | San Bernadino |
San Bernadino | Los Angeles |
Los Angeles | Glendale |