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 can we use multiple data providers in a single report in business objects?

2 Answers  

---

what is meant by slowly changing dimensions?

3 Answers   TCS,

---

Explain what would you consider as your biggest achievement and why?

0 Answers  

---

I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report )

6 Answers   Exilant, Siebel,

---

Explain difference between zabo and webi?

0 Answers  

---

WHAT IS SAP BO AND BO?

1 Answers  

---

What is batch processing in Business Objects?

2 Answers  

---

Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.

4 Answers   TCS,

---

How to create a tooltip in Webi? Is there a way to create Tooltips in Webi reports for non- hyperlinked columns? Users should be able to hover over a value in a column in the report and that should show a tooltip box with more detail regarding that column value. This is possible when you hyperlinked the column,Is it possible when you dn't have hyperlinking? Thanks in advance.

1 Answers  

---

HOW TO PUBLISH A REPORT IN BO?

1 Answers   Polaris,

---

Explain is there any default username & pwd for bo designer & supervisor?

0 Answers  

---

Explain what are the steps to do to use alerts in bo?

0 Answers  

---