what is the syntax for aggregate awareness?

Question Posted / dinesh

3 Answers
18627 Views
Exilant, i-Tree, Wipro, I also Faced
E-Mail Answers

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

How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?

2 Answers

what is slice & dice?

3 Answers Cognizant, Saama Tech, TCS,

Difference between scope of analysis in webi and in deski?

1 Answers CA,

Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?

1 Answers

CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?

2 Answers

what is master-detail report

3 Answers Patni, TCS,

Is there any other repository domains rather than universe, security, document?