FDM Smart Merge – Overwriting Data Without Using Replace Mode


February 29th, 2012

Many customers who use HFM have a typical close cycle where G/L data is first loaded using Financial Quality Data Management (FDM) and then, supplemental inputs are made directly in HFM using data forms.  Since the close cycle is iterative, what happens to supplemental input data when G/L data is loaded again via FDM?  If the FDM data load mode is set to either Merge or Replace, it’s very possible that the supplemental input data is going to be overwritten and users will have to key them in again.  This redundancy is a problem for companies that want a quick moving close cycle.  We have a dynamic solution to resolve that problem.  We call it FDM Smart Merge.

FDM Smart Merge leverages the default FDM data load process to dynamically clear only data intersections from the most recent data load.  You no longer have to worry about other data intersections outside of the data file being cleared.  To best understand how it works, follow the illustrations below.

First, when you load data via FDM, it’ll create a data file in the standard HFM format that will be stored in the FDM Outbox.

Illustration 1:  First load, FDM Data file loaded into HFM

Second, FDM Smart Merge will dynamically copy all the data lines in that previous data file and change the data amounts to the special HFM code “noData”.  And all those data lines will be appended to the top of your new data file.

Illustration 2:  FDM Smart Merge creates data lines to clear the first load data records

Typical of the close cycle, the next load of G/L data will have changes to the data lines.  It’s very common for data records to disappear because adjustments have been made in the G/L.  For example, let’s assume the “Discounts” lines do not appear for valid accounting reasons in the new G/L data file.

Illustration 3:  New G/L data file

Third and last, FDM Smart Merge will ensure that the previous data records that loaded to the “Discounts” lines will be cleared out in HFM.  The full file that FDM will load into HFM will look like this example below:

Illustration 4:  Second load into HFM, FDM data file with Smart Merge

In HFM, if the entities California and Texas have supplemental data via data forms or data grids, they will not be affected.  That supplemental data will still show up in HFM.

FDM Smart Merge can be deployed to impact specific FDM Locations to give you flexibility when you have special instances when you do not want to overwrite the previous data load.



About TopDown Team

The TopDown Team includes members of TopDown Consulting who want to let the community know about webcasts, conferences, and other events. The team also conducts interviews on various EPM industry topics.

Leave a Reply

Your email address will not be published. Required fields are marked *