ODI - EPM Junkie

Error in CommData.loadData line 4135, in loadData

Follow me down the rabbit hole as I dig into the inner workings of FDMEE to resolve a somewhat cryptic error message.

ORA-01400: cannot insert NULL into ("FDMEE"."TDATASEG_T"."DATAKEY")

Behind the scenes FDMEE inserts values into DATAKEY but sometimes things can get a little messed up. Fixing this issue is generally quick and simple.

Jython

Accessing ODI Physical Schema via FDMEE

Story time! Recently I was migrating FDMEE from 11.1.2.3 to 11.1.2.4 at a client that has extensive scripting in FDMEE. Lot's of neat stuff going on here. One of the things they were doing was accessing the ODI physical schema to obtain the login

ODI

Planning Integration with the FDMEE Built-In Agent

When using the FDMEE integrated agent resolving the "java.lang.NoSuchMethodError: com.hyperion.planning.HspHALBean.endLoad()" error message may require adding HspJS.jar to the classpath...

ODI

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

PyDev

Jython Debugging for ODI (revisited)

Over a year ago I wrote a two part (1, 2) post about ODI (Oracle Data Integrator) debugging using Eclipse. This post was meant to have at least one more part; somewhere along the way I gave up. It is not that is isn’t important, in fact I still

Jython

Installing Jython

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

Planning

Confessions from a EPMA user

So this a confession from a consultant that has primarily used EPMA. So when I first learned Oracle EPM the Enterprise Performance Management Architect (EPMA) product had already had most of the kinks worked out. I never really understood why so many people had such a bad view of it.

ODI

Working with temporary folders in ODI

In the past I have (like I assume most ODI developers) setup local folders or network shares to house files that ODI needs to manipulate(modify, write). These folders and files have had various purposes. Sometimes it has been a staging location for a file copied off another system using

ODI

Parallel Execution in ODI

For a while now we have run into an issue on EPM 11.1.2.3.x with regards to FDMEE. The issue has been that the physical ODI topology for the FDMEE data source seems to randomly change the values for the work table prefix settings on Loading and

ODI

Avoiding Variables in ODI File Copy

Copying files in ODI is a trivial task. There are many ways to do it (ODIFileCopy, Procedures, OSCommand etc.) One of the biggest issues though is when you need to move from environment to environment. Frequently I have implemented the file copy using variables and I have seen enough implementations

Error

ODI: SnpPschema does not exist

Recently when working on a migration for a client I ran into an error in ODI I had seen before but forgot about. This one was "ODI-26016: The requested operation cannot succeed. The object no longer exists." in the detail of the error I found the text "

Hyperion

Configuring ODI Studio with FDMEE

This post is a continuation of my previous post on Installing ODI Studio with FDMEE. I know this has been covered elsewhere but I figure it can't hurt to have a step by step guide. FDMEE Settings First locate the Data Management component of Oracle EPM by Navigating to Administer

Hyperion

Installing ODI Studio with FDMEE

Prior to 11.1.2.3 FDMEE was known as ERPi and while it worked together with Oracle Data Integrator (ODI) they were seperate installs. ODI's installer is good but I woudln't call friendly or great. The agent configuration in ODI for example is not part of the install and

Hyperion

Enable Multiple Data Columns Using ODI

When using ODI to push multiple data fields into Essbase, it's a lot easier than one might think. All the tools you need are right inside ODI RKM for Essbase. I'm not going to go into how to use ODI to reverse engineer an Essbase application that is a topic