With the company’s work focused most recently on the medical field, Onyx found itself in the enviable position of experiencing several years of double-digit growth and decided it was time to conduct an intensive assessment of its business intelligence reporting structure and to make some changes to prepare for the future.
At that time, the Onyx five-person IT department was using Oracle Report Developer and a desktop report mining tool (Monarch) to extract data from Oracle E-Business Suite 11.0.3 into Microsoft Excel in order to develop a high-level set of end user reports. However, this tedious method fell short when it came to integrating Oracle data with the company’s non-Oracle database systems. It was a demanding task to make changes or additions to the existing reports, and the process was extremely time-consuming, with at least one employee dedicated full-time to assembling reports for the next day’s meetings.
“There wasn’t much room to be creative or to elaborate on the details of requested data,” said Ken McIntosh, MES Administrator at Onyx EMS. “Maybe you could add a column here, or you could do a comparison there, but we didn’t even really know at the time what we were missing.”
Onyx determined it was time to overhaul and improve the company’s data access systems and kicked off an internal business intelligence initiative. The initial goal was to enable end users to create their own reports to elevate and extend the life of the company’s dated Oracle ERP system (until an upgrade could be completed), and to integrate Oracle data with all the non-Oracle databases.
The IT team met with Noetix to learn more about the wide-range of pre-built report templates that were part of the solution offered and realized they could now have easy access to a whole new world of data to use for reporting.
Onyx purchased several NoetixViews for Oracle E-Business Suite modules including Oracle Human Resources, Manufacturing, Financials, Purchasing, and Order Entry, plus Noetix Platform and Noetix Dashboard. Within a week of implementation, Onyx had Noetix up and running and the IT team was busy developing ideas for new reports.
After that, it didn’t take long for innovation to strike. In 2011, Onyx hired a new CEO, Mike McCammack, who immediately implemented several strategic objectives for the company including cutting defects to customers in half, increasing sales, and streamlining their new product introduction process. The Onyx IT team was able to leverage NoetixViews to build reports that mapped to these objectives and then build out Noetix dashboards to monitor a range of related items. Today, those dashboards are located on every employee’s desktop internet homepage.
Onyx also uses Noetix to manage the actions the company takes on a continuous basis. For example, software and report developer, Barbara Smith, created a multi-layered dashboard with gauges that shows detailed production stats used to manage many of Onyx’s more complex assemblies.
Finally, Onyx has used Noetix to enact a method for measuring the number of man hours required for many of the diverse tasks within the company. This dashboard pulls from five different data sources.
Today, nearly every one of Onyx’s 260 employees access Noetix to obtain the information they require to do their jobs. IT has created more than 500 different reports, 100 of which are used daily or weekly by employees. Approximately 2,600 reports are run on a monthly basis.
“We know that Noetix has allowed us to be a more efficient organization,” said McIntosh. “The employees who used to spend hours a day pulling reports have been able to take on many new projects because they can now access information instantly without help from IT.” In fact, Onyx conducted a survey asking users how much time they think that using Noetix reports has saved them and the results total over one full-time employee.
According to McIntosh: “With Noetix I have information in a matter of seconds. It allows me to include data from different databases and combine them into the views without having to look in multiple places. We’re able to see data we’ve been collecting for years finally come to life.”
In November 2012, Sparton Corporation, a premier supplier of sophisticated electromechanical devices, sub-assemblies, and related services for highly regulated environments in the Medical, Military & Aerospace, and Industrial markets, acquired Onyx EMS.
As part of the Magnitude Software family of products, Noetix world-class business intelligence solutions are used by hundreds of industry leading customers worldwide. Armed with immediate access to Oracle E-Business Suite data, users finally have the answers they need to make better business decisions.
Magnitude Software leads the way in delivering corporate performance management (CPM), master data management (MDM) and connectivity in heterogeneous environments.
© Magnitude Software, Inc.