FDMEE Parallelism Gone Wild? Rein it in with custom throttling!
If you're like me, you've noticed (perhaps despairingly) that FDMEE settings can be a bit extreme. You need to tightly control the order and concurrency of your data loads? Sequential to the rescue! Oh wait now, you need to allow multiple loads to process at the same time? Parallel to
FrankenHyperion (Ubuntu, SQL Server for Linux and Nginx)
If you read my last post you know I ran into some problems at the end. Not related to SQL Server but related to how OHS (Oracle HTTP Server aka. Oracles version of Apache) plays with Ubuntu. For whatever reason I was not able to get OHS to install correctly
EPM 126.96.36.199 and SQL Server on Ubuntu
Today we try something different. I have a stock Ubuntu installation in Hyper-V. Microsoft has released SQL Server for Linux, I think SQL Server for Linux is a Release Candidate (RC), which we over at Tevpro have been using with some .NET Core applications. Lastly, I need a VM of
Splitting multi-period into single period load files
When loading data into Oracle EPM applications the tool of choice is Financial Data Quality Management Enterprise Edition (FDMEE). Dating back to Classic FDM it has been possible to load either by single period or multi-period. In Classic FDM there was a performance penalty associated with processing multi-period files. The
Comparing Properties in DRM
Overview My client updates several hierarchies monthly using extracts from SAP (DRM is not currently the source of Master Data). One of the things updated with the hierarchies are the member descriptions. They have a requirement to move the existing description to another property when descriptions change. We then load
Creating DRM Properties that Inherit from Descendants
Overview To inherit is defined as "to receive or be left with (a situation, object, etc.) from a predecessor or former owner." DRM allows for property inheritance which works great for things like Account Types in planning applications or currencies on entities but, what happens when you need
Extracting UDAs from the Outline
First, hope everyone had a wonderful holiday weekend. Now it's back to real life... I have been doing quite a bit with DRM for a while now and am currently migrating a Planning application to DRM. One of my most recent tasks was to load the UDA's into DRM. Now
Installing JunkieFramework in FDMEE
In a previous blog post we announced the release of the JunkieFramework (call it whatever you want). This post will focus on getting the framework installed and show some basic usage. Save Script The simplest way to load the framework is by grabbing the source file JunkieFramework.py. Then save
PEP 8 and Logging
Over the weekend I spent a little more time on the FDMEE framework, while implementing some new logging functionality I felt compelled to look into the Python Style Guide (PEP 8) and realized while my new logging code seemed to be in line with guide, our property names were not.
Its a collaboration not a dictatorship
Well we already have our first big change to the framework. As Justin was working with it he found the instance variables to be a pain point. Each use of a variable required it be wrapped in a to string function str(jf.variable). If the variable was not explicitly
Whats that you say an FDMEE Framework?
Lately Justin, Erik and I have been discussing FDMEE quite a bit. We recently realized that we were doing many of the same things however our implementations may differ. While chatting last Friday we decided to change that. So I would like to be the first to introduce the JunkieFramework.
JConsole to the Rescue
A few months back I ran into this error Java.lang.OutOfMemoryError: PermGen space while working on some ODI integrations. I pulled up a quick google search and found the second link of the list was stackoverflow bam problem resolved. Well that was in Development. Then couple weeks ago I
Jython is the language that powers Oracle Data Integrator (ODI), it also is one of two options (Visual Basic (VB) is the other, it has been speculated the option for VB may disappear at some point in the future) for Financial Data Quality Management - Enterprise Edition (FDMEE). Jython is