DRM (Data Relationship Management) version 11.1.2.4.341 brings some new features to DRG, specifically to the workflow tasks and in this post we will talk about the Calculate Name and Calculate Parent features. (Hopefully, a Calculate Description option will be added in a future release) Before I start, I just want to mention that I had not personally used……
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:……
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……
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……
A few weeks back I was looking to install Oracle Data Relationship Management (DRM) on a virtual machine for some testing. I fired up my trusty Windows 2008 server VM and went to work installing Oracle DRM using the installation instructions found on this very blog (written by the magnificent Vijay Kurian no less). The software……
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,……
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……
This is the last in a series of posts related to deriving metadata from HFM’s backed tables. The earlier posts can be found here and here. It will be a short post and I’ve put it together mainly for the sake of completeness. Today, we will look at the Entity dimension. A quick look at EPMA……
