Viewing OLAP Catalog Metadata , 7 of 25

ALL_OLAP2_CUBE_DIM_USES

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.