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 |