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.

what is mean of Meta data definistions?

4 Answers   IBM,

---

if u generate a cube r pakage then its published we open in cc its ask every time for username &pass word?what we do?the pak r cube was not asking the password? what we do for this problem?pls ans me.............

1 Answers  

---

What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?

2 Answers  

---

In an existiing Framework model, how will you add a new column to the existing table?

6 Answers   CTS,

---

What is meant by junk dimension?

0 Answers  

---

I am currently pursuing a career in Cognos and need your support in the same regard. I am in the position that you were in as described above. I would like you to share your experience during interviews, project explanation, on the job etc. I am preparing for the interviews and am quite nervous about cracking it. I am sure you understand the anxiety. Your help will be greatly appreciated. Awaiting your response!

3 Answers  

---

what is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running

2 Answers   IBM,

---

at what level u prepared the reports in cognos???? in dataware housing what is the automation tool u r using???

1 Answers   Covansys, IBM, Wipro,

---

what are the filters in framework manager and report studio?

0 Answers   IBM,

---

Can you please tell me the limitation of Excel file when exporting from report to Excel? I can export to HTML and PDF but I can't export to Excel. The report is more than 13000 rows. When exporting to Excel, system can view it. After that, I save the report to an Excel file. The size of Excel file is more than 11 MB. But I can't view this file by Excel. Please help me to solve this problem. Thanks!

1 Answers  

---

What is the difference between a cascading report and drill through the report?

0 Answers  

---

-------------What is a Conformed Dimension?

3 Answers   Bank Of America,

---