Viewing OLAP Catalog Metadata , 8 of 25

ALL_OLAP2_CUBE_MEAS_DIM_USES

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.