Activating and Filling Aggregates
Use
To use an aggregate for an InfoCube when executing a query, you must first activate it and then fill it with data.
Prerequisites
You have created or changed an aggregate.
Procedure
- Select the aggregate that you want to activate and fill.
- 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.
|
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 . |
- 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.
- An active aggregate is selected and marked in the Active/Inactive column with an .
- Select Fill aggregate. The Execution Time of Aggregation dialog box appears.
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.
- Define when you want to start the job to fill the aggregate:
- now
- later
- 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
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 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: |
- 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.
- The large, detailed aggregates are filled first.
- The smaller, very compressed aggregates are filled next.
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 in Displaying Aggregates and their Components.
You can roll up new data packages (requests) into the aggregate. For more information see Rolling up Data into an Aggregate.
Really a great addition. I have read this marvelous post. Thanks for sharing information about it. I really like that. Thanks so lot for your convene.6f5 birmingham
ReplyDelete