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
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
What are the steps to import the two data sources in framework manager?
How the Bursting happens in same report and how to Print the bursting Report?
What is a Framework manager?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
What are slice and dice?
what is the difference between list report and crosstab report?
What is the difference between a data mart and a data warehouse?
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.....
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
What do you understand by the term 'aggregate cache'?
How to deploy from one server to another server?
Explain the difference between native sql and cognos sql?
Why is auto-regression used in forecasting used on cognos platform?
What is the use of Cognos scenario?