Aggregates in sap bi pdf

In many cases index on data request dimension is chosen. The tool helps you to identify how much block size you can actually generate with your existing aggregates. Skip to Content. Former Member. September 21, 5 minute read. Split of the query is based on the following rules: Condition 1: Parts of the query on different aggregation levels are split. Condition 2: Different Selections on characteristics are combined Condition 3: Parts on different hierarchy levels or parts using different hierarchies are split.

Condition 1: Summarization Ratio greater than 10 Summarization Ratio is the ratio of number of records in the cube to the number of records in the aggregate. Please note that building an aggregate will only improve the database access time. It basically helps to analyze the queries with highest run time.

Aggregate Rollup: Is a step by which, the newly added data at the cube level gets aggregated and available for reporting. All the data containing the navigational attributes gets realigned.

Adjustment of time dependent aggregates: This is done to recalculate the aggregates with time dependent navigational attributes. Any aggregate that is created on a cube has to be periodically monitored for its usage and the last used date. If there is any aggregate that is not being used, it has to be either modified or removed Un-used aggregates add to the load performance.

It is always a good practice to drop the aggregates that are not being used. The aggregate is transparent for the end user. New data is loaded at a defined time using logical data packages requests in an aggregate. After this transaction, the new data is available for rolling up in reporting.

Labels: Maintaining Aggregates in BW. An aggregate is a materialized view on a subset of an InfoCube. It can contain characteristics and navigational attributes and can be restricted to fixed values F and hierarchy levels H. Its purpose is to reduce the amount of data read from the DB during query execution. A BEx query always tries to use performance-optimized sources by checking the sources from which it can draw the requested data.

It checks them in the following order:. So, if there is no cache entry or BWA index available, the system takes proper aggregates in case some exist. On the Maintenance of Aggregates screen, you can find detailed information about the structure and status of the individual aggregates.

Tools are available as further functions for temporarily deactivate or switch off for reporting or completely delete aggregates that you no longer want to use in reporting:. See also Further Edition Functions for Aggregates.

With this function you can query information on the fill process of an aggregate, in which the system simulates the fill process and writes selected information to the log. The Process Chain provides the following rollup processes:.