|Oracle9i OLAP User's Guide
Release 2 (18.104.22.168)
Part Number A95295-02
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: