m-Fin REVENUE AND EXPENDITURE TOTAL Tuning

We are improving the performance of m-Fin REVENUE AND EXPENDITURE TOTAL on project id’s and on large orgnodes (i.e. orgnodes having 100+ orgs). I invite you to test in Cognos QA. If you have windows open to Cognos production you may need to close them.

Let us know your test results by leaving a reply on this blog post.

If the production version of the report has been running well for you, confirm that the QA version of the report also runs well.
If the production version of the report has been running poorly for you (sometimes taking minutes to do what it did in seconds just moments before, or simply not running certain parameters well), confirm that performance is improved in the QA version of the report.

Example run-times

Here highlighted in green are examples of improved run-times we’ve experienced this week with the QA version of the report:

QA Production
Large orgnode S0007 15 seconds Inconsistent, occasionally taking minutes
Large orgnode C0001 but just fund 80 08 seconds Same
Small orgnode D0017 12 seconds Same
Large project 1543911 10 seconds 1 minute
Normal sized project 1546517 05 seconds Same
Two normal sized speedtypes 11020234 13000099 05 seconds Same
Large award NNG07HW00C 12 seconds Same