| 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_CUBE_DIM_USES lists the dimensions within each cube.
A dimension may be associated more than once with the same cube, but each association is specified in a separate row, under its own unique dimension alias.
| Column | Data Type | NULL | Description |
|---|---|---|---|
CUBE_DIMENSION_USE_ID |
NUMBER |
NOT NULL |
ID of the association between a cube and a dimension. |
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the cube. |
CUBE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the cube. |
DIMENSION_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the dimension. |
DIMENSION_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the dimension. |
DIMENSION_ALIAS |
VARCHAR2(30) |
Alias of the dimension, to provide unique identity of dimension use within the cube. | |
DEFAULT_CALC_HIERARCHY_NAME |
VARCHAR2(30) |
The default hierarchy to be used for drilling up or down within the dimension. | |
DEPENDENT_ON_DIM_USE_ID |
NUMBER |
ID of the cube/dimension association on which this cube/dimension association depends. |
