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.

REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.

0 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 did u give developed universe to ur client?

1 Answers  

---

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

0 Answers   CTC,

---

What is the pragma?

2 Answers  

---

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

2 Answers  

---

how to prepare the documentation in business objects and where to get the requirement?

0 Answers   IBM, TCS,

---

I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it?

1 Answers   IBM,

---

how many reports have u created ? explain a few.

0 Answers   Bank Of America, TCS,

---

every alternative row should be hilighted ? how u can ?

1 Answers  

---

Explain the difference between union and group?

0 Answers  

---

Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?

2 Answers   Accenture,

---