Data for the BW statistics InfoCube and the created queries can be used as part of the automatic selection and optimizing of aggregates.
In this, the system makes an assessment based on the definition of particularly suitable aggregates. Aggregates that appear to be suitable are proposed automatically. You can optimize the proposed aggregates and use them for further working with the InfoCube.
An active version of the InfoCube is available.
Before you can use the query statistics, queries have to exist for the InfoCube.
These must be collected before BW statistical data can be analyzed. In order to collect statistical data, the corresponding function has to be activated for the InfoCube (DW Workbench → Tools → BW Statistics for InfoCubes) and queries must have already been executed.
You can choose Proposals in the menu if you want the system to propose aggregates. You have the following options:
You can also postprocess the aggregates and add or delete characteristics.