what is the syntax for aggregate awareness?
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 |
2.What is loop? How resolve the loop?explain it?
11 Answers TCS, UHG,
How to link one location universe to other location universe
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
how to create reports on screech?
What is the stored procedure ? What is the need of stored procedure ? How to create a stored procedure Universe?
How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?
Explain difference between zabo and webi?
what do u mean by variable functions ?
What are the different types of Filters available in BUSINESS OBJECTS?
i want to hide a chart in reporting level? i want to hide a prompt in designer level?
Can we create universe with no cache??
why less number of records in loop? why more number of records in traps?