CWM2_OLAP_LEVEL_ATTRIBUTE , 5 of 11

DROP_LEVEL_ATTRIBUTE Procedure

This procedure drops a level attribute from the OLAP Catalog.

Syntax

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

Parameters

Table 22-5 DROP_LEVEL_ATTRIBUTE 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.

Exceptions

Table 22-6 DROP_LEVEL_ATTRIBUTE Procedure Exceptions

Exception	Description
`no_access_privileges`	User does not have the necessary privileges. User must be the owner and have the `OLAP_DBA` role.
`dimension_not_found`	Parent dimension not found.
`dimension_attribute_not_found`	Parent dimension attribute not found.
`level_not_found`	Parent level not found.
`level_attribute_not_found`	Level attribute not found.