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:……
Though we are fast moving to a cloud-focused world, I still thought we’d look at an old school solution. I was recently doing some work in a Linux environment which had multiple Essbase cubes and I had to do something simple, set up backup exports for these cubes. To do this, all we need is……
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……
This one’s an oldie and applies to those of us who use Unix/Linux as the operating system for Essbase. If we need to set up SQL loads to Essbase cubes, we have a couple of options, either use OCI connections, or use old school ODBC connections. In most cases, we would use OCI, but as……
Today, I thought we’d look at one of the new features that DRM has rolled out. Version 11.1.2.4.330 allows you to do a lot of cool things. Perhaps my favorite among them, is the ability to perform external operations, whether to web services or to databases. Let’s look at how we can set up external……
Here’s a quick hack, which works on versions 11.1.2.4+. I haven’t had the opportunity to check out earlier versions. I ran into a scenario recently where I had a number of exports that I needed to rename. Now, DRM does not give us the ability to rename objects. It allows us to copy or move……
So here is a quick post for using DRM with Internet Explorer 8+. Now I never use IE when I am in development mode. It’s usually Firefox for me. But a lot of times, there are folks who have to use IE, because it’s the corporate standard (In 2016, it’s hard to see why, to……
I know it’s been a while, but I finally got some time to write a couple of posts on DRM automation, specifically, on the DRM batch utility. DRM ships with a Windows executable which allows us to automate some of the work we typically do, like run imports, blends, action scripts etc. First off, let’s……
In this series of posts, we will look at how DRM allows us to associate nodes as property values. As an example, think of those scenarios where we might need an attribute dimension for Essbase. We could set that up as a list property with DRM, if the following conditions hold true (at least in……
Q: What did the tree say to autumn? A: Leaf me alone. Now that I’ve got that out of my system, I thought we’d take a quick look at the humble DRM Leaf property. We’ve all used it one way or the other, whether we are setting up a hierarchy or applying formula logic. The Leaf……
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,……
