3 arrows

Get a Free AWS Exam retake using promo code DOUBLESHOT

closeClose

Hyperion Financial Data Quality Management EE Administration

  • Tuition USD $4,000
  • Reviews star_rate star_rate star_rate star_rate star_half 4731 Ratings
  • Course Code D103531GC20
  • Duration 4 days
  • Available Formats Classroom, Virtual

This Oracle Hyperion Financial Data Quality Management training teaches you how to implement Oracle Hyperion Financial Data Quality Management, Enterprise Edition (FDMEE)in version 11.1.2.4. Learn a single, systematic process for loading source metadata and data from disparate systems into target analytical applications. Learning activities provide hands-on process for application administrators, configurators, and implementers.

Oracle Hyperion Financial Data Quality Management, Enterprise Edition is the key application for integrating Enterprise Resource Planning (ERP) systems with Oracle's Hyperion EPM applications, and is accessed through Oracle Hyperion Enterprise Performance Management Workspace. Using these advanced metadata and data transformation management solutions, you will explore a single, systematic process for loading source metadata and data from disparate systems into target analytical applications such as Hyperion Financial Management and Planning.

Skills Gained

  • Create member mappings
  • Define data load rules and load data to target systems
  • Create check rules and check entities
  • Set up security
  • Create scripts
  • Describe FDMEE integration with other source systems
  • Use Lifecycle Management to migrate artifacts
  • Process batches and manage reports
  • Define system, application, and user profiles
  • Perform integration tasks
  • Create import formats for file systems
  • Set up locations, period mappings, and category mappings

Who Can Benefit

  • Administrator
  • Analyst
  • Developer
  • Implementer
  • Systems Administrator

Course Details

Topics

  • Product Orientation
  • Preparing FDMEE Integrations
  • Setting Up Import Formats for File Systems
  • Completing the Integration Setup
  • Setting Up Data Load Mappings
  • Defining and Executing Data Load Rules
  • Processing Data in Data Load Workbench
  • Setting Up Check Rules and Check Entities
  • Processing Batches
  • Reporting in FDMEE
  • Setting Up Security
  • Defining Import Scripts
  • Defining Mapping and Event Scripts
  • FDMEE Integration with Other Source Systems
  • Loading FDMEE Journals
  • Creating Logic Accounts
  • Enabling Cell Text Loading
  • Performing Migrations with Lifecycle Management
  • Processing Planning Data in Data Load Workbench
  • FDMEE Overview
  • Key Benefits and Features of FDMEE
  • FDMEE Integration Process
  • Processing Data Overview
  • Accessing and Navigating in FDMEE

Preparing FDMEE Integrations

  • Set up the application root folder
  • Define profiles
  • Set up source systems
  • Register target applications and define application options
  • Register custom applications

Setting Up Import Formats for File Systems

  • Create import formats
  • Describe import format mappings
  • Build file-based mappings
  • Add import expressions

Completing the Integration Setup

  • Add locations
  • Set location details
  • Define period mappings
  • Define category mappings
  • Set up the POV

Setting Up Data Load Mappings

  • Describe mapping types
  • Define member mappings
  • Import and export member mappings
  • Explain processing order
  • Delete, restore, and share member mappings

Defining and Executing Data Load Rules

  • Explain data load rules
  • Define data load rules for file-based source systems
  • Execute data load rules
  • Check the status of data load rules
  • View imported data
  • Schedule data load rules
  • Delete data load rules

Processing Data in Data Load Workbench

  • Import source files
  • Validate member mappings
  • Manage data
  • Load data to target applications
  • Drill through to FDMEE from target applications

Setting Up Check Rules and Check Entities

  • Create check rule groups and check rules
  • Create check entity groups and check entities
  • Assign check rule groups and check entity groups to locations
  • Verify check rules
  • Verify consolidations

Processing Batches

  • Describe batch processing
  • Create batch definitions
  • Schedule batches
  • Execute batches
  • Set up and schedule open batches
  • Execute batch scripts

Reporting in FDMEE

  • Run reports
  • Review and add query definitions
  • View and add report definitions

Setting Up Security

  • Describe FDMEE security
  • Define role security
  • Define batch and report security
  • Set up location security
  • Set up security in Shared Services

Defining Import Scripts

  • Scripting in FDMEE Overview
  • Jython Basics
  • Accessing Script Editor
  • Creating Import Scripts
  • Assigning Import Scripts to Import Formats
  • Applying Import Script Functions
  • Using Temporary Variables in Import Scripts

Defining Mapping and Event Scripts

  • Mapping Scripts Overview
  • Jython and SQL Objects in Mapping Scripts
  • Setting Up Mapping Scripts
  • Event Scripts Overview
  • Creating Event Scripts
  • Changing Import Formats Dynamically
  • Using the File System Object in Event Scripts

FDMEE Integration with Other Source Systems

  • Describe the GL integration in FDMEE
  • Register ERP source systems
  • Create import formats
  • Define mappings
  • Define data load rules for source systems
  • Load source data with the open interface adapter

Loading FDMEE Journals

  • Create journal templates
  • Add metadata tags
  • Enable journal entry loads
  • Check in and post journals

Creating Logic Accounts

  • Describe logic accounts
  • Create logic groups
  • Create simple logic accounts
  • Create complex logic accounts
  • Assign logic groups to locations

Enabling Cell Text Loading

  • Enable cell text loading
  • Create cell documents
  • Upload cell documents
  • Create cell text
  • Load cell documents and cell text to target application
  • Verify cell documents and cell text on target application

Performing Migrations with Lifecycle Management

  • Describe Lifecycle Management
  • Identify the artifacts that you can migrate for FDMEE
  • View and search for artifacts
  • Explain the application and artifact migration process
  • Select the appropriate migration scenario for your environment
  • Access and view migration status reports
  • Enable and view audit reports

Processing Planning Data in Data Load Workbench

  • Register a Planning target application, define application options, settings, import formats, locations, etc.
  • Migrate Planning FDMEE artifacts into FDMEE using Shared Services/LCM
  • Use Planning artifacts to load Planning data using the Workbench
  • Verify data loads in Planning using a data form and drill through

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

What does vendor-authorized training mean?

As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.

Is the training too basic, or will you go deep into technology?

It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.

How up-to-date are your courses and support materials?

We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.

Are your instructors seasoned trainers who have deep knowledge of the training topic?

ExitCertified instructors have an average of 27 years of practical IT experience. They have also served as consultants for an average of 15 years. To stay up to date, instructors will at least spend 25 percent of their time learning new emerging technologies and courses.

Do you provide hands-on training and exercises in an actual lab environment?

Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.

Will you customize the training for our company’s specific needs and goals?

We will work with you to identify training needs and areas of growth.  We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.

How do I get started with certification?

Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact Edu_customerexperience@techdata.com

Will I get access to content after I complete a course?

You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.

Labs and the study materials provided for Architecting on AWS course are very easy to understand and explains all the topics required to pass the Associate certification.

Great and very intuitive. Better than the traditional hit the wrong button/lose points.

Although there seemed to be too many links for the course, everything worked smoothly.

They were very good. They made sure everyone was able to get into the training and got all of the material needed for class.

Simply great training provider that I can go for updating/acquiring my skill sets.

1 options available

undo
  • Mar 14, 2022 Mar 17, 2022 (4 days)
    Location
    iMVP
    Language
    English
    Time
    9:00AM 5:00PM EDT
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward