Latest Features in 11.1.2.4 @ Oracle FDMEE

Latest Features in 11.1.2.4 @ Oracle Hyperion FDMEE

1.        EPM to EPM Data Sync

FDMEE 11.1.2.4.x will allow you to import data directly from a source EPM application (e.g. HFM) and load to a target EPM application (e.g. Planning) right in the user interface. You will no longer need to generate a data file from the EPM source app.  You will simply identify the source and target EPM applications, map the data, and presto, you’re done!

2.       True Integration with FCM

FCM will be able to launch FDMEE at the Data Load Workbench page for a specific point of view. B) FCM will be able to issue location level locking for a specific point of view.

3.       Enhanced Metadata Integration

That’s right, FDMEE supports metadata loads. You may not have known that. With 11.1.2.3, you can load metadata from ERP systems like Oracle eBS and PeopleSoft to EPM target applications, like HFM and Planning. With 11.1.2.4.x, FDMEE takes it to the next level. You will be able to load file-based metadata loads.

4.      DRM to FDM Map Integration

A number of my clients have been using DRM to manage FDM maps for years. Yeah, it’s a custom solution but it’s fairly straight forward. Well, with FDMEE 11.1.2.4.x this will be natively supported.

5.       Target Application Enhancements

In this release, Oracle Hyperion Financial Data Quality Management, Enterprise Edition now supports:

 Oracle Hyperion Profitability and Cost Management (HPCM)

 Tax Provision Application of Oracle Hyperion Financial Management

6.       Target Load Options

In Data Load Rules, you can now specify target application options specific to a location. For example, you can select different data protection values for each location

7.       Write-Back

FDMEE has been enhanced to support write-back from all EPM applications (except the Accounts Reconciliation Manger) to Enterprise Resource Planning (ERP) applications. This feature offers significant advantages, such as writing back budgets created in Planning to Peoplesoft or E-Business Suite ERP GL, or moving adjustment journals from Oracle Hyperion Financial Management to ERP Systems like Oracle E-Business Suite or Peoplesoft. Other target systems still need to use a custom application framework.

8.       POV Locking

New POV lock options are available in this release that enable you to lock the POV for all locations or to lock the POV for an individual location. Locking the POV prevents locations from modifying the data. When a location has been locked for a particular period or category, users cannot import, validate, export, or rerun the validation report.Data in a locked POV can only be loaded when the locked POV is “unlocked.”

9.       Import Format Builder

A new Import Format Builder feature has been added in this release to Import Formats. When the source system is a file-based data load, use the Import Format Builder feature to map source fields graphically to target dimension members instead of typing the starting position and the field length. This feature is available for both fixed and delimited files.

10.   New Fix Mapping Feature

In the Data Load Workbench, you now have the option to view mapping errors and fix them instantly when mapping errors have occurred

11.   Report Translation

You can now view report descriptions and parameters in the language selected for your user interface. Language templates are available at:C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\templates for you to select and associate with a report definition.

Remaining FDM Classic Features jumping in 11.1.2.4

With FDMEE Release 11.1.2.3.520, most of the worthwhile FDM Classic features have been incorporated in FDMEE.  Here’s a list of remaining parity items that will be rolled out in in 11.1.2.4.x.

·         Fix Mapping Errors Inside of Data Load Workbench – In FDMEE 11.1.2.3 users can only resolve data load mapping errors on the Data Load Mapping screen.  With 11.1.2.4.x users will be able to fix mapping errors right where they’re encountered – on the Data Load Workbench > Validation screen.

·         Location Level POV Locking – Release 11.1.2.3.520 introduced POV locking to FDMEE, but it only works for all locations.  In 11.1.2.4.x, users will be able to lock the POV for individual locations.

·         Export to Excel Option on More Screens – Like FDM Classic, this feature will allow end users to easily export metadata items from just about any screen.

·         Copy Maps Option – Using this feature users can easily copy mapping tables from source location to a target location.

·         Graphical Import Format Builder – Instead of creating import formats for from scratch, users can use this wizard to map source fields to target dimension members.

·         Location Hierarchy Groups – FDMEE 11.1.2.3 has a flat structure for locations, that is it’s simply a listing of locations with no groupings.  With 11.1.2.4.x, location groupings (e.g. control review locations) are back!

                                                                                        

                                                                                                          *(Source taken from various forums and blogs)