Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2)

Part Number A95295-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

OLAP Catalog Union Views , 3 of 24


Summary of OLAP Catalog Union Views

The OLAP Catalog union views are summarized in the following table.

Table 12-1 OLAP Catalog Union Views
Synonym View Name Description

ALL_OLAP2_CATALOG_ENTITY_USES

ALL$OLAP2UCATALOG_ENTITY_USES

Represents measures in measure folders (catalogs).

ALL_OLAP2_CATALOGS

ALL$OLAP2UCATALOGS

Represents measure folders (catalogs).

ALL_OLAP2_CUBE_DIM_USES

ALL$OLAP2UCUBE_DIM_USES

Represents the association between cubes and their dimensions.

ALL_OLAP2_CUBE_MEAS_DIM_USES

ALL$OLAP2UCUBE_MEAS_DIM_USES

Represents the aggregation method specified for measure/dimension combinations.

ALL_OLAP2_CUBE_MEASURE_MAPS

ALL$OLAP2UCUBE_MEASURE_MAPS

Represents the mapping of measures to columns in fact tables.

ALL_OLAP2_CUBE_MEASURES

ALL$OLAP2UCUBE_MEASURES

Represents measures.

ALL_OLAP2_CUBES

ALL$OLAP2UCUBES

Represents cubes.

ALL_OLAP2_DIM_ATTR_USES

ALL$OLAP2UDIM_ATTR_USES

Represents dimension attributes and their associated level attributes.

ALL_OLAP2_DIM_ATTRIBUTES

ALL$OLAP2UDIM_ATTRIBUTES

Represents dimension attributes.

ALL_OLAP2_DIM_HIER_LEVEL_USES

ALL$OLAP2UDIM_HIER_LEVEL_USES

Represents the relationship between pairs of levels in a hierarchy.

ALL_OLAP2_DIM_HIERARCHIES

ALL$OLAP2UDIM_HIERARCHIES

Represents hierarchies.

ALL_OLAP2_DIM_LEVEL_ATTR_MAPS

ALL$OLAP2UDIM_LEVEL_ATTR_MAPS

Represents the association between levels and level attributes.

ALL_OLAP2_DIM_LEVEL_ATTRIBUTES

ALL$OLAP2UDIM_LEVEL_ATTRIBUTES

Represents level attributes.

ALL_OLAP2_DIM_LEVELS

ALL$OLAP2UDIM_LEVELS

Represents levels.

ALL_OLAP2_DIMENSIONS

ALL$OLAP2UDIMENSIONS

Represents dimensions.

ALL_OLAP2_ENTITY_DESC_USES

ALL$OLAP2UENTITY_DESC_USES

Represents the association between OLAP metadata entities and their descriptors.

ALL_OLAP2_FACT_LEVEL_USES

ALL$OLAP2UFACT_LEVEL_USES

Represents join relationships between fact tables and dimension tables.

ALL_OLAP2_FACT_TABLE_GID

ALL$OLAP2UFACT_TABLE_GID

Represents Grouping ID (GID) columns in fact tables.

ALL_OLAP2_HIER_CUSTOM_SORT

ALL$OLAP2UHIER_CUSTOM_SORT

Represents custom sorting information for hierarchies.

ALL_OLAP2_JOIN_KEY_COLUMN_USES

ALL$OLAP2UJOIN_KEY_COLUMN_USES

Represents the mapping between levels in a hierarchy.

ALL_OLAP2_LEVEL_KEY_COLUMN_USES

ALL$OLAP2ULEVEL_KEY_COLUMN_USES

Represents the mapping of levels to columns in dimension tables.


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 2001, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback