CWM_CLASSIFY , 16 of 19

REMOVE_ENTITY_DESCRIPTOR_USE Procedure

This procedure removes a descriptor from an OLAP metadata entity.

Syntax

REMOVE_ENTITY_DESCRIPTOR_USE (
   descriptor_id                  IN   NUMBER,
   entity_type                    IN   VARCHAR2,
   entity_owner                   IN   VARCHAR2,
   entity_name                    IN   VARCHAR2,
   child_entity_name              IN   VARCHAR2,
   secondary_child_entity_name    IN   VARCHAR2);

Parameters

Table 28-25 REMOVE_ENTITY_DESCRIPTOR_USE Procedure Parameters

Parameter	Description
`descriptor_id`	Identifier of the descriptor.
`entity_type`	One of the following types of entities: `DIMENSION, CUBE, MEASURE, LEVEL, ATTRIBUTE, HIERARCHY, PARAMETER`
`entity_owner`	Owner of the entity.
`entity_name`	Name of the parent entity. If there is no child entity, this is the name of the entity from which the descriptor should be removed.
`child_entity_name`	If the entity is a child of `entity_name`, name of the child entity. If the entity is not a child of another entity, this parameter is `NULL`. When this parameter is specified and there is no secondary child entity, this is the name of the entity from which the descriptor should be removed. Levels, hierarchies, and dimension attributes are children of dimensions. Measures are children of cubes.
`secondary_child_entity_name`	Used for specifying level attributes, which are children of levels. If the entity is not a level attribute, this parameter is `NULL`.

Exceptions

Table 28-26 REMOVE_ENTITY_DESCRIPTOR_USE Procedure Exceptions

Exception	Description
`entity_not_found`	Entity not found.