O'Reilly logo

Creating Universes with SAP BusinessObjects by Taha M. Mahmoud

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

  1. Insert the aggregated tables into our Data Foundation layer.
  2. Use the @Aggregate_Aware() function with common objects.
  3. 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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required