| 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_KEY or LEVEL_NAME | 
|
COLUMN_TYPE | 
VARCHAR2(7) | 
Type of the column:
  | 
|
OBJECT_NAME | 
VARCHAR2(30) | 
Name of the measure or dimension represented in the column |