The client is a manufacturer of residential and commercial turf maintenance equipment. They have a complex supply chain with a significant number of vendors. Most of the material that is supplied by vendors forms part of a sub-assembly which eventually ends up a part of a manufactured piece of equipment that is sold though a commercial distributor or retailer. The issue the client was experiencing was related to their ability to connect warranty claims to the vendor part that failed. In most cases there was not an efficient way to tie the warranty claim back to the vendor which resulted in the warranty costs being borne by the Client. The supply chain team figured out that by using a number of data points that existed within their systems they could link the warranty claim to the vendor part and then charge the vendor back though the invoice payment process. Prior to this project, the process to create the linkage between warranty claim and vendor part would require a series of queries from different systems that would be integrated using a desktop data base package. However, given the thousands of transactions that occur on a daily basis, this process was not practical. There was an urgent need for a reporting solution that (1) did not require manual preparation (2) delivered accurate results on demand and (3) provided the flexibility to drill into the detail and look at the data from different perspectives.