Hi,

Aggregate awareness is the ability of a universe to make use of aggregate tables in a database. These are tables that contain pre-calculated data. You can use the @Aggregate_Aware function in the Select statement for an object that directs a query to be run against aggregate tables rather than a table containing non aggregated data.

If the above mentioned answer is not useful or want more details on this
please feel free to write me. you can also send me an email: tanvir.mir12@gmail.com

Thanks,
Tanveer