|Oracle9i OLAP User's Guide
Release 2 (18.104.22.168)
Part Number A95295-02
CWM2 PL/SQL packages contain stored procedures that can create OLAP metadata for a variety of data warehouses, as described in "Data Warehouse Requirements".
Part IV, "OLAP Catalog Metadata API Reference" for the comprehensive syntax of the
A set of views, identified by the
ALL_OLAP2 prefix, presents the metadata in the OLAP Catalog. The metadata may have been created with the
CWM2 PL/SQL packages or with Enterprise Manager. These views are described in Chapter 14, "Viewing OLAP Catalog Metadata".
The following packages contain procedures that create metadata for dimension tables:
CWM2_OLAP_DIMENSIONcontains procedures for creating dimensions.
CWM2_OLAP_HIERARCHYcontains procedures for creating hierarchies for dimensions.
CWM2_OLAP_LEVELcontains procedures for creating levels for dimensions and for associating levels with hierarchies.
CWM2_OLAP_LEVEL_ATTRIBUTEcontains procedures for creating level attributes and associating them with levels.
CWM2_OLAP_DIMENSION_ATTRIBUTEcontains procedures for creating dimension attributes and associating them with dimensions.
The following packages contain procedures that create metadata for fact tables:
CWM2_OLAP_CUBEcontains procedures for creating the multidimensional structure of cubes.
CWM2_OLAP_MEASUREcontains procedures for creating measures and associating them with cubes.
CWM2_OLAP_TABLE_MAP package contains procedures that map logical metadata entities to their physical data source. The data may be stored in relational tables, or it may be represented by relational views. When the dimension tables and fact tables are defined as views, the actual data may reside in analytic workspaces.
CWM2_OLAP_AW_CREATE package contains procedures for replicating a star schema within an analytic workspace and creating relational views of the workspace.
CWM2_OLAP_AW_ACCESS package contains generic procedures for creating relational views of analytic workspaces. These workspaces do not have to be created by
CWM2_OLAP_PC_TRANSFORM package contains a procedure for transforming parent-child dimension tables to level-based dimension tables. This conversion is necessary if the dimension will be accessed by the OLAP API.
The following packages contain procedures for creating measure folders and validating OLAP metadata: