AW_DIM_DEFINE_LOAD Procedure

This procedure creates a load definition for an OLAP Catalog dimension. The load definition specifies the dimension members to load from the dimension tables and how to store them within the analytic workspace.

The load definition is used by AW_DIMENSION_REFRESH.

The load definition can have one of the types described in Table 16-3.

Table 16-3 Load Types for Dimensions

Load Type	Description
FULL	Load all dimension members. If the dimension has already been loaded, delete all members and replace with the new ones.
FULL_ADDITIONS ONLY	Load all dimension members. If the dimension has already been loaded, keep the existing members that have not changed and add the new members.

Syntax

AW_DIM_DEFINE_LOAD (
          dimension_owner       IN   VARCHAR2,
          dimension_name        IN   VARCHAR2,
          load_name             IN   VARCHAR2,
          load_type             IN   VARCHAR2,
          unique_keys           IN   VARCHAR2);

Parameters

Table 16-4  AW_DIM_DEFINE_LOAD Procedure Parameters

Parameter	Description
dimension_owner	Owner of the OLAP Catalog dimension.
dimension_name	Name of the OLAP Catalog dimension.
load_name	Name of a load definition.
load_type	Type of data load. Specify one of the values listed in Table 16-3, "Load Types for Dimensions".
unique_keys	Whether or not the members of this dimension are unique across all levels. Values can be YES or NO. The default is NO.