AW_CUBE_CREATE_ACCESS Procedure

The AW_CUBE_CREATE_ACCESS procedure creates a script that you can run to generate fact views of AW cubes.

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 script created by AW_CUBE_CREATE_ACCESS generates a fully solved fact view for every dimension/hierarchy of the cube. Each view has a column for each of the cube's measures. It also contains a grouping ID column and an ET key column for each dimension to link the fact view with the associated dimension views.

Syntax

AW_CUBE_CREATE_ACCESS (
          cube_owner          IN   VARCHAR2,
          cube_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-15  AW_CUBE_CREATE_ACCESS Procedure Parameters

Parameter	Description
cube_owner	Owner of the OLAP Catalog cube.
cube_name	Name of the OLAP Catalog cube.
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 cube owner, the first five characters of the cube name, and the suffix OBJ. The following name identifies an ADT for the Sales cube owned by SH, with a prefix of mydim.

mydim_sh_sales_OBJ

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

mydim_sh_sales_TBL

The view name is similarly constructed, but it contains an additional sequence number that uniquely identifies the view. The following name identifies the first view of the Sales cube owned by SH, with a prefix of mydim.

mydim_sh_sales_1_view