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)

how to link 3 fact tables

1 Answers  

---

What are the security level used in BO?

6 Answers   Oracle,

---

is it possible to export the webi reports to crystal reports?with out using businessview?

0 Answers   CTC, TCS,

---

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

0 Answers  

---

What Is Snow Flake Schema?

0 Answers   Informatica,

---

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 YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?

4 Answers   CitiGroup,

---

Explain about a tricky situation for which you found a very simple solution?

0 Answers  

---

Explain how to schedule the report in b.o?

0 Answers  

---

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

1 Answers   Wipro,

---

2 table is there , thats column is different name but data type is same, 2 tables values are same. how to you findout both values are same?

1 Answers   iFlex, Patni,

---

how do you give security to universe ?

2 Answers   InfoStep, Tech Mahindra,

---