6. Which of them will increase the performance?
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.
| Is This Answer Correct ? | 0 Yes | 1 No |
---------------Can we use more than 1 Fact table ?
How can we do the unit testing?
What is use of Field Set present in toolbox?
what is field set? what is the query calculation and layout calculation?
-------------------What is Deployment?
What do you understand by the term 'aggregate advisor?'
What are the differences between Cognos ReportNet 1.1, Cognos 8? and enhancements in cognos 8?
For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?
hi guys, i think this would be a simple question but i was asked. what is total time taken to develop a report from getting requirement document from the client? dont reply as it depends,i am expecting something else.
Difference between Express authoring mode and Professional authoring mode?
How to Improve the Performance of the Report? i need this urgently .
What is the diff between Drill through reports and Master detail reports?