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
which type of project we r going to snowflake schema
Can you define metrics designer?
What is the difference between drill through, drill across?
How do you Parametermap variables in Quiries?
How to do Performence Tunning in Cognos Reports?
What is drill down and slicing and dicing whats the difference between them?
Define catalog in cognos and write its various types?
What is the difference between set functions and filter function in dimensional data?
What is called materialized view?
What are the main services provided by application tier?
What is set to be cardinality?
Can you define set to be cardinality?
what is the difference between filter and condition?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?