2.104 ALL_CUBE_HIER_VIEW_COLUMNS
ALL_CUBE_HIER_VIEW_COLUMNS
describes the columns of the relational hierarchy views of the OLAP cube dimensions accessible to the current user.
Related Views
-
DBA_CUBE_HIER_VIEW_COLUMNS
describes the columns of the relational hierarchy views of all OLAP cube dimensions in the database. -
USER_CUBE_HIER_VIEW_COLUMNS
describes the columns of the relational hierarchy views of the OLAP cube dimensions owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the cube dimension |
|
|
|
Name of a cube dimension, such as |
|
|
|
Name of a hierarchy for the cube dimension, such as |
|
|
|
Name of a view of the hierarchy, such as |
|
|
|
Name of a column in the view, such as |
|
|
|
Type of the column:
|
|
|
|
Name of a level or attribute for the dimension |
See Also: