Fun with Oracle DRM and JavaScript

Episode 1: PropDefObject Good day all! I thought I would start a new blog series detailing the different (Oracle DRM) Data Relationship Objects and how to work with them using the newer JavaScript option available for derived property types. In this first episode, we will look at the PropDefObject object since I recently worked with……

Continue reading

ODI, the Essbase API and Jython I

Through this blog, we’ve been trying to advertise the fact that the tools we have at our disposal go a long way towards creating user-friendly solutions. Today, I thought I’d delve into the world of the Essbase API. Further, I thought we’d explore how the API can work, with Jython, and by extension, ODI. There……

Continue reading

Export Substitution Variables, The PBCS Edition I

These days, I find myself working with on-premises applications quite a bit. So, once in a while, it is refreshing to look at what Planning’s cloud counterpart can do. One of my absolute favorite features that Oracle has rolled out over the last few years is the advent of the REST APIs. I thought I’d……

Continue reading

The DRM Batch Client II

I thought today, I would do a little follow-up post, based on a question from one of our commenters. The question was, “How do we automate blends and backups using the batch client?”. As we saw from an earlier post, configuration files allow some flexibility when setting up DRM automations. Let’s walk through a simple scenario……

Continue reading

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 up. Normally, we would just……

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 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

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