Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax for aggregate awareness?
- 3 Answers
- 19904 Views
- Exilant, i-Tree, Wipro, I also Faced
- E-Mail Answers
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
Explain is there any other repository domains rather than universe, security, document?
What is aggregate table and aggregate fact table ... Any examples of both?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
what are the tables used in health care domain project and columns used in report?
how to create reports on screech?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What is the profile and package?
How to execute the plsql procedure from the report by clicking with mouse?
Differences between business objects and web intelligence reports?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain about a task that really tested your analytical abilities?
