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 | 1 No |
Post New Answer View All Answers
What is set to be Cognos configuration?
Why is auto-regression used in forecasting used on cognos platform?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
explain how to create powerplay reports?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
What is Metrics designer?
What are all types of Batches?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
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 ?
is cognos 7 is better than cognos 8
How can we create a dynamic column name in cognos?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
What is metric store database?