|Oracle9i OLAP User's Guide
Release 2 (18.104.22.168)
Part Number A95295-02
CWM2 APIs support and extend Enterprise Manager's warehouse requirements.
Enterprise Manager creates OLAP metadata for star and snowflake schemas. It creates a database dimension object for each logical OLAP dimension. The database dimension object imposes the following restrictions on dimension tables and related fact tables:
If your data warehouse complies with these requirements, you can use either Enterprise Manager or the
CWM2 APIs to create OLAP metadata.
If your dimension tables include any of the following variations, you must use the
CWM2 APIs to create OLAP metadata:
Fact data is unsolved when it is stored at the lowest level of aggregation. Fact data is solved when it is stored with embedded totals.
Enterprise Manager creates OLAP metadata for unsolved fact data. With the
CWM2 APIs, you can create OLAP metadata for both solved and unsolved fact data.
CWM2 APIs also support multiple fact tables per cube. In this case, the data associated with a given combinations of hierarchies can be stored in a separate fact table. All the fact tables associated with a cube must have the same column structure.
CWM2 APIs, you can create and populate analytic workspaces from a star schema and generate relational views of the resulting workspaces. You can then create OLAP metadata based on these views. Use the following procedure.
CWM2_OLAP_AW_CREATEpackage, as described in Chapter 9 to create the workspace and create relational views of the data. These views take the place of fact tables and dimension tables.
CWM2APIs to create OLAP metadata based on these views.
If your data is stored in an analytic workspace that was created in some other way, for example by using OLAP Worksheet or the
If the dimensions of your data are stored in parent-child dimension tables, then you must convert them to level-based dimensions before creating OLAP metadata. Use the following procedure:
CWM2_OLAP_PC_TRANSFORMpackage, as described in Chapter 25 to convert the parent-child dimensions to a level-based dimensions.
CWM2APIs to create OLAP metadata based on the level-based dimensions.