GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Business Objects

 Print  |  
Question:  @aggregate aware function

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


November 11, 2007 19:45:56 #5
 sheriey   Member Since: November 2007    Total Comments: 6 

RE: @aggregate aware function
 

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

     

 

Back To Question