本站中文解释
ALL_CUBE_HIER_VIEW_COLUMNS视图提供OLAP计算列名称和类型的元数据信息，用于客户端应用程序来构建OLAP层次结构以及用于他们呈现的报表。你可以用它来映射出应用程序的层次结构，从而更好地探索处理OLAP cube。
使用该视图的方式很简单，只需要用SQL语句查询类似如下的内容即可：
SELECT owner, cube_name, hier_name, hier_column_name, hier_column_type,
datatype, hier_column_order, depth
FROM all_cube_hier_view_columns
WHERE owner = ‘SYS’
ORDER BY hier_column_order;
官方英文解释
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_COLUMNSdescribes the columns of the relational hierarchy views of all OLAP cube dimensions in the database. -
USER_CUBE_HIER_VIEW_COLUMNSdescribes the columns of the relational hierarchy views of the OLAP cube dimensions owned by the current user. This view does not display theOWNERcolumn.
| 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:
-
“DBA_CUBE_HIER_VIEW_COLUMNS”
-
“USER_CUBE_HIER_VIEW_COLUMNS”