13
Using the OLAP Catalog Metadata APIs

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

This chapter discusses the following topics:

• OLAP Metadata Entities
• Constructing a Dimension
• Constructing a Cube
• Mapping OLAP Metadata
• Validating OLAP Metadata
• Invoking the Procedures
• Viewing OLAP Catalog Metadata
• Example: Creating OLAP Metadata for a Dimension Table
• Example: Creating OLAP Metadata for a Fact Table