OLAP Catalog (CWM2-Specific) Views , 20 of 25

ALL$OLAP2_ENTITY_DESC_USES

Each row represents an association between an OLAP metadata entity and its descriptor. The OLAP metadata entities and descriptors are defined in the OLAP 1 Catalog classification system and referenced from the OLAP 1 Catalog.

The following OLAP metadata entities are represented in this view:

Dimensions whose descriptor is Time.
Dimension attributes whose descriptor is: Long Description, Short Description, or Description.
Dimension attributes (for time dimensions only) whose descriptor is: End Date, Time Span, Prior Period, or Year Ago Period.

Level attributes (for time dimensions only) whose descriptor is: Day, Month, Quarter, or Year.

Column	Datatype	NULL	Description
`DESCRIPTOR_ID`	`NUMBER`	`NOT NULL`	ID of the descriptor, derived from the OLAP 1 classification system.
`ENTITY_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the entity. If the entity is a dimension attribute or level attribute, the owner is the owner of the dimension.
`ENTITY_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the entity. The entity may be a dimension, a dimension attribute, or a level attribute.
`CHILD_ENTITY_NAME`	`VARCHAR2(30)`		Name of the child entity (if applicable). A dimension attribute is a child entity of a dimension. A level attribute is a child entity of a dimension attribute.
`SECONDARY_CHILD_ENTITY_NAME`	`VARCHAR2(30)`		Name of the secondary child entity name (if applicable). A dimension attribute is a child entity of a dimension. A level attribute is a child entity of a dimension attribute. A level attribute could be the secondary child entity of a dimension.