Cloud

Why Oracle DRM is Essential for Managing Master Data (Part 3)

Why Oracle DRM is Essential for Managing Master Data Part 3

Link to Part 1

Link to Part 2

One of our clients’ favorite features of DRM is the ability to configure custom governance rules for their dimensions. Without DRM, many organizations are forced to use manual enforcement coupled with inadequate tools such as Excel, Access, and SQL procedures. Simply maintaining these processes becomes a job in itself.

DRM validations provide a simple and scalable solution. The application can easily be configured to enforce even the most complex rules governing an organization’s enterprise dimensions.

So let’s look at an example…

The infamous ABC Corporation has a rule that all accounts beginning with numeral 6 or 7 must be classified as an ‘Expense’ in the organization’s Hyperion Planning application. ABC utilizes DRM for governing the Planning account dimension:

DRM_Validation_1

Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

Get the Guide

Steve, ABC Corporation’s awesome DRM administrator, has received a request from a Finance Manager to create a new expense account for Trash Removal. Steve right-clicks on the ‘Misc Expense’ parent/limb and selects New -> leaf. (Leaf = bottom member, no descendents)

DRM_Validation_2

He enters a name and description for the new account. But notice, he is creating an expense account without 6 or 7 as the first numeral in the name field. He’s violating ABC’s governance rules (something he rarely, if ever does. But hey, everyone has an “off-day”).

DRM_Validation_3

Steve clicks ‘OK’. But since he has violated a custom DRM violation, he is presented with an error!

DRM_Validation_4

DRM has disallowed the creation of the new account since it violates a configured validation. At this point the user clicks ‘OK’ and is returned to the New Leaf window to enter a valid name.

DRM_Validation_5

With the valid name entered, the new account passes validations and is saved to the hierarchy. Additionally, the Planning account type property is automatically set by inheriting the value from the parent (i.e. Misc Expense). This is confirmed by resting the cursor over the Status column of the property pane on the right.

DRM_Validation_6

To summarize, DRM provides mechanisms for configuring validations unique to an organization. The validations can be configured to prevent the creation of invalid data — a feature that enhances any organization’s governance process!

About the Author

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up
Categories