Creating an Analytic Workspace From Relational Tables, 4 of 8

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

Note:

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