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 (CWM2-Specific) Views , 4 of 25


Summary of OLAP Catalog (CWM2)Views

The OLAP Catalog (CWM2) views are summarized in the following table.

Table 13-1 OLAP 2 Catalog Views
View Name Description

ALL$OLAP2_CATALOG_ENTITY_USES

Represents measures in measure folders (catalogs).

ALL$OLAP2_CATALOGS

Represents measure folders (catalogs).

ALL$OLAP2_CUBE_DIM_USES

Represents the association between cubes and their dimensions.

ALL$OLAP2_CUBE_MEAS_DIM_USES

Represents the aggregation method specified for measure/dimension combinations.

ALL$OLAP2_CUBE_MEASURE_MAPS

Represents the mapping of measures to columns in fact tables.

ALL$OLAP2_CUBE_MEASURES

Represents measures.

ALL$OLAP2_CUBES

Represents cubes.

ALL$OLAP2_DIM_ATTR_USES

Represents dimension attributes and their associated level attributes.

ALL$OLAP2_DIM_ATTRIBUTES

Represents dimension attributes.

ALL$OLAP2_DIM_HIER_LEVEL_USES

Represents the relationship between pairs of levels in a hierarchy.

ALL$OLAP2_DIM_HIERARCHIES

Represents hierarchies.

ALL$OLAP2_DIM_LEVEL_ATTR_MAPS

Represents the association between levels and level attributes.

ALL$OLAP2_DIM_LEVEL_ATTRIBUTES

Represents level attributes.

ALL$OLAP2_DIM_LEVELS

Represents levels.

ALL$OLAP2_DIMENSIONS

Represents dimensions.

ALL$OLAP2_ENTITY_DESC_USES

Represents the association between OLAP metadata entities and their descriptors.

ALL$OLAP2_FACT_LEVEL_USES

Represents join relationships between fact tables and dimension tables.

ALL$OLAP2_FACT_TABLE_GID

Represents Grouping ID (GID) columns in fact tables.

ALL$OLAP2_HIER_CUSTOM_SORT

Represents custom sorting information for hierarchies.

ALL$OLAP2_JOIN_KEY_COLUMN_USES

Represents the mapping between levels in a hierarchy.

ALL$OLAP2_LEVEL_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