Although Oracle Hyperion DRM has the ability to track Master Data changes as transaction history, however let say you want to be able to export a hierarchy and most likely you want to be able to show who created the member and when; or who updated the member last and when, there’s a way to do this.
The first thing you need to do is to create a new global property to store who created the master data member. Depending on your tracking needs you can create a new property for the following:
- Created by User ID – string global property
- Created on Date – string global property
- Updated by User ID – string global property
- Updated on Date – string global property
- Node Changed Flag – string global property
…
The second step is that Oracle Hyperion DRM has a number of system preferences that will need to point to these properties. They include:
- AddedByProperty
- AddedOnProperty
- ChangedByProperty
- ChangedOnProperty
- NodeChangedProperty
When you update each of the system preferences, you’ll be asked to restart the DRM engine. However, you don’t have to change this until all the properties have been changed. Also, you and pick and choose the system preference to change (i.e. you won’t have to use it all).
Once this is done, you can open the property window for each node and locate the property that you have created. For existing node, you’ll probably see an empty cell. However, if you create any new nodes, the system will automatically populate who and when created or updated the node.
That’s it!
- Tracking Changes – Revisited
- I found a bug!
- Tracking Changes – Part II
- Random Q&A
- Introduction to building a financial hierarchy in DRM – Part 2
- New Features on Oracle® Hyperion Data Relationship Management, Fusion Edition 11.1.1
- Building Hierarchies with Automator
- Automate a Parent-Child hierarchy build – Part 3
- Documenting All Your Properties and DRM Formulas in Seconds
- How to Solve Hyperion DRM Startup Problem
