What is Performance Tunning Test?
Answers were Sorted based on User's Feedback
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 | 0 No |
Answer / ashok
To reduce the run time of a report is known as performance tuning. to reduce the run time we have follow some tricks like query optimization, remove unwanted filters.. etc..
| Is This Answer Correct ? | 0 Yes | 0 No |
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?
is there any difference between operational database and data base?if yes what r they?
How to findout YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE. WHEN YOU FILTER THIS YEAR VALUE THE RESULT SHOULD DISPLAY THIS YEAR RESULT AND LAST YEAR RESULT.
I have a report with list and cross tab in same page,How do you restrict one user can see only the list and other user can see both?
suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???
How do add dynamic titles in PP?
what is an sid (surrogate key)?
How to create Events?
what is filter?give me one example that you created a report in your project?
Explain is there any comparison available for cognos reportnet vs crystal reports?
-----------------What is Determination Model?