Automatic Selection and Optimization of
Aggregates
Use
Data for the BI 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.
Prerequisites
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 BI statistical data can be analyzed. In order to collect statistical data, the corresponding function has to be activated for the InfoCube (DW Workbench → Tools → BI Statistics for InfoCubes) and queries must have already been executed.
Features
You can choose Proposals in the menu if you want the system to propose aggregates. You have the following options:
● Proposals from queries: The system considers the queries that are created for an InfoCube.
● Proposals from the previous navigation: The system evaluates the last navigational step that you carried out with a query.
● Proposals from BI Statistics (tables): The system considers BI statistical data (database tables).
● Proposals from BI Statistics (InfoCube): The system considers the data that is contained in the BI Statistics InfoCube.
You can also postprocess the aggregates and add or delete characteristics.
See also: