Port of Seattle Maximo Reporting Using
Actuate
Active Solutions Northwest enhanced the 'canned' Maximo 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:
Goal:
Enhance Maximo reports that did not work as needed "out of the
box" and create completely new custom reports.
Execution:
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.
Port of Seattle Shilshole Bay Marina (SBM)
Active Solutions Northwest
developed custom systems and software modules to provide the Port of
Seattle with a better trouble-ticketing system for the marina. Find
out how:
back to case studies Goal:
Design and develop a trouble-ticket application.
Execution:
Active Solutions staff members designed and developed the SBM
Trouble Ticket System, using custom VBScript within Microsoft Outlook forms to
retrieve data from Microsoft Exchange and Sybase SQL Server on an
HP 9000.
It captured information entered by SBM facility maintenance staff,
stores it in a Microsoft Access database, and sent an email to the
Maintenance Department. Simultaneously, it created a task in Microsoft
Exchange to track the ticketed item. The system allowed SBM staff to
view the ticketed items in a Microsoft Access form, and easily
correlated trouble ticket data with scheduled maintenance in the Sybase
SQL-Server based work management system. The system also included a VBA
batch process that updated Microsoft Exchange public folders containing
the trouble ticket items, storing them as Exchange Tasks, with status
information from the maintenance system. Active Solutions staff members
created custom Outlook views to enable Port of Seattle authorized users
to view, sort, filter and report on trouble-ticket data from anywhere in
the Port of Seattle network.
Result:
Development was successfully completed and delivered to
the customer.
Their Website: www.portseattle.org |
