AW_CUBE_REFRESH Procedure

This procedure uses a load definition to load data from a fact table into an analytic workspace. Unless a filter criteria was established for the data load, AW_CUBE_REFRESH loads all the data from the fact table.

If an aggregation plan was established for this data load, AW_CUBE_REFRESH aggregates the data to the specified level. Otherwise, it fully aggregates the data within the analytic workspace.

Syntax

AW_CUBE_REFRESH (
          aw_owner         IN   VARCHAR2,
          aw_name          IN   VARCHAR2,
          cube_owner       IN   VARCHAR2,
          cube_name        IN   VARCHAR2,
          load_name        IN    VARCHAR2);

Parameters

Table 16-14  AW_CUBE_REFRESH Procedure Parameters

Parameter	Description
aw_owner	Owner of the analytic workspace.
aw_name	Name of the analytic workspace.
cube_owner	Owner of the cube.
cube_name	Name of the cube.
load_name	Name of the load definition.