CWM2_OLAP_TABLE_MAP, 8 of 19

MAP_DIMTBL_LEVEL Procedure

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

The level being mapped has no hierarchical context. Typically, this level is the only level defined for this dimension.

Syntax

MAP_DIMTBL_LEVEL (
         dimension_owner     IN   VARCHAR2,
         dimension_name      IN   VARCHAR2,
         level_name          IN   VARCHAR2,
         table_owner          IN   VARCHAR2,
         table_name          IN   VARCHAR2,
         keycol               IN   VARCHAR2);

Parameters

Table 26-10 MAP_DIMTBL_LEVEL Procedure Parameters

Parameter	Description
`dimension_owner`	Owner of the dimension.
`dimension_name`	Name of the dimension.
`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.

Exceptions

Table 26-11 MAP_DIMTBL_LEVEL 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 not found.
`level_not_found`	Level not found.
`table_not_found`	Dimension table not found.
`column_not_found`	Dimension table column not found.