| 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_DIM_LEVEL_ATTR_MAPS shows the mapping of each level attribute to a column.
The mapping of level attributes to levels is dependent on hierarchy. The same level may have different attributes when it is used in different hierarchies.
| Column | Data Type | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the dimension. |
DIMENSION_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the dimension. |
HIERARCHY_NAME |
VARCHAR2(30) |
Name of the hierarchy containing this level. | |
ATTRIBUTE_NAME |
VARCHAR2(30) |
Name of a dimension attribute grouping containing this level attribute. | |
LVL_ATTRIBUTE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the level attribute, or name of the column if the level attribute name is not specified. |
LEVEL_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the level. |
TABLE_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the dimension table containing the level and level attribute. |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the dimension table containing the level and level attribute columns. |
COLUMN_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the column containing the level attribute. |
DTYPE |
VARCHAR2(10) |
NOT NULL |
Data type of the column containing the level attribute. |
