Skip to main content


Data Relationship Management Versioning (Part 1)

The ability to create different versions of hierarchies within Oracle Data Relationship Management (DRM) is one of the tool’s biggest benefits. The definition of a version is simply the grouping of hierarchies. This simple, yet effective, function allows organizations to create versions for several different types of scenarios:

  • Grouping of hierarchies based on time periods (e.g. Monthly, Quarterly, Yearly)
  • To test/plan hierarchy changes for a future period
  • What-if analysis for reorganizations, restructures, mergers, etc.
  • To compare hierarchies to identify differences/similarities
  • To support integration with downstream systems

The most common use of versioning is to provide historical views of hierarchies, coinciding with the business reporting cycle – usually monthly.

In the example below, we can see two versions. One for March 2017 and one for February 2017. Both contain the same hierarchies, but March contains the most recent version of the hierarchies with changes applied.

Now you may be wondering how easy is it to create the next month’s version, say April 2017 in our example? Well, with a few clicks the process can be completed within minutes!

The time savings comes from the fact that the April version doesn’t have to be created from scratch. We simply copy the March version and rename it.

  1. First, since we are going to use March’s ending point as our starting point for April, we need to prevent any changes being applied to it during our copy procedure.

This is accomplished by modifying the version status from Working to Finalized. (Finalized status prevents any changes from being applied to the hierarchies and properties within the respective version.)

The version status is changed in the Version Properties window. To bring up the properties window, click the Version Properties button.

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

Next, change the Version Status value to Finalized. Click Save.

  1. Right click on March. Select Copy.

  1. Name the new version and enter a description. Click OK.

  1. The new April 2017 version has been created!

Note that the version is not yet saved (i.e. no blue check mark in the Saved column). This means that the version exists only in memory – no data/records have been written to the database. The version is essentially a “sandbox” until it is saved.

  1. Save the version by simply right clicking and selecting Save.

Blue check mark in the Saved column indicates the version has been saved to the database.

Now users can begin applying changes to the April version.

That’s it! Pretty simple right?

Stay tuned for the next post where we take a look at some of the more in-depth aspects of DRM versioning!

Thoughts on “Data Relationship Management Versioning (Part 1)”

Leave a Reply

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

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

Steve Bogner, Project Manager

Steve Bogner is Project Manager with 15+ years experience within Perficient’s Corporate Performance Management practice. He is certified in several technologies including Oracle Data Relationship Management and Oracle Enterprise Data Management. He is constantly striving to ensure successful experiences with CPM technologies for his clients.

More from this Author

Follow Us