AN ORACLE HYPERION PLANNING UPGRADE PROVIDES MULTI-NATIONAL
ORGANIZATION HYPERION APPLICATION OPTIMIZATION AND STABILIZATION
Celgene is a multinational biopharmaceutical company committed to improving
the lives of patients worldwide. Their mission as a company is to build a major
global biopharmaceutical corporation while focusing on the discovery, the
development, and the commercialization of products for the treatment of cancer
and other severe, immune, inflammatory conditions. Celgene sells each drug
under strict risk management plans that ensure they are safely administered. The
firm has other drugs in development that combat inflammatory diseases and
After completing a Functional and Technical Application Review, Celgene sought
to apply these insights and best practices to an Oracle Hyperion Planning
upgrade to version 220.127.116.11. With the goal of increasing the capabilities of their
budgeting, planning, and forecasting process, the existing Celgene applications
had significant opportunities for improvement. With a new functional budgeting
and forecasting process, Celgene reached out to MindStream to replace their
inefficient data integration process and enhance overall application performance.
Celgene's main concerns included forward adaptability of their system to expand
over time, without having to rework core foundations or negatively affect
performance, as business processes change. Too much time was spent managing
the ebb and flow of data, constricting their opportunities for true business
First, MindStream upgraded their Hyperion Planning to 11.1.2, stabilizing their environment. This upgrade,
along with some tactical redesign of the application architecture and underlying plan types, simplified and
consolidated both the number of applications and total number of environments. Together with the
improved functionality of Enterprise Performance Management Architect (EPMA) in system 18.104.22.168, the
new environment improved the management of metadata across multiple applications.
During the upgrade, Celgene utilized MindStream's Development environment located in their Amazon
Cloud slice. The service enabled Celgene to begin the project while they were in the process of procuring
and staging their Production hardware. Once the application was ready, MindStream then facilitated the
application migration to Celgene's permanent environment.
In addition, MindStream implemented Financial Data Quality Management (FDM) to not only ensure data
integrity but to save time spent on data reconciliation and maintenance. This gave way to more time for
analysis, an ultimate goal of the organization. Oracle Hyperion's data integration and validation tool
improved data flow and automated data feeds directly from PeopleSoft.
Finally, the new application leveraged Oracle Hyperion Essbase to improve management reporting
capabilities. Using certain configurations of the Essbase's powerful engine, budget reporting submission
and analysis could be done more swiftly, integrating data smoothly from PeopleSoft to Hyperion for a full
view of the business.
The organization was able to report back a smooth transition to a new, more stablized Oracle Hyperion
environment with the upgrade of the Planning application and related application architecture. The
consolidation of applications across their American and European organizations with Corporate was key to
a more simplified, dynamic environment, capable of adapting as their business grew and processes
Throughout the project, many processes are implemented as opportunities for efficiencies and process
improvements arose, including: implementation of defragmentation and error routines, business process
advisement on use/elimination of dimensions (including Legal Entity and Currency), automation of data
feeds from PeopleSoft to Hyperion, improved calculations for allowing more what-if-scenarios, enabling
Dynamic Time Series, and more. Together with the implementation of FDM
for data flow enhancement,
levering Essbase provided for improved management reporting, No longer hindered by inefficient
processes and applications, Celgene was now capturing the full value of their Hyperion investments.
Contact MindStream Analytics
Want to know more about how we helped Celgene? Fill out the form below and we'll get back to you shortly.