OLAP Catalog Metadata Descriptors

The OLAP Catalog metadata descriptors provide additional information about your data. These descriptors can be used by the OLAP API.

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

You can view the descriptors that have been set for your OLAP Catalog metadata in the views ALL_OLAP2_ENTITY_EXT_PARMS (described) and ALL_OLAP2_ENTITY_PARAMETERS (described ).

Table 8-1 OLAP Catalog Metadata Descriptors

Descriptor	Applies To	Description
`Level Standard`	level	The level is not in a time dimension.
`Level Year`	level	The year level in a time dimension.
`Level HalfYear`	level	The half year level in a time dimension.
`Level Quarter`	level	The quarter level in a time dimension.
`Level Month`	level	The month level in a time dimension.
`Level Week`	level	The week level in a time dimension.
`Level Day`	level	The day level in a time dimension.
`Level Hour`	level	The hour level in a time dimension.
`Level Minute`	level	The minutes level in a time dimension.
`Level Second`	level	The seconds level in a time dimension.
`Value Separator`	dimension	The separator character used by the OLAP API to construct the names of dimension members. The default separator is "::".
`Skip Level`	hierarchy	Whether or not the hierarchy supports skip levels. An example of a skip level hierarchy is City-State-Country, where Washington D.C. is a City whose parent is a Country.
`Measure Format`	measure	The display format for a measure.
`Measure Unit`	measure	The unit of measurement of a measure.
`Fact Table Join`	hierarchy	The key columns in a dimension table that satisfy the join to a fact table. This descriptor applies to CWM2 metadata only.
`Default Member`	hierarchy	The default dimension member in a hierarchy.
`Dense Indicator`	dimension	Whether or not the data over a given dimension of a cube is dense or sparse.
`Estimated Cardinality`	level	Estimated number of dimension members in a given level.