Answer Posted / 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.

how u will design the report if the objects are available

2803

---

how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

2156

---

How to a create header dynamically in a crosstab report in cognos 8.1?

2476

---

What are the components of the report studio?

1242

---

Can you explain new content durability?

1088

---

Which studio is used to create reports?

1153

---

What do you understand by the term 'aggregate advisor?'

1010

---

Define query items?

1050

---

how to connect datamarts

2846

---

Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

2172

---

actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

1742

---

how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?

9310

---

What are all the components of Report Studio?

1153

---

Can you define a datastore in cognos?

1072

---

-----------Diff b/w OLAP and RDBMS?

2105

---