Show TOC

Activating and Filling AggregatesLocate this document in the navigation structure

Activating and Filling Aggregates

Use

To use an aggregate for an InfoCube when executing a query, you must first activate it and thenfill it with data.

Prerequisites

You have created or changed an aggregate.

Procedure

  1. Select the aggregate that you want to activate and fill.
  2. Choose Activate and Fill. The system creates an active version of the aggregate.

System Activity

Result

The system creates the tables required by the aggregate definition in the database. Aggregates are created according to the same schema as InfoCubes.

  • An aggregate contains two fact tables and a number of dimension tables.
  • The table names are derived from the technical names of the aggregates.

If the aggregate was activated successfully, the status display in the Status column changes from for a newly create aggregate or for a changed aggregate to .
  1. Once the aggregate was activated, you must trigger the action to fill the aggregate with data. The Subsequently Aggregate the Aggregates of an InfoCube dialog box appears.
  2. An active aggregate is selected and marked in the Active/Inactive column with an .

  3. If you do not want to fill an aggregate, you can deselect it.

  4. Select Fill aggregate. The Execution Time of Aggregation dialog box appears.

Since it can take a long time to build an aggregate from an InfoCube, all the aggregates are filled in the background.

Note that an aggregate can also read data from a larger aggregate that is already filled. You can therefore assign data to very compressed aggregates quickly.

  1. Define when you want to start the job to fill the aggregate:
  • now
  • later

This takes you to the Time of Subsequent Aggregation dialog box. Enter the date and time for the background processing.

  1. In the Subsequently Aggregate the Aggregates of an InfoCube dialog box, choose Refresh. The system copies the relevant data to the columns
  • User who scheduled the aggregate for building,
  • Date for scheduling the new version of the aggregate
  • Time for scheduling the new version of the aggregate
  • Name of the background job

In the column Job Status you have the following display options:

shows that the job of filling the aggregate is currently running.

shows that the job of filling the aggregate is scheduled, but is not running yet.

shows that the job of filling the aggregate was canceled.

To find out about your background jobs for filling aggregates, choose Jobs. You get to the Simple Job Selection screen.

To view the logs for filling your aggregates, choose Log. The Evaluate Application Log dialog box appears.

By using the transaction SLG1, you can directly access the application log even if the job is not canceled. The Evaluate Application Log dialog box appears.

Enter the required data in the following fields:

Field labels

Entry

Object

RSSM

(Scheduler; Monitor; Tree Callback)

Subobject

MON

(Monitor)

Ext. Identif. (External Identification)

For displaying all logs:

*InfoCube*

For filling new aggregates:

MON:PROTOCOLL_ACTION-AGGR2-InfoCube

(For rolling up already existing aggregates:

MON:PROTOCOLL_ACTION-AGGR1-InfoCube)

Instead of entering InfoCube, enter the technical name of the desired InfoCube.
  1. Choose .

System Activity

Result

The system reports all the executed actions in the lower right part of the log display.

If you used a variable for the key date in an aggregate with time-dependent attributes or hierarchies, the system evaluates this variable when it fills it and builds the aggregate on the computed key date.

If the aggregate was filled successfully, the status display in the column Filled/Switched off, changes from to .

To activate and fill a number of aggregates at the same time, select them and choose Activate and fill.

The system chooses the optimum sequence for filling the aggregates.

  1. The large, detailed aggregates are filled first.
  2. The smaller, very compressed aggregates are filled next.

The larger aggregates can therefore be used already when you are still building the smaller ones.

Result

The active aggregate that is filled with data can be used for reporting. If the aggregate contains data that is to be evaluated by a query, the query data is read automatically from the aggregate.

You can find more information about the number of records read and the use of an aggregate in queries inDisplaying Aggregates and their Components.

You can roll up new data packages (requests) into the aggregate. For more information seeRolling up Data into an Aggregate.