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_DIMTBL_LEVELATTR Procedure

This procedure removes the relationship between a level attribute and a column in a dimension table.

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

Syntax

REMOVEMAP_DIMTBL_LEVELATTR (
          dimension_owner             IN   VARCHAR2,
          dimension_name              IN   VARCHAR2,
          dimension_attribute_name    IN   VARCHAR2,
          level_name                  IN   VARCHAR2,
          level_attribute_name         IN   VARCHAR2);

Parameters

Table 26-22  REMOVEMAP_DIMTBL_LEVELATTR Procedure Parameters
Parameter Description

dimension_owner

Owner of the dimension.

dimension_name

Name of the dimension.

dimension_attribute_name

Name of the dimension attribute.

level_name

Name of the level.

level_attribute_name

Name of the level attribute associated with this level.

Exceptions

Table 26-23  REMOVEMAP_DIMTBL_LEVELATTR 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.

dimension_not_found

Dimension not found.

level_not_found

Level not found.

attribute_not_found

Level attribute not found.