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.

5.what is slowly changing dimension ?

2 Answers   IBM,

---

can anybody tell me about complicated object you have created

0 Answers  

---

what is local filter

2 Answers   Cap Gemini,

---

What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?

2 Answers  

---

Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important

7 Answers   Zylog,

---

Can any one gve me the complete information abt Certfication of Business Objects ?

2 Answers  

---

I am working on Business Objects-reporting side. Database is Teradata. I have two questions here: 1. We will be working only on Infoview on QA environment. Do I need to add ODBC entries for the QA database server on my machine to be able to create/refresh Infoview reports? I will not be using Desk_I or Web_I rich client. 2. Once reports are developed,Admin team would migrate the reports to Production and make these available to business users. The reports are Refresh on Open. Would the business users need to have the ODBC entries of Production database server in their machines to be able to refresh these reports?

2 Answers  

---

Can you please send me the migration related issues .

0 Answers  

---

Explain about MTD(Month To Date) and YTD(Year To Date) with one example and where you use this in your project?

2 Answers   TCS,

---

2 table is there , thats column is different name but data type is same, 2 tables values are same. how to you findout both values are same?

1 Answers   iFlex, Patni,

---

while developing a report in BO i had created prompts at query level? When an end user runs the report he has to see the details of the report with out entering the prompt values? How can we do this in BO?

2 Answers   PWC,

---

Can any body tell me,What is the universe testing ? What is the report testing Explain?

2 Answers  

---