Improved FDMEE
Improved FDMEE
Improved FDMEE
Mike Casey
Director, Product Management
2
Safe Harbor
THE INFORMATION CONTAINED IN THIS DOCUMENT IS FOR INFORMATIONAL
SHARING PURPOSES ONLY. IT IS NOT A COMMITMENT TO DELIVER ANY
MATERIAL, CODE, OR FUNCTIONALITY, AND SHOULD NOT BE RELIED UPON IN
MAKING PURCHASING DECISIONS. THE DEVELOPMENT, RELEASE, AND TIMING
OF ANY FEATURES OR FUNCTIONALITY DESCRIBED IN THIS DOCUMENT REMAINS
AT THE SOLE DISCRETION OF ORACLE.
THIS DOCUMENT IN ANY FORM, SOFTWARE OR PRINTED MATTER, CONTAINS
PROPRIETARY INFORMATION THAT IS THE EXCLUSIVE PROPERTY OF
ORACLE. YOUR ACCESS TO AND USE OF THIS CONFIDENTIAL MATERIAL IS
SUBJECT TO THE TERMS AND CONDITIONS OF YOUR ORACLE SOFTWARE
LICENSE AND SERVICE AGREEMENT, WHICH HAS BEEN EXECUTED AND WITH
WHICH YOU AGREE TO COMPLY. THIS DOCUMENT AND INFORMATION
CONTAINED HEREIN MAY NOT BE DISCLOSED, COPIED, REPRODUCED OR
DISTRIBUTED TO ANYONE OUTSIDE ORACLE WITHOUT PRIOR WRITTEN
CONSENT OF ORACLE. THIS DOCUMENT IS NOT PART OF YOUR LICENSE
AGREEMENT NOR CAN IT BE INCORPORATED INTO ANY CONTRACTUAL
AGREEMENT WITH ORACLE OR ITS SUBSIDIARIES OR AFFILIATES.
3
Agenda
Overview
Integration Strategy
Best Practices
Q&A
FDMEE Overview
Write-back capability
FDM helps finance users increase their confidence in the numbers and lowers their cost of compliance by eliminating data integrity
risks associated with collecting, mapping, validating, and moving critical financial data from across the enterprise.
Financial restatements
Repeatable Processes
Single standard and
defined solution for any
target application
Standard upward data
certification process
Standardized database
schema
FDM
Internal Controls
Write-back Capability
Write-back to Source System
Synch ERP and EPM Systems
archival
Prepackaged audit and
internal control reports
Comprehensive role based
security
Metadata
Financial Close
Planning &
Forecasting
Data Warehouse
Data Mart
Web Interface
Financial Reports
Other
Systems
Data
File
Excel
XML
Strategy Management
Microsoft Office
Profitability
Management
Drill-Through & Write-Back
FDM Benefits
Confidence in the numbers FDM provides robust audit trails
from source systems to target and back, with robust validation
capabilities, providing transparency into the numbers
Decrease cost of compliance FDM with its internal control
checks over the process ensure adherence to company policies
and procedures, enhancing controls while lowering costs
Speed and agility Improve the EPM cycle by days with a
Finance owned and maintained application that is quick to
implement and supports a simple, easy to follow, repeatable
process
10
Integration Strategy
11
FDM Adapters
12
ODI
Native
FDMEE
Requires Coding
Connect to ERP
Requires Coding
Drill-through / Write-Back
Audit Trails
Process driven
13
Data Sync
Requires Coding
Complex Mapping
Requires Coding
11.1.2.4
14
PSFT HCM 9.0, 9.1, 9.2 to Public Sector Planning and Budgeting
15
SAP BW 7.0+
16
17
FDMEE Features
Parity with FDM
Workflow process - Import, Validate,
addition of multi-dimension
Fish icon retained option to
check entity
Condensed menu structure
18
FDMEE Features
HFM adapter parity
All options available in
19
FDMEE Features
Reporting
Implemented with BI
Publisher
FDM Reports ported to
FDMEE
Generate outputs in
20
FDMEE Features
Batch Processing
Scheduler built into
FDMEE
Support for windows.bat
21
Import Scripting
Mapping Scripting
Event Scripting
22
Jython and VB
/data/scripts/custom folder
on FDMEE server
Once created, the user
23
Query
Static
target application
24
execute
System will present
25
details
Multiple scripts may be run
Script execution assigned a scope, event and
sequence
26
Open Batches
Load in multiple files in a
single run
POV determined from
Execution UI
27
include
Define Application
Options
Set up artifacts like any
data to file
28
Workbench
Load journal by selecting
29
Balance Template
Download from Workbench
template
Download from Mapping UI
Template is available in import
dropdown
30
intersections
Generated as part of the
31
existing rows in
TDATASEG
Replace data in
32
to Essbase
File FDMEE will create a file
in loaded directly by Essbase.
SQL In-Memory loading of
data to Essbase
Default is SQL
33
34
workbench
Excel template also supports
multiple periods
35
requirements
Also available for non-
ARM implementations
Enhanced replacement
and substitution
functionality for targets
36
Source
12345-6789-012-3456ABC-001
Target
#FORMAT(???-*-GROUP-AA##?#*X-GROUP,-)
Result: 123-6789-GROUP-AA5ABCX-GROUP
Explanation
Take the first three characters of the first segment, take the
entire second segment, replace the third segment with the
text GROUP, prefix the fourth segment with AA, drop the
third and fourth characters, keep the fifth character, drop
the sixth character, keep ABC and add suffix X, replace
the fifth segment with the text GROUP.
Additional Considerations
37
mapping
SAP BW Metadata Load
38
POV Locking
Check Rule Test
Fix explicit mapping rules from workbench
Review mode for mapping UI
Integration with Strategic Finance
39
40
41
42
Financial Management
Use intersection validation report as
needed
Identifies invalid cells on target
Resource intensive be careful
metadata missing
Planning
Include currency dimension in import
format
Invalid cells will show in FDMEE log
as Essbase errors
43
unmapped
Limit the number of unmapped sources
Use IGNORE rule type as needed
Analyze data in workbench before
loading to ARM
Concatenate source fields for easy mapping
to profile dimension
Use new #FORMAT Mask feature as
needed
Mapping only required for Profile and Source
Type dimensions
44
dimensions
Handle via mapping or with Prefix
to member
Use . between members to define
full path
45
Q&A
46
47