Supply Chain Analytics Success Stories
Logitech - Oracle Order Management Analytics from Oracle eBusiness Suite
This project, involved the implementation of Oracle Order Management Analytics from Oracle eBusiness Suite 11.5.10. Customizations were done to different dimensions such as the product dimension and the organization dimension. New metrics were added to the Sales Line Order, Backlog Lines, and Sales Cycle Line Fact tables. ETL performance tuning was conducted to ensure that the ETL process could run 3 times per day in less than 30 minutes to ensure that users had up to date information. A combination of out of the box and custom reports totaled 200 reports placed within a total of 8 dashboards with numerous pages and drill down reports.
DJO – Oracle Supply Chain Analytics, Financial Analytics and Procurement/Spend Analytics
DJO is a leading global provider of high-quality, orthopedic devices, with a broad range of products used for rehabilitation, pain management and physical therapy. DJO is the largest non-surgical orthopedic rehabilitation device company in the United States and among the largest globally, as measured by revenues.
Over seventy Descriptive Flex Fields (DFFs) and columns from Oracle’s EBS R12 application are being brought in to support reporting for Order Management and Supply Chain. A custom security solution was developed to enable data level visibility restriction rules for both employees and non-employees. This project also involves integration of Noetix Views and a custom Hyperion data warehouse with the OBIEE application.
The project involved a concurrent deployment of BI with EBS and went live in January, 2010.
Examples of customizations are:
Over seventy Descriptive Flex Fields (DFFs) and columns from Oracle’s EBS R12 application are being brought in to support reporting for Order Management and Supply Chain.
For Campaign to Cash reporting, new star schema has been developed to bring Quota related information from Oracle EBS as this is not available in out of the box analytics application. Another module that has been developed is the Territory Manager module which will enable a user to report based on their sales territories. This initial phase for Campaign to Cash involved four consultants over six months and a follow-up phase will involve four consultants over a six to eight month span.
A custom security solution is being to enable data level visibility restriction rules for both employees and non-employees. This project also involves integration of Noetix Views and a custom Hyperion data warehouse with the OBIEE application.
The project involved a concurrent deployment of BI with EBS and went live in January, 2010.