Buy

Buy

List of Posts

Get this widget
To get notifications, Please like our Facebook Page >>>>>>

Use Search box to find a topic in this Blog!!!

Activating and Filling Aggregates


Procedure documentation Activating and Filling Aggregates Locate the document in its SAP Library structure
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
  1. Select the aggregate that you want to activate and fill.
  2. Choose This graphic is explained in the accompanying text 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 This graphic is explained in the accompanying text for a newly create aggregate or This graphic is explained in the accompanying text for a changed aggregate to This graphic is explained in the accompanying text.
  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 This graphic is explained in the accompanying text.
  3. Note
    If you do not want to fill an aggregate, you can deselect it.
  4. Select This graphic is explained in the accompanying text Fill aggregate. The Execution Time of Aggregation dialog box appears.
Caution
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 This graphic is explained in the accompanying text 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:
This graphic is explained in the accompanying text shows that the job of filling the aggregate is currently running.
This graphic is explained in the accompanying text shows that the job of filling the aggregate is scheduled, but is not running yet.
This graphic is explained in the accompanying text shows that the job of filling the aggregate was canceled.
To find out about your background jobs for filling aggregates, choose This graphic is explained in the accompanying text Jobs. You get to the Simple Job Selection screen.
To view the logs for filling your aggregates, choose This graphic is explained in the accompanying text Log. The Evaluate Application Log dialog box appears.
This graphic is explained in the accompanying text
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 This graphic is explained in the accompanying text.
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 This graphic is explained in the accompanying text to This graphic is explained in the accompanying text.
Note
To activate and fill a number of aggregates at the same time, select them and choose This graphic is explained in the accompanying text 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 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.

1 comment:

  1. 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

Note

This blog is solely for the purpose of getting educated in SAP. This blog does not encourage distribution of SAP hold copyright and any other publication and/or materials bearing SAP mark. If you find any copyright materials, please mail me so I can remove them. This blog is not in association with SAP.

ALL Posts

Get this widget