MAP_DIMTBL_HIERLEVEL Procedure

This procedure maps a level to one or more columns in a dimension table.

The level being mapped is identified within the context of a hierarchy.

Syntax

MAP_DIMTBL_HIERLEVEL (
         dimension_owner     IN   VARCHAR2,
         dimension_name      IN   VARCHAR2,
         hierarchy_name      IN   VARCHAR2,
         level_name          IN   VARCHAR2,
         table_owner          IN   VARCHAR2,
         table_name          IN   VARCHAR2,
         keycol              IN   VARCHAR2,
         parentcol           IN   VARCHAR2 DEFAULT NULL);

Parameters

Table 24-4 MAP_DIMTBL_HIERLEVEL Procedure Parameters

Parameter	Description
dimension_owner	Owner of the dimension.
dimension_name	Name of the dimension.
hierarchy_name	Name of the hierarchy.
level_name	Name of the level.
table_owner	Owner of the dimension table.
table_name	Name of the dimension table.
keycol	Column in the dimension table to which this level should be mapped. This column will be the key for this level column in the fact table. If the level is stored in more than one column, separate the column names with commas. These columns will be the multicolumn key for these level columns in the fact table.
parentcol	Column that stores the parent level in the hierarchy. If you do not specify this parameter, the level is the root of the hierarchy.

Exceptions

Table 24-5 MAP_DIMTBL_HIERLEVEL Procedure Exceptions

Exception	Description
no_access_privileges	User does not have the necessary privileges. User must be the owner and have the OLAP_DBA role.
dimension_not_found	Dimension does not exist within the OLAP 2 Catalog.
hierarchy_not_found	This hierarchy does not exist for this dimension.
level_not_found	This level does not exist for this dimension.
table_not_found	Dimension table does not exist or is not accessible to the calling user.
column_not_found	This column not found in this dimension table.