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

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