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
how to prepare the documentation in business objects and where to get the requirement?
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?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Explain what are the measure objects?
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.
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What are the steps to do to use alerts in bo?
What is the difference in creating filters in designer and business objects?
Can more than 1 metric be applied on an analytic in business objects?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What is report template in b.o?
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)?
Explain is data mart?
What is object stores?