Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2.0.2)

Part Number A95295-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

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".

Table 14-1  OLAP Catalog Dimensional Model Views
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).