Active Solutions Northwest enhanced the 'canned' Maximo 5.2 reports,
developed custom reports to provide the Port of Seattle with
custom-tailored information about their work orders, purchase orders,
etc., and trained the Port's staff in the use of the Actuate
report-development environment, eReport Designer:
2004 - 2006
Many custom and customized reports were produced, including a report
providing statistics such as Mean Time Between Failures
(MTBF) and Mean Time To Repair (MTTR) report for the
subway connecting satellite terminals at SeaTac Airport.
The approach taken was to make extensive use of SQL Server stored
procedures, views, and user-defined functions to enhance performance and
make better use of the inherently three-tiered architecture provided by
Actuate. Within the reports, good use was made of Actuate Basic
and JavaScript to enhance the functionality and appearance of the
reports.
In one case, the execution time for a report was reduced from hours
to minutes by removing Actuate Basic on-the-fly queries with a stored
procedure.
Custom report criteria pages (request pages) were also created to
provide custom parameter entry and custom data lookups.
A report was created that displays data concerning Maximo's issuances
of inventory and simultaneously creates an interface file so the
inventory issues can be imported to PeopleSoft. This enables the
aviation and marine division maintenance departments to update
accounting records with summary inventory issuances on a
monthly basis, rather than being forced to rely on a year-end adjustment
process.
2010
Re-create some of the same reports using BIRT 2.3.2; create a new
report consolidating multiple reports, some written using Crystal
Reports, supporting multiple divisions of the Port of
Seattle
