Client wants to build a data warehouse environment and reporting solution using OBIEE. To capture the EBS data, extract, transform and load into data warehouse and make it ready for visualization in OBIEE. To use real-time reporting solution to get the business metrics in real-time and to replace their existing legacy Discoverer reports with KPI real-time analytics solution.
Company evaluated many consulting companies but selected KPI Partners because of KPI's expertise in OBIA 11g implementations and to leverage the ready-to-use. KPI real-time analytics solution. In addition, KPI proposed a team with 100% offshore team resources to minimize cost and risk for the customer.
What KPI Delivered
KPI proposed OBIA for the client warehouse and reporting requirements for their EBS source.
KPI did end to end implementation of OBIA for Financial, Procurement and Spend and Projects analytics. Also provided KPI real-time analytics solution for the client real-time reporting requirement along with the conversion of Discoverer reports in to OBIEE with data modeling. Implemented custom ETL logics for the client-specific exchange rates and custom Purchase category derivation logics. OBIA full and incremental loads for Financial, Procurement and Spend and Projects were completed for 500 GB of data within customer permissible limits.
Client able to access around 1278 OBIA OOTB reports across Financials, Procurement & Spend and Projects Modules. The client is able to leverage KPI real-time Analytical solutions to replace the legacy discoverer tool with OBIEE. KPI Implemented OBIA solution on Exalytics server to enable the high performance for OBIA reports.