Skip Headers

Oracle9i OLAP User's Guide
Release 2 (

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

Go to previous page Go to next page
View PDF

Overview of the OLAP Catalog

The repository for OLAP metadata is known as the OLAP Catalog. OLAP metadata represents warehouse data as logical cubes, as described in "OLAP Metadata Model".

OLAP metadata must be defined and mapped to any data that will be accessed by the OLAP API. OLAP metadata may also be used by other types of analytical applications.

OLAP metadata maps to dimension tables and fact tables. The dimension tables must be organized in levels. The dimension tables and fact tables may be actual relational tables or they may be views representing data stored in analytic workspaces. A number of different warehouse configurations can be represented by OLAP metadata, as described in "Data Warehouse Requirements".

Tools for Creating OLAP Metadata

There are two tools for creating OLAP metadata:

OLAP Catalog Components

The OLAP Catalog includes the following:

Logical Steps for Creating OLAP Metadata

Whether you create OLAP metadata programmatically or by using Oracle Enterprise Manager, you follow the same logical steps.

To create OLAP metadata:

  1. Create the dimensions. Specify the levels, attributes, and hierarchies associated with each one.
  2. Create cubes and specify their edges (dimensions).
  3. Create measures that represent the fact data. Associate each measure with a cube.
  4. Map the metadata entities to the source data.
  5. Create measure folders in which to store related measures. Populate the folders with measures.