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)

Can anybody tell me . Is it required CMS Server for Desktop Intelligence Reports?

3 Answers  

---

What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...

7 Answers   TCS,

---

Can any body tell me,What is the universe testing ? What is the report testing Explain?

2 Answers  

---

IN BOXIR2 creating universe by using Designer and Business View. What is the difference b/t two?

4 Answers   TCS,

---

Explain what are the steps to be taken to schedule the report?

0 Answers  

---

Can we add our own component in Xcelcius ,I am having a Indian client and I want to either create or import component (map) is it possible?? Currently I have imported Map image and working through icons is there any other way out??Please help.

1 Answers  

---

How to create Index to the table in the universe designer and how it improves the Query performence

0 Answers  

---

if i hv 2 reports in one block... first report contains ten rows and second report contains 100 rows. my question is ....if i want to enter the values into first report(i want more than ten rows in first report)..is it possible to get ..

1 Answers   TCS,

---

What is the definition of derived table ?

2 Answers   JPMorgan Chase,

---

what is local filter

2 Answers   Cap Gemini,

---

What is Indexing? how did u implement indexing?

0 Answers   TCS,

---

Tell me the difference between cmc and cms?

4 Answers   Wipro,

---