Oracle Quality Management, Enterprise Hyperion Financial ...

1 Oracle Hyperion Financial DataQuality management , EnterpriseEditionAdministrator's GuideRelease 2019 Oracle Hyperion Financial Data Quality management , Enterprise Edition Administrator's Guide, 2009, 2019, Oracle and/or its affiliates. All rights Author: EPM Information Development TeamThis software and related documentation are provided under a license agreement containing restrictions onuse and disclosure and are protected by intellectual property laws. Except as expressly permitted in yourlicense agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify,license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any engineering, disassembly, or decompilation of this software, unless required by law forinteroperability, is information contained herein is subject to change without notice and is not warranted to be error-free.

2 Ifyou find any errors, please report them to us in this is software or related documentation that is delivered to the Government or anyone licensing it onbehalf of the Government, then the following notice is GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,any programs installed on the hardware, and/or documentation, delivered to Government end users are"commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of theprograms, including any operating system, integrated software, any programs installed on the hardware,and/or documentation, shall be subject to license terms and license restrictions applicable to the other rights are granted to the software or hardware is developed for general use in a variety of information management is not developed or intended for use in any inherently dangerous applications, including applications thatmay create a risk of personal injury.

3 If you use this software or hardware in dangerous applications, then youshall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure itssafe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of thissoftware or hardware in dangerous and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks oftheir respective and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks areused under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron,the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced MicroDevices. UNIX is a registered trademark of The Open software or hardware and documentation may provide access to or information about content, products,and services from third parties.

4 Oracle Corporation and its affiliates are not responsible for and expresslydisclaim all warranties of any kind with respect to third-party content, products, and services unless otherwiseset forth in an applicable agreement between you and Oracle . Oracle Corporation and its affiliates will not beresponsible for any loss, costs, or damages incurred due to your access to or use of third-party content,products, or services, except as set forth in an applicable agreement between you and Documentation Accessibility Documentation Feedback1 Using FDMEES upported Source Systems1-1 File-Based Data Loads1-2 Supported EPM System Target Applications1-2 Key FDMEE Benefits1-3 FDMEE Application Folder Architecture1-3 FDMEE Architecture1-6 Drilling Through1-8 Drilling Through to the FDMEE Landing Page1-9 Configuring Oracle Data Integrator With FDMEE1-10 Set up the Data Server Based on the Enterprise Resource Planning (ERP)

5 Source System1-10 Setting up Physical Schemas1-11 Setting up the ODI Context Code1-12 Setting up ODI to Integrate with JD Edwards1-12 Security1-17 Integration Process Overview1-19 Extracting General Ledger Data1-19 Writing Back Data from EPM Applications1-19 Integrating Metadata1-20 Understanding General Ledger Integration1-20 Requirements1-21 Required Dimensions1-22 Member Properties Sourced from the Enterprise Resource Planning (ERP)System1-22 How Dimensions Are Processed1-26 How Languages Are Processed1-27iiiHow Currencies Are Processed1-28 Defining Metadata Rules1-29 Loading Source System Hierarchies into EPM Dimensions1-36 Extracting Human Resource Data1-36 Navigating FDMEE1-37 Toolbars1-37 Help Menu1-37 Task Pane Options1-37 Workflow Tasks1-37 Setup Tasks1-38 Working with Data in Grids1-39 FDMEE User Interface Elements1-39 Advanced Search Options1-40 Using the POV Bar1-41 Selecting the Location POV1-41 Setting the Period POV1-42 Setting the Category POV1-43 Locking and Unlocking a POV1-43 Administration Tasks1-44 Predefining a List of Profiles1-45 Setting System-Level Profiles1-45 Setting Application-Level Profiles1-54 Setting User Level Profiles1-59 Setting Security Options1-61 Setting up Source Systems1-67 Registering Enterprise Resource Planning (ERP)

6 Source Systems1-68 Registering File-Based Source Systems1-70 Deleting Registered Source Systems1-70 Editing Registered Source System Details1-71 Adding File-Based Data Load Definitions1-71 Working with Source Adapters1-72 Using a Prepackaged Integration for SAP1-72 Adding Source Adapter Definitions1-73 Defining Source Adapter General Information1-73 Defining Source Adapter Detail1-76 Registering Target Applications1-82 Creating a Custom Target Application1-84 Adding Lookup Dimensions1-87 Defining Application Dimension Details1-87 Defining Application Options for Essbase and Planning1-88 Defining Application Options for Profitability and Cost management (HPCM)1-96ivDefining Application Options for Public Sector Planning and Budgeting1-99 Defining Application Options for Financial Management1-101 Deleting Registered Target Applications1-110 Reusing Target Application Names Multiple Times1-111 Selecting Source Accounting Entities1-111 Assigning General Ledger Responsibility1-112 Working with Source Accounting Entity Groups1-113 Loading Excel Data1-114 Downloading to Excel1-115 Uploading from Excel1-1162 Integrating TasksWorking with Import Formats2-1 Defining the Import Format2-2 Viewing Import Format Information2-2 Adding Import Formats2-3 Deleting an Import Format2-5 Querying by Example2-6 Defining Import Format Mappings2-6 Defining the Import Format Mappings2-7 Concatenating Source Dimensions for Enterprise Resource Planning (ERP)

7 Segments2-8 Adding Import Expressions2-9 Import Expression Types2-10 Processing Order2-13 Defining Import Formats for File-Based Mappings2-14 Concatenating Source Dimensions for a File-Based Source2-17 Using the Import Format Builder2-18 All Data Types Data Loads2-20 All Data Types Data Load Process Description2-20 Setting the All Data Types Load Method2-21 Setting the All Data Types Load Method2-22 Setting the Import Format Data Types2-22 Setting the Import Format for Multi-Column Data Types2-24 Loading Incremental Data using the LINEITEM Flag to an EPM Application2-29 Loading Multi-Column Numeric Data 2-32 Loading Periods as a Column from the Data File2-35 Write-Back Mappings2-36 Defining Import Formats for Data Synchronization Between EPM Applications2-37 Defining Import Formats for Data Synchronization Between Enterprise ResourcePlanning (ERP) and EPM Applications2-38vDefining the Write-Back Mappings (E-Business Suite and PeopleSoft only)

8 2-40 Defining Locations2-40 Defining Period Mappings2-43 Global Mappings2-46 Application Mappings2-46 Source Mappings2-47 Defining Category Mappings2-49 Global Mappings2-50 Application Mappings2-503 Integrating DataLoading Data3-1 Creating Member Mappings3-1 Creating Mappings Using the Explicit Method3-3 Creating Mappings Using the Between Method3-4 Creating Mappings Using the In Method3-5 Creating Mappings Using the Multi-Dimension Method3-5 Using Special Characters in Multi-Dimensional Mapping3-6 Creating Mappings Using the Like Method3-7 Using Special Characters in the Source Value Expression for Like Mappings3-7 Automap Wildcarding3-10 Using Special Characters in the Target Value Expression3-12 Format Mask Mapping for Target Values3-13 Ignoring Member Mappings3-16 Importing Member Mappings3-17 Downloading an Excel Template (Mapping Template)3-19 Importing Excel Mappings3-20 Exporting Member Mappings3-22 Deleting Member Mappings3-22 Restoring Member Mappings3-23 Defining Data Load Rules to Extract Data3-23 Defining Data Load Rule Details3-23 Defining Data Load Rule Details for a File-Based Source System3-43 Defining Source Parameters for Planning and Essbase3-45 Defining Source Parameters for Financial Management3-46 Managing Data Load Rules3-47 Editing Data Load Rules3-48 Running Data Load Rules3-48 Scheduling Data Load Rules3-52 Checking the Data Load Rule Status3-53viDeleting Data Load Rules3-53 Working with Target Options3-53 Creating Custom Options3-54 Loading Exchange Rates to Financial Management3-54 Using Drilling Through3-56 Creating the Drill Region3-57 Drill Through Components3-58 Adding the Server Component for the Drill Through URL3-58 Adding the Detail Component for the Drill Through URL3-59 Viewing the Drill

9 Through Results 3-60 Integrating with the EPM Cloud3-63 Configuring the Secure Sockets Layer (SSL) Certificate3-64 Pre-requisites3-66 Setting up the EPM Cloud Deployment 3-67 Loading Data to the EPM Cloud or On-Premise Application3-67 Exporting the EPM Cloud Application3-67 Using the Data Load Workbench3-67 Workflow Grid3-68 Processing Data3-68 Using the Workbench Data Grid3-72 Viewing Process Details3-80 Integrating with the Oracle Financials Cloud3-81 Integration Process Description 3-82 Configuring a Source Connection3-83 Working with Import Formats3-86 Defining Locations3-87 Defining Category Mappings3-89 Data Load Mapping3-89 Adding Data Load Rules 3-91 Processing Oracle General Ledger Adjustment Periods3-92 Adding Filters for Data Load Rules3-94 Drilling Through to the Oracle Financials Cloud3-96 Writing Back to the Oracle Financials Cloud3-96 Using Excel Trial Balance Files to Import Data3-101 Text Trial Balance Files Versus Excel Trial Balance Files3-101 Downloading an Excel

10 Trial Balance Template3-101 Defining Excel Trial Balance Templates3-101 Adding a Multiple Period Data Load Using Excel3-102 Importing Excel Mapping3-103 Using Journal Templates to Import Data3-104 Additional Considerations for Loading Journal Templates3-104viiIntegrating Financial management Journals 3-105 Downloading a Journal Template3-106 Defining Journal Templates3-106 Processing Journals3-109 Loading Data Using a Universal Data Adapter3-112 Defining a Universal Data Adapter in Oracle Database Integrator (ODI)3-113 Configuring SAP HANA3-116 Working with a Universal Data Adapter in FDMEE3-117 Universal Data Adapter Source Systems and Import Formats3-123 Universal Data Adapter Source Systems and Locations3-123 Data Load Mapping for Universal Data Adapter Related Sources3-124 Data Load Rules for Universal Data Adapter Related Source3-124 Integrating Data Relationship management with FDMEE 3-127 Setting up the Integration3-127 Data Relationship management and FDMEE Locations3-129 Data Relationship management and FDMEE Metadata Rules3-129 Importing Data Load Mappings from Data Relationship Management3-130 Financial Close management Integration with FDMEE3-131 Data Load.