Oracle 视图 ALL_CUBE_HIER_LEVELS 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图 ALL_CUBE_HIER_LEVELS提供了有关每个 OLAP 架构(schema)中度量(measure)和层次(hierarchy)层级的详细信息。
它包括:
MEASURE_NAME- 包含度量名称的列
HIERARCHY_NAME – 包含层次名称的列
LEVEL_NUMBER – 包含层次编号的列
LEVEL_NAME – 包含层次名称的列
NUMBER_FORMAT- 包含层次的数字格式代码的列
使用:
1.查看所有数据库上下文中的层次:
SELECT measure_name,
hierarchy_name,
level_name,
number_format
FROM all_cube_hier_levels;
2.在数据库上下文中查找某个层次:
SELECT measure_name,
hierarchy_name,
level_name,
number_format
FROM all_cube_hier_levels
WHERE level_name = ‘MyLevel’;
官方英文解释
ALL_CUBE_HIER_LEVELS
describes the hierarchy levels for the OLAP cube dimensions accessible to the current user.
Related Views
-
DBA_CUBE_HIER_LEVELS
describes the hierarchy levels for all OLAP cube dimensions in the database. -
USER_CUBE_HIER_LEVELS
describes the hierarchy levels for 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 dimension, such as |
|
|
|
Name of the dimension level, such as |
|
|
|
ID of the hierarchy level |
|
|
|
Order number of the level within the hierarchy; 0 is the top level |
|
|
Description of the level in the session language |
See Also:
-
“DBA_CUBE_HIER_LEVELS”
-
“USER_CUBE_HIER_LEVELS”