|Oracle9i OLAP User's Guide
Release 2 (9.2)
Part Number A95295-01
Creating OLAP Catalog Metadata, 4 of 6
The repository for OLAP metadata is known as the OLAP Catalog. This repository is included by default with the Enterprise Edition of the database when installed with either the General Purpose or Data Warehouse configuration.
The OLAP Catalog is one component of Oracle OLAP. The other server-side components are the OLAP calculation engine and support for analytic workspaces. On the client side, Oracle OLAP includes the OLAP API, an API for developing OLAP client applications in Java.
The OLAP Catalog, owned by the
OLAPSYS user, contains two distinct metadata repositories each with its own set of APIs:
CWMmetadata repository, first released with Oracle 9i Release 1, is still supported in the current release. The
CWMmetadata repository, based on CWM Lite (Common Warehouse Metadata) is used by Oracle Enterprise Manager. You can create and view
CWMmetadata by using Enterprise Manager's OLAP Management feature.
CWM2metadata repository, newly available with Release 2 (9.2), provides support for additional warehouse configurations. You can create and view
CWM2metadata by using the
CWM2PL/SQL packages and views.
Both metadata repositories include the following:
CWMmodel tables are named with the
CWM2model tables are named with the
CWMpackages are named with the
CWM2packages are named with the
CWMviews are named with the
CWM2views are named with the
CWM2 additionally includes Preprocessors, PL/SQL packages for transforming certain types of warehouse data to a format supported by the
CWM2 APIs. Preprocessors are available for data stored in analytic workspaces and for parent/child dimension tables.
Depending on the organization of your warehouse and the needs of OLAP clients, you can use
CWM metadata or
CWM2 metadata, or some combination of both.
A separate set of
Whether you create OLAP metadata programmatically (
CWM2) or by using Oracle Enterprise Manager (
CWM), you follow the same logical steps.
To create OLAP metadata: