|Oracle9i OLAP User's Guide
Release 2 (9.2)
Part Number A95295-01
Creating OLAP Catalog Metadata, 2 of 6
There are two tools for creating OLAP metadata:
The tool that you can use depends on the structure of your data warehouse.
OLAP Management is a tool in Oracle Enterprise Manager that provides an easy-to-use graphical interface to release 1 of the OLAP Catalog (
CWM). This tool creates a database
DIMENSION object for all logical dimensions defined in the metadata, which imposes the following requirements on the dimension tables:
If your data warehouse complies with all of these requirements, then you can use either Enterprise Manager or the
CWM2 APIs for defining OLAP metadata. No preprocessing steps are required.
Your ITT tool may have created metadata already. If so, you should check it using the OLAP Management tool to see if the metadata structures are "OLAP enabled."
Release 2 of the OLAP Catalog (
CWM2) supports the following variations in dimension tables:
If your dimension tables have any of these characteristics, then you must use the
CWM2 APIs to create OLAP metadata. No preprocessing is required.
If your data warehouse stores data in analytic workspaces or has parent/child (instead of level-based) dimensions, then you must use the
CWM2 APIs to create OLAP metadata. For both types of warehouse storage, OLAP metadata creation is a two-step process:
CWM2_OLAP_PC_TRANSFORMpackage to generate the views, as described in Chapter 16.
CWM2_OLAP_AW_ACCESSpackage, as described in Chapter 15.
When you use the
CWM2PL/SQL procedures to generate the metadata for all of the data regardless of whether it is stored in relational tables or analytic workspaces.
If some or all of your warehouse solution is stored in analytic workspaces, you may wish to create metadata that directly represents the multidimensional objects defined within the workspaces. This can be done using the
Objects within analytic workspaces are defined and manipulated by the OLAP Data Manipulation Language (DML).
To create metadata for analytic workspace objects, use the procedures in the
CWM2_OLAP_AW_OBJECT package. To map this metadata to objects in an analytic workspace, use the procedures in the