| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
ALL_CUBE_VIEW_COLUMNS describes the columns of the relational views of the OLAP cubes accessible to the current user.
DBA_CUBE_VIEW_COLUMNS describes the columns of relational views of all OLAP cubes in the database.
USER_CUBE_VIEW_COLUMNS describes the columns of relational views of OLAP cubes owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
| OWNER | VARCHAR2(30) | Owner of the cube | |
| CUBE_NAME | VARCHAR2(30) | Name of a cube, such as UNITS_CUBE | |
| VIEW_NAME | VARCHAR2(30) | Name of a view of the cube, such as PRODUCT_VIEW | |
| COLUMN_NAME | VARCHAR2(30) | Name of a column in the view, such as DIM_KEYorLEVEL_NAME | |
| COLUMN_TYPE | VARCHAR2(7) | Type of the column: 
 | |
| OBJECT_NAME | VARCHAR2(30) | Name of the measure or dimension represented in the column |