ALL_CUBE_VIEW_COLUMNS

ALL_CUBE_VIEW_COLUMNS describes the columns of the relational views of the OLAP cubes accessible to the current user.

Column Datatype NULL Description
OWNER VARCHAR2(128)   Owner of the cube
CUBE_NAME VARCHAR2(128)   Name of a cube, such as UNITS_CUBE
VIEW_NAME VARCHAR2(128)   Name of a view of the cube, such as PRODUCT_VIEW
COLUMN_NAME VARCHAR2(128)   Name of a column in the view, such as DIM_KEY or LEVEL_NAME
COLUMN_TYPE VARCHAR2(7)  

Type of the column:

  • MEASURE

  • KEY

OBJECT_NAME VARCHAR2(128)   Name of the measure or dimension represented in the column

See Also: