| Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
|
|
View PDF |
| Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
|
|
View PDF |
ALL_OLAP2_AW_DIM_HIER_LVL_ORD lists the levels in hierarchies in standard form analytic workspaces. It includes the position of each level within the hierarchy.
| Column | Datatype | NULL | Description |
|---|---|---|---|
AW_OWNER |
VARCHAR2(30) |
Owner of the analytic workspace. | |
AW_NAME |
VARCHAR2(30) |
Name of the analytic workspace. | |
AW_DIMENSION_NAME |
VARCHAR2(90) |
Name of a dimension in the analytic workspace. | |
AW_HIERARCHY_NAME |
VARCHAR2(1000) |
Name of a hierarchy of the workspace dimension. | |
IS_DEFAULT_HIER |
VARCHAR2(1000) |
Whether or not this hierarchy is the default hierarchy | |
AW_LEVEL_NAME |
VARCHAR2(1000) |
Name of a level of the workspace hierarchy. | |
POSITION |
NUMBER |
The position of the level in the hierarchy |
