Answer / sai

Aggregate tables are used in the schema in oreder to
inprove the query performance.it is implemented by using
@aggregate_aware()function.these tables carries
precalculated aggregates(measures).it will improve query
performane,so we will get data fastly.refer this link to
know more:
http://www.dwoptimize.com/2007/09/aggregate-awareness.html

Answer / sonia

Aggregate Awareness is used to avoid having an object
multiple times, in different classes, for the fact table
and the aggregated table.

Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

0 Answers  

---

how can we build one report from two data bases

4 Answers   IBM,

---

In a report i want to fetch teh data from 2 data Providers. which condetion wil satisfy to link the 2 data providers. ex: Q1 have columns A,B,C Q2 has a X,Y,Z columns. requirement is like i want to get all the columns from those 2 tables in report level..like A,B,C,X,Y,Z in a single report.

5 Answers  

---

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

0 Answers  

---

what is casual dimension?

1 Answers   CA,

---

HOW TO SPOT A HIERARCHY?

2 Answers   TCS,

---

Is it possible to create a new calendar using BO? Ex:- Wants to create a calendar where the year starts with the 1feb - 25Feb. Next month from 26Feb - 14Mar.

1 Answers  

---

how do you give security to universe ?

2 Answers   InfoStep, Tech Mahindra,

---

what is static filter and dynamic filter

1 Answers  

---

date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2

1 Answers   Honeywell,

---

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,

---

What is a Set?

1 Answers  

---