"converting" fdm to fdmee
TRANSCRIPT
![Page 1: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/1.jpg)
Getting the Most out of EPM
Converting FDM to FDMEE
September 18, 2015
Scott Peters ([email protected])
![Page 2: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/2.jpg)
• Founded in 2002
• 75+ employees in 20+ states• Mostly CPAs, MBAs
• We have extensive Hyperion product and financial reporting backgrounds
• 50+ Planning / Essbase Clients
• 80+ HFM Clients• Managed several of the largest EPM projects in the U.S.
• Including the largest roll-out of HFM in North America
• Market Leader in ARM/FCM
• World Leader in FDM implementations and custom solutions
Finit Overview
![Page 3: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/3.jpg)
EPM Services
• Finit Answers‒ Technical Support‒ Functional / Admin
Support‒ Access to Hyperion
SMEs‒ Dedicated support
team and guaranteed response times
‒ Customer Service Focus
‒ Flexible Time and Material support packages
‒ ‘Pay as you Go’ option
• Hyperion Planning & Essbase
• Oracle Financial Close Suite
• Infrastructure• Data Services• Project / Program
Management• Redesign /
Enhancements
• Product Upgrades• Application enhancements /
redesign• Performance optimization
Dedicated Support
Upgrades
Full Cycle Implementations
![Page 4: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/4.jpg)
• We make and deliver personalized financial reporting solutions and experiences. • By listening, questioning, and analyzing
• By building relationships … not company to company, but person to person.
• We are Makers and Doers
Why is Finit Here?
![Page 5: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/5.jpg)
We Run Finit like a Family
• Invest in our employees
• All owners actively involved in the business
• No debt or external owners • Prioritize the customer, not
profitability
• Long term stability• Hire employees, not subcontractors
• Compensation model based on client satisfaction
How do we achieve our beliefs?
![Page 6: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/6.jpg)
• Our values, on which we ask you to provide consultant feedback:
Finit Values
![Page 7: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/7.jpg)
• Our values, culture, and approach to becoming a trusted advisor to customers has led to 100% customer success for every Finit client (225+) and for every Oracle Hyperion project (450+)
Finit Customer Success
![Page 8: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/8.jpg)
Some Finit Customers
![Page 9: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/9.jpg)
Questions
![Page 10: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/10.jpg)
Scott Peters [email protected]
• Partner and Director of Integration Services
• 10 years Hyperion Experience
• FDM, FDMEE, ODI, ERPi, HFM, Essbase, Enterprise
• Designed and implemented some of the most complex FDM integrations in the world (HFM, HE, Essbase/Planning and Data Warehouses)
About the Presenter
![Page 11: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/11.jpg)
• What will the utility convert
• What won’t the utility convert
• Prerequisites of the conversion
• Performing the conversion
• Post conversion steps
• FDMEE Nuances
• Intro to Jython
Agenda
![Page 12: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/12.jpg)
Conversion Utility Overview
![Page 13: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/13.jpg)
• Create the Integration with the Target
• Periods and Categories (Global and Application)
• Locations
• Import Formats (.uss scripts will be tagged)
• Validation Entities and Validation Rules
• Logic Groups
• Mapping
• Data
• Data Load Rules
What WILL Convert
![Page 14: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/14.jpg)
• User Security
• Object Security
• Scripts
• Custom Reports
• Control Group Locations
• Task Flows
What WILL NOT Convert
![Page 15: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/15.jpg)
• FDM version 11.1.1.x and 11.1.2.x are supported
• ERPi with FDM is only 11.1.2.x (11.1.1.3 and 11.1.1.4 will not migrate)
• ODI Studio must be installed
• Must be able to access the FDM and FDMEE databases via SQL Developer/SQL Management Studio
• Download the Patch (21379349)
Prerequisites
![Page 16: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/16.jpg)
• Look at FDM to see what should convert
Viewing FDM
![Page 17: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/17.jpg)
Performing the Conversion
![Page 18: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/18.jpg)
• Database Activities• Update FDMEE Schema with SQL
• Update FDM Schema with SQL
• Install ODI Components• Create Logical Schema
• Create Physical Schema
• Import Scenarios
Performing the Conversion
![Page 19: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/19.jpg)
• Execute the Metadata Migration• Set Context
• Set Variables (App Name, object prefix, etc.)
• Execute
• Execute the Data Migration• Set Context
• Set Variables (App Name, object prefix, periods of data, etc.)
• Execute
• ***Need to repeat these steps for each Adapter that you have in FDM or each FDM application
Performing the Conversion
![Page 20: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/20.jpg)
• Need to repeat these steps for each Adapter that you have in FDM or each FDM application
Performing the Conversion
![Page 21: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/21.jpg)
• There could be several items that need to be done after the conversion is run• Update Drill Regions
• Review Check Rules
• Update Data Load Rules for filename
• Run SQL if Oracle database due to CAPS issue
• Run SQL to drop the FDM data models from FDMEE database
• Update Calc Sequence for Planning/Essbase apps
Post Conversion
![Page 22: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/22.jpg)
Nuances of FDMEE
![Page 23: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/23.jpg)
• When Importing data, automatically goes to Validate
• Intersection Validation Report no longer has tooltips
• Mapping has an ‘All Mappings’ tab where you cannot add a rule but can view all types
• When browsing for data in FDMEE Workbench and maps it is case sensitive
• FDMEE does not log mapping changes yet
Nuances of FDMEE
![Page 24: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/24.jpg)
Introduction to Jython
![Page 25: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/25.jpg)
• Indentation is important• If statements must line up (no end if)
• Case sensitivity• StrCheck is not the same as strCheck or strcheck
• If analyzing the length of a string or a taking the left 1, make sure that the length is greater than 0 first
• It is different but it is not that scary!!
Introduction to Jython
![Page 26: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/26.jpg)
• File Parsing
• String Parsing
Introduction to Jython
![Page 27: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/27.jpg)
• If Statement
Introduction to Jython
![Page 28: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/28.jpg)
• Additional If Statement
Introduction to Jython
![Page 29: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/29.jpg)
• Replace and Skip
Introduction to Jython
![Page 30: "Converting" FDM to FDMEE](https://reader033.vdocuments.us/reader033/viewer/2022042511/5872af671a28ab523c8b529d/html5/thumbnails/30.jpg)
Questions?Email us for a copy of the slides or link to the recording
Past webinars:
www.finitsolutions.com/webinars
Thank you for attending!
Presenter:Scott Peters
General Questions:Greg Barrett
Joe Mizerk