Ask an Expert

Oracle EPM & BI Blog

Jython Script vs. VBScript for FDMEE: Keeping Your Options Open

Posted by Peter O'Reilly   |   Oracle FDMEE,   |   Data Integration

From time to time Oracle releases an EPM product that, as a developer, causes you to pivot. 

The first release of FDMEE in 2013 was one such product. With Oracle Data Integrator (ODI), as the foundation on which FDMEE was built, the ability to integrate different systems and automate processes with EPM applications got turbocharged. Since FDM was VB-based, I initially thought I would be translating a lot of FDM application VBScripts to FDMEE. I’m happy to say I was wrong!

Read More

The Top 10 EPM Downloads of 2018

This year was all about thinking strategically — what is going to help your team, your business, and your career more forward? We created a lot of content to help get you in a strategic mindset, and this blog post will help you continue that outlook into the new year.

These are the top 10 downloads of 2018...

Read More

The Top 10 EPM Downloads of 2017

This year, we created more content than ever before to help you get the most out of your EPM investment. We looked back at all the eBooks, tools, webinars, and checklists to see what you loved most.

Read More

FDMEE Tutorial: 10 Steps to Using a Source Adapter Parameter to Filter Data


Financial Data Quality Management Enterprise Edition (FDMEE) and Oracle Data Integrator (ODI) are useful products with an abundance of features. The various menus, options, and setup screens within FDMEE and ODI can be overwhelming. This is why I was intimidated when initially challenged with the task of leveraging FDMEE parameters to filter data sets, but the task turned out to be a great learning experience. Going through the process helped me gain a better understanding of the relationship between FDMEE and ODI objects.

NOTE: The steps below will not walk through installing or setting up FDMEE. The assumption is that the environment is already setup and running with working source and targets.  

Read More

How to Install Oracle Data Integrator (ODI) Studio for FDMEE

All of us that have been using Hyperion products for years know that version was the last edition of the “FDM Classic” or Financial Data Quality Manager (FDM), formerly Upstream Weblink. The result of a merger of FDM with Enterprise Resource Planning Integrator (ERPi) (which uses the Oracle Data Integrator engine), is what we call Financial Data Quality Management, Enterprise Edition (FDMEE)

FDMEE now has a full Oracle Data Integrator (ODI) backend installed by default. If you enter through “Workspace” you will see that not much has changed with the user interface. However, if you are an ODI or Oracle Data Integration developer, the screens that you are used to seeing in ODI Studio are not available.

Read More

FDMEE Tutorial: Search Icon Missing from Select Point of View Dialog Box

Posted by Terry Ledet   |   Oracle FDMEE,   |   Data Integration

With numerous clients upgrading to EPM and migrating from FDM Classic to FDMEE, one issue we’ve heard repeatedly is that the search icon is missing from the Select Point of View dialog box when using Internet Explorer 11. This is the result of the Workspace hostname / computer name being listed in Compatibility View or Display intranet sites in Compatibility View being selected.

Read More

FDMEE Tutorial: How to Install PSE 22506614

Posted by Terry Ledet   |   Oracle FDMEE

In my previous blog post FDMEE Map Monitor Reports (Finally!), I demonstrated how to enable this new functionality included in FDMEE patch The tutorial listed which Map Type and Action were logged and which were not logged concluding with Bug 22526857 - AIF_ARTIFACT_AUDIT TABLE NOT LOGGING ANY CHANGES FOR EXPLICIT AND MULTI DIMENSION, which was provided by Oracle Support based on an SR opened during the creation of the tutorial.

This tutorial below will review the implementation of Patch Set Exception (PSE) 22506614, which contains three code fixes.


Read More

Tutorial: FDMEE Map Monitor Reports (Finally!)

Posted by Terry Ledet   |   Oracle FDMEE,   |   Data Integration

One of the features missing in FDMEE to achieve parity with FDM Classic is Map Monitor Reports, which for numerous clients is a key internal / SOX control. Thankfully, a much-needed enhancement included in PSU are two Map Monitor Reports.

Specifically, the Readme states, “Two new Map Monitor Reports have been added to the Audit Reports report group: Map Monitor for Location and Map Monitor for User. Map Monitor Reports show changes made to the data load mapping rules using any of the methods data load mappings UI, Excel template imports, text file imports, and Lifecycle Management imports. The Map Monitor Reports do not capture historical data earlier than release Map Monitor Reports are enabled only if the Enable Map Audit is set to 'Yes' in System Settings.”

This blog post will demonstrate how to enable the functionality and detail which map types are logged “monitored” based on the type of change and which are not.

Read More

FDMEE Tutorial: How to Utilize Essbase as a Source

Posted by Terry Ledet   |   Oracle FDMEE,   |   Data Integration


In previous FDMEE tutorials, we've talked about how to utilize HFM as a source and how to utilize Essbase as a Target.

One of the enhancements to FDMEE is the functionality to utilize an Essbase application not only as a Target but also as a Source. Unfortunately, prior to PSU, the product had a bug that prevented this functionality. Now with the release and installation of PSU, bug 20747662 “Import from EPM source (Essbase) fails” has been resolved. This step-by-step tutorial will demonstrate this functionality, i.e. extracting data from an Essbase Block Storage “BSO” application.

Read More

FDMEE Patch Release: PSU

Posted by Terry Ledet   |   Oracle FDMEE,   |   Data Integration

FDMEE Patch Number 20648390 (also known as PSU lists 42 defects fixed in this patch based on the included Readme as well as new features. Before I provide my first impressions, a brief installation of the patch is needed. Warning: I am an application consultant. However, I do create and install the various EPM products on virtual machines for personal testing and development. 

Read More

Subscribe to Email Updates

Browse by Topic

See All