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 |
we have package it contain Query subject (123456). If u generate report with 6 query subject error will occure how to resolve this problem
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
pls help me out to find a projects for attending cognos interviews pls anybody send me projects with detail description to explain at the interview time pls send me real time project anybody pls mail me at kittuchoudary2007@gmail.com
Explain the characteristics of cognos?
---------------Tell me about DWH Concepts?
what are the dimensions that you have in your current project?list them?
Where do you edit cognos sql in report studio?
New coloums are added in database, then how you know in report level
In Report page i have three types like (List,Cross tab,Chart), using Conditional Block i need only type of Report (Chart)at run time.How to do this I need The Complete Steps to do this?
what is filter?give me one example that you created a report in your project?
What is Parametermap?
what is the automation tool used for data warehouse testing???
3 Answers Covansys, IBM, Wipro,