ODI Studio, External Authentication and Multiple Environments

I wanted to go over a scenario that arises when you have enterprise licensing for ODI and how this relates to authentication. Specifically, when ODI is authenticated externally. Now, this is not something that most of us EPM developers are used to, but this is standard when BIAPPS is set……

Continue reading

Part 1: Essbase and Hyperion Planning Outside-the-box

Welcome to Part 1 of a multi-part series detailing the creation of some out-of-the-ordinary processes leveraging Hyperion Planning command-line utilities, new (and old) Essbase CDFs and Hyperion Planning back-end repository tables. In this series, we will look at a requirement that arose at a recent client requiring the ability to……

Continue reading

Super-size me! ODI Variables and long string values (ORA-12899/ODI-1228 errors)

I often use Oracle Data Integrator (ODI) for automation and ETL processes in the EPM projects I help deliver. ODI is a wonderfully flexible and powerful tool that works incredibly well out of the box. But there are some little tweaks to ODI that I find necessary to resolve some……

Continue reading

Hyperion Calc Manager validation versus EAS validation (RUNJAVA)

While working with the @CalcMgrExecuteMaxLScript Essbase CDF I came across some intricacies around using the RUNJAVA flavor of this CDF (RunJava com.hyperion.calcmgr.common.cdf.MaxLScriptFunction). I was developing some calc scripts in EAS with the intention of converting them to Calc Manager calculation rules for use with Hyperion Planning. I find the script……

Continue reading