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 to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????

1 Answers   IBM,

---

how many user were there

1 Answers  

---

What is metrics?

2 Answers  

---

How do you restrict access to rows of a database?

2 Answers  

---

what is mean by lov?

4 Answers  

---

---

how can u find the granularity in fact table

1 Answers   iGate,

---

1) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment

3 Answers   Hexaware,

---

Can anyone tell me how to display (calculate )Turn Around Time between two dates in the BO Report? Thanks in Advance

1 Answers  

---

WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE?

2 Answers   PCS,

---

Explain how to execute the plsql procedure from the report by clicking with mouse?

0 Answers  

---

in xir2 how to send reports to end user

2 Answers   TCS,

---

Hi, How to navigate one report to another report in webi? Thanks in Advance

3 Answers  

---