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 the Difference b/w Server based Ranking and normal Ranking?

1 Answers  

---

How to Avoid the overlaping the blocks in WEBI.

3 Answers  

---

1.what is input level context and output level context in webI? 2.what is a cascading prompt? Where will you give this and how? 3. What is External Strategy?

1 Answers   IBM,

---

Can we link the Universes from two different sourcess?Explain?

2 Answers   IBM, Oracle,

---

Hi I am starter in BOXIR2.CAn anyone plz tell me the user identification details to be entered at the time of login to designer/deski

1 Answers  

---

What is maximum number of promts we can give in a BO report?

1 Answers   Patni,

---

What is the profile and package?

0 Answers  

---

Explain how many universes can be created in a project?

0 Answers  

---

how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?

1 Answers   Accenture, TCS,

---

Can anybody tell me about issues faced while creating universe. thanks in advance

1 Answers   Accenture,

---

What is domain? How many are there in a basic setup? What are they?

1 Answers  

---

How can we improve performance?

2 Answers  

---