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 up. Normally, we would just……
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……
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……
I’ve always wanted to put together a post about DRM’s audit capabilities. I feel this particular feature might be a bit underused. Nonetheless, it does offer up a number of possibilities. So, here is the first in a series that I will update periodically on this feature. Recently, I was asked whether it was possible……
I was recently asked whether it was possible to run the DRM batch client from a different server, than the one on which DRM is installed on. I had to think a bit on this as I normally just run any automations on the DRM box as a matter of habit. To refresh your memory,……
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……
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……
So, after a bit of a break, it’s time to get back on the horse. Today, I thought we’d look at another DRM feature that has been around forever, but one, that I think gets lost during implementations. I am talking about the pivot feature, when using DRM exports. Recently, a requirement came up, where……
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……
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.……
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……
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……
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……
Today, I thought we’d do a followup post to this one where we initially started looking at shell scripts. Exports are by default, single-threaded, i.e., you get 1 file exported out and when it hits the maximum (2 GB in most cases), a separate file is spawned. But what if we wanted to do multi-threaded exports? MaxL allows……
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:……
