CWM2_OLAP_AW_CREATE , 3 of 15

AW_DIMENSION_CREATE Procedure

This procedure creates the containers within an analytic workspace to hold an OLAP Catalog dimension.

The OLAP Catalog dimension must conform to the requirements specified in "Basic Star or Snowflake Schema".

If the analytic workspace does not already exist, AW_DIMENSION_CREATE creates it.

Syntax

AW_DIMENSION_CREATE (
          aw_owner           IN   VARCHAR2,
          aw_name            IN   VARCHAR2,
          dimension_owner    IN   VARCHAR2,
          dimension_name     IN   VARCHAR2);

Parameters

Table 16-2 AW_DIMENSION_CREATE Procedure Parameters

Parameter	Description
`aw_owner`	Owner of the analytic workspace.
`aw_name`	Name of the analytic workspace.
`dimension_owner`	Owner of the OLAP Catalog dimension.
`dimension_name`	Name of the OLAP Catalog dimension.