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.

Answer / vams_gk

@Aggregate_Aware(sum(agg_table_1), ... sum(agg_table_n))

Answer / suresh

@AGGRIGATE_AWARE(SUMMERY TABLE1.COLUMN,SUMMERY TABLE2.COLUM.........,DETAILED TABLE.COLUMN)

what is a filter?

4 Answers  

---

I need to develop cross tab in format: Values D E F A 1 3 4 B 2 5 8 C 9 8 10 My problem is values in header I am able to do same in WEBI how to manipulate same in deski? Plz Help

1 Answers  

---

what are the documentations u r created?

2 Answers   Wipro,

---

am a fresher hw to get real time experience?

1 Answers   Cap Gemini,

---

How to link two different universes ?

3 Answers  

---

How to restrict the user to refresh or Run the report only 1 time in BO?

6 Answers   Perot Systems,

---

can anybody tell me about issues faced while creating reports

1 Answers   Accenture, Tech Mahindra,

---

how to restrict null values in webi report?

2 Answers   InfoStep,

---

How to hide the table s in webi?can any one tell me plzzzzzzzz

9 Answers   Accenture, TCS,

---

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

0 Answers   PWC,

---

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

0 Answers  

---

What is batch processing in Business Objects?

2 Answers  

---