Category: Financial Data Quality Management (FDMEE)

June 3, 2018

  As we know FDMEE (Financial Data Quality Management Enterprise Edition) is a packaged solution for finance users to bring data from other environments. It has a Web-based interface and it is a powerful integration engine.   When the source system is a flat file, we are able to set up the import format to…

June 2, 2017

  We have discussed many tricks about FDMEE. If you are interested, you can check the previous posts. This time, let’s discuss more about the mappings.   Import Mapping File As we know, we are able to set up mappings manually. In the meantime, FDMEE provides a way to import mappings automatically.   Under the…

May 12, 2017

  As we know, Data management is the tool for finance users to load data through files or other systems, such as Fusion ERP. But what should we do, when it comes to a situation that we need to transfer data from one instance to another instance, like from cloud to cloud? For example, if…

May 5, 2017

  The on-premise FDMEE gives us an opportunity to use batch files to load data. We can store the data files to a batch folder, then define a batch to load the data files. The PBCS / EPBCS FDMEE, which is the EPM Cloud version, is a little bit different. I will discuss the EPM Cloud…

April 7, 2017

  Data Load In this section, let’s take a look at how to load and validate data in FDMEE and then export the data to other Oracle products, such as Planning. Data Load – Workbench System Settings Before using FDMEE, we must register the source system from which you want to import data. Then register…

March 30, 2017

  FDMEE offers a powerful extensibility framework by providing Jython and Visual Basic based scripting. Using the rich set of the API library, users can extend and customize the product to best fit their needs. FDMEE supports four types of scripts:   Import scripts – Executed as source files are imported. Uses Jython script only….

March 16, 2017

  Oracle Hyperion Financial Data Quality Management Enterprise Edition (FDMEE) is a data integration tool that helps transform data and metadata from a variety of sources into a consumable format for Hyperion products like Planning, HFM and Essbase.   Abbreviations, Acronyms and Definitions Description FDMEE Financial Data Quality Management Enterprise Edition ERPi Enterprise Resource Planning…

January 27, 2017

  From a business perspective, Periods 1 to 12 are the twelve months of the year. Period 13 is the year end adjusting period which would have adjustment GL entries booked into it.  So for all reporting purposes, period 13 also needs to be taken into consideration and merge into December to get the actual…