Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2)

Part Number A95295-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

OLAP Catalog Union Views , 13 of 24


ALL_OLAP2_DIM_HIER_LEVEL_USES

ALL_OLAP2_DIM_HIER_LEVEL_USES is a synonym for ALL$OLAP2UDIM_HIER_LEVEL_USES.

Each row represents a hierarchical relationship between two levels in a dimension hierarchy. Within separate hierarchies, the same parent level may be hierarchically related to a different child level.

Column Data Type NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension.

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension.

HIERARCHY_NAME

VARCHAR2(30)

NOT NULL

Name of the hierarchy.

PARENT_LEVEL_NAME

VARCHAR2(30)

NOT NULL

Name of the parent level.

CHILD_LEVEL_NAME

VARCHAR2(30)

NOT NULL

Name of the child level.

POSITION

NUMBER

NOT NULL

Position of this parent-child relationship within the hierarchy, with position 1 being the most detailed.


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 2001, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback