| 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_MEAS_DIM_USES shows how each measure is aggregated along each of its dimensions. The default aggregation method is addition.
| Column | Data Type | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the cube that contains this measure. |
CUBE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the cube that contain this measure. |
MEASURE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the measure. |
DIMENSION_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of a dimension associated with this measure. |
DIMENSION_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the dimension. |
DIMENSION_ALIAS |
VARCHAR2(30) |
Alias of the dimension. | |
DEFAULT_AGGR_FUNCTION_USE_ID |
NUMBER |
The default aggregation method used to aggregate this measure's data over this dimension. If this column is null, the aggregation method is addition. |
