FDMEE- Data Management - 10 Hours

FDMEE- Data Management - 10 Hours

Course Summary

Learn the various approaches for loading source data into Oracle EPM Cloud applications using Data Management. Data Management is available with all Oracle EPM Cloud and NetSuite Planning and Budgeting subscriptions and provides a comprehensive toolset for integrating source data with Cloud applications.

PLEASE NOTE:

  • This training is designed for new EPM Cloud administrators who are not familiar with the ‘on-premises’ FDMEE solution.
  • This course is also appropriate for those using NetSuite Planning and Budgeting 

Learning Objectives

By the end of this course learners will be able to:

  • Identify how to set up source systems and target EPM Cloud / NetSuite Planning and Budgeting applications in Data Management
  • Differentiate between mapping types and how they are used to map source information to the correct target
  • Recognize how to create Import Formats and how they can be used to format data as it is being imported into Data Management
  • Explain how Locations bring together the required information to successfully perform an import from the source and an export to the target application
  • Implement SQL, Multi-Dimensional and Format Mask mappings
  • Differentiate between Simple and Complex Logic accounts and their applications

Course Description

Explore the look, feel and functionality of Data Management for the Oracle EPM Cloud and NetSuite Planning and Budgeting. Find out how to load data and discover how to synchronize data seamlessly across various systems. This course explores the creation and management of mapping tables and examines the process of building import formats to capture source data in a variety of formats. We’ll investigate the available data load options, such as loading data to multiple periods, adding trial balance and journal data and scheduling import jobs, allowing them to be run automatically.

We’ll also look at how to enhance the standard workflow by building in complexity through the use of import format expressions, logic accounts and advanced mapping techniques. This course is ideal for Oracle EPM Cloud administrators who are looking to maximize the potential of their cloud environments.

Performance Evaluation

An Initial evaluation of the performance of the candidate, Identifying the improvement areas, training/ enlightening the gaps, and roll out the final evaluation before the end of the training

Outcome of the Program

You will become an expert Data Mangement conceptually and technically in implementing your functional skills at your work, and driving the process/project more effectively in compliance to the project requirements. In addition, a certificate is awarded after completion of the program.