IBM Support

Scripting report execution in 7.5

Technical Blog Post


Abstract

Scripting report execution in 7.5

Body

A few days ago Pam Denny and I had a discussion on whether any aspects of reporting could be automated through automation scripts. I had heard similar questions from clients at a previous Pulse event and I was quite intrigued by the possibilities. The user need was very clear though: can the end user avoid having to click through a number of steps to configure report execution and instead of the system execute the report in a pre-configured way? Such an approach should not require Java customization.
 
I spent some time reviewing the reporting framework and came up with the possibility of automating scheduled reports using scripts. Wanting to test this possibility I developed a script and launch point that can schedule the report upon the status change of a Purchase Order record in the Purchase Order application.
 
I wanted to share the results of investigation with you all. Attached to this blog are a detailed write up of my implementation and the script code itself. Though I do not describe it in the document, I was able to quickly prepare a Migration Manager package of the launch point and script and distribute it to a test environment where I tested my implementation further.
 
I hope to see your comments on this approach and outcomes - will this simplify report execution for your end users?

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11133799