what is the syntax for aggregate awareness?
- 3 Answers
- 17085 Views
- Exilant, i-Tree, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / vams_gk
@Aggregate_Aware(sum(agg_table_1), ... sum(agg_table_n))
| Is This Answer Correct ? | 15 Yes | 3 No |
Answer / suresh
@AGGRIGATE_AWARE(SUMMERY TABLE1.COLUMN,SUMMERY TABLE2.COLUM.........,DETAILED TABLE.COLUMN)
| Is This Answer Correct ? | 1 Yes | 0 No |
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?
What is the test methodology for testing BO Universes?
3.what is alias?
5 Answers Business Intelligence Analytics, TCS,
HOW DO YOU SCHEDULE THE REPORTS?
What task is 98% of the required work of a business analyst?
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
What are universe parameters?
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?
What is the degenerated Objects?
what is crystal reports?how to migrate them?
How to execute the MACRO through Infoview?
Teradata 
