20 CWM2_OLAP_PC_TRANSFORM

The CWM2_OLAP_PC_TRANSFORM package contains a procedure for generating a SQL script that creates a solved, level-based dimension table from a parent-child dimension table.

After running the script and creating the new table, you can define OLAP Catalog metadata so that OLAP API applications can access the dimension.

This chapter discusses the following topics:

• Prerequisites

• Parent-Child Dimensions

• Solved, Level-Based Dimensions

• Example: Creating a Solved, Level-Based Dimension Table

• Summary of CWM2_OLAP_PC_TRANSFORM Subprograms