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 static filter and dynamic filter

1 Answers  

---

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

4 Answers  

---

Tell me the difference between cmc and cms?

4 Answers   Wipro,

---

i Have created the universe in which i have one table and different derived tables from the same table i am supposed to create report from the same universe which should dispalay the duplicates rows, but all the time i run the report i am not getting the duplicate rows i have checkd the duplicate report option too in report.. is there problem with universe or report,.. can any body help?

2 Answers  

---

How to get red line in the graph at some point (value)? Example : In graph at 200000 value

1 Answers   Rolta,

---

how do u implement dense rank in bo reports?

2 Answers   CTS,

---

What is a Set?

1 Answers  

---

What is the use of Surrogate Key in BO?

2 Answers   CTS, IBM,

---

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

1 Answers  

---

1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?

3 Answers   Wipro,

---

What is thumbnail?

0 Answers  

---

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

0 Answers  

---