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 profile and package?

0 Answers  

---

How to add additional objects or tables into the universe,and what are steps we need to follow to achieve the above task.

1 Answers   Patni,

---

Are you in Developing or Support in BUSINESS OBJECTS. What is the difference? what are the responsibilites in both?

2 Answers   CSC,

---

What are the join problems comes appart from loop,chasm & fan Traps

0 Answers   IBM,

---

How to solve the following errors coming in report development? 1.Syntax 2.multi value 3. #Error 4.computation and 5.Objects are not compatible

2 Answers  

---

can anybody tell me about complicated object you have created

0 Answers  

---

What problems you have faced while creating an universe? tell me an incident and how you went about solving it?

1 Answers   Fidelity,

---

HOW DO YOU RESOLVE MULTIVALUE AND COMPUTATIONERROS?

2 Answers  

---

What is meant by multiple data provider.How to use it in universe as well as reporting environment?

6 Answers   TCS,

---

i Have created the universe in which i have one table and different derived tables from the same table i am supposed to create report from the same universe which should dispalay the duplicates rows, but all the time i run the report i am not getting the duplicate rows i have checkd the duplicate report option too in report.. is there problem with universe or report,.. can any body help?

2 Answers  

---

Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.

1 Answers   TCS,

---

What is the dense rank?

0 Answers  

---