Oracle9i OLAP User's Guide Release 2 (9.2) Part Number A95295-01 |
|
OLAP Catalog (CWM2-Specific) Views , 24 of 25
Each row represents the key information that joins two levels in a hierarchy. Multiple column keys are represented by multiple rows in the view, one for each column use.
In a snowflake schema, where levels are defined in separate dimension tables, levels in a hierarchy have a logical foreign key relationship. When levels are defined within the same dimension table, the child level key specifies its position in the hierarchy.
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|