what is the syntax for aggregate awareness?

Answer Posted / kshatri

Aggregate awareness is a feature that makes use of
predefined aggregate tables to enhance the performance of
SQL transactions. It is used to improve the speed by which
aggregates are calculated in the database. To set up
aggregate awareness in a universe, you define or more
objects using the @Aggregate_Aware function. The syntax for
this function is as follows:

@Aggregate_Aware(aggregate_table_1, ... aggregate_table_n)

The arguments of this function are all the names of
alternative aggregate tables. When you formulate the
syntax, you should be aware of the order of the arguments.
The precedence is from left to right; this means that
BusinessObjects determines the aggregate to use beginning
from the leftmost argument.

Is This Answer Correct ?    20 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to prepare the documentation in business objects and where to get the requirement?

1759


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

524


Explain how to execute the plsql procedure from the report by clicking with mouse?

579


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

575


Explain what are the measure objects?

525






I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

2971


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

644


What are the steps to do to use alerts in bo?

611


What is the difference in creating filters in designer and business objects?

560


Can more than 1 metric be applied on an analytic in business objects?

1632


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

1940


What is report template in b.o?

557


Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

517


Explain is data mart?

567


What is object stores?

561