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 r the universe connection types?

4 Answers  

---

what is maximum scope of analysis --> can we define more than 3 levels?

2 Answers   CTS,

---

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

2 Answers  

---

what are the day to day activities of BO administrator ?

0 Answers   TCS,

---

what is optional prompt in boxi r2

4 Answers   Mind Tree,

---

Can we Save (save as) WEBI Doc as DESKI?

2 Answers   HCL,

---

what is the different between link and join ?

2 Answers  

---

I have Startdate,enddate objects in querypanel and prompt on those objects.how would i get before 2 years data,if i run that query.

1 Answers   Accenture,

---

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

0 Answers  

---

while developing a report in BO i had created prompts at query level? When an end user runs the report he has to see the details of the report with out entering the prompt values? How can we do this in BO?

2 Answers   PWC,

---

Instead of cms which server you have to use?

2 Answers   CTS,

---

What is aggregate table and aggregate fact table ... Any examples of both?

0 Answers  

---