Interface, Inc. designs, produces, and sells modular carpet products for the commercial, institutional, and residential markets primarily in the Americas, Europe, and the Asia-Pacific. The company was founded in 1973 and is headquartered in Atlanta, Georgia.
KPI Partners delivered a complete ERP Analytics solution by implementing Supply Chain / Order Management Analytics and Financial Analytics for JD Edwards.
Archived data from 2007 onward was imported into a data warehouse from JD Edwards. Financial Analytics reports and metadata were also migrated from a previous generation analytical application to this new enterprise standard deployment.
The decision support system has been designed to enable insightful reporting from the financial module of Oracle BI Applications to include general ledger, accounts receivable, and accounts payable. Additional subject areas were deployed to support other related out-of-the-box (OOTB) dashboards.
Dashboards were constructed to feature a hierarchical reporting feature for creating reports from finance subject areas. The analytic application also extends the OOTB data model to include all the data elements necessary for Interface's custom reports.
Data Load
Five years of historical lead data had to be loaded into the data warehouse, which impacted the performance. This type of data load challenge led to the need for strategies such as table partitioning, summary tables, etc.
Interface Custom ERP Data
Interface has 150 custom tables in JD Edwards. The engineers on the project were challenged to use more than 20 extract-transform-load (ETL) extensions required to support existing Financial and Supply Chain Analytic reports.