12
Aggregating Data

This chapter describes how to use the aggregation features of the OLAP DML. This chapter includes the following topics:

• About Aggregating Detail Data
• Preliminary Steps Prior to Aggregation
• Creating an Aggregation Map
• About the RELATION Command
• Aggregating Non-Hierarchical Data
• How to Generate Precalculated Data
• How to Calculate Data at Runtime
• Creating Custom Aggregates
• Balancing Precalculated and Runtime Aggregation
• Performing Partial Aggregations
• Combining AGGREGATE with Forecasts and Programs