us-analytics.png
Ask an Expert
blog-Hero.jpg

Oracle EPM & BI Blog

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 11.1.2.3 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 11.1.2.4.x 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 11.1.2.4.100. 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 11.1.2.4.100 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 11.1.2.4.100. 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 11.1.2.4 is the functionality to utilize an Essbase application not only as a Target but also as a Source. Unfortunately, prior to PSU 11.1.2.4.100, the product had a bug that prevented this functionality. Now with the release and installation of PSU 11.1.2.4.100, 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 11.1.2.4.100

Posted by Terry Ledet   |   Oracle FDMEE,   |   Data Integration

FDMEE Patch Number 20648390 (also known as PSU 11.1.2.4.100) 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

When Should You Upgrade to Oracle Hyperion 11.1.2.4?

Posted by US-Analytics   |   Upgrades & Migrations,   |   Oracle FDMEE


Companies today are facing difficult decisions with timing their upgrades for Oracle Hyperion EPM environments as well as the supporting operating systems, browsers, and office applications. So how do you figure out when you should upgrade to Hyperion 11.1.2.4?

The Problem

Many IT departments are coming to terms with the fact that Windows Server 2008 and Windows Server 2008 R2 lost Mainstream Support as of January 13, 2015. Currently, their only option for support from Microsoft is through Extended Support, which is expensive and should only be used as a short-term migration strategy. Along the same lines, Microsoft SQL Server 2008 also lost Mainstream Support as of July 8, 2014, with Extended Support only available. Consequently, IT departments throughout the world are making plans to migrate to Windows Server 2012 R2 and SQL Server 2012.

Read More

Subscribe to Email Updates

Browse by Topic

See All