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

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

Continue reading

Don’t forget the WORKERTHREADS!

Beginning in 11.1.2.4 Essbase, there is a new configuration setting that should not be forgotten – “WORKERTHREADS”. Why is this configuration setting important you may ask. Previously, Essbase operations that could run in parallel (calculations, data loads etc) used dynamically created threads for their work. Administrators need not bother setting thread pools or assigning threads.……

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

ODI 12c Installation (Standalone install)

PREREQUISITES Download the ODI install file http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html. Make sure you have a Java JDK installed. I used the version seen below. The Oracle support matrix shows any version greater than 1.7.0_55 as supported. I’m not sure if 1.8 is supported though so I stuck with version 7. Note that support for 7 is set to……

Continue reading