The DRM Batch Client 1
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……
Oracle DRM Application Not Starting (DRM-61003 and ORA-12514 errors)
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……
DRM Node Properties I
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……
The Humble DRM Leaf Property
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……
Copy Planning Security to Essbase II
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,……
Copy Planning Security to Essbase I
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……
Changing the Plan Type for Hyperion Planning Webforms
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……
Dynamic Data Load Rules
This week, we will look at a feature of Essbase data load rules that has been around for ages. But, it is not as widely used as it should be (or maybe it is, what do I know). We’ve all been in situations where we perform a data load, but one of the members in……
Tasty Pork Tenderloin Marinade Recipe
The other day I threw together a marinade for some Pork Tenderloin (Premium Swift from Costco – great deal) with some miscellaneous items I had around the kitchen. It ended up turning out really tender and quite tasty. I’m not a big believer in measuring at least in instances like this. Cookies or something like……
Fixing the new Essbase FIXPARALLEL calculation command
Recently, Oracle released a fantastic new calculation command in the 11.1.2.3.500 patch set – the FIXPARALLEL calculation command (click here for details of this command). Expanding the horizon of ways that Essbase developers can perform multi-threaded calculations. I recently finished a project at client that had some stellar Exalytics machines chock full of CPUs and……
How to Use HFM Dimension Tables III
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……
ODI Studio Connection Setup: The easy method
The first time a user launches the ODI Studio they will be prompted or required to set up the initial connection to the Master and Work repositories. This connection information is stored in each user profile. So each user that wishes to log into the ODI Studio console will have to perform this action. To……
How to Use HFM Dimension Tables II
Today’s post is just a quick follow up to the last one, on using HFM dimension tables. The disclaimers from the last post still apply. We will be looking at additional code to generate the dimension extracts from HFM’s Account tables. As mentioned in the last post, the accounts dimension has additional attributes and additional……
How to Use HFM Dimension Tables
I need to preface today’s post with the following disclaimer, “I am not an HFM guy”. I understand it and respect it, but I am not an HFM developer. What I wanted to do today though, was look at how we can extract dimensions from HFM directly. A lot of times, we have to depend on……
Hyperion Planning Security – Import, Export Utilities and More
Today, I’d like to review how we can quickly and easily setup Security in a Planning application using the Import & Export Utilities, as well as a custom Excel VBA template. Before anything else, I should probably explain or remind some basics about Planning security. Why do we need to setup security and how is security……