image_1.pngCopyright©2024 Yonyou Group All Rights Reserved.Without the written permission of Yonyou Group, no part of this user manual may be copied, reproduced, translated, or reduced for any purpose. The content of this user manual may change without notice, please stay informed.Please note: The content of this user manual does not represent a commitment made by Yonyou Network.OverviewThe main function of EPM data integration is to obtain data from external systems, then process the data into a multidimensional format using built-in system processing or rules, and finally import the data into the target system through mapping. EPM data integration supports the import of data, vouchers, and dimensions, and during the import, the target can be selected as consolidated reports, planning budgets, or corporate reports.Definitions of commonly used terms in EPM data integration:• Application Model: Refers to each model constructed in systems such as consolidation and budgeting;• External System: Refers to the source system, generally indicating business systems, data warehouses, files, and other data source systems;• Business Object: A collection of data, generally corresponding to a table, but can also correspond to files, SQL query results, etc. An external system can contain any number of business objects;• Import Rule: Used to associate each specific business object with a generic interface table;• Task: The smallest unit of user operation, through which external data can be imported into the target system;• Scheduled Task: Initiated by the system, the task is automatically executed at a specific time (once or at a certain interval);• Dedicated Interface Table: A dedicated interface table corresponds one-to-one with a business object, storing the raw data imported from external sources, as well as the task information at the time of execution;• Generic Interface Table: All data, after processing, will enter this interface table. In addition to containing business data information, the generic interface table also needs to include task information, etc.;• Period Mapping: When creating a task, period mapping needs to be selected, where the source period serves as a filter condition for the source data, and the target period refers to the period into which the data will be imported;• Data Mapping: After data enters the generic interface table, it is transformed through maintained data mapping before entering the final target model.Operation GuideEPM Data Collection MapIntegration SettingsOverviewIntegration settings are used to define external systems, business objects, and the association between business objects and common interface tables. Integration settings are generally completed by administrators. It includes the following functions:External System;Import Rules;Event Script;Period Mapping;Task Creation;Task grouping.External Systemsimage_2.pngExternal systems include a collection of data source systems and the objects from which data needs to be retrieved. The external system is the starting point for data aggregation and must be defined.image_3.pngWhen adding a new external system, select the button at the top left of the interface.image_4.pngWhen adding a new entry, you need to specify the system type, fill in the system code, system abbreviation, and description. The system types include: database connection, file, general ledger, semantic model, budget planning, consolidated report, and U8. - Database Connection: Generally, if this type is selected, you need to set the database connection properties, which serve as a parameter for the external system.- File: Select this type when file import is needed.- General Ledger: Select this type when data needs to be retrieved from the flagship version of the general ledger.- Semantic Model: Select this type when data needs to be retrieved from the semantic model.- Budget Planning: Select this type when data needs to be retrieved from budget planning to the consolidated report.- Consolidated Report: Select this type when data needs to be retrieved from the consolidated report to budget planning.- U8: Select this type when data needs to be retrieved from the U8 general ledger.- Add Semantic Model General Ledger: The overall usage is basically consistent with the original general ledger, with more available fields and support for directly retrieving parent item data. It is recommended to use this new type if data needs to be retrieved from the flagship general ledger.The system defaults to include the following parameters:- year: Year- month: Month- period: Period- entity: Entity- periodFrom: Period From- periodTo: Period ToIf you need to add parameters, select on the new entry interface, which will add an empty row at the bottom. The default parameter type is custom.When an external system is selected in the left tree, clicking the button allows for modifications to the existing external system. Once in edit mode, you can modify the external system description, default values of parameters, descriptions, and add parameters, etc.When an external system is selected in the left tree, clicking the button will delete the external system and all business objects under it, provided that the business objects in the selected system are not referenced; otherwise, they cannot be deleted.image_5.pngWhen hovering over the external system on the left side, clicking the <+> button allows you to add a new directory under that external system.image_6.pngAfter opening the new directory pop-up, you need to fill in the directory code and directory name. Once the addition is complete, you can add business objects under that directory.image_7.pngSelect the button to export the currently selected external system definitions and business objects, with support for selecting business objects; the exported file is not human-readable and cannot be modified.Import external systems and business objects, commonly used for data migration between different environments.image_8.pngWhen creating a new business object, select the corresponding external system for the business object, and then click the button at the top right of the interface.image_9.pngOpen the new business object interface.The system supports the following source types:• Table: This option is supported when the external system is a "database connection," allowing the search for database table names in the source object;• SQL: This option is supported when the external system is a "database connection";• File: This option can only be selected when the external system type is "file";• Balance Sheet: This option is supported when the external system type is "general ledger";• Cash Flow Statement: This option is supported when the external system type is "general ledger";• Semantic Model: This option allows searching for specific semantic models in the source object when the external system type is "semantic model";• Budget Planning: This option allows selecting the application model of budget planning in the source object when the external system type is "budget planning";• Consolidated Report: This option allows selecting the application model of consolidated reports in the source object when the external system type is "consolidated report";• U8 Account Balance Sheet: This option is supported when the external system type is "U8";• U8 Auxiliary Balance Sheet: This option is supported when the external system type is "U8";• U8 Cash Flow Statement: This option is supported when the external system type is "U8". When the external system type is "Database Connection," "Semantic Model," or "U8," it supports referencing parameters defined in external systems or business objects (parameter tab). The format for parameters is '$parameterName$', and the parameter name is case-sensitive. For example, to reference the year as a parameter, it can be written in SQL as: WHERE YEAR = '$year$'; when it is of "Table" type, it can be written as: YEAR = '$year$'.image_10.pngWhen a business object is selected in the left tree, clicking the "Edit" button allows for modifications to the existing business object. Once in edit mode, you can modify field information, add or delete fields, and add or delete filter conditions, etc.• Is it an auto-increment row: Manually added custom fields are automatically marked as auto-increment rows and cannot be modified.• Is it a data column: If selected, it can only be set as a data value when importing rule field mappings.When a business object is selected in the left tree, click the "Delete" button. The business object can be deleted only if it is not referenced by any import rules; otherwise, it cannot be deleted.image_11.pngUsed for data joint query configuration, supports tracing data in the business system to view detailed data from the data source.• Optional NCC General Ledger, requires configuration of the general ledger address URL and definition of parameter conditions;• BIP General Ledger, the address and parameter conditions are pre-set and can be used directly. If the data source is not the general ledger, the parameter field encoding needs to be modified to match the actual conditions;• Others, used for joint queries with third-party systems or custom-developed pages, also requires configuration of the jump address and parameter conditions.image_12.pngAllows adding conditions for preliminary filtering of the data source, with multiple conditions linked by a separator; condition operators support various conditions such as equal to, greater than, within a range, etc.Import Rulesimage_13.pngThe import rules connect business objects (dedicated interface tables) with general interface tables, establishing a mapping between business object fields and general interface fields.image_14.pngWhen adding a new entry, first select the target product: Consolidated Report or "Plan Budget". By default, all import rules under the current product are displayed. You can filter to show only the rules under the current model by selecting the model above. In the main interface, select , which will add a blank line at the bottom. You need to fill in the following information: - Rule Code: Required, must be filled in; - Rule Name: Required, must be filled in; - Rule Type: Required, the Consolidated Report includes four types: data, voucher, dimension, and mapping; "Plan Budget" only has two types: data and dimension; - Business Object: Required, a list of all business objects; - Dimension: Optional, required when the rule type is "Dimension" or "Mapping", not required for others.image_15.pngOnly modifications to the import rule name are supported. When you need to make changes, select , and the interface will enter edit mode, allowing you to change the rule name as needed; if no changes are required, select .image_16.pngAfter adding the import rules and saving, you need to edit the detailed information of the import rules. The operation is as shown in the figure below:image_17.pngAfter selecting , the Import Rule Details interface will open:image_18.pngimage_19.pngIn the detail information interface, the association between business objects and the general interface table can be set, and it is also possible to customize whether fields are displayed and the display order. The new import rules established in 2024 support multi-business object field matching, which will change to a multi-select reference. Once this configuration takes effect, it will affect subsequent mapping configurations, matching specified target field members based on multiple source field member...
