Functional Summary

With the CWM2_OLAP_AW_CREATE package, you can accomplish the following basic tasks:

• Create an analytic workspace, and define containers within it to represent an OLAP Catalog cube. The cube must be mapped to a star schema.
• Create load definitions. These definitions specify which data to load from the relational tables and how to aggregate it within the analytic workspace.
• Use a load definition to load data from the relational tables and aggregate it within the analytic workspace.
• Build relational views of the resulting analytic workspace. The views use the OLAP_TABLE function, described in Chapter 12, to access the workspace via object technology.

  Note: Currently, the source cube in the OLAP Catalog must be mapped to a star or snowflake schema, as described in "Data Warehouse Requirements".