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 we cretae views in universe level?

2 Answers  

---

Say, the query gets executed and we got the results. In case if we have a large number of rows, how can we know the exact no of rows returned?

6 Answers  

---

When upgrading from 3.1 to 4.0. Which services need to run ONLY? Do ALL services need to be running?

2 Answers   TCS,

---

my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it

1 Answers  

---

normally we get many contexts when resolving loops or traps,how do u take them to reports.

2 Answers   Wipro,

---

What is a loop? How can we overcome?

5 Answers  

---

How can we use multiple data providers in a single report in business objects?

2 Answers  

---

Can We customize the Business Object infoview in BO?

2 Answers  

---

WHAT IS CARDINALITY?

7 Answers  

---

I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers

1 Answers   IBM,

---

HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?

2 Answers   Polaris,

---

what is meant by report busting

2 Answers   TCS,

---