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".

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_OLAP_DIMENSION contains procedures for creating dimensions.
• CWM2_OLAP_HIERARCHY contains procedures for creating hierarchies for dimensions.
• CWM2_OLAP_LEVEL contains procedures for creating levels for dimensions and for associating levels with hierarchies.
• CWM2_OLAP_LEVEL_ATTRIBUTE contains procedures for creating level attributes and associating them with levels.
• CWM2_OLAP_DIMENSION_ATTRIBUTE contains procedures for creating dimension attributes and associating them with dimensions.

CWM2 Packages for Creating Cubes

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

• CWM2_OLAP_CUBE contains procedures for creating the multidimensional structure of cubes.
• CWM2_OLAP_MEASURE contains procedures for creating measures and associating them with cubes.

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:

• CWM_CLASSIFY
• CWM2_OLAP_VALIDATE