@aggregate aware function

What is the purpose of @aggregate aware function?
please draw, how you use the @aggregate aware function.

Questions by senthil0613   answers by senthil0613

Showing Answers 1 - 5 of 5 Answers

subramanyam

  • Nov 17th, 2007
 

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

  Was this answer useful?  Yes

MuthuKumar Sankar

  • Nov 22nd, 2007
 

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

  Was this answer useful?  Yes

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

  • 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

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions