Performance Tuning for Queries with Aggregates
Data in a data warehouse tends to be very detailed. In SAP BW, the InfoCube is the primary unit of storage for data for reporting purposes. The results obtained by executing a report or query represents a summarized dataset. Drilling down from the higher aggregation levels provides more detailed data, but at the same time restricts the resulting dataset. Aggregates can be created to optimize the performance of these analyses.