Loading Data into Aggregates Efficiently 

Setting Automatic Compression

For each InfoCube, you can set whether the aggregates of the InfoCube are compressed automatically when it is filled with data or after the rollup of data packages (requests).

...

       1.      You are in the Data Warehousing Workbench in the Modeling functional area. In the InfoProvider tree, navigate to the required InfoCube.

       2.      In the context menu of the InfoCube, choose Manage. The Manage Data Targets screen appears.

       3.      In the lower part of the screen, select the Rollup tab page.

       4.      Under the Aggregates group header, set the corresponding indicator in the Compress After Rollup field.

Indicator	What You Need to Know
Set (default): Automatic compression switched on	The aggregates of an InfoCube are compressed automatically when the InfoCube is filled with data or after the rollup of data packages (requests). If you want to delete a data package (request) from the InfoCube and the InfoCube has already been rolled up to the aggregate, you have to deactivate the aggregate and build it again.
Not set: Automatic compression switched off	The aggregates are only compressed with the InfoCube. Use this setting if you have to frequently delete requests from the InfoCube. A specific request can be deleted from the aggregates when it has been deleted from the InfoCube. Note the possible effects on performance; aggregates can become quite large if they are not compressed automatically.

 

Reading the Data in Blocks

If the amount of data is very large when you fill the InfoCube, the system reads the data in blocks and not all at one time. This avoids the problems with the temporary tablespace on the database that may occur if you have very large sources (InfoCubes or aggregates).

For more information about the block size settings, see Customizing under SAP Customizing Implementation Guide ® SAP NetWeaver ® Business Intelligence ®  Performance Settings ® Parameters for Aggregates.

Optimizing Performance of Aggregates with Fewer Characteristics

Aggregates with fewer than 14 characteristics are created for all databases in such a way that each characteristic is in a separate dimension (artificial) and these dimensions are created as line item dimensions. Aggregates that only consist of line item dimensions are filled with pure database means. This improves the performance during filling and when rolling up.

The logical tree display in the right part of the Maintenance for Aggregate screen is copied from the left part of the Selection Options for Aggregates screen but does not mirror this special form of storage on the database.