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:
@Aggregate_Aware()function with common objects.
As we don't have any aggregated tables in
NorthWind, we will create an aggregated derived table to simulate a data mart table.
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. ...