CWM_CLASSIFY , 6 of 19

ADD_ENTITY_DESCRIPTOR_USE Procedure

This procedure assigns a descriptor to an OLAP metadata entity. An entity may have multiple descriptors.

This procedure is only available to DBAs.

Syntax

ADD_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-5 ADD_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 to which the descriptor should be applied.
`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 to which the descriptor should be applied. 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-6 ADD_ENTITY_DESCRIPTOR_USE Procedure Exceptions

Exception	Description
`entity_not_found`	Entity not found.
`descriptor_undefined`	Descriptor value not found in `ALL$OLAP_DESCRIPTORS` lookup view.