Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?

5 Answers   TCS,


What is the test methodology for testing BO Universes?

3 Answers   Cisco, TCS,


3.what is alias?

5 Answers   Business Intelligence Analytics, TCS,


HOW DO YOU SCHEDULE THE REPORTS?

5 Answers  


What task is 98% of the required work of a business analyst?

0 Answers  






IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

2 Answers   Accenture, Rolta, TCS,


how to creat 2 way drilling mode.can any one know this

0 Answers  


What are universe parameters?

6 Answers  


1)Difference between BO 5.1.2 and BO 6.5.1 and also BO XI (R2)?? 2)Difference between oracle 8i amd oracle 9i? 3)Difference between SQL and PL/SQL? 4)what is Broad cast Agent? 5)what is prompts? 6)master detail format means? 7)performance tuning of reports means? 8)ad-hoc reports means? 9)can't we generate reports without creating universe?

3 Answers   Oracle,


What is the degenerated Objects?

2 Answers  


what is crystal reports?how to migrate them?

2 Answers   IBM,


How to execute the MACRO through Infoview?

1 Answers  






Categories