A DRM Hack I

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 (!) them, currently.

20_1_Export

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

Disclaimer

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.

20_2_Tables

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

20_3_Export_Tables

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

20_4_Columns

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

20_5_Export

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

20_6_Abbrev

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

20_7_Descr

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

20_9_Rename

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

20_10_Book

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