2 Creating OLAP Catalog Metadata with CWM2

The OLAP Catalog CWM2 PL/SQL packages provide stored procedures for creating, dropping, and updating OLAP Catalog metadata. This chapter explains how to work with the CWM2 procedures. For complete syntax descriptions, refer to the reference chapter for each package.

This chapter discusses the following topics:

• Understanding OLAP Catalog Metadata

• OLAP Catalog Metadata Entities

• Creating a Dimension

• Creating a Cube

• Mapping OLAP Catalog Metadata

• Validating and Committing OLAP Catalog Metadata

• Invoking the Procedures

• Directing Output

• Viewing OLAP Catalog Metadata