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.

how will you move the universe/report from development to production?

3 Answers   TCS,

---

What is the use of AFD? Where it can be stored?

1 Answers  

---

how can we overcome by loops?and also is it possible ,one user can different universe

4 Answers  

---

How to resolve the partial result error in the report

4 Answers   Keane India Ltd,

---

What is the test methodology for testing BO Universes?

3 Answers   Cisco, TCS,

---

Can We customize the Business Object infoview in BO?

2 Answers  

---

How many universes can be created in a project?

0 Answers  

---

I HAVE USED A PROMPT TO SELECT A COUNTRY IF I REFRESH THE REPORT IT HAS TO SELECT COUNTRY AS INDIA IN DEFAULT AND HAVE TO GIVE THE RESULT? HOW TO ACHIEVE THIS?

3 Answers   BirlaSoft,

---

What is package in BO

0 Answers   Infosys, Saksoft,

---

How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?

1 Answers   Emphasis,

---

whats the diff between break and section

4 Answers   TCS,

---

Explain what is aggregate table and aggregate fact table ... Any examples of both?

0 Answers  

---