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..

what are diff b/w cognos and business objects

6 Answers   HCL,

---

hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls........

2 Answers  

---

Is it possible to create drill through access to other report from PDF report?

1 Answers   IBM,

---

Hi Friends, Please tell me at What situations we use the Segment, Link in FM, What is the Main Difference functionality wise? Thank You

1 Answers  

---

How do you Parametermap variables in Quiries?

0 Answers   TCS,

---

What is Tool Tip? and how to create in report studio?

1 Answers   Wipro,

---

Interval Prompt's Usage? Example for usage in Project

2 Answers   Cap Gemini,

---

what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

0 Answers   IBM,

---

How can we improve performance in framework manager level?

3 Answers   Wipro,

---

what is difference btw summary filter and detail filter, plz explain with example

10 Answers   IBM, TCS,

---

When we use consume in cognos?

1 Answers   IBM,

---

what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

0 Answers   HCL,

---