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

This section gives comprehensive knowledge of all the import sections that are present in Hyperion DRM. You’ll gain hands-on experience in creating, running, copying, and running imports. 

• Import Sections
• Creating Imports
• Running
• Copying and Deleting Imports

This module presents an explicit knowledge of all the export types that are present in data relationship management. Also, you’ll be taught how to create these export types.

• Creating Exports
• Creating Hierarchy Exports
• Creating Hierarchy XML Exports
• Creating Generation Exports
• Creating Compare Exports
• Creating Difference Exports
• Creating Version Exports
• Creating Property List Exports
• Creating Property Lookup Exports
• Creating Transaction Log Exports
• Creating Merge Log Exports
• Creating Export Books
• Running, Copying & Deleting Exports and Export Books

In this module, you’ll learn how to create change requests to add and delete hierarchies, add and delete nodes, insert and move nodes, update properties, and remove property values. This module also covers the various elements included in the change requests such as customer workflow ID, customer workflow status, approved flag, and much more.

This module explains how to use audit tasks to query and view transaction history. Also, you’ll comprehend various action types and administrative actions that are logged in the transaction history.

• Auditing Transaction History
• Data Actions in Transaction History
• Administrative Actions in Transaction History
• Auditing Requests

This section gives complete knowledge of how to access the various Data Relationship Management operations in batch mode including action script, import, blender, export, opening and closing versions using Data Relationship Management Batch Client.

• Securing the Batch Client
• Setting up Batch Client Credentials
• Running the Batch Client
• Dependencies
• Saving Versions in the Batch Client
• Command Line Syntax
• Configuration File Syntax
• Outputs and Result Codes

Mindmajix offers advanced Oracle Hyperion DRM Training interview questions and answers that help you prepare for job interviews.