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 |
Explain difference between powerplay transformer and power play reports?
My problem is as follows I made two pages of the portal; in the first page i have two reports and from one of these i would like to communicate in some way (i.e drill- through?) with the second page that contains four reports (prompt value [product] and three chart [sales revenue, sales quantity and budget]). Particularly I would like to communicate with the report that contains the prompt, passing the Product. How can i drill from the first page of the portal to the second page ? More generally, is it possible to move from one page, containing 2 report, to another page with 4 report, through a drill-through or any other mechanism? Thank in advance.
how to change the colour of the bar in charts...?
What are the differences between cognos 8.2 and cognos 8.4? Please help me..
Write a SQL query which should fetch the 5th maximum salary of an employee from the table?
How can you create prompts in framework manager?
What is snapshot ?
What is the difference between List and Cross tab? Could some on explain with an example..
what do you mean by parallel execution of query?
what is model and say about process how to create model and how to test model?
what is render variable
5 Answers Accenture, Cap Gemini, Systime, TCS,
WHAT STEPS SHOULD BE TAKEN BY A REPORT DEVELOPER TO INTERACT WITH THE CLIENT SERVER?