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 |
what is the difference between aggregation and role up aggregation ?
What DB View and Bus View?
Why do we create shortcuts in framework manager
Can you define metrics designer?
where we use page break and page set. with example?
What is defined as catalog and types of catalogs in Cognos?
What are all types of Batches?
Define olap designer?
How is cognos model organization works?
what is report burn and where it occurs
how can i provide security to my reports in report studio?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?