Oracle DRM Administrator (4 days)
Audience
System administrators
Learning Objectives
Learn how to administer Oracle DRM to manage changes in enterprise master data across information silos.
Course Description
Oracle Data Relationship Management (DRM) enables organisations to synchronise master data across Enterprise Performance Management applications including BI platforms, financial and analytic applications, and transaction systems. This product was formerly known as Hyperion Master Data Management (MDM).
This 4 day course for System Administrators and Oracle Developers provides a thorough grounding in the architecture and functionality of the DRM software. The course also covers the creation of the tasks, workflows and roles associated with Data Relationship Governance (DRG) that aid the streamlining of the business user experience.
We'll also compare the differences between standard DRM scripting and JavaScript (that provides more flexibility and better performance in terms of the validations that enforce business logic) and your corresponding control of enterprise-wide master data.
Course Information
Audience: System administrators, Oracle developers and consultants
Duration: 4 days
Pre-requisites: None
Delivery method:
-
Classroom: Public - Live Online (check current schedule)
-
Classroom: Private - In Person or Live Online (contact us to schedule)
Advanced preparation: None
CPE credits: 28 credits
Day Summary
Day 1: DRM concepts and navigation. Application, version, hierarchy and property creation, formulas
Day 2: Exporting application elements, node types, validations, importing and blending hierarchies, scripts, importing application elements and the batch client
Day 3:Exporting to flat files and SQL tables, comparing application element exports, mappings management
Day 4:Exporting to EPMA, security and transaction log, Data Relationship Governance (DRG) tasks, workflows and roles
Detailed Agenda
Overview
• DRM in business contexts
• The DRM and EPMA relationship
• DRM navigation
• Searching for nodes
• Comparing hierarchies
• Working with versions
• System preferences
Application Building
• Creating DRM applications
• Creating versions
• Creating hierarchies
• Hierarchy groups
• Properties
• Inheritance
• Property categories
• Data types and property types
• Custom sort orders
Deriving Property Values
• Formulas
• Version variables
• Hierarchy structures in formulas
• Testing derived property values
Node Types
• The HierarchyNodeType property
• Creatong and configuring node types
• Glyphs
Validations
• Real time vs. batch validation
• Creating and assigning validations
• Running validations
• Using the CustPropQuery Validation
Javascript
• Derived properties using Javascript
• Creating validations using Javascript
• Deriving mapping properties using Javascript
The Migration Utility
• Exporting DRM properties
• Importing DRM properties
• Comparing exported XML Files
Importing Master Data
• Importing master data to a newVersion
• Blending versions
• Setting hierarchy and top node properties
• Using scripts to add nodes
• Updating master data using scripts
Exporting Master Data
• Exporting to a flat file
• Exporting to SQL database tables
• Exporting hierarchies to EPMA
The Batch Client
• Automating tasks
• Automating imports and blends
Managing Mappings
• Managing mappings within DRM
• Restricting node choices
Security
• Managing security
• Creating users and node access groups
• Assigning nodes to node access groups
• Testing security
Auditing the Application
• Auditing master data
• Transaction history
• Using as-of versions
Data Relationship Governance (DRG)
• Tasks
• Workflows
• Roles
Case Study
Register
This course is offered through our strategic partnership with Keyteach, using state-of-the-art technology and a live environment for hands-on labs. Contact us to schedule a private class, or view the public class schedule.
