This function is user to aggregate the values in ascending order which is present in the class.

Lets understand the use of Aggregation first with examples.

Information is stored in the datawarehouse in the summarised form.
Instead of recording the date and time each time a certain product is sold the data warehouse could store the quantity each hour each day or each week.
Here comes the use of aggregation--
Primarily for 2 purposes;
- To save the storage space
DWHs can get large with exponential increase in data. Use of aggregations greatly reduces the space
- To improve the performance of BI tools.
When queries run faster they take up less processing time and the users get their information back more quickly.

Relating these facts to BO now
@Aggregate_Aware is a function which determines which tables to use in SQL generation.
(detailed or aggregated ?)
@Aggregate_Aware(sum(table1.revenue) sum(table2.revenue))

The @Aggregate_Aware function allows an object to take advantage of tables

containing summary data in the database. If your database contains summary

tables and you are running queries that return aggregate data it is quicker to run

a Select statement on the columns that contain summary data rather than on the

columns that contain fact or event data.

You can use the @Aggregate_Aware function to set up aggregate awareness in

a universe. This process includes a number of other steps which are associated

with the use of the @Aggregate_Aware function