25
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 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