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.

can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com

0 Answers  

---

Why we take so long time to display date prompt before displaying a report? How can we reduce the time?

2 Answers  

---

I need to display blue color for max Revenue and red color for min Revenue by using condition formatting how it possible........?

1 Answers  

---

----------0Diff b/w Report Functions and Database functions?

1 Answers   IBM,

---

1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

0 Answers  

---

---

Can you define confirmed dimension?

0 Answers  

---

Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how?

5 Answers   TCS,

---

Can we install Cognos 8.4 on Windows Vista...Please let me know....Thanks!!!

2 Answers  

---

How can we improve performance in report studio level?

1 Answers  

---

What is the Main Difference between Conditional Block and Render Variable in Cognos. Both are used for Condtional rendering.But what is the Main Diff?

4 Answers   Wipro,

---

hi friends pls forward impropmtu interview question

0 Answers  

---

suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?

4 Answers  

---