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 called a slice?
what are the filters in framework manager and report studio?
is cognos 7 is better than cognos 8
4. How many dimensions did you use in your reports?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
Explain the workflow of your current project from end to end?what is the steps?
2 Answers Accenture, Cap Gemini, Cognizant, HCL, IBM, Infosys, Nokia,
what is the use of layout component reference
Hi is any one having link to download books on datawarehouse tool kit by ralph kimball or any other authors books.
Can any one expalain the procedure for How to create a Mastr Detail Report in Cognos 8.3 ver?
pls any body give the cognos 8 versions release year.
What is the difference between filter & Condition?
what is textsource variable