Start of Content Area

Function documentation Further Editing Functions for Aggregates  Locate the document in its SAP Library structure

Use

In order to work efficiently with aggregates, you must check the structure and use of the aggregates. You can save time during uploading by either deactivating or deleting the aggregates that you no longer need for reporting.

Functions

Function

Information

This graphic is explained in the accompanying text Aggregate Tree

The Aggregate Tree dialog box appears.

The system shows how the aggregates of an InfoCube lie in relationship to one another. In other words, which aggregate can be built from which other aggregate.

With the help of the aggregate tree, you can identify similar aggregates and manually optimize the specific aggregates on this basis.

Choose automatic optimization in the Maintenance for Aggregate screen from Propose→ Optimize. For further information about automatic optimization, look under Automatically Selecting and Optimizing Aggregates).

This graphic is explained in the accompanying text Switch On/Off

You can temporarily switch off an aggregate to check if you need to use it. An aggregate that is switched off is not used when a query is executed.

To do this select the relevant aggregate and choose This graphic is explained in the accompanying text Switch On/Off. An aggregate that is switched off is marked in column Filled/Switched off with This graphic is explained in the accompanying text.

Since aggregates that are switched off must also be consistent, you do not have to activate the aggregate again or to fill it when you switch it back on.

Execute a query or trace that would use the aggregate that was switched off. Compare the time that the database needs with the time that the query needs when using the aggregate. If the query is not significantly slower without the aggregate, you can deactivate or delete the aggregate.

You can find more information about evaluating and controlling the use of aggregates in Displaying Aggregates and their Components.

This graphic is explained in the accompanying text Deactivate

The system deletes all the data and database tables of an aggregate. The definition of the aggregate is not deleted.

Select the required aggregate and choose This graphic is explained in the accompanying text Deactivate.

The status display in the columns Status and Filled/switched off change back to This graphic is explained in the accompanying text.

If you want to, you can activate and fill the aggregate again later.

This graphic is explained in the accompanying text Delete

The system deactivates the aggregate and deletes the definition of the aggregate.

To do this, select the aggregate to be deleted and select the delete function either with This graphic is explained in the accompanying text  Delete or from the context menu of the aggregate.

 

 

End of Content Area