Company

Hammond Group, Inc

Description

Producer of lead chemicals based in Indiana, US

Web

www.hmndgroup.com

Requirements to meet

To interface with both an Oracle ERP system and a purchasing data warehouse to provide a real-time performance metrics monitoring utility.

Issues to tackle

Data must be real-time, refreshable using VB macros, and support drill-down capabilities.

Approach taken

Using the development examples provided with SQL*XL, as well as the assistance of technical support,prototyping and delivery of the final utility was easily accomplished.

Results

Successful integration of the monitoring utility with strategic planning, resulting in a considerable gain in performance knowledge and the timeliness of that knowledge.