Skip Headers

Oracle9i OLAP User's Guide
Release 2 (

Part Number A95295-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page Go to next page
View PDF

Procedure: Create the OLAP Catalog Metadata

Before you can use the CWM2_OLAP_AW_CREATE procedures, you must create a cube in the OLAP Catalog. You can use Enterprise Manager, as described in "Creating Metadata Using Oracle Enterprise Manager", or you can write scripts that use the CWM2 PL/SQL packages, as described in Chapter 13, "Using the OLAP Catalog Metadata APIs".


If you choose to write your own script using the CWM2 packages, be sure to create the cube for a star schema with a single fact table containing only lowest level data.

Each of the cube's hierarchies must have a solved code set to UNSOLVED LEVEL, and the join relationships between the fact table and dimension tables must be mapped with storage type indicator of LOWEST LEVEL.

For more information on setting the solved code for a hierarchy, see Chapter 20. For more information on setting the storage type indicator, see "Mapping OLAP Metadata".