| Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
|
|
View PDF |
| Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
|
|
View PDF |
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 and Committing OLAP Catalog Metadata" |
DIMENSION_TYPE |
VARCHAR2(10) |
Not used. |
