Oracle Hyperion Data Relationship Management 11.1.2 Administration

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

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

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

Learn To:

• Describe Data Relationship Management concepts, terminology, and architecture
• Create Data Relationship Management applications
• Manage enterprise data and security in Data Relationship Management
• Explain best practices for implementing Data Relationship Management

Audience

• Functional Implementer
• Administrator
• End Users

Course Topics Product Orientation

• Oracle's Enterprise Performance Management System
• About Data Relationship Management
• Data Relationship Management Architecture
• Implementation Process for Data Relationship Management Applications
• Audiences for Data Relationship Management

Creating Applications

• Starting Data Relationship Management Console
• Configuring New Applications
• Connecting to Applications with Web Client
• Navigating Web Client

Working with Versions, Hierarchies, and Nodes

• Working with Versions
• Working with Hierarchies
• Working with Nodes
• Viewing and Editing Properties
• Implementation Considerations

Defining Properties

• 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

Importing Data into Applications

• About Importing Data
• About Import Files
• Opening, Copying, and Deleting Imports
• Creating Imports
• Running Imports

Querying and Comparing Data

• Searching for Nodes
• Viewing Orphan Nodes
• Creating Queries
• Creating Compares
• Working with Query and Compare Results

Updating Data with Action Scripts

• About Action Scripts
• Creating Flat Files for Action Scripts
• Loading Action Scripts from Flat Files
• Running Action Scripts and Reviewing Results
• Downloading Action Script Results
• Modeling Nodes by Using Action Scripts

Blending Versions

• About Blending Versions
• Opening, Copying, and Deleting Blenders
• Creating Blenders
• Running Blenders

Creating Formulas for Derived Properties

• About Formulas for Derived Properties
• Formula Syntax
• Creating Derived Properties
• Testing Formulas

Validating Data

• About Validations
• Creating Validations
• Assigning Validations to Versions, Hierarchies, and Nodes
• Running Batch Validations
• Working with Batch Validation Results
• Editing and Deleting Validations

Setting Up Node Types

• 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

Exporting Data

• About Exporting Data
• About Export Types
• Opening, Copying, and Deleting Exports
• Creating Exports
• Running Exports
• Creating and Running Export Books

Managing Security

• Security Levels
• Creating and Managing Users
• Assigning Access to Nodes
• Assigning Access to Property Categories
• Setting System Preferences for Security
• Granting Anonymous Access

Auditing Data

• About Auditing Data
• Querying and Viewing Transaction History
• Querying and Viewing Request History
• Analyzing Data Changes
• Archiving Metadata Changes

Course Objectives

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