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

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.