Skip Headers

Oracle9i OLAP User's Guide
Release 2 (

Part Number A95295-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page Go to next page
View PDF

Preparing the Analytic Workspace

The CWM2_OLAP_AW_ACCESS package can expose various types of analytic workspace objects in relational views. You will need to gather information about these objects and decide how you are going to map them to the columns of a relational view. These are the steps you might take:

  1. Identify the measures that you want to make available to applications.
  2. Identify the dimensions of the measures.
  3. For hierarchical dimensions, identify the objects that support the hierarchy:
    • Parent relation
    • Hierarchy dimension
    • Inhierarchy variable
  4. Identify the dimension attributes, which are objects that provide additional information about the dimensions.
  5. If you plan to create OLAP Catalog metadata, be sure that you have a GID needed by the OLAP API. For a description of this object, refer to Chapter 12, "OLAP_TABLE".