ProActive Upgrades OBIEE and Implements OBIA While Saving Significant Cost and Time Over Typical Approaches

August 13th, 2014


Business intelligence via the Oracle Business Intelligence (OBIEE) platform is a critical reporting system at this leading manufacturer, packager, and distributor of over-the-counter (OTC) pharmaceutical products and consumer healthcare goods (the Company). It is heavily used by the Finance, Sales and Supply Chain management teams. The Company management receives key performance metrics from the system every day.


Business Goals and Objectives:

The Company needed to upgrade the platform to meet business objectives of

  1. Enabling the latest platform functionality (11g) to leverage Oracle Business Intelligence Applications (OBIA) including Financial, Human Resources, Manufacturing and Agile Analytics
  2. Avoiding de-support due to the aging current BI and ETL software versions.



The Company faces significant challenges in upgrading due to complexity and cost, specifically

  • The  typical solutions being proposed required multiple consulting resources (project management, functional analyst, technical developer, DBA/ administrator) resulting in high cost of resources and overhead to coordinate
  • Significant business disruption was being faced due to downtime impact of the upgrade and related technical complexities.


ProActive Strategies Approach and Value:

  • A parallel, out-of-place upgrade was designed and executed for the platform upgrade, eliminating the production system impact.  Since a point in time replication of the systems was made the data counters went out of sync and Informatica ETL failed due to conflicting row id’s. The problem was resolved by updating the sequence counters in Informatica by executing a custom-developed solution.
  • The entire project was executed with a single SME / OBIEE Architect with end-to-end implementation and management experience resulting in cost savings for the Company. The Company resources were involved to provide infrastructure and system support.
  • Timely status reporting for project tracking with realistic estimates provided overall satisfaction and on time delivery of the product.
  • Provided hands on training and support to the Company resources to build OBIEE skills.
  • Proactively identified areas for improvement and suggested enhancements so that the Company can get the most out of their OBIEE investment.
  • Conducted demo sessions to demonstrate new capabilities and worked with the Company to come up with a future roadmap for future projects.


The project was implemented in phases as described below.

  • Phase 1 – > Upgrade existing OBIEE 10g system to OBIEE 11g on BIAPPS
  • Phase 2 -> Implement Oracle HR Analytics
  • Phase 3a -> Single Sign on
  • Phase 3b -> iPad implementation
  • Phase 4 -> Data center migration with infrastructure upgrade with failover capabilities, OHS and replicated databases.
  • Phase 5 -> Implement Oracle Manufacturing Analytics
  • Phase 6 -> Transition Oracle discoverer capabilities to OBIEE
  • Phase 7 -> Implement Oracle Agile Analytics.


Leave a Reply