subramanyam

• Nov 17th, 2007

 

@aggregate aware function is used to increase the query performence by using aggregate tables.

MuthuKumar Sankar

• Nov 22nd, 2007

 

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

senthil0613

 Profile Answers by senthil0613 Questions by senthil0613

• Nov 22nd, 2007

 

hi

thanks. but i need how we use the @ Aggregate function in aggregate table.
please send the syntax.
please explain with one example.

shilps.verma

• Nov 23rd, 2007

 

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))

sheriey

 Profile Answers by sheriey 

• Nov 28th, 2007

 

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