AW_DIMENSION_REFRESH Procedure

This procedure uses a load definition to load values from dimension tables into an analytic workspace.

If the analytic workspace dimension has never been populated, AW_DIMENSION_REFRESH does a full load. Otherwise, it refreshes the dimension based on the load type described in Table 16-3 and on any filter criteria that may have been established by a call to AW_DIM_FILTER_LOAD.

Syntax

AW_DIMENSION_REFRESH (
          aw_owner              IN   VARCHAR2,
          aw_name               IN   VARCHAR2,
          dimension_owner       IN   VARCHAR2,
          dimension_name        IN   VARCHAR2,
          load_name             IN   VARCHAR2);

Parameters

Table 16-6  AW_DIMENSION_REFRESH 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.
load_name	Name of a load definition.