Oracle9i OLAP User's Guide Release 2 (9.2.0.2) Part Number A95295-02 |
|
|
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 of the dimension. |
|
|
|
Name of the dimension. |
|
|
Plural name for the dimension. Used for display. |
|
|
|
Display name for the dimension. |
|
|
|
Description of the dimension. |
|
|
|
|
Default display hierarchy for the dimension. |
|
|
|
Whether or not the dimension is valid. See "Validating OLAP Metadata" |
|
|
Not used. |