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 , 24 of 24


ALL_OLAP2_LEVEL_KEY_COLUMN_USES

ALL_OLAP2_LEVEL_KEY_COLUMN_USES is a synonym for ALL$OLAP2ULEVEL_KEY_COLUMN_USES.

Each row represents the logical key linking a dimension level to one of its underlying columns in a dimension table. If the level is mapped to more than one column, each column mapping is represented in a separate row in the view.

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)

Name of the hierarchy that includes this level.

CHILD_LEVEL_NAME

VARCHAR2(30)

NOT NULL

Name of the level.

TABLE_OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension table.

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension table.

COLUMN_NAME

VARCHAR2(30)

NOT NULL

Name of the column that stores CHILD_LEVEL_NAME.

POSITION

NUMBER

Position of the column within the key. Applies to multi-column keys only (where the level is mapped to more than one column).


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