Reporting in Maximo is one of the best ways to stay on top of your data and BIRT is the embedded report engine and primary reporting tool utilized in Maximo. BIRT has been used with Maximo since Maximo V7.1.1 with BIRT V2.1.2. Since Maximo V220.127.116.11, BIRT has grown in popularity with clients and is now the report engine that drives all Query Based Reports (QBRs) and out of the box (OOB) reports.
- The passing of parameters happens for QBR (Ad Hoc) reports in embedded BIRT or to a BIRT report design for an out of box report
- Executing an Out of Box BIRT report, Maximo opens a new tab with BIRT’s standard report viewer interface
- Parameter values are retrieved from Maximo. The standard parameters are as follows:
- appname: Passed from Maximo. Represents the application name that the current MBO is accessed through
- “where” clause is built dynamically based on the user’s input
- e. Sitting on the Work Order List tab in Work Order Tracking and user filters for =APPR work orders, the “where” clause will contain the filter [workorder].status=’APPR’ ([workorder] is implied from the parameter appname)
- If no additional conditions are defined in the where clause passed, BIRT defaults to using “1=1”
- paramdelimeter: Indicate the parameter delimiter inbound/unbound parameter strings
- paramstring: Contains the undelimitated parameter string
- A data set is created/opened - this consumes a database connection given to the Maximo application server
- The data set’s query is run
- Data is fetched from the query’s results
- Data is written to the report’s layout
- The data set is closed – this returns the database connection
Note: each data set in a report design is processed individually such that BIRT uses the minimal number of database connections required. In other words, a data set will be created/opened then closed before another data set is created/opened.
Stay with Cohesive; we will have more blogs covering BIRT topics in the coming weeks. You can learn more about our complete consulting service offerings by visiting our website.