I’ve always been a big proponent of REST and REST-based integrations as it relates to the EPM stack, or indeed, to any cloud solution. Here is some sample content that illustrates this. When you use the (E)PBCS REST API (or any EPM API, for that matter), one issue that crops up, is how to mask……
Continuing on with my love-fest on Essbase Cloud, I wanted to explore another little trick that the nice folks at Oracle have shipped with OAC. Specifically, the ability to run Groovy scripts from Essbase Cloud. The first clue that this is possible, comes from the “Jobs” tab. Well that’s great, but how do we get……
I tend to work with ODI quite a bit. Recently, I came across a scenario where the standalone agent on one of our boxes was turning itself off once in a while. While the issue was fixed, it did provide the impetus for this post. Today, we’ll take a look at the ODI (11g) standalone……
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……
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……
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……
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……
Now that the KScope hangover is done with, I thought we’d look at another example of how REST with Groovy works. Today, we will look at another example using the HPCM REST API; this one deals with executing tasks, such as running rulesets. While our earlier example used the “GET” method, we now will be……
Today, I wanted to post a little addendum to our earlier post on Groovy and REST. We’ll take a look at how you can further extend your integration capabilities, by adding ODI to your Groovy > REST calls. You might have noticed Groovy on ODI and wondered how you might use it. To access ODI’s……
One of the most important things that Oracle has come up with recently, is extending the capabilities of EPM products, using various REST APIs (Representational State Transfer). For instance, PBCS has a REST API that can be used to run business rules, or load data using these API calls. So does BICS. Recently, Oracle also……
I thought today we’d look at how executing dynamic SQL with ODI is both simple and effective. I ran into a scenario recently, where I had to make updates to an indeterminate number of tables. The number was indeterminate, but not the names of the tables. The table names were derived from a view, which……
As we’ve seen in the last post, we have a list of users and their filter names as they exist in Planning. Continuing on, let’s take a look at what the documentation tells us about filters. It’s not evident at first glance, the importance of the section, “as FILTER-NAME”. If you dig one step deeper,……
Today, I thought we’d look at a little proof of concept, in this part 1 of a 2-part series of posts. One of my co-authors and I were trying to figure out how to replicate security from a Planning application to an Essbase cube. Imagine the scenario, where we might have a planning application, for inputs……
You may find yourself needing to change the plan type that a Hyperion Planning webform references and wondering “How do I do that?”. Hyperion Planning will not allow a change to the plan type for an existing webform from the Planning web interface. The following steps will demonstrate how to do it leveraging the Hyperion Life……
