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
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain when to use local filter and when to use global filter?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
how to create reports on screech?
any difficulitis have you phase while creating bo reports and how did u solve it
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
How can you first report in Business Objects by using broadcast agent?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
What Is Snow Flake Schema?
What is thumbnail?
Explain how we drill up week to month?
What is object stores?
Difference between zabo and webi?
What would you consider as your biggest achievement and why?