CWM2_OLAP_TABLE_MAP, 10 of 19

MAP_FACTTBL_MEASURE Procedure

This procedure maps a measure to a column in a fact table.

Syntax

MAP_FACTTBL_MEASURE (
          cube_owner        IN   VARCHAR2,
          cube_name         IN   VARCHAR2,
          measure_name       IN   VARCHAR2,
          facttable_owner   IN   VARCHAR2,
          facttable_name    IN   VARCHAR2,
          column_name        IN   VARCHAR2,
          dimkeymap         IN   VARCHAR2);

Parameters

Table 26-14 MAP_FACTTBL_MEASURE Procedure Parameters

Parameter	Description
`cube_owner`	Owner of the cube.
`cube_name`	Name of the cube.
`measure_name`	Name of the measure to be mapped.
`facttable_owner`	Owner of the fact table.
`facttable_name`	Name of the fact table.
`column_name`	Column in the fact table to which the measure will be mapped.
`dimkeymap`	A string specifying the mapping for each of the measure's dimensions. For each dimension you must specify a hierarchy and the lowest level to be mapped within that hierarchy. Enclose the string in single quotes, and separate each dimension specification with a semicolon. Each dimension specification must be in the following form: `DIM:``dimname``/HIER:``hiername``/GID:`columnname`/LVL:``levelname`/COL:`columnname`; This string must also be specified as an argument to the `MAP_FACTTBL_HIERLEVELKEY` procedure.

Exceptions

Table 26-15 MAP_FACTTBL_MEASURE Procedure Exceptions

Exception	Description
`no_access_privileges`	User does not have the necessary privileges. User must be the dimension owner and have the `OLAP_DBA` role.
`cube_not_found`	Cube not found.
`fact_table_not_found`	Fact table not found.
`measure_not_found`	Measure not found.
`column_not_found`	Fact table column not found.