Show TOC

Creating the First Aggregate for an InfoCubeLocate this document in the navigation structure

Prerequisites

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

Note that the following conditions have to be met if you want the system to propose aggregates:

  • You must have created at least one query for the selected InfoCube or a MultiCube that uses the InfoCube. The system can propose the required aggregates 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. More information: Maintenance of Statistics Properties .

Procedure

  1. In the context menu for the InfoCube, choose Maintain Aggregates . The Proposals for Aggregates dialog box appears.
  2. Specify if you want the system to propose aggregates.

    Function

    What You Need to Know

    Create proposals

    The system proposes suitable aggregates.

    The Specify Statistics Data Evaluation dialog box appears. Enter the required data. Choose Continue .

    The Maintain Aggregates screen appears. The system displays the proposed aggregates in the right area of the Aggregates screen.

    Note

    You can change these proposals by using drag and drop to add or remove dimensions, characteristics or attributes.

    Create yourself

    The Maintain Aggregates screen appears.

    More information: Editing Aggregates Manually .

    1. To check the aggregate definition for inconsistencies, choose Check Definition .

    2. Save the aggregates.

Results

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