Creating the First Aggregate for an InfoCube (SAP Library

Creating the First Aggregate for an InfoCube

Prerequisites

The InfoCube for which you want to create an aggregate has been saved and is active. There are not yet any aggregates for the selected InfoCube.

Note the following requirements if you want to have the system propose aggregates:

You must have created at least one query for the selected InfoCube or for a MultiCube that uses the InfoCube. The necessary aggregates can be proposed when you start the queries and navigate in them.

Make sure that you have switched on BW statistics collection for the selected InfoCube in the OLAP area. For more information see Activating Data Transfers for BW Statistics.

Procedure

In the context menu for the InfoCube, select Maintain Aggregates. The Proposals for Aggregates dialog box appears.

Specify if you want the system to propose aggregates.

Function	What you need to know
Generate proposals	The system proposes suitable aggregates. The Specify Statistics Data Evaluation dialog box appears. Type in the data that the system asks you for. Choose Continue. This will bring you to screen Maintenance for Aggregate. The system displays the proposed aggregates in the right area of the Aggregates screen. You can change these proposals by using Drag & Drop to add or remove dimensions, characteristics or attributes.
Create by yourself	This will bring you to screen Maintenance for Aggregate. For more information see Editing Aggregates.

To check the aggregate definition for inconsistencies choose

Check definition.

Save the aggregates.

Result

You can activate the aggregates you just created and fill them with data.