ADD_DESCRIPTOR_ENTITY_TYPE Procedure

This procedure adds a descriptor type to a metadata entity type.

This procedure is only available to DBAs.

The following pairs of entity types and descriptor types are predefined in the OLAP Catalog.

Entity Type	Descriptor Type
Dimension	Dimension Type
Dimension	Dimension Primary Display Sort Order
Dimension	Dimension Secondary Display Sort Order
Dimension Attribute	Dimension Attribute Descriptor
Dimension Attribute	Time Dimension Attribute Type
Level Attribute	Dimension Attribute Descriptor
Level Attribute	Time Dimension Attribute Type
Level	Total Level
Level	Time Dimension Level Type
Parameter	Parameter Source Type

Syntax

ADD_DESCRIPTOR_ENTITY_TYPE (
          descriptor_type     IN   VARCHAR2,
          entity_type         IN   VARCHAR2);

Parameters

Table 28-4  ADD_DESCRIPTOR_ENTITY_TYPE Procedure Parameters

Parameter	Description
descriptor_type	Name of the descriptor type. Examples might be dimension type, or attribute type.
entity_type	One of the following types of entities: DIMENSION, CUBE, MEASURE, LEVEL, ATTRIBUTE, HIERARCHY, PARAMETER