oracle hyperion data relationship management administration

By attending Oracle Hyperion Data Relationship Management Administration Workshop, Participants will learn to:

  • Manage versions, hierarchies, and nodes
  • Define properties for applications
  • Import data into applications
  • Query and compare application data
  • Describe Data Relationship Management
  • Create Data Relationship Management applications
  • Update application data with action scripts
  • Blend versions in applications
  • Create formulas and dynamic scripts for derived properties
  • Create validations for applications
  • Set up node types in applications
  • Export application data
  • Manage security for applications
  • Audit application data
  • Configure Governance Workflows

In Oracle Hyperion Data Relationship Management Administration Training course, Participants are tasked with building a Data Relationship Management application. Participants start by defining an application, and then add versions, hierarchies, and nodes. To support the application data, they create properties both manually and in bulk through the Migration Utility.

Before finalizing a version, Participants clean the data by creating queries and compares. They also update the data with action scripts. Finally, they blend versions to create a final version.

With the application structure completed, they create business rules for the data by creating validations and properties with formulas. They fine-tune the display of properties for nodes by setting up node types. Participants also export the data to a file and to a database table. To complete the implementation, they set up user security, perform audit activities, and archive the application by exporting it with the Migration Utility.

  • Administrators
  • Functional Implementors

COURSE AGENDA

  • Creating Nodes
  • Inserting and Removing Nodes
  • Adding and Deleting Nodes
  • Inactivating and Re-Activating Nodes
  • Copying and Moving Nodes
  • Viewing and Editing Properties
  • Domain Membership for Nodes
  • Implementation Considerations
  • Working with Versions
  • Working with Hierarchies
  • Implementation Considerations
  • Querying and Viewing Transaction History
  • About Data Relationship Management
  • Data Relationship Management Architecture
  • Implementation Process for Data Relationship Management Applications
  • Audiences for Data Relationship Management
  • Connecting to Applications with Web Client
  • Navigating Web Client
  • About Custom Properties
  • Configuring Defined Properties
  • Configuring List Values
  • Configuring Lookup Values
  • Configuring Inheriting Properties
  • Assigning Controlling Hierarchies to Global Inheriting Properties
  • Creating Property Categories
  • Loading Metadata with the Migration Utility
  • About Importing Data
  • About Import Files
  • Opening, Copying, and Deleting Imports
  • Creating Imports
  • Running Imports
  • Searching for Nodes
  • Viewing Orphan Nodes
  • Creating Queries
  • Creating Compares
  • Working with Query and Compare Results
  • About Action Scripts
  • Creating Flat Files for Action Scripts
  • Loading Action Scripts from Flat File
  • Running Action Scripts and Reviewing Results
  • Downloading Action Script Results
  • Modeling Nodes by Using Action Scripts
  • Creating Blenders
  • Running Blenders
  • About Blending Versions
  • Opening, Copying, and Deleting Blenders
  • About Formulas for Derived Properties
  • Formula Syntax
  • Creating Derived Properties by Using Formulas
  • Testing Formulas
  • Creating Derived Properties by Using Dynamic Scripts
  • About Validations
  • Creating Validations
  • Assigning Validations to Versions, Hierarchies, and Nodes
  • Running Batch Validations
  • Attaching Batch Validation to Exports
  • Working with Batch Validation Results
  • Editing and Deleting Validations
  • About Node Types
  • Process for Setting Up Node Types
  • Creating, Editing, and Deleting Glyphs
  • Creating, Editing, and Deleting Node Types
  • Assigning Node Types to Node
  • Configuring Hierarchy Node Type Property Values
  • Troubleshooting Node Type Assignments
  • About Data Relationship Governance
  • Working with Requests
  • Navigating the Worklist
  • Managing Workflow Tasks
  • Managing Workflow Models
  • Integrating External Workflow Applications
  • About Exporting Data
  • About Export Types
  • Opening, Copying, and Deleting Exports
  • Creating Exports
  • Running Exports
  • Creating and Running Export Books
  • Security Levels
  • Creating and Managing Users
  • Assigning Access to Nodes
  • Assigning Access to Metadata Objects
  • Assigning Access to Property Categories
  • Granting Anonymous Access
  • Analyzing Data Changes
  • Archiving Metadata Changes