Business Driver
Conversion of Cognos, Noetix, and Kronos reports to Oracle Analytics Cloud (OAC), OOTB Reports, and KPI RTR report enablement to bring all the different reporting applications of reports to a single Reporting application (OAC).
Selection Process
The company evaluated many consulting companies but selected KPI Partners because of KPI's expertise in all the BI Reporting tools, In addition, KPI proposed a team with 100% offshore team resources to minimize cost and risk for the customer.
What KPI Delivered
- Setting up and Configuration of OAC
- Installation of Oracle DB and ODI in different environments
- Converted all the custom Datamart reports from SQL Server DB and Cognos to Oracle DB and OAC Reports
- Converted all the Noetix reports to OAC Reports
- Converted all the Kronos reports to OAC Reports
- Configuration and deployment of OOTB reports for Financials, Supply chain management, Manufacturing,
- Projects & Procurement modules
- KPI Real-time reports Enablement
- Providing Production support & maintenance
- Running out of the box and custom load plans to cater to OAC reports and to the custom warehouse team
- Creating the Tableau reports to a separate team
- Implemented the user authentication through ADFS
- Implemented OAC data level security based on EBS roles
Business Benefits
- This project brought all the Cognos, Noetix, Kronos & Datamart reports into OAC
- This reduced the Cognos, Noetix, Informatica & SQL Server licensing cost and maintenance Cost
- OOTB Reports enablement brought more flexibility in the decision making and detailed analysis
- KPI Real time reports enablement has provided the more accurate analysis