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

Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

815


Explain when to use local filter and when to use global filter?

1169


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?

2026


how to create reports on screech?

2284


any difficulitis have you phase while creating bo reports and how did u solve it

3200


Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

773


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

828


How can you first report in Business Objects by using broadcast agent?

2840


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2126


What Is Snow Flake Schema?

911


What is thumbnail?

767


Explain how we drill up week to month?

859


What is object stores?

790


Difference between zabo and webi?

868


What would you consider as your biggest achievement and why?

819