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.

Course content

Task Group Descriptions

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

Managing Versions

• 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

Product Orientation

• Product Orientation
• Starting Services
• Browsing Web Client

Working with Versions and Hierarchies

• Working with Versions and Hierarchies
• Creating the Accessories Version and Hierarchies

 Working with Nodes

• Working with Nodes
• Adding Nodes to Hierarchies in the Accessories Version

Defining Properties

• Defining Properties Part 1
• Defining Properties Part 2
• Creating the Location Property Category
• Creating the StateProvince Property
• Creating the Country Property
• Creating the RegionalMgr Property
• Creating the DefaultCurrency Property
• Creating the LocalOffice Property
• Importing Properties with the Migration Utility

Importing Data

• Importing Data
• Importing Nodes into a New Version
• Import Sections
• Creating Imports
• Running
• Copying and Deleting Imports

Querying and Comparing Data 

• Querying and Comparing Data Part 1
• Querying and Comparing Data Part 2
• Finding and Removing Duplicate Nodes
• Listing and Resolving Orphan Nodes
• Finding and Deleting Stranded Parents
• Resolving Nodes with Name Conflicts

Updating Data with Action Scripts

• Updating Data with Action Scripts
• Making Data Changes in a Copy of the Accessories Version
• Applying Data Changes to the Accessories Version

Blending Versions

• Blending Versions
• Blending the Accessories and HardwareSoftware Versions

Creating Derived Properties 

• Creating Derived Properties Part 1
• Creating Derived Properties Part 2
• Creating the AllowAdj Property
• Creating the DefaultParent Property
• Creating the EntitySize Property

Validating Data 

• Validating Data
• Creating a Name Length Validation
• Creating the DynamicCalcLeaf Validation Based on a Validation Script

Using 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

Setting Up Node Types 

• Setting Up Node Types
• Setting Up Node Types Based on Dimension Types
• Creating a Note Type for the Geography Hierarchy

Exporting Data

• 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

Working With Change Requests

Managing Security

• Managing Security
• Creating Users and Node Access Groups
• Assigning Nodes to Node Access Groups
• Assigning Nodes to Node Access Groups

Configuring Governance Workflows 

• Configuring Governance Workflows
• Building the Product Maintenance Workflow Model
• Creating and Approving a New Product Request

Analyzing Data Changes 

• Analyzing Data Changes
• Identifying Changes to the Member Formula Property

To see the full course content Download now