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 |
what is variable ?
Explain when we use aggregate awareness function in designer?
What is the stored procedure ? What is the need of stored procedure ? How to create a stored procedure Universe?
what is drill down?
WHAT IS SYNCHRONIZATION IN BOXI?
My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?
In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?
Explain how to schedule the report in b.o?
How to fix the order of Prompts? How to assign the default value in prompt?
in BO module, you forgot all password even all user in business object, designer, supervisor, gen.supervisor everythicg, how to you recover your datas?
How many tables can an universe contain is their any limit to insert tables in the universe?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?