ALL_OLAP2_CUBE_MEASURE_MAPS

ALL_OLAP2_CUBE_MEASURE_MAPS is a synonym for ALL$OLAP2UCUBE_MEASURE_MAPS.

Each row represents the mapping of a measure to a column in a fact table.

In the OLAP 2 Catalog, measures are mapped separately for each combination of dimension hierarchies. For example, if a measure has three dimensions and each dimension has two hierarchies, then the measure has eight separate fact table mappings. These eight columns may exist within the same fact table or in separate fact tables. Each of the eight column mappings would appear as a separate row in the view.

Column	Data Type	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the cube.
CUBE_NAME	VARCHAR2(30)	NOT NULL	Name of the cube.
MEASURE_NAME	VARCHAR2(30)	NOT NULL	Name of the measure defined by this cube.
DIM_HIER_COMBO_ID	NUMBER	NOT NULL	ID of the association between this measure and one combination of its dimension hierarchies. (Release 2 metadata only)
FACT_TABLE_OWNER	VARCHAR2(30)	NOT NULL	Owner of the fact table.
FACT_TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the fact table.
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the column in the fact table where this measure's data is stored. In Release 2 metadata, the measure's data is for one combination of its hierarchies.