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 aggrigate navigation ? can anybody explain me with some practical example?

1 Answers  

---

What is Complex Reports?

3 Answers   TCS,

---

Is import wizard, report conversion tool, report comparison tool, security viewer ---- where all r migrating tools. whether all the tools available in BOXIR2? ..

2 Answers  

---

What do you mean by Object qualification?

3 Answers  

---

What are the general issues in migration process?

3 Answers   Deloitte,

---

why do we use crystal reports rather than webintelligence reports ?

7 Answers   CTS, Tech Mahindra,

---

1.what is context? How u create? With example.

2 Answers   Polaris, TCS,

---

Difference between Decode and Case?

8 Answers   Polaris, TCS, Wipro,

---

HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?

1 Answers  

---

WHAT ARE THE TYPES OF UNIVERSES?PLZ EXPLAIN IT

9 Answers   Business Intelligence Analytics, SRA,

---

what is difference between WEBi Report and Crystal Report?

3 Answers   Cognos, Nucleus Software, Red Cross,

---

What is meant by data federator and what is the use of it?

2 Answers   TCS,

---