AGG

The AGG command consolidates database values. An AGG command ignores all member formulas; it simply consolidates parent/child relationships.

Syntax

AGG (dimList);

dimList Name of a single dimension or a comma-delimited list of dimensions.

Description

The AGG command is used for a limited set of high-speed consolidations. Although AGG is faster than any of the CALC commands when calculating sparse dimensions, it cannot calculate formulas; it can only perform aggregations based on the database structure. The AGG command aggregates a list of sparse dimensions. The aggregation is based on the hierarchical relationship defined in the database outline. If a member has a customized calculation defined in the outline, the formula is ignored and the result does not match the relationship defined by the database outline.

If you want to aggregate a dimension that contains formulas:

Calculate any members that are "leaf" members (i.e., level 0).
Aggregate the dimension, using the AGG command.
Calculate all other members with formulas that have not been calculated yet.

Notes

AGG only works with sparse dimensions.
When a dimension contains fewer than six consolidation levels, AGG is typically faster than CALC. Conversely, the CALC command is usually faster on dimensions with six or more levels.
AGG follows the rules for any defined FIX command.

Example

AGG(Market);
AGG(Product,Market,Scenario);

See Also

CALC ALL
CALC DIM
SET AGGMSG