Answer / vams_gk

Aggregate awareness is a term that describes the ability of
a universe to
make use of aggregate tables in a database. These are
tables that contain
pre-calculated data. You can use a function called
@Aggregate_Aware in the
Select statement for an object that directs a query to be
run against aggregate
tables rather than a table containing non aggregated data.
Using aggregate tables speeds up the execution of queries,
improving the
performance of SQL transactions.
The reliability and usefulness of aggregate awareness in a
universe depends
on the accuracy of the aggregate tables. They must be
refreshed at the same
time as all fact tables.
A universe that has one or more objects with alternative
definitions based on
aggregate tables is said to be “aggregate aware”. These
definitions
correspond to levels of aggregation. For example, an object
called Profit can
be aggregated by month, by quarter, or by year. These
objects are called
aggregate objects.
Queries built from a universe using aggregate objects
return information
aggregated to the appropriate level at optimal speed.

Answer / ramesh puli

It is an ability to dynamically rewrite sql to the level
granularity is needed to answer business question.

Allows faster query speed.

what is the diff between etl tool and olap tool

2 Answers  

---

i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?

5 Answers   TCS,

---

How would I achieve Traffic Lighting in Business Objects

3 Answers   Virtusa,

---

Who launches the supervisor product in Business Objects for first time?

2 Answers  

---

I have only 1 dataprovider and using that i have to create 2 tabular report on Webi on same page. One report will display all the salary details and other report will display only max salary. How will you achieve this.

2 Answers   L&T,

---

IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?

1 Answers   Accenture,

---

HOW DO YOU RESOLVE MULTIVALUE AND COMPUTATIONERROS?

2 Answers  

---

How to Shedule the reports in Xi R2

3 Answers   iFlex,

---

where are objects are stored ?

6 Answers   Tech Mahindra,

---

Difference between b.o 5.1 and 6.1b?

0 Answers  

---

I have a report with some hyperlinks,any issue will i get when i migrate this report?

1 Answers   Zensar,

---

WHAT IS SYNCHRONIZATION IN BOXI?

2 Answers   HCL,

---