FDMEE: Administrator (3 days)

Audience

Financial and Technical System Administrators​

Learning Objectives

Learn the various approaches for loading source data into analytical applications using FDMEE. As a system administrator you'll need to understand how to integrate FDMEE with numerous source and target systems.  You’ll need to define mapping tables and import formats, define validation reports and work with locations and load rules to load data. Students will also learn to define user and object security.

Course Description

Explore the look, feel and functionality of FDMEE. Find out how to load data to HFM, Planning and Essbase and discover how to synchronise data seamlessly across these products. You’ll be taught how to create and maintain mapping tables and mapping scripts and build import formats to define ledger output files. You will work with Life Cycle Management and see how to back up or migrate your application. You will gain an understanding of the Excel Interface and  explore the underlying FDMEE relational database. This course also includes a brief introduction to the Jython scripting language used by FDMEE, although a more detailed scripting course is also available.

Course Information

Audience: Financial and technical system administrators

Duration: 3 days

Pre-requisites: None

Delivery method: 

• On Demand self-paced training via our Keyteach partnership (click here for details)

• Classroom: Public - Live Online (check current schedule)

• Classroom: Private - Live Onsite or Live Online (contact us to schedule a private class)

Advanced preparation: None

Recommended CPE credits: 21 credits 

Day Summary

Day 1: FDMEE process overview, sources & targets, category & period mapping, import formats, locations & load rules, mapping tables, importing & validating source files, functions & expressions, multi-period loads

Day 2: Check rule groups, simple & complex logic accounts, journals, batches, report definitions, security, lifecycle management, creating import scripts using Jython, what’s new in 11.1.2.4.

Day 3: Data synchronisation, using the Excel interface, protection settings for HFM, mapping scripts, metadata and writeback overview, configuring ODI, understanding the FDMEE database, FDM to FDMEE migration notes, case study.

Detailed Agenda

Introduction

• Process overview

Initial Setup

• Edit system settings

• Creating source & targets

• Integration settings

• Global application & source mapping

Category & Period Mapping

Import Formats

• Creating import formats

• Adding functions and expressions

• Locations & load rules

• Creating locations

• Creating load rules

• Point of View

Mapping Tables

• Excel templates

• Map loader

• Importing mappings

Loading Test Data

Multi-Period Loads

Check Rules

• Check rule groups

• Check entity groups

Logic Accounts

• Creating simple logic accounts

• Creating complex logic accounts

Journals

• Journal templates

• Intersections

Trial Balances

• Loading trial balance databatches

• Creating batches

• Executing batches

FDMEE Reports

• Report definition

Security

• Shared services Setup

• Security roles

• Location access

Excel Interface

• Download & upload

• Working with tables

• Understanding relational tables

Lifecycle Management

What’s New in 11.1.2.4

​​​

Data Synchronization

• HFM to HFM

• HFM to Essbase

• Planning to HFM

Integration

• Metadata

• Write back

• DRM & FDMEE

​​

Application Options

• Source & target

• Protection settngs for HFM

• Essbase settings

• Planning settings

Scripting

• Jython overview

• Methods

• Creating import scripts

• Mapping scripts

Register

This course is offered through our strategic partnership with Keyteach, using state-of-the-art technology and a live Cloud environment for hands-on labs. Contact us to schedule a private class, or view the public class schedule.

​

​

Also available as

ON DEMAND

self-paced training via our Keyteach partnership.

Click here for details.