Viewing OLAP Catalog Metadata , 3 of 25

Views of the Dimensional Model

The following views show the basic dimensional model of OLAP metadata.

For more information on the logical model, see Chapter 4, "Designing Your Database for OLAP".

View Name Synonym	Description
`ALL_OLAP2_CUBES`	Lists all cubes in an Oracle instance.
`ALL_OLAP2_CUBE_MEASURES`	Lists the measures within each cube.
`ALL_OLAP2_CUBE_DIM_USES`	Lists the dimensions within each cube.
`ALL_OLAP2_CUBE_MEAS_DIM_USES`	Shows how each measure is aggregated along each of its dimensions.
`ALL_OLAP2_DIMENSIONS`	Lists all OLAP dimensions in an Oracle instance.
`ALL_OLAP2_DIM_HIERARCHIES`	Lists the hierarchies within each dimension.
`ALL_OLAP2_DIM_LEVELS`	Lists the levels within each dimension.
`ALL_OLAP2_DIM_ATTRIBUTES`	Lists the dimension attributes within each dimension.
`ALL_OLAP2_DIM_LEVEL_ATTRIBUTES`	Lists the level attributes within each level.
`ALL_OLAP2_DIM_ATTR_USES`	Shows how level attributes are associated with each dimension attribute.
`ALL_OLAP2_DIM_HIER_LEVEL_USES`	Show how levels are ordered within each hierarchy.
`ALL_OLAP2_CATALOGS`	List all measure folders (catalogs) within the Oracle instance.
`ALL_OLAP2_CATALOG_ENTITY_USES`	Lists the measures within each measure folder.
`ALL_OLAP2_ENTITY_DESC_USES`	Lists the reserved attributes that have application-specific meanings. Examples are dimension attributes that are used for long and short descriptions and time-series calculations (end date, time span, period ago, and so on).