TopDown Blog


Using FDMEE to Add a Cloud Application as a Target

By on December 21st, 2016

The release of PSU 200 for FDMEE introduced some exciting new features, including the ability to add a Cloud application as a target application, eliminating the need for a file based approach at a recent client.

Top 10 Blog Posts of 2016

By on December 19th, 2016

As the year comes to a close, we’d like to take the opportunity to showcase the most popular topics selected by all the visitors to the TopDown website by listing the Top 10 blog posts of 2016. Some of these topics remain evergreen, making the list for multiple years. Other topics are more recent. In addition, this year our experts are weighing in on how each of these topics fits in with the maturing of EPM in the cloud. Be sure to check back each day between now and December 31, 2016, to find out what our experts have to say this year’s Top 10.

On-Premise to Cloud FDMEE integration

By on December 13th, 2016

At a recent engagement, we needed to load Actuals from a Hyperion Financial Management (HFM) application to a new Oracle Planning and Budgeting Cloud Service (PBCS) application. We were able to take advantage of the newly released PSU for FDMEE ( PSU 200), which introduced some exciting new features, including the ability to add a Cloud application as a target application.

Working with FDMEE v11.1.2.4 and the .200 Patch

By on June 13th, 2016

Recently, we’ve implemented FDMEE version at a major client. This client has been using FDM classic version 11.1.2.x for many years and needed to upgrade to version for compliance and maintenance support reasons. When we started this project, we installed the base version of FDMEE with the .100 patch. Through the course of our implementation we ran into some noteworthy findings that we’ll discuss in this blog post. Our guideline for the FDMEE build was to use built-in functionality and be fairly vanilla, so avoid any custom coding.

Reporting in FDMEE

By on April 6th, 2016

FDMEE comes installed with variety of standard reports, just like in FDM. Most of the reports that came with FDM are ported to FDMEE. The big difference is that the embedded engine that renders the reports now is Oracle BI Publisher. The core data tables remain the same, making it easier to convert old custom…

FDMEE / FDM – Map One Source Account to Multiple Target Accounts

By on March 8th, 2016

What do you do when one line item provides more information than only one destination Point of View? For instance, assume that all of the trial balance accounts from an extract will load to a custom dimension member of “END”. However further assume that the trial balance has multiple members, typically in a custom dimension, for the balance sheet accounts that record movement.

Using FDMEE Multi Dimension Mapping

By on March 1st, 2016

In old FDM if there was ever a need to source two fields for an exception mapping, it was required to write a script to resolve this issue so that the scripted member would then be able to be mapped accordingly. For instance, there might be a Long-Term liability account in HFM, “AccruedTax”, that in almost all instances is sourced from a G/L account, 290100. Let’s say however, that there is one exception to this based upon the Entity, “WestSales”, where instead of being a long-term liability, this instead is a long-term asset for HFM, “LongTermDefTaxAsset.”

FDM / FDMEE Mapping – General Principles

By on February 24th, 2016

Let’s discuss the basic fundamental purpose of FDMEE. That is to say mappings. FDMEE has come a long way since its origins, and is at this stage is an ETL-like tool (Extract Transform Load). Mapping is the “T”, Transform, part of this acronym. This is where source system, typically General Ledgers, metadata members are transformed to a destination EPM application dimension member. Think of these as accounts, entities, cost centers, product members, and so on.

Oracle Hyperion Security

By on November 9th, 2015

Application security is the security within an application. Security prevents two types of errors: intentional and accidental. Intentional errors are rare, the majority of errors are unintentional or accidental. A large public corporation normally consists of several small entities. The accounting numbers will more likely be correct if accountants are prevented from making unintentional errors by only having the minimum access needed to do their job.

Kscope15 – DAY 3

By on June 22nd, 2015

The second day of sessions delivered in spades. Highlights are below. Everyone is talking about the cloud…

© Copyright 2020 TopDown Consulting. All Rights Reserved.