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


This procedure creates a script that you can run to generate relational views of an AW dimension.

The 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

The AW_DIMENSION_CREATE_ACCESS procedure creates a separate ET-style view for each dimension hierarchy. Each view has a column for each level and level attribute participating in the hierarchy. It also contains grouping ID columns and ET key columns as described in Table 9-2, "Dimension View Columns".

See Also:

"Procedure: Create SQL Access to the Analytic Workspace" and "Column Structure of Dimension Views" .


          dimension_owner       IN   VARCHAR2,
          dimension_name        IN   VARCHAR2,
          aw_owner              IN   VARCHAR2,
          aw_name               IN   VARCHAR2,
          prefix                IN   VARCHAR2,
          access_type           IN   VARCHAR2,
          script_directory      IN   VARCHAR2,
          script_name           IN   VARCHAR2);


Table 16-7  AW_DIMENSION_CREATE_ACCESS Procedure Parameters
Parameter Description


Owner of the OLAP Catalog dimension.


Name of the OLAP Catalog dimension.


Owner of the analytic workspace.


Name of the analytic workspace.


Prefix to be applied to the name of the ADT, the name of the table of ADTs, and the name of the view. See Usage Notes.


How the view will be accessed. Examples are straight SQL, OLAP API, and Discoverer. This argument is not currently used.


The directory that will contain the script.


The script that will generate the views.

Usage Notes

The script creates an ADT (abstract data type) that encapsulates multidimensional data in the analytic workspace, a table of the ADTs, and a view of the table. The ADT, table, and view are named according to specific rules.

The ADT name is the concatenation of the user-supplied prefix, the first five characters of the dimension owner, the first five characters of the dimension name, and the suffix OBJ. The following name identifies an ADT for the Product dimension owned by SH, with a prefix of mydim.


The table of ADT name is like the name of the ADT, but with the suffix TBL. For example,


The view name is similarly constructed, but it contains additional information: the first five characters of the hierarchy name and a hierarchy sequence number. The hierarchy sequence number uniquely identifies each view, starting with one. The following name identifies the first view of the Product dimension owned by SH.