Oracle Hyperion DRM Training

Oracle Data Relationship Management is an enterprise performance management platform. It provides enterprise change management solutions to build and retain consistency within master data assets regardless of any changes required to support primary transactional and analytical systems. This section deals with an overview of Data Relationship Management and concepts related to it.

The following are the task groups in the Data Relationship Management web user interface. This module gives essential knowledge of all the major tasks listed below and also how they are being implemented in data relationship management.

• Key User Experience Differences
• Logon
• Browse
• Query
• Compare
• Script
• Import
• Blend
• Export
• Audit
• Administers

This section will walk you through the fundamentals of creating versions for various types of business scenarios. You’ll also learn how to edit, validate, unload, and delete versions through hands-on practice.

• Data Relationship Management Version Life Cycle
• Version Type and Status
• Creating Versions
• Copying Versions
• Saving Versions
• Creating As-Of Versions
• Editing Version Properties
• Assigning Validations to Versions
• Unloading and Deleting Versions

This module will help you understand how to create hierarchies, edit hierarchy properties, enable and disable node types, assign hierarchies to the hierarchy groups, assign validations, and delete hierarchies.

• Creating Hierarchies
• Editing Hierarchy Properties Databases
• Enabling and Disabling Node Types
• Opening Hierarchies
• Creating Hierarchy Groups
• Assigning Hierarchies to Hierarchy Groups
• Assigning Controlled Properties
• Assigning Controlled Node Access Groups
• Assigning Validations
• Deleting Hierarchies

This section covers the fundamental concepts of how to add and insert nodes. Also, you’ll learn about node deletion methods, orphan nodes, node security, and much more in this section.

• About Nodes and Adding and Inserting Nodes
• ID Function, Modeling a Node and Moving and Ordering Nodes
• Relaxed Move Option, Sorting Nodes and Node Deletion Methods
• Merging Nodes, Deleting Nodes and Removing Nodes
• Annulling Nodes and Inactivating Nodes
• Reactivating Nodes and Assigning Validations
• Orphan Nodes and Viewing Orphan Nodes
• Deleting Orphan Nodes and Navigating in Tree View
• Finding Nodes and Node Security
• Using Shared Nodes and Enabling Shared Nodes
• Shared Node Properties
• Adding and Inserting Shared Nodes and Removing and Deleting Shared Nodes
• Renaming Shared Nodes
• Converting a Shared Node to a Primary Node
• Displaying Shared Nodes

This section highlights the key fundamentals of managing properties. You’ll comprehend default property categories, system properties and statistical properties that are displayed at the node level, the scope of the property, the origin of the property, property statuses, and also editing property values.

• Property Categories
• System Properties
• Stats Properties
• Property Value Scope and Origin
• Property Status
• Editing Property Values

In this section, you’ll go through the detailed process of how to validate versions, hierarchies, and nodes. You’ll also learn to navigate the node results in both list and tree view, download the node results, and clear the validation results.

• Validating Versions
• Validating Hierarchies
• Validating Nodes
• Navigating Validation Results
• Navigating Version and Hierarchy Results in List View
• Navigating Node Results in List View
• Navigating Node Results in Tree View
• Downloading Node Results
• Clearing Validation Results

This section will help you understand how to create queries, navigate query results, and manage queries.

• Query Types
• Creating Queries
• Navigating Query Results
• Navigating in List View
• Navigating in Tree View
• Downloading Query Results
• Managing Queries
• Opening Queries
• Copying Queries
• Deleting Queries

Hierarchies can be compared in the same version or across two different versions. In the section of comparing hierarchies, you’ll learn about comparison types and understand how to create compares and manage them.

• Compare Types
• Visual Compare
• Structure Compare
• Property Compare
• Rename Compare
• Creating Compares
• Navigating Compare Results
• Navigating in List View
• Navigating in Tree View
• Downloading Compare Results
• Managing Compares
• Opening Compares
• Copying Compares
• Deleting Compares

Action scripts are very useful while executing the same set of actions for multiple hierarchies, versions, or nodes. It allows processing bulk set of incremental changes in an automated fashion. In this section, you’ll understand how to load action scripts from flat files, transactions log, and a node model.

• Loading Action Scripts From Flat Files
• Downloading Action Script Results
• Required Action Script Parameters
• Loading Action Scripts From a Transaction Log
• Loading Action Scripts From a Node Model