Oracle Hyperion Financial Close Suite Tips and Tricks

  • Published on

  • View

  • Download


Corporate PowerPoint- June '11

Business Analytics Solutions Provider Using Oracle EPM and BI Technologies

FDMEE: Tips & Tricks

2Oracle Platinum Consulting Partner - 100% EPM/BI Focus190+ Full time EPM/BI Billable Consultants US, Canada, and the United KingdomExperience & SuccessFounded in 19961,700+ Oracle EPM & BI successful projects Depth & Breadth of Service OfferingsFull EPM/BI Platform Product DeliveryVisioning & Roadmaps, Full Life Cycle Implementations, Tech Review & Assessments, Staff AugmentationEPM/BI Solution ExpertsOracle ACEs Across EPM/BI PlatformPartner Advisory Boards, Beta Testing, Certification Exam Development

18+ Years850+ Clients1700+ ProjectsAbout Edgewater Ranzal

FDMEE Key Benefits3End user friendly tool Integrated into Workspace64 bit architectureLeverages ODI as its data engineDirect integration into multiple ERP systemsDrill ThroughSupports LCMSupports Shared ServicesPlatform agnostic

FDMEE Key Benefits Close Suite4Intersection Validation ReportData ProtectionAutomated Consolidation/CalculationJournal Creation & PostingData Load Rule specific integration optionsARM integration

UI Mapped Data Investigation5Similar to the Validate screen of FDM ClassicMultigrid layout allows explosion of mapped record to show source records contributing to the target intersection

UI Customized Data Layout6Complete control of fields/columns displayed as well as orderUseful for when exporting information from FDMEE to Excel Not Sticky

UI Customized Data Layout7

UI Query By Example8Enables records to be filtered across multiple data columnsSupports wildcarding with asterisks (*) and underscore (_)Useful for data investigationExported data sets respect filtering and layout

Multidimensional Mapping9Map data based on two or more source dimension valuesSimilar to varValues mappingBetter performanceNo scriptingNot available for target dimension based mapping

Script Based Mapping10Map based on the mapped result of other dimensionsUpdate additional fields on the recordSimilar to varValuesCan utilized Jython or SQLSQL is preferred for performance

Life Cycle Management11Supports SDLCUpdate existing itemsAbility to migrate at object level, not individual item levelDoes not migrate scriptsConsider disabling Validation during LCM importAvoid migrating Source Adaptors & System SettingsIf possible, use same name for target applications across environments

Terminating FDMEE Jobs12Restart FDMEE ServiceRight click ODI session and choose Stop ImmediateIn Process Details, highlight the process ID and choose reset status

Migration UtilityProsConverts most metadata & mapsConverts data for drill through purposesConsDoes not convert scripts, reports or securityUtilizes a lift & shift approach does not force an investigative eye

Rebuild FDMEEProsOpportunity to purge metadata elements not neededOpportunity to examine/enhance processesConsNo drill through availableMore time consuming/costlyAdditional riskMaintain the FDM Classic database and use FDMEE reports to access historical data and process information.FDMEE Upgrade Options

14Contact InformationEdgewater Ranzal108 Corporate Park Drive, Suite 105White Plains, NY 10604Tel (914) 253-6600Email:

ContactTony Scalese, Integration Practice Director

45 Beech Street, Suite 109London EC2Y 8ADUnited KingdomTel +44 (0) 2033 717 174

150 North Michigan Ave.Suite 2800Chicago, IL 60601Tel (312) 624-7738

200 Harvard Mill SquareSuite 210Wakefield, MA 01880Tel (781) 246-3343