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.

I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all the columns are misplaced. the report size is 12MB Can any one tell me why the columns are incorrect position when XI report converted into CSV format?

3 Answers  

---

while migrate bo 5.1 report into boxir2 ,what are the problems faced

2 Answers  

---

How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?

1 Answers  

---

can any one say me exactly when and where alias and context are used in resolving a loop. If possible try to give me a scenario also.

3 Answers  

---

1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?

1 Answers   iGate,

---

1. how do u connect one report with another ? 2. how do u generate reports from different data sources( ex: oracle, sql server)? 3.how do u give the security to universe ?

1 Answers   BNP Paribas,

---

how do you share the universe ?

4 Answers   Tech Mahindra,

---

What is the purpose of @aggregate aware function?please draw, how you use the @aggregate aware function

6 Answers   Cap Gemini, Deloitte,

---

What is report template in b.o?

0 Answers  

---

what r the disadvanges in boxir2

3 Answers   Accenture,

---

Explain how to schedule the report in b.o?

0 Answers  

---

IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT?

2 Answers   Clover, Rolta,

---