CWM2_OLAP_TABLE_MAP, 17 of 19

REMOVEMAP_FACTTBL_MEASURE Procedure

This procedure removes the relationship between a measure column in a fact table and a logical measure associated with a cube.

Upon successful completion of this procedure, the measure is a purely logical metadata entity. It has no data associated with it.

Syntax

REMOVEMAP_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-28 REMOVEMAP_FACTTBL_MEASURE Procedure Parameters

Parameter	Description
`cube_owner`	Owner of the cube.
`cube_name`	Name of the cube.
`measure_name`	Name of the measure.
`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 is 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` This string must also be specified as an argument to the `MAP_FACTTBL_HIERLEVELKEY` procedure.

Exceptions

Table 26-29 REMOVEMAP_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.