KScope16 and FDMEE: Everything You Need to Know

KScope, ODTUG’s annual conference for Oracle Developers, was held just a couple of weeks ago.  And Oracle product managers were out en masse to reveal new offerings, application features, and product roadmaps. The Oracle mantra was pretty simple: cloud, cloud, cloud, and more cloud. In fact, if you drank a shot every time you heard the word “cloud” at KScope16, you would have been in a drunken stupor 5 minutes into Sunday’s EPM Symposium. Really, though, this is no surprise. Cloud services was the centerpiece of Larry Ellison’s Oracle OpenWorld 2015 keynote address. So, if you’re a Hyperion customer or implementation specialist using FDMEE what does all of this cloud rhetoric mean for you?  Here’s what you need to know. FDMEE and Hybrid Support Oracle mothership doesn’t see companies taking all of their EPM applications to the cloud right away. In fact, Oracle expects most companies will go for a hybrid approach – a mix of cloud-based applications and on-premises or hosted applications – for the foreseeable future.  In a hybrid world, companies need a simple, efficient solution to collect, transform and load data to all of their EPM applications.  This is where FDMEE comes into play.                       As of Release 11.1.2.4.200, on-premises FDMEE can integrate with on-premises and cloud-based EPM applications.  So, now you can use on-prem FDMEE to load your actuals data to Hyperion Financial Management (HFM) and to load your budgeting and forecast data to Oracle Planning and Budgeting Cloud Service (PBCS).  Yeah, this is kind of a big deal. It’s so significant that we re-worked our Peloton FDMEE Hands-on Training for this year’s KScope to highlight cloud...

How to Use FDMEE Data Sync to Copy HFM Actuals to Planning

Okay, first off, when it comes to the data synchronization feature in FDMEE, we’re not a fan of the name.  Being techies, when we hear “synchronization” we think true two-way synchronization. That is, data is compared between two systems and reconciled with the latest changes in System A copied to System B and the updates in System B replicated in System A. That’s not how this works. You use this new FDMEE functionality to copy data from one EPM application to another EPM application. Consider it a one-way sync. So, the name might be a little misleading but this is still one killer feature.  In fact, we think it’s the most significant new feature introduced in FDMEE Release 11.1.2.4.  Why, you ask? Many of our clients have multi-product EPM environments with both HFM and Planning. And one of the most common monthly tasks is to copy Actuals from HFM to Planning for variance reporting.  FDMEE Data Synchronization, more commonly known as “Data Sync”, makes this really easy. Data Synchronization isn’t a component with its own a menu item. Instead, Oracle has baked this functionality into the import format and data load rule components. Here’s a rundown of how to set up. Step 1 – Create your import format. The import format is used to instruct FDM how to interpret the incoming data from HFM.  For the source application, pick your HFM application.  For the target application, select your Planning application.  From there, map the dimensions accordingly. View Image Step 2 – Assign your import format to a new location. Next, create a new location to associate with your new import format....

Oracle Wants to Make FDM Classic Seem Really Old

Oracle recently released FDMEE 11.1.2.4. Back when Oracle rolled out Enterprise Performance Management (EPM) System Release 11.1.2.3 in 2013, FDMEE was missing a number of core FDM Classic features (e.g. support for file-based data loads and scripting). Since the initial release, the Oracle development team published several patch set updates; each delivering more FDM Classic features to FDMEE. Now, with 11.1.2.4, FDMEE is FDM Classic and more. Like an aging superstar athlete in the twilight of a storied career, FDM Classic is looking ready to give way to its successor. Here are a few reasons why.   Web-enabled Application – FDM Classic comes with a Windows client called Workbench.  A Windows client is so 2005.  Like most other Oracle EPM applications, FDMEE is a fully Web enabled application.   Direct Connect to Any ERP System – Want to integrate data and metadata directly from an Enterprise Resource Planning (ERP) source system?  With FDM Classic, you will need to use the ERPi add-on module.  ERPi turns FDM Classic into a bit of a Frankenstein monster.  With FDMEE, this functionality is baked into one product.   Advanced Architecture – FDMEE’s underlying data transformation engine is Oracle Data Integrator (ODI).  ODI is a world-class data integration tool on par with Informatica.  FDM Classic doesn’t have ODI (unless you use it in conjunction with ERPi module).   EPM Data Sync – Oracle Hyperion FDMEE Release 11.1.2.4 introduced data synchronization to the product.  Using the data synchronization feature, you can now move data between EPM applications (e.g. from HFM to Planning).  FDM Classic does not have this capability.     Superior Performance on Exalytics – Want blazing data transformation performance using Exalytics,...

FDMEE – At First Glance

You’ve heard with FDMEE Oracle has combined the architecture of ERPi (Enterprise Resource Planning Integrator) and the functionality of FDM Classic.  Now, you’re wondering, What’s it look like? If you’ve used ERPi in Oracle Enterprise Performance Management System 11.1.2.1 or 11.1.2.2 – interface-wise – FDMEE will be very familiar. If you’ve never used ERPi, or you’ve had some exposure to ERPi release 11.1.1.3, then the look-and-feel of FDMEE will be new, but easy to grasp.  Under the hood FDMEE is a revolutionary step forward. However, when it comes to the user experience, the Oracle development team wanted to make it more of an evolutionary step. Let’s take a look. User Interface The most obvious difference between FDM Classic and FDMEE is the user interface (UI).  FDM Classic has it’s own web address (URL) and opens in an entirely separate window from Oracle EPM Workspace.  FDMEE, on the hand, is fully integrated in Workspace. So, how do I launch FDMEE?  Once you’re in Workspace, you might be inclined to search for a menu item labeled “FDMEE”.  Lose that inclination.  Instead look for “Data Management”.  You launch FDMEE from the Navigation menu – Navigation > Administer > Data Management. Task Panes The FDM Classic Web interface consists of a number of drop-down menu lists.  (There’s an alternate menu pane, as well.)  FDMEE has a more simplified interface with just two task panes: Workflow and Setup. Administrators are the primary users of tasks on the Setup pane. Power users may also have access to some Setup pane tasks, for instance, to create new locations. End users will spend all of their time in...

We’re Upgrading – 6 Reasons to Go with FDMEE vs. FDM Classic

So, you’re considering upgrading your Oracle Hyperion application software. Perhaps your current version is out of support. Maybe your IT department has a new enterprise standard requiring you to move your Hyperion applications to the cloud. Whatever the reason, you’ve been doing your due diligence and you’ve now heard about this “FDMEE” as a replacement for your current FDM software. You can’t seem to figure out which way to go: FDMEE or FDM Classic. Here are six reasons you should seriously consider getting on board with FDMEE. 1) Out to Pasture Well, for starters Oracle is retiring FDM Classic.  Oracle Enterprise Performance Management System 11.1.2.3 is the terminal release for FDM Classic.  (In fact if you’re a new Oracle Hyperion customer, you can no longer purchase a license to FDM Classic.)  Oracle Hyperion Financial Data Quality Management Enterprise Edition – FDMEE – is the successor to FDM Classic. 2) Workspace Integration Since the introduction of the Hyperion System 9 platform in 2006, Workspace has been the portal for nearly all Hyperion applications.  Since that time, FDM Classic has never been integrated into Workspace; for the most part, it’s remained a stand-alone product. (This is probably due to its Windows constraints. See below.) FDMEE, on the other hand, is accessible from and fully integrated with Workspace. 3) ODI Under the hood, FDMEE uses the world-class Oracle Data Integrator (ODI) as the engine for data processing.  With ODI, you get more advanced data integrations (think direct connections to general ledger systems) and faster processing times. 4) Lifecycle Management Unlike FDM Classic, FDMEE supports the use of Oracle EPM Lifecycle Management (LCM).  Using LCM, administrators...