InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How To Set Up Aggregate Awareness? |
|
Answer» To use aggregate AWARENESS, first the aggregated table has to be loaded to database and then ADD the table to DATA Foundation. Define aggregate aware objects. These are objects in the business layer for which you want queries to use the aggregate tables when possible instead of PERFORMING aggregation using non-aggregate tables. In the SQL expression for the object, define the SELECT statement to use the @Aggregate_Aware function − @Aggregate_Aware(sum(aggr_table_1), …, sum(aggr_table_n)) To use aggregate awareness, first the aggregated table has to be loaded to database and then add the table to Data Foundation. Define aggregate aware objects. These are objects in the business layer for which you want queries to use the aggregate tables when possible instead of performing aggregation using non-aggregate tables. In the SQL expression for the object, define the SELECT statement to use the @Aggregate_Aware function − @Aggregate_Aware(sum(aggr_table_1), …, sum(aggr_table_n)) |
|