Aggregate awareness
The aggregate awareness feature is used to increase performance by leading the report query to select objects from the aggregated table instead of the detailed table at runtime. There are three main steps to set up the aggregate awareness feature:
- Insert the aggregated tables into our Data Foundation layer.
- Use the
@Aggregate_Aware()function with common objects. - Detect and set the incompatible objects.
As we don't have any aggregated tables in NorthWind, we will create an aggregated derived table to simulate a data mart table.
Inserting aggregated tables
The first step is to insert the data mart aggregated table into our Data Foundation layer. As we don't have one, we should create the aggregated derived table to simulate the case. ...
Get Creating Universes with SAP BusinessObjects now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
