Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2.0.2)

Part Number A95295-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

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.