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 is bobble chart?

1 Answers   Syntel,

---

what are the joins present in reportnet?which is most widely used?

2 Answers   IBM, Satyam,

---

When we deploy the report to live the client get the data error how can we resolve that

1 Answers   CTS,

---

In Report page i have three types like (List,Cross tab,Chart), using Conditional Block i need only type of Report (Chart)at run time.How to do this I need The Complete Steps to do this?

1 Answers  

---

Where do you edit cognos sql in report studio?

3 Answers   HCL,

---

HI,can one suggest best institute for cognos Training in Hyderabad

14 Answers  

---

----------------What is meant by DSS?

1 Answers   Bank Of America,

---

suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me

2 Answers  

---

Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

0 Answers   TCS,

---

How many fact tables you have in your project?

1 Answers   HCL,

---

what is dimention?explain dimentable with example?

3 Answers   Syntel,

---

Hi is any one having link to download books on datawarehouse tool kit by ralph kimball or any other authors books.

5 Answers  

---