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

how to perform back drill through in cognos 8 what is the use of it

0 Answers  

---

Is cognos models are version compatible?

2 Answers  

---

how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?

2 Answers   HCL,

---

What are the Ways to Import Data into Catalong?

1 Answers   Cognos, IBM,

---

pls any body give the cognos 8 versions release year.

3 Answers  

---

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?

7 Answers   Cap Gemini, iFlex,

---

Can you define report item?

0 Answers  

---

how u create security to reports ????

10 Answers   iFlex, iGate,

---

what is stitched query???

2 Answers   IBM,

---

what are the uses of report studio,q.studio,analysis studio,event studio&.metric studi.

2 Answers  

---

What is meant by Tabular SQL in Cognos Report net

3 Answers   Infosys,

---

------------------What is Focalpoint?

1 Answers  

---