ALL_OLAP2_ENTITY_EXT_PARMS

ALL_OLAP2_ENTITY_EXT_PARMS lists the following metadata descriptors: Default Member, Dense Indicator, Fact Table Join, and Estimated Cardinality.

The metadata descriptors are described in Table 8-1, "OLAP Catalog Metadata Descriptors".

Column	Data Type	Description
`DESCRIPTOR_ID`	`NUMBER(38)`	ID of the metadata descriptor.
`DESCRIPTOR_NAME`	`VARCHAR2(240)`	One of the following metadata descriptor names: `Default Member` — The default dimension member within a hierarchy. The `Default Member` descriptor is set by the `CWM2_OLAP_CLASSIFY.ADD_ENTITY_DEFAULTMEMBER_USE` procedure (described). `Dense Indicator` — Specifies whether the data is sparse or dense over a dimension of a cube. The `Dense Indicator` descriptor is set by the `CWM2_OLAP_CLASSIFY.ADD_ENTITY_DENSEINDICATOR_USE` procedure (described). `Fact Table Join` — Specifies the key columns in a dimension table that satisfy the foreign key columns in the fact table. The `Fact Table Join` descriptor applies only to CWM2 metadata. The `Fact Table Join` descriptor is set by the `CWM2_OLAP_CLASSIFY.ADD_ENTITY_FACTJOIN_USE` procedure (described). `Estimated Cardinality` — The `Estimated Cardinality` descriptor is set by the `CWM2_OLAP_CLASSIFY.ADD_ENTITY_CARDINALITY_USE` procedure (described).
`ENTITY_OWNER`	`VARCHAR2(240)`	Schema of the cube or dimension.
`ENTITY_NAME`	`VARCHAR2(240)`	Name of the cube or dimension.
`CHILD_ENTITY_NAME`	`VARCHAR2(30)`	Name of a child of the cube or dimension. For example, a dimension attribute is a child of a dimension, and a measure is a child of a cube. If the descriptor applies to a cube or dimension, this parameter is NULL.
`SECONDARY_CHILD_ENTITY_NAME`	`VARCHAR2(30)`	Name of a child of the child entity. For example, a level attribute is a child of a level, which is a child of a dimension. If the descriptor applies to a cube or dimension, or a child of a cube or dimension, this parameter is NULL.
`PARAMETER_NAME`	`VARCHAR2(80)`	User-defined label for the descriptor.
`PARAMETER_VALUE`	`VARCHAR2(4000)`	Value of the descriptor. For the `Fact Table Join` descriptor, this parameter contains the table owner.
`PARAMETER_VALUE2`	`VARCHAR2(4000)`	Table name for `Fact Table Join` descriptor.
`PARAMETER_VALUE3`	`VARCHAR2(4000)`	Column name for `Fact Table Join` descriptor.
`PARAMETER_VALUE4`	`VARCHAR2(4000)`	Hierarchy name for `Fact Table Join` descriptor.
`POSITION`	`NUMBER`	Position in multi-column key for `Fact Table Join` descriptor.