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

Creating Metadata Using PL/SQL

The CWM2 PL/SQL packages contain stored procedures that can create OLAP metadata for a variety of data warehouses, as described in "Data Warehouse Requirements".

Before using these packages, make sure that you have performed any required preprocessing steps, as described in "Multidimensional Data" and "Parent-Child Dimensions".

See Also:

Part IV, "OLAP Catalog Metadata API Reference" for the comprehensive syntax of the CWM2 packages and examples of their use.

Views of OLAP Catalog Metadata

A set of views, identified by the ALL_OLAP2 prefix, presents the metadata in the OLAP Catalog. The metadata may have been created with the CWM2 PL/SQL packages or with Enterprise Manager. These views are described in Chapter 14, "Viewing OLAP Catalog Metadata".

CWM2 Packages for Creating OLAP Dimensions

The following packages contain procedures that create metadata for dimension tables:

CWM2 Packages for Creating Cubes

The following packages contain procedures that create metadata for fact tables:

CWM2 Package for Mapping Metadata

The CWM2_OLAP_TABLE_MAP package contains procedures that map logical metadata entities to their physical data source. The data may be stored in relational tables, or it may be represented by relational views. When the dimension tables and fact tables are defined as views, the actual data may reside in analytic workspaces.

CWM2 Package for Creating Analytic Workspaces

The CWM2_OLAP_AW_CREATE package contains procedures for replicating a star schema within an analytic workspace and creating relational views of the workspace.

The CWM2_OLAP_AW_ACCESS package contains generic procedures for creating relational views of analytic workspaces. These workspaces do not have to be created by CWM2_OLAP_AW_CREATE.

CWM2 Package for Creating Level-Based Dimension Tables

The CWM2_OLAP_PC_TRANSFORM package contains a procedure for transforming parent-child dimension tables to level-based dimension tables. This conversion is necessary if the dimension will be accessed by the OLAP API.

CWM2 Packages for Classification and Validation

The following packages contain procedures for creating measure folders and validating OLAP metadata: