Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2.0.2)

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

Go to previous page Go to next page
View PDF

ALL_OLAP2_DIM_LEVEL_ATTR_MAPS

ALL_OLAP2_DIM_LEVEL_ATTR_MAPS shows the mapping of each level attribute to a column.

The mapping of level attributes to levels is dependent on hierarchy. The same level may have different attributes when it is used in different hierarchies.

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 containing this level.

ATTRIBUTE_NAME

VARCHAR2(30)

Name of a dimension attribute grouping containing this level attribute.

LVL_ATTRIBUTE_NAME

VARCHAR2(30)

NOT NULL

Name of the level attribute, or name of the column if the level attribute name is not specified.

LEVEL_NAME

VARCHAR2(30)

NOT NULL

Name of the level.

TABLE_OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension table containing the level and level attribute.

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension table containing the level and level attribute columns.

COLUMN_NAME

VARCHAR2(30)

NOT NULL

Name of the column containing the level attribute.

DTYPE

VARCHAR2(10)

NOT NULL

Data type of the column containing the level attribute.