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

Procedure: Create SQL Access to the Analytic Workspace

Once you have completed the steps described in Procedure: Create the Analytic Workspace Cube, you can generate the relational views that will allow SQL applications to access the analytic workspace. These views contain calls to the OLAP_TABLE function. OLAP_TABLE, described in Chapter 12, uses object technology to present the contents of the workspace in table format.

Use the following steps to generate the views:

  1. Call the AW_DIMENSION_CREATE_ACCESS Procedure to generate views of the cube's dimensions.
  2. Call the AW_CUBE_CREATE_ACCESS Procedure to generate views of the cube's measures.


    In the current release, the views generated by AW_DIMENSION_CREATE_ACCESS and AW_CUBE_CREATE_ACCESS are structured in the format required by the OLAP API.