what is the syntax for aggregate awareness?

Answers were Sorted based on User's Feedback



what is the syntax for aggregate awareness?..

Answer / 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

what is the syntax for aggregate awareness?..

Answer / vams_gk

@Aggregate_Aware(sum(agg_table_1), ... sum(agg_table_n))

Is This Answer Correct ?    15 Yes 3 No

what is the syntax for aggregate awareness?..

Answer / suresh

@AGGRIGATE_AWARE(SUMMERY TABLE1.COLUMN,SUMMERY TABLE2.COLUM.........,DETAILED TABLE.COLUMN)

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Business Objects Interview Questions

What is meant by data federator and what is the use of it?

2 Answers   TCS,


What is the purpose of @aggregate aware function?please draw, how you use the @aggregate aware function

6 Answers   Cap Gemini, Deloitte,


how to restrict up to three levels in hierarchy when u do drill mode?

3 Answers   iGate,


IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT?

2 Answers   Clover, Rolta,


Give some information on report bursting?

0 Answers  






what is local filter

2 Answers   Cap Gemini,


GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH PROJECTS?

4 Answers  


Please Send to my e-mail Interview Questions With Answers , Technical Test Questions With Answers and Code Snippets Of Business Objects - Dev , Business Objects - Reporting Analysis .

3 Answers   AOL,


Hi I am starter in BOXIR2.CAn anyone plz tell me the user identification details to be entered at the time of login to designer/deski

1 Answers  


if we shortcut join between two tables what will be the output?that it will give all columns or same columns?

2 Answers  


HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

3 Answers  


What is the difference between Sychronisatio and join?

2 Answers   Mind Tree,


Categories