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_TRANSFORM
package to generate the views, as described in Chapter 16.CWM2_OLAP_AW_ACCESS
package, as described in Chapter 15.
Note: When you use the |
CWM2
PL/SQL procedures to generate the metadata for all of the data regardless of whether it is stored in relational tables or analytic workspaces.
See Also:
|
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 CWM2
APIs.
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 CWM2_OLAP_AW_MAP
package.
See Also:
|
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|