Answer / amar

1. Use local cache property set to NO.

2. Validate expression properly.

3. Use detail filters after auto aggregation instead of summarized filters.

4. Test with limited number of data.

5. minimize sql hard code.

6. Avoid Java script usage maximum.

7. Use sql having clause expressions.

8. Avoid usage of cognos functions Maximum.

I hope this is useful...
If am wrong let me know...

Thanks

Answer / ashok

To reduce the run time of a report is known as performance tuning. to reduce the run time we have follow some tricks like query optimization, remove unwanted filters.. etc..

Can you define cognos powerplay?

0 Answers  

---

what is a query subjects item?

1 Answers   HCL,

---

How the Bursting happens in same report and how to Print the bursting Report?

0 Answers   IBM,

---

if there are list,crosstab,chart how can you apply a single filter to all object?

3 Answers   IBM, Syntel,

---

----------------Diff b/w Dimensional modeling and Relational modeling?

2 Answers   Cap Gemini, L&T,

---

Which studio is used to create reports?

0 Answers  

---

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

2 Answers   IBM,

---

suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?

4 Answers  

---

How is cognos model organization works?

0 Answers  

---

Can we test the report other than manual testing?

0 Answers  

---

Are you aware of any limitations in Cognos?

1 Answers   HCL,

---

Hi, I am Searching on Cognos 8, I don't know how to explain the projects in cognos.Can anybody help me in this regard. My email id is hchereddy@gmail.com. Thanks in advance

0 Answers   IBM,

---