What is aggregate awareness in BO Universe?

Is a function used to aggregate the data from table, is used to enhance the performance of SQL
transactions; it determines which tables to use in SQL generation either aggregate or detailed tables. Precedence: left to right
Syntax: @Aggregate_Aware (sum (table1.sal), sum (table2.sal))

Setting up Aggregate Awareness:

Build the Objects:
1. Identify all the possible definitions (table/column combinations) of the objects.
2. Arrange the objects by level of aggregation.
3. Build the objects using the @Aggregate_Awareness function.

Specify the incompatible objects
1. Build an objects/aggregate tables matrix.
2. For the first aggregate table, decide whether each object is either:
- at the same level of aggregation or higher (compatible)
- at a lower level of aggregation (incompatible)
3. Check only the boxes of objects that are incompatible for that table.
4. Repeat the steps for the remaining aggregate tables.

Define any necessary contexts
1.Define one context per level of aggregation.

Test the results
1. Run several queries.
2. Compare the results.