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 xcelsius architecture?

0 Answers   Zensar,

---

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

0 Answers  

---

filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?

2 Answers   IBM,

---

how many micro cubes can a report can have

3 Answers  

---

how we improve the performance of report and universe?

4 Answers   Accenture, IBM,

---

how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this

5 Answers   HCL,

---

What is the difference between Thin client & thick client?

5 Answers  

---

If the Hi-rarchies are not defined in the universe level .Is it possible to do in the report level?

3 Answers   Infotech,

---

HOW MANY TABLES ARE EXISTED IN WEBI REPORT?

3 Answers   Polaris,

---

BO Webi report in running fine in Dev but takes a long time to run in Production environment, how to reduce this processing time.

1 Answers   Infosys,

---

In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?

4 Answers   Cap Gemini,

---

What is the difference between derived table and views? which one gives better performance?

2 Answers   TCS,

---