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

Continue reading

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

Continue reading

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

Continue reading

Dynamic Scripting Validation Goodness

With the arrival of Dynamic Scripting in DRM 11.1.2.3, JavaScript is a valid scripting option within DRM. This is pretty neat because a script provides a more robust alternative to traditional DRM formulas. I also like the fact that you can now put comments inside your code. I thought it would be nice to do……

Continue reading

DRM 11.1.2.4 Application Creation

Now that we’ve finished the DRM install, it’s time to create a new DRM application. This process is pretty straight-forward as well. As usual, let’s look at some of the pre-requisites. Pre-requisites Create a new repository (ensure you have the database rights to do this). Alternatively, you can choose to run scripts manually as well. Suitable……

Continue reading