Introduction

Introduction • DataFusion Consulting Group • Services • FDM (formerly UpStream WebLink) • History with FDM • Grew with the product • We understand what it does, how it does it and why it was made to do it that way • Products • DataFusion Extractor (Source Adaptor)

Financial Data Quality Management • Loads from disparate GL Systems • Loads to HFM, Essbase, Planning, Enterprise, Strategic Finance (not yet released), and DataMart adaptor. • Powerful mapping engine • Logging, audit trail • End user driven process • Automated “lights out” capabilities. • Scripting capabilities for Custom solutions to fit just about any process.

What is the DataFusion Extractor? • Packaged Source Adapter for FDM to extract data from HFM at any data level. • Extract data from any value dimension member as well as any level of the custom dimension members • The DataFusion Extractor uses the standard FDM import functionality

Features and Benefits • Extract Base and Calculated Data for all members of the HFM hierarchy • Extract all Journal Entries • Extract Data from any member of the Value Dimension • Extract Data based on any Custom Dimension Member • Use FM Entity Lists and/or FM Account Lists to maintain extract parameters • Use Validation Entities and Validation Rules to maintain extract parameters • Use a file to get any combination of derived intersections from HFM

2. DataFusion Adaptor Extracts the data automatically 4. Data Loaded through FDM to Target System 1. HFM Source for Extracting Data 3 Imported into FDM Base and Calculated Data HFM Journals HFM Essbase FDM Planning Any Custom Dimension Member Data Warehouse Any Value Dimension Member

Demo • Entity Currency Total • Entity Currency & Entity Curr Adj • Eliminations • TopC1 • From File

Questions ???

Introduction

Introduction

Presentation Transcript

Introduction to introduction to introduction to … Optimization

INTRODUCTION/ INTRODUCTION

Introduction

INTRODUCTION

Introduction

Introduction