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.
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. In this example, we will create the Yearly Order Details derived table to aggregate the order quantity using Order Year, Order Quarter, and Order Month. These dimensions will be based on Order Date from the Orders table. To create the aggregated...