Object documentation Displaying Aggregates and their Components Locate the document in its SAP Library structure

Definition

The screen area of the Aggregate Maintenance screen in which aggregates and their components are displayed in a logical tree.

Use

You use this screen area to:

You can define several aggregates for an InfoCube. However, make sure that their usefulness balances out their disadvantages:

To optimize an InfoCube, you should repeatedly check:

The display of the aggregates in the Aggregate Maintenance screen helps you to evaluate the aggregates.

Structure

Column

Information

Aggregates

Aggregates with all transferred components in a tree display

Technical name

  

Save

This graphic is explained in the accompanying text Marks new or changed aggregates

Proposed action

The system proposes actions if necessary

Example

Once the system has proposed a new aggregate, it recommends that you activate this aggregate. This is marked by a This graphic is explained in the accompanying text in this column.

Status

This graphic is explained in the accompanying text Created

This graphic is explained in the accompanying text Changed (The modified aggregate definition is no longer the same as the active aggregate definition)

This graphic is explained in the accompanying text Saved and active

Filled/switched off

This graphic is explained in the accompanying text Not filled with data

This graphic is explained in the accompanying text Filled with data

Refers to individual components in the aggregate:

By default the system aggregates by value of the selected objects:

  • '*' All characteristic values
  • 'H' Hierarchy level
  • 'F' Fixed value

You can change this setting from the context menu of the displayed aggregation level.

  • Hierarchy

If necessary, name of the selected hierarchy
  • Hierarchy level

If necessary, selected level of the hierarchy
  • Fixed value

If necessary, selected fixed value

Evaluation

Representation in a bar chart:

  • The larger the number of minus signs, the worse is the evaluation of the aggregate:

"-----" means: The aggregate can possibly be deleted.

  • The larger the number of plus signs, the better is the evaluation of the aggregate:

"+++++" means: The aggregate could make a lot of sense.

The evaluation is based on a number of criteria. At the moment the following is used in the evaluation:

  • The compression of the data compared with the InfoCube: How much smaller is the aggregate compared to the InfoCube?
  • When was the aggregate last used? (see under last used).

Records

Number of records in the filled aggregate.

This information tells you something about the size of the aggregate.

Records compressed (mean value)

Number of records read on an average from the source in order to create a record in the aggregate.

Example 

Given an aggregate with three records. For example if 10 records were read for the first record in the aggregate, 15 records were read for the second record and 20 records for the third record, the aggregate has a mean of 15 "records compressed".

This information tells you something about the quality of the aggregate.

  • The larger the value, the greater is the compression and the better the quality of aggregate.

Note 

Since an aggregate should be 10 times smaller than its source, the number should be larger than 10.

  • If the value is "1", the aggregate is a copy of the InfoCube. In this case, consider deleting the aggregate.

Use

Number of uses (in queries).

How often was the aggregate used for Reporting

Last usage

Date.

When was the aggregate last used for Reporting?

If an aggregate has not been used for a long time, deactivate or delete it.

Caution

Note that certain aggregates cannot be used at certain times (for example during vacation).

Do not delete basic aggregates that you created to speed up the hierarchy/attribute change run.

Last roll-up

Date.

When was the last time that data was entered for the aggregate?

Last roll-up by

User name of the person who scheduled the roll-up.

Last changed on

Date.

When was the aggregate definition last changed?

Last changed by

User name of the person who made the last change.

Integration

The log display is shown in the lower part of the screen when the aggregate is defined and after filling it with data.

Status Overview of the Aggregates

You can find a status display for all the aggregates in the BW system in the functional area Monitoring of the Administrator Workbench:

In the navigation window choose This graphic is explained in the accompanying text Status overview. The screen area Status of the Aggregates lists all the InfoCubes and all the existing aggregates under each InfoCube.

The structure of this screen area corresponds to the Aggregate screen area of the Aggregate Maintenance screen. Only the status and not the components of the aggregate are displayed.

By double-clicking on This graphic is explained in the accompanying text of a certain aggregate you go to the Aggregate Display screen. The aggregate is displayed here together with its components.