AW_DEFINE_AGG_PLAN Procedure

This procedure reads a table of level combinations for a cube and defines an aggregation plan for a cube load definition.

Before calling this procedure, call AW_CHOOSE_LEVEL_TUPLES to create the table SYS.OlapTabLevels. To specify partial aggregation, you must edit this table before calling AW_DEFINE_AGG_PLAN.

Syntax

AW_DEFINE_AGG_PLAN (
          cube_owner     IN   VARCHAR2,
          cube_name      IN   VARCHAR2,
          load_name      IN   VARCHAR2);

Parameters

Table 16-13  AW_DEFINE_AGG_PLAN Procedure Parameters

Parameter	Description
cube_owner	Owner of the OLAP Catalog cube.
cube_name	Name of the OLAP Catalog cube.
load_name	Name of a load definition.