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
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.
|
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 . |
If you do not want to fill an aggregate, you can deselect it.
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.
This takes you to the Time of Subsequent Aggregation dialog box. Enter the date and time for the background processing.
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. |
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.
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.