AW_CHOOSE_LEVEL_TUPLES Procedure

This procedure creates a table listing all the level combinations associated with a cube.

The table, SYS.OlapTabLevels, has columns for each of the cube's dimensions. The rows contain the level names for the dimensions. By default, all the levels are selected for aggregation within the analytic workspace.

If you want to specify partial aggregation, you must edit the table. Uncheck each level for which summary data should not be stored.

Once you have established the table of level tuples for a cube, you can call AW_DEFINE_AGG_PLAN to define a set of aggregation rules for a given load definition.

Syntax

AW_CHOOSE_LEVEL_TUPLES (
                       cube_owner  IN   VARCHAR2,
                       cube_name   IN   VARCHAR2);

Parameters

Table 16-12  AW_CHOOSE_LEVEL_TUPLES Procedure Parameters

Parameter	Description
cube_owner	Owner of the OLAP Catalog cube.
cube_name	Name of the OLAP Catalog cube.