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?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Which versions are used in the bo dashboard work?
What is object stores?
What are all difference between business objects 6.5 and xi r2?
Explain what are the steps to do to use alerts in bo?
Explain which versions are used in the bo dashboard work?
Can anybody tell me what are the tuning problems?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain what task is 98% of the required work of a business analyst?
What is top business?
what are the tables used in health care domain project and columns used in report?
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 what three things do you consider to be the most important factors for a manager?