Start of Content Area

Procedure documentation Creating the First Aggregate for an InfoCube Locate the document in its SAP Library structure

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 Structure linkActivating the Data Transfer for BW Statistics.

Procedure

...

       1.      In the context menu for the InfoCube, choose Maintain Aggregate. The Proposals for Aggregates dialog box appears.

       2.      Specify if you want the system to propose aggregates.

Function

Information

Create proposals

The system proposes suitable aggregates.

The Specify Statistics Data Evaluation dialog box appears. Enter the data that the system asks you for. Choose This graphic is explained in the accompanying text Next.

This will bring you to the Maintain Aggregates screen. The system displays the proposed aggregates in the right area of the Aggregates screen.

Note 

You can change these proposals by using Drag & Drop to add or remove dimensions, characteristics or attributes.

Create yourself

This will bring you to the Maintain Aggregates screen.

For more information see Editing Aggregates.

       3.      To check the aggregate definition for inconsistencies choose This graphic is explained in the accompanying text Check definition.

       4.      Save the aggregates.

Result

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

 

 

End of Content Area