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

1.How will u link a list to crosstab.?i.e link a pramater in list so that it shows further information in cross tab.? 2.I have different regions,I want region specific logo to be displayed when I run the report.How it is done ? 3.Among Drill through and Master detail relationship which is more effective? 4.How do u hide a column in list report? Ans: In properties,Burn list option-check whichever column u wanna hide. 5.What is Roll play dimension? 6.What is Data Item Value n Parameter value?,What exactly it ll take when select either of them? 7.How many types of filters are there? 8.What will happen if u use detailed filter ?,n what is da result when used on summary filter?

0 Answers   TCS,

---

What are the types of studio?

0 Answers  

---

How to create measures and Demensions?

2 Answers  

---

first of all i want say thanks to Zilanibasha, As u said that now these days Cirtification in cognos8 is only possible. Will u like to tell me in detail How i apply for cirtification As i m very much Interested.

1 Answers  

---

What is the difference between macro & Parameter

1 Answers   IBM,

---

Can you explain new content durability?

0 Answers  

---

Mail me at: Amit_Cog@yahoo.com for a Very latest COGNOS 8 Certi Dumps like COG-112, COG-122, COG-125, COG-132, COG-142, COG-145 I scored Full Score, if anyone need it, just drop me a mail with Code

8 Answers  

---

where you can save the report net documentation in our local system?

0 Answers   IBM,

---

What junk dimension contains?

0 Answers  

---

--------------what is MemberCaption?

1 Answers  

---

difference between imprompt and reportnwt1.1

2 Answers   HSBC,

---

how many facts and dimensions in ur project and query items,how u deliver ur report to end users..i am going with fake exp...pls ans me generally what to ans..

2 Answers   Wipro,

---