Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

Page i OFSAA - Data Relationship Management Interface User Manual 8.0.0.0.0 Tab

Page i OFSAA - Data Relationship Management Interface User Manual 8.0.0.0.0 Table of Contents Page ii T TA AB BL LE E O OF F C CO ON NT TE EN NT TS S PREFACE ........................................................................................................................................................ 3 Audience ..................................................................................................................................................................... 3 Prerequisites ............................................................................................................................................................... 3 Related Information Sources ....................................................................................................................................... 3 Acronyms .................................................................................................................................................................... 3 1 INTRODUCTION TO DRM TO OFSAA INTERFACE ...................................................................................... 5 1.1 Data flow .................................................................................................................................................... 5 2 DEPLOYMENT OF APPLICATION TEMPLATE ............................................................................................... 6 3 EXTRACTION OF GENERATED FILES .......................................................................................................... 7 4 PUBLISHING OFSAA-DRM CONNECTORS TO ODI ENVIRONMENT THROUGH DIH....................................... 8 5 OFSAA-DRM INTERFACE EXPORT DETAILS ............................................................................................ 9 5.1 Filtering Properties using Node Type in DRM Application .......................................................................... 9 6 OFSAA-DRM INTERFACE PROPERTIES ................................................................................................. 11 7 DIMENSION TYPE – COA ........................................................................................................................ 12 7.1 List of COA tables .................................................................................................................................... 12 8 DIMENSION TYPE – GL ........................................................................................................................... 13 9 DIMENSION TYPE – ORGANIZATIONAL UNIT ............................................................................................. 14 10 DIMENSION TYPE – PRODUCT ................................................................................................................. 15 11 PRE-REQUISITES FOR RUNNING OFSAA - DRM DATA LOADER DT (FN_DRMDATALOADER) ................. 16 DRM- OFSAA Interface User Guide Page 3 P Pr re ef fa ac ce e A Au ud di ie en nc ce e Following are the intended audience for the DIH user guide:  ETL Developers: The ETL Developers from the IT Department of the financial services institution, who do the data sourcing.  Business Analysts: The business analysts from the IT Department of the financial services institution, who do the mapping of the tables. P Pr re er re eq qu ui is si it te es s  Data Integration Hub (DIH) should be installed  DIH plug-in to publish OFSAA-DRM interface  Oracle Data Integration environment for executing the interfaces R Re el la at te ed d I In nf fo or rm ma at ti io on n S So ou ur rc ce es s Along with this user manual, you can also refer to the following documents:  Data Integration Hub user guide  DRM - OFSAA Integration guide A Ac cr ro on ny ym ms s Acronym Description DIH Data Integration Hub UI User Interface ODI Oracle Data Integrator ADI Application Data Interface KM Knowledge Module SDI Source Data Interface Apps Application CASA Current And Savings Account CL Consumer Lending ELCM Enterprise Limits and Collateral Management FX Foreign Exchange DRM- OFSAA Interface User Guide Page 4 Acronym Description GL General Ledger MM Money Marketing TD Term Deposit FIS FLEXCUBE Information Server EOFI End of Financial Input DRM Data Relationship Management DRM- OFSAA Interface User Guide Page 5 1 1 I In nt tr ro od du uc ct ti io on n t to o D DR RM M t to o O OF FS SA AA A I In nt te er rf fa ac ce e Oracle Financial Services Analytical applications(OFSAA) enables financial institutions to measure and meet risk-adjusted performance objectives, cultivate a risk management culture, lower the costs of compliance and regulation, and improve customer insight. Oracle Data Relationship Management (DRM) helps proactively manage changes in master data across operational, analytical, and enterprise performance management silos. Users may make changes in their departmental perspectives while ensuring conformance to enterprise standards 1 1. .1 1 D Da at ta a f fl lo ow w Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Oracle Proprietary and Confidential. DRM OFSAA Staging Area DRM Data Flow Master Data Management Staging Dimension Translations Interface Staging Dimension Attributes Interface Staging Dimension Members Interface Staging Dimension Hierarchies Interface DIH DRM Export Utility Flat Files Import DRM Application Template Migration utility Download OFSAA-DRM Application Template from Oracle e-delivery The OFSAA-DRM Application template is an xml based metadata file that is imported into the DRM application through migration utility. The nodes of the hierarchies that qualify within the scope of this interface release is assigned with correct values before executing the DRM exports. Four DRM books are created to generate the delimited files. The mapping between the delimited extracted files (SDI) and OFSAA staging tables (ADI) is predefined in the DRM connectors. The pre-defined DIH connectors that map the multiple file SDI’s to the corresponding ADI’s is published through front end. This creates corresponding interfaces in Oracle Data Integrator Repository. The interfaces is then executed to load the data from the delimited into the target staging tables. DRM- OFSAA Interface User Guide Page 6 2 2 D De ep pl lo oy ym me en nt t o of f A Ap pp pl li ic ca at ti io on n T Te em mp pl la at te e OFSAA-DRM Application template is an xml based metadata file that needs to be imported into the DRM application through migration utility. This would deploy all the out-of-the-box properties, Validations, Exports and Books in the target DRM application. The nodes of the hierarchies that qualify within the scope of this interface release is assigned with correct values before executing the DRM exports. NOTE: The names of the Version and Hierarchies as defined in the target application need to be manually edited in the template before importing. For more information, refer the OFSAA-DRM Interface Installation manual. DRM- OFSAA Interface User Guide Page 7 3 3 E Ex xt tr ra ac ct ti io on n o of f g ge en ne er ra at te ed d f fi il le es s There are four DRM books, that is, one for each dimension, that are created to generate the delimited files. These files are copied to an agreed file share, post execution of the books. The mapping between the delimited extracted files (SDI) and OFSAA staging tables (ADI) are predefined in the DRM connectors. Refer to the below Excel for more details. DRM_SDI_to_ADI_M apping.xlsx DRM- OFSAA Interface User Guide Page 8 4 4 P Pu ub bl li is sh hi in ng g O OF FS SA AA A- -D DR RM M C Co on nn ne ec ct to or rs s t to o O OD DI I e en nv vi ir ro on nm me en nt t t th hr ro ou ug gh h D DI IH H The pre-defined DIH connectors that map the multiple file SDI’s to the corresponding ADI’s needs to be published through the front end. This creates the corresponding interfaces in Oracle Data Integrator Repository. The interfaces are then executed to load the data from the delimited into the target staging tables. For more information on How to Publish a connector, refer OFSAA – Data Integration Hub user guide. DRM- OFSAA Interface User Guide Page 9 5 5 O OF FS SA AA A- -D DR RM M I In nt te er rf fa ac ce e E Ex xp po or rt t d de et ta ai il ls s The OFSAA-DRM Interface export details is available in the below Excel sheet. OFSAA-DRM Interface Export Details.xlsx 5 5. .1 1 F Fi il lt te er ri in ng g P Pr ro op pe er rt ti ie es s u us si in ng g N No od de e T Ty yp pe e i in n D DR RM M A Ap pp pl li ic ca at ti io on n Follow the below procedure to map the node type to each dimension: 1. At the home screen, select a version, say COA version. 2. Select the COA Hierarchy. 3. On RHS, under the Properties tab, select “OFSAA ATTRIBUTES”. Select COA NODE TYPE against COA label. 4. Click Save. 5. From RHS, select “System” under Properties tab. 6. Click the Hierarchy Node Type, select COA_MEMBER and click OK. DRM- OFSAA Interface User Guide Page 10 This is used to filter and display properties specific to particular dimension. Similarly, filtering can be done for other dimensions also. DRM- OFSAA Interface User Guide Page 11 6 6 O OF FS SA AA A- -D DR RM M I In nt te er rf fa ac ce e P Pr ro op pe er rt ti ie es s The OFSAA-DRM Interface properties is available in the below Excel sheet. OFSAA-DRM Interface Properties.xlsx DRM- OFSAA Interface User Guide Page 12 7 7 D Di im me en ns si io on n t ty yp pe e – – C CO OA A 7 7. .1 1 L Li is st t o of f C CO OA A t ta ab bl le es s Refer the attached excel sheet for DRM Column name and the Target Logical Name: COA.xlsx DRM- OFSAA Interface User Guide Page 13 8 8 D Di im me en ns si io on n t ty yp pe e – – G GL L Refer the attached excel sheet for DRM Column name and the Target Logical Name: GL.xls DRM- OFSAA Interface User Guide Page 14 9 9 D Di im me en ns si io on n t ty yp pe e – – uploads/Management/ drm-ofsaa-interface-user-guide.pdf