Automatically Selecting and Optimizing Aggregates (SAP Library

Automatically Selecting and Optimizing Aggregates

Use

Data for the BW statistics InfoCube and the created queries can be used as part of the automatic selection and optimizing of aggregates.

In this, the system makes an assessment based on the definition of particularly suitable aggregates. Aggregates that appear to be suitable, are proposed automatically. You can optimize the proposed aggregates and use them for further work with the InfoCube.

Prerequisites

An InfoCube in active version is available.

Obviously, queries have to be in the InfoCube already, in order for you to be able to use the query statistics.

These must be collected before BW statistical data can be analyzed. You must activate the collection process for statistical data for the InfoCube ( Administrator Workbench ® Tools ® BW Statistics for InfoCubes) and you must have already executed queries .

Functions

You can display a proposal of aggregates by choosing Proposals from the menu. You have the following options:

Proposals from queries: The queries that are created for an InfoCube are taken into account.

Proposals from the previous navigation: The last navigational step is evaluated, which you carried out with a query.

Proposals from BW Statistics (tables): BW statistical data is taken into account (database tables).

Proposals from BW Statistics (InfoCube): Data which is contained in the BW Statistics InfoCube, is taken into account.

You can also subsequently process the aggregates and add or delete characteristics.

See also:

Proposals from Queries

Proposals from BW Statistics