Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2.0.2)

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

Go to previous page Go to next page
View PDF

AW_DIMENSION_CREATE_ACCESS Procedure

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" .

Syntax

AW_DIMENSION_CREATE_ACCESS (
          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);

Parameters

Table 16-7  AW_DIMENSION_CREATE_ACCESS Procedure Parameters
Parameter Description

dimension_owner

Owner of the OLAP Catalog dimension.

dimension_name

Name of the OLAP Catalog dimension.

aw_owner

Owner of the analytic workspace.

aw_name

Name of the analytic workspace.

prefix

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.

access_type

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

script_directory

The directory that will contain the script.

script_name

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.

mydim_sh_produ_OBJ

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

mydim_sh_produ_TBL

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.

mydim_sh_produ_std_1_view