Course Description

Prepare to pass exam: Oracle Hyperion Data Relationship Management Essentials

The Oracle Hyperion Data Relationship Management Specialization is for individuals focused on selling and implementing a Master Data Management software solution to build consistency within master data assets despite endless changes within the underlying transactional and analytical systems. The certification will cover such topics as: creating applications, working with hierarchies and nodes, defining properties, querying and comparing data, blending versions, formulas for derived properties and managing security. This certification is available to all candidates but is geared toward members of the Oracle PartnerNetwork. OPN members earning this certification will be recognized as OPN Certified Specialists. This certification helps the OPN member's company qualify for the Oracle Master Data Management Specialization.

Get ready to excel in the Oracle Hyperion Data Relationship Management Essentials exam! Equip yourself with comprehensive study materials and practical experience to master key concepts and functionalities. With the right preparation, you'll gain the knowledge and confidence needed to pass the exam and enhance your career prospects in data management.

Dive deep into the intricacies of Oracle Hyperion Data Relationship Management Essentials with targeted study strategies. Utilize real-world scenarios and hands-on practice to solidify your understanding of data governance and management. Prepare effectively to not only pass the exam but also apply your skills in real-world situations, making you a valuable asset to any organization.

Exam topics covered

Implementation Scope and Risks

• Describe best practices for project scoping and establishing implementation timelines
  
• Describe common implementation risks
• Describe phasing implementations
• Describe implementation roles and responsibilities
• Evaluate common customer Issues
• Evaluate common customer strengths
• Describe testing and rollout best practices

DRM Overview

• Describe DRM key features
  
• Manage versions
• Manage hierarchies
• Manage nodes
• Use Property Queries
• Manage Exports / Reports
• Use Audit Data
• Describe user roles and responsibilities
• Describe the DRM Architecture

Managing the Initial Data Load

• Perform structural reconciliation
  
• Manage naming collisions
• Manage duplicate nodes

Managing Properties and Property Categories

• Manage properties from upstream and downstream systems
  
• Manage similar properties
• Manage property defaults
• Manage calculated properties (derived, inherited, lookup)
• Manage property scoping
• Manage node types
• Manage property categories
• Define and load properties and structure

Alternate Hierarchies

• Define and build alternate hierarchies
  
• Support differences or force consistency
• Build alternate hierarchies from attributes and an export

Mappings

• Manage basic one to one or one to many mappings using properties
  
• Manage basic one to one or one to many mappings using hierarchies
• Manage complex many to many mappings

Managing Data Feeds

• Identify upstream and downstream systems
  
• Identify and analyze interfaces used
• Describe timing of feeds
• Describe file format and restrictions
• Describe Imports, Action Scripts, Blender, and Exports
• Manage upstream data feed(s) and reconciliation
• Manage downstream data feed(s) and reconciliation
• Include skipping and padding levels in balance or recursive hierarchy feeds  
• Manage multiple downstream systems of the same type
• Generate mapping tables for ETL processes for downstream systems
• Implement automated data feed(s)

Versioning

• Manage version composition
  
• Manage version timings
• Manage usage of version status
• Manage synch methodology for what/if and planning versions

Business Rules

• Manage business rules for downstream systems
  
• Manage business rules for client processes
• Manage business rules to address system issues

Users

• Manage users and assign roles
  
• Manage node access groups and property categories
• Manage node access for users
• Setup anonymous access

Workflow

• Evaluate if workflow is needed and determine workflow requirements
  
• Integrate workflow through the request API

API Integration

• Evaluate API integration requirements
  
• Integrate through the public API