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…
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…
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…
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…
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…
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….
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…
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…