BO Designer Interview Question:

What is mean by aggregate aware?
How we are using this function?

Submitted by: Administrator

Aggregate awareness is a term that describes the ability of a universe to make use of aggregate tables in a database. These are tables that contain precalculated data. You can use a function called @Aggregate_Aware 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.

Pros:
Speed up the execution of query and Improve the performance of Sql transaction.

If you are using the aggregate tables then you must refresh the aggregate table with all fact tables to have the consistency in your result.
Submitted by: Administrator