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 update security within a Planning……

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 occasional hiccups I encounter. I……

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 editor in Calculation Manager to……

Continue reading

Issue with Shell Escape and @CalcMgrExecuteMaxLScript

Thought I’d post a little tip that could prove useful to others that are looking to use the @CalcMgrExecuteEncryptMaxLFile and @CalcMgrExecuteMaxLScript Essbase functions (CDFs). I often find the ‘shell’ command that is available with MaxL scripting to be very useful. According to the Oracle technical documents the ‘shell’ or ‘Shell Escape’ allows the user to……

Continue reading

DRM Duplicate Check

One of the things I’ve always wanted to focus on, with this blog, is how the tools we use, sometimes provide simple and effective solutions. For instance, there are always cases, when we develop hierarchies on DRM, where we will need to filter down our exports based on the existence of duplicate attributes. In other……

Continue reading

Using escape character (\) to retain quotes in Essbase dim builds

Hello fellow Essbasers, I thought I’d pass on a little tip for an issue you may come across when creating an Essbase dimensional build. Occasionally you may need to build outline members that require quotes in one of the dimensional build fields (typically involving member formulas). Let’s take the following source data as an example.……

Continue reading

DRM – Insufficient Rights Error

I thought today, we’d look at a simple error message that might crop during your implementations. I’ve been neglecting the blog for a month or so, and I need something simple to get me back in gear. So, here goes. Sometimes, when you run action scripts, you might run into the following error, “Insufficient rights……

Continue reading

Essbase Warning 1002023? Check your Config File

The other day I was running MaxL scripts on some Essbase applications at a client. In the corresponding MaxL logs generated by data load statements, I noticed the following warning being generated. I noticed that every data load and dim build was generating this same warning. WARNING – 1002023 – No message for message #1002023……

Continue reading

Reduce size of Runtime Prompts in Hyperion Planning applications

Hyperion planning users sometimes, when running a business rule that require some kind of selection through a runtime prompts window will complain that the OK and Cancel button are not displayed on their screen, as seen below. The runtime prompt window is too big for their screen resolution, so those buttons don’t show up and users……

Continue reading

DRM Errata Close Version

Here’s a quick little post on some errata in the DRM documentation. I was recently looking at setting up a process to unload versions as part of my automation scripts. I was using regular batch utility execution, instead of the configuration file method (see here). According to the documentation, the way to do this is:……

Continue reading