TopDown Blog

Category: Integration

Loading Metadata with Cloud Data Management

By on July 26th, 2018

Let’s take a look at a recent Oracle EPBCS project where we used this relatively new feature in Data Management to automate the load of three large dimensions from flat files sourced from a data warehouse. The setup is straightforward, and Oracle has made it easy to add the new target dimensions.

Integration and the Cloud

By on December 29th, 2017

While the push toward the cloud most certainly gained steam in 2017, some applications are not yet robust enough to accommodate the needs of the business. As a result, the most popular topic in 2017 was data integration and FDMEE  (a topic that will no doubt remain a hot one in 2018). This new blog post discusses integration and a Hybrid Approach to help companies decide which option best accommodates the goals and needs of the business.

FDMEE – Map One Source Account to Multiple Target Accounts

By on December 22nd, 2017

Managing data integration between different applications is a common challenge many companies face and this is FDMEE comes in handy. The fundamental purpose of this applications is mapping. As more applications move to the cloud, understanding how to correctly map one source to account to multiple targets is key to successful integration.  

NEW Data Load Possibilities in Cloud Data Management & FDMEE

By on December 21st, 2017

As the number of cloud applications increases, many companies still find themselves in a position where they need to integrate data between on-premise and cloud applications. FDMEE offers a number of different features, including Hybrid Implementation Support, which lets you extract data from your on-premise HFM application and load it to the cloud. This new blog post goes over additional data load possibilities in FDMEE.

Getting the Most Out of FDMEE Using SQL

By on March 21st, 2017

When companies integrate FDMEE with an ERP system, they often find that they can no longer massage data using scripting in an import format. The good news is Oracle added SQL in FDMEE. It allows you to do more than just mapping, and as a result you can use it to solve the data scrubbing problem that comes with the FDMEE and ERP integration. In this blog post, I will walk through a scenario where I did just that.

Integrating DRM with Oracle Planning and Budgeting Cloud Service

By on March 14th, 2017

When it comes to Oracle Planning and Budgeting Cloud Service (PBCS), the question we are consistently asked is: Can DRM publish metadata for consumption into Oracle Cloud? The answer is yes, with a couple of asterisks. Read on to find out how.

Working with FDMEE v11.1.2.4 and the .200 Patch

By on June 13th, 2016

Recently, we’ve implemented FDMEE version 11.1.2.4 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 11.1.2.4 for compliance and maintenance support reasons. When we started this project, we installed the base version of FDMEE 11.1.2.4 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.”

© Copyright 2018 TopDown Consulting. All Rights Reserved.