pinki

• Jul 20th, 2006

 

aggregate awareness function is used to aggregate the values present in the classes in decending order.

for instance we have year,quarter,month,week tables

then we sum the year,sum(quarter),sum(month),sum(week) in decending order respectively.

we also select the compatable as well as incompatible objects through aggregate  navigation so that it improves the performance of the system in generating the report.

opbang

 Profile Answers by opbang 

• Sep 27th, 2006

 

You can use features in Designer to allow you to define the Select statement for an object to run a query against aggregate tables in the database instead of the base tables. You can set conditions so that a query will be run against aggregate tables when it optimizes the query, and if not, then the query will be run against the base tables. This ability of an object to use aggregate tables to optimize a query is called aggregate awareness.