ALL_CUBE_DIMENSIONS

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`	`VARCHAR2(30)`	`NOT NULL`	Owner of the cube dimension
`DIMENSION_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of a cube dimension, such as `TIME`
`DIMENSION_TYPE`	`VARCHAR2(17)`		Type of the OLAP cube dimension: `STANDARD` `TIME`
`AW_NAME`	`VARCHAR2(30)`		Name of the analytic workspace that contains the cube dimension, such as `GLOBAL`
`DEFAULT_HIERARCHY_NAME`	`VARCHAR2(30)`		Name of the default hierarchy for the cube dimension, such as `FISCAL`
`DESCRIPTION`	`NVARCHAR2(300)`		Description of the cube dimension in the session language