ALL_CUBE_DIMENSIONS
describes the OLAP cube dimensions accessible to the current user.
Related Views
DBA_CUBE_DIMENSIONS
describes all OLAP cube dimensions in the database.
USER_CUBE_DIMENSIONS
describes the OLAP cube dimensions owned by the current user. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the cube dimension |
|
|
|
Name of a cube dimension, such as |
|
|
|
ID of the cube dimension |
|
|
Type of the OLAP cube dimension:
|
|
|
|
Name of the analytic workspace that contains the cube dimension, such as |
|
|
|
Name of the default hierarchy for the cube dimension, such as |
|
|
|
Description of the cube dimension in the session language |
|
|
|
Hierarchy consistency rule of the OLAP cube dimension. Possible values:
|
|
|
|
|
|
|
|
The textual representation of the sort orderby clause used to load dimension members into the AW |
See Also: