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 24-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 24-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 does not exist within the OLAP 2 Catalog.
fact_table_not_found	Fact table does not exist or is not accessible to the calling user
measure_not_found	This measure does not exist in this cube.
column_not_found	This column does not exist in this fact table.