aggregate (SAP Library

aggregate

SAP Business Information Warehouse (BW)

An aggregate stores the dataset of an InfoCube redundantly in a summarized form. In this instance, summarization means the condensing of the original fact table of an Infocube to an aggregate table. This table no longer contains certain characteristics of the Infocube and has been summarized across attributes, or to characteristic values, or a hierarchy level.

The summarization enables you to access the data of an InfoCube quickly when reporting. Aggregates are, therefore, tools for enhancing performance.

Aggregates are created from logical data packets (requests). You can distinguish between the processes of filling and rolling up here:

The first time that data is loaded in an active aggregate is described as filling. After filling, the aggregate is used by reporting.

Rolling up is understood as the loading of data packets from the fact table of an InfoCube in all of the aggregates for this InfoCube.