Contact Us

When Should You Upgrade to Oracle Hyperion

Companies today are facing difficult decisions with timing their upgrades for Oracle Hyperion EPM environments as well as the supporting operating systems, browsers, and office applications. So how do you figure out when you should upgrade to Hyperion

The Problem

Many IT departments are coming to terms with the fact that Windows Server 2008 and Windows Server 2008 R2 lost Mainstream Support as of January 13, 2015. Currently, their only option for support from Microsoft is through Extended Support, which is expensive and should only be used as a short-term migration strategy. Along the same lines, Microsoft SQL Server 2008 also lost Mainstream Support as of July 8, 2014, with Extended Support only available. Consequently, IT departments throughout the world are making plans to migrate to Windows Server 2012 R2 and SQL Server 2012.

Learn the Top 5 Features of Hyperion

IT departments with Oracle Hyperion environments need to exercise the customary due diligence and collaborate with the Hyperion stakeholders to ensure planned upgrades of Windows Server and SQL Server do not interrupt Hyperion service. Oracle Hyperion requires version for installation / configuration on Server 2012. Prior versions will simply not install on Windows Server 2012 R2.

The Solution

Enterprises with Oracle's Hyperion EPM products — such as Hyperion Planning, Hyperion Financial Management, and some versions of Hyperion Essbase — will need to upgrade to version For environments that have FDM (note: FDMEE, the Enterprise Edition), this will also include converting from FDM "Classic" to FDMEE. While this may sound somewhat daunting, it is actually a tremendous opportunity to revitalize data flow processes, simplify tool selections, and strengthen data integrity.

The Benefits

It is important to know that one of the main benefits of FDMEE is that HFM is now available as both a source and a destination. The opportunity to streamline and optimize data flows and integrations with this feature cannot be overstated. Many companies either have a time-consuming manual extract then import process or have implemented a custom solution with various technologies to schedule and automate data integration processes. This is driven by the need to use one tool to extract data from HFM, another tool to import it into Planning, and yet another to schedule and automate the entire process.

With FDMEE, administrators can run the entire data integration process from within FDMEE. It can extract specific data from HFM and load it to Planning, all scheduled and automated within the same product. Updating settings, scripts, variables, pathways, and parameters within multiple data integrations may now be simplified greatly. Removing the third-party tools and complexity of numerous touchpoints not only optimizes data flows, but it also removes layers of risks, improves internal controls, and potentially eliminates the costs of licenses for third-party products as well as resource skillsets.

Other enhancements with respect to version of FDMEE include:

New Target Applications

  • Oracle Hyperion Profitability and Cost Management (HPCM)
  • Tax Provision Application of Oracle Hyperion Financial Management

Integration with Financial Close Manager

  • User defined source filter (includes HFM journals)
  • Write-back enhancement of moving HFM Journals to either Oracle EBS or PeopleSoft
  • Concatenation of unlimited ERP segments, removing the previous 5 source column limit

Graphical Import Format Builder

  • Drag and drop fields from file to define source columns
  • Supports delimited or fixed format data files
  • POV Lock options for all location or one location


Again, the main motivation to upgrade to for many companies is the need to get off of Windows Server 2008 or Windows Server 2008 R2 as well as SQL 2008. When planning to do so, whether in IT or Finance, key stakeholders should be sure to look closely at Hyperion version and time the upgrade of Server Operating Systems carefully. Also, when upgrading to FDMEE, take time to review new features and functionality to streamline the data integration routines and reduce risk throughout the EPM platform.

To discover more new features in Hyperion, view the Best of Hyperion video. 


New call-to-action

Ask an EPM/BI Advisor

If you're here, you've got questions — and we've got answers. Book your consultation to ask us about any range of topics, including:

  • Evaluating EPM or BI technologies
  • Comparing on-prem vs. cloud
  • Planning upgrades and migrations
  • Estimating project costs and timeframes
  • And much more — ask us anything!

Let our experts tackle your toughest questions for you.

Let's Talk