The client is a manufacturer of consumer food products that are sold to grocery retailers through a network of grocery wholesalers. Transportation of the products from the plants to the customer and between plants is a multi-million dollar spend that directly impacts the cost of goods for the retailers. The significant increase in fuel prices has exacerbated the situation for the company to the point that the analysis of transportation spend has become a top priority. Transportation is handled via an application called Oracle Transportation Manager (OTM), which manages the transportation procurement process. While the application does a great job in managing and reporting on the transactional data, it is not as strong on the analytical reporting which involves a higher degree of slice and dice capability. Several attempts had been made at extracting data from OTM touse in a reporting tool but the business users’ reporting needs remained largely unmet.