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.

Hai, Can anyone tell me 'how to use one dataprovider result as an input to another dataprovider?. In BO6.5 there is an option like "select query result". we can use this option in the filter. but the same thing not available in BO XI webi. if any one face this problem , can you please share with me how to do this? Thanks, Narmatha.

3 Answers  

---

IN BOXIR2 creating universe by using Designer and Business View. What is the difference b/t two?

4 Answers   TCS,

---

What is the definition of derived table ?

2 Answers   JPMorgan Chase,

---

wha is the difference b/w merge dimension and combining two different data providers?

1 Answers  

---

what is the core universe and what is the active universe?

1 Answers  

---

REGULAR CLASSES for OBIEE Reporting(RPD, Answer, BI Publisher) is Starting From Tuesday, 25th Oct, 7:00 AM IST

1 Answers  

---

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

0 Answers   Patni,

---

What is the dense rank?

0 Answers  

---

what is confirm dimension ?

11 Answers   IBM, Wipro,

---

Difference between scope of analysis in webi and in deski?

1 Answers   CA,

---

What is the difference between the Webintelligence and desktopintelligence?

2 Answers   IBM,

---

How to schedule the report in b.o?

0 Answers  

---