AGGREGATION

The AGGREGATION function is available only within a model. Its purpose is to allow you to create a model that represents a custom aggregate. Such an aggmap can be used for dynamic aggregation with the AGGREGATE function.

Note:

Because the AGGREGATION function is intended only for dynamic aggregation, a model that contains such a function cannot be used with the AGGREGATE command.

Syntax

AGGREGATION(dimval-list)

Arguments

dimval-list

A list of one or more dimension values to include in the custom aggregation. The specified values must belong to the same dimension to which the target dimension value belongs. You must specify each dimension value as a text literal. That is, they cannot be represented by a text expression such as a variable.

Examples

Example 7-13 Using the AGGREGATION Function to Create a Custom Aggregate

The following lines of code from a program perform these steps:

Add the new dimension value my_time to the time dimension.

MAINTAIN time ADD 'My_Time'

Define the model mytime_custagg and set the specification of the model using the AGGREGATION function.