A DRM Hack I

Here’s a quick hack, which works on versions 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 (!) them, currently.


So what’s a quick way to do this? There are a couple of ways, I can think of. Here’s one of them.


Before you try this out, make sure to back up all necessary objects and test this out on a development instance first. And in case it’s not clear enough, test, test and test some more.

The Hack

In this scenario, I would like to rename the export in the screenshot above. In order to do this, you will need access to the SQL repository. As I am sure you are aware, DRM stores all data inside a series of SQL tables. Each node you create, property you update, it’s all here.


And that includes our exports as well. References to exports are held in this series of tables.


The one we care about right now, is RM_EXPORT. And in particular, the C_EXPORT_ABBREV column within this table.


As you can see, this column captures the name of the export.


All you need to do (after backing everything up), is update this value directly with the correct name.


If you want to update the description, it’s one column over, in the C_EXPORT_DESCR column.


Now, if you toggle back to DRM, you will see that the export has been renamed.


If it’s part of a book, the changes are reflected there as well.


And there you have it, a quick hack to make a change using the DRM backend tables. I don’t recommend making changes like this on the repository directly; this exercise just proves that it is possible to do this. I’ll do another post later, on a more “acceptable” hack next time, to do this same type of action.


About Vijay Kurian

Known as the Clem Fandango of EPM consulting, Vijay Kurian has been developing enterprise solutions for companies for the last 12 years (increment years if reading post-2015). Having worked with Essbase, Planning, DRM and other assorted technologies during that time, he’s made the frankly, average decision, to write about them. He is, surprisingly, an Oracle ACE Associate. He hopes to contribute frequently to US Weekly, People and Sensible Chuckle magazines on improving reporting solutions, creating master data management systems and zzz…

Leave a Reply

Your email address will not be published. Required fields are marked *