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_DIMENSIONS

ALL_OLAP2_DIMENSIONS lists all the OLAP dimensions in the Oracle instance.

OLAP dimensions created with the CWM2 APIs have no association with database dimension objects. OLAP dimensions created in Enterprise Manager are based on database dimension objects.

Column Data Type NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension.

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension.

PLURAL_NAME

VARCHAR2(30)

Plural name for the dimension. Used for display.

DISPLAY_NAME

VARCHAR2(30)

Display name for the dimension.

DESCRIPTION

VARCHAR2(2000)

Description of the dimension.

DEFAULT_DISPLAY_HIERARCHY

VARCHAR2(30)

NOT NULL

Default display hierarchy for the dimension.

INVALID

VARCHAR2(1)

NOT NULL

Whether or not the dimension is valid. See "Validating OLAP Metadata"

DIMENSION_TYPE

VARCHAR2(10)

Not used.