In this post I’m sharing an automation script to generate a BIRT report automatically and attach it a work order. I my scenario I have triggered it from the workflow but it can be also triggered from an escalation.
Security groups and application authorizations
We all know how flexible Security Groups are when dealing with user roles and granting application authorizations. However, flexibility often brings complexity.You have carefully designed user’s roles defining what applications and actions they are allowed to access in Maximo and implemented all using Security Groups application. The system goes live and after one or two […]
Improving BIRT report style
I have always been an admirer of beautifully designed web sites. Today’s mobile and desktop application have beautiful and eye-catching UIs. To my eyes the current design of out of the box Maximo BIRT reports has an old-fashioned style that doesn’t sound pleasant to my eyes. That’s why I decided to tweak the Maximo out […]
Analyze BIRT report performances and execution time
Some days ago I came across this interesting post from Pam Denny that describes the 80/20 rule. Based on this empirical rule 80% of the report processing is done by only 20% of used reports.That’s why I developed a simple SQL query that uses the LASTRUNDURATION field of the REPORT table to list the report […]
Troubleshooting Birt report performances
Sometimes I had the hard task to debug performance issues of specific Maximo reports. The main thing to understand here is that 95% of the times the problem is related to a long execution time of the underlying SQL query .What I typically do is the following: Look at the ‘Performance’ tab of the Report […]
Enable lookup in report parameters selection page
In this post I will show how to enable the lookup functionality for selecting one or multiple values in a report parameter.Instead of creating a new lookup I will show all the necessary configurations looking at the built-in report ‘Inventory Balance’ (inventory_balance_tbl.rptdesign). Enabling lookup in report Open the ‘Report Administration’ application and search for ‘Inventory […]