Answer / joydeep

go through the generated sql and try to compare it with the
regular sql code by running the sql in the navigator. that
will give you an estimate of the time difference.

secondly try to check the joins. avoid outer joins as far
as possible.

thirdly try to add prompts and filters if possible to
reduce the number of records to be pulled into the query.

Answer / ajay

deselect the option auto-aggregate&sumarry option if it
selected it takes much time to get the data

Hi Friends, Just want to know, day to day is increasing or decreasing Cognos Usage in the Market? New Reporting tools to driving Reporting Market Spotfire, Tableau,Qlick View, some other New Tools. Which Reporting tool can generate Lot of Opportinities in the Market? Please Reply to this, My Advanced Thank to you. Thank You Kumar

2 Answers  

---

What are the two types of framework manager?

0 Answers  

---

Can you define drill across?

0 Answers  

---

what is the difference between aggregation and roll up aggregation?

1 Answers  

---

what is the role of cognos comsultant?what actually it means?pls reply

0 Answers  

---

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

0 Answers  

---

if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?

2 Answers   CTS,

---

I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-2012.

2 Answers   IBM,

---

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

0 Answers  

---

How to connect three fact tables?

11 Answers   L&T, TCS,

---

how u migrate the reports from impromptu to reportnet???

3 Answers   Wipro,

---

how can i test the reports in cognos

1 Answers   IBM,

---