Copyright©2025 Yonyou Group All rights reserved.Without the written permission of Yonyou Group, no part or whole of the content 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 be aware.Please note: The content of this user manual does not represent any commitment made by Yonyou.Overall OverviewProduct 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 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. During the import, you can choose the target as Financial Consolidation, Planning, Budgeting and Forecasting, or Financial Reports.Definitions of commonly used terms in EPM Data Integration:• App Model: Refers to each model constructed in systems such as consolidation and budgeting;• External System: Refers to the source system, generally referring to 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 Rules: Used to associate each specific Business Object with the generic interface table;• Task: The smallest unit of user operation, through which external data can be imported into the target system;• Scheduled Task: A task initiated by the system that automatically executes at a specific time (once or at a certain time interval);• Dedicated Interface Table: The dedicated interface table corresponds one-to-one with the business object, preserving the original data imported from external sources, while also saving the task information during execution;• General Interface Table: All data will enter this interface table after processing. In addition to containing business data information, the general interface table also needs to include task information, etc.;• Period Mapping: When creating a task, it is necessary to select a period mapping, where the source period serves as the filter condition for the source data, and the target period refers to the period into which the data will be imported.• Data Mapping: After the data enters the universal interface table, it is converted through the maintained data mapping and then enters the final target model.Operation GuideIntegration SettingsOverall OverviewIntegration settings are used to define the external systems for integration, business objects, and to set the association relationships between business objects and the common interface table, etc. 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 SystemFunction DescriptionThe external system includes 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.Operation InstructionsExternal SystemAddWhen adding a new external system, select the
button at the top left of the interface.When adding, it is necessary 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, planning, budgeting and forecasting, financial consolidation, and U8, etc.• Database Connection: Generally, when selecting this type, it is necessary to set the database connection properties, which serve as a parameter for the external system. The public cloud version does not support this type of data retrieval;• File: Select this type when file import is required;• General Ledger: s03 General Ledger has been deactivated, and the existing data extraction configurations created based on s03 have been automatically upgraded to the General Ledger implementation based on the s12 semantic model, which does not affect the execution of existing tasks;• Semantic Model: Select this type when data needs to be retrieved from the semantic model;• External Interface: When the Financial Reports need to retrieve data from an external database, select this type. The public cloud version does not support this type of data retrieval.• Planning, Budgeting and Forecasting: Select this type when data needs to be extracted from Planning, Budgeting and Forecasting to Financial Consolidation;• Financial Consolidation: When data needs to be extracted from the financial consolidation for planning, budgeting, and forecasting, select this type;• U8: Select this type when you need to extract data from the U8 General Ledger;• Semantic Model General Ledger: Overall usage is basically consistent with the original General Ledger s03, with more available fields and support for directly retrieving parent item data. If data needs to be retrieved from the flagship General Ledger, this new type should be used uniformly.• New Item Accounting: When data needs to be extracted from the multi-dimensional balance sheet, aging analysis table, monthly cash flow summary, and cash flow detail table of item accounting to the Enterprise Performance Management app, select this type.The system defaults to include the following parameters:• entity: Subject• year: Year• month: Month• period: PeriodThe above three parameters are used for data extraction during the merging order period.• periodFrom: From Period• periodTo: End of Period• yearFrom: Year (From)• yearTo: Year (to)• monthFrom: Month (From)• monthTo: Month (to)The above six parameters are used for budget data retrieval over multiple periods.Please do not delete the preset parameters, as it will cause task execution errors. Future versions will impose restrictions.The preset parameters can be used in variable form such as $year$, for SQL statements or filtering conditions, to filter source data based on the options passed during task execution, for example:Where source_year >= ‘$yearFrom$’ and source_year <= ‘$yearTo$’ and source_month >= ‘$monthFrom$’ and source_month <= ‘$monthTo$’Represents the selected period range for executing the budget task, filtering the relevant parts from the source data's year and month fields.If you need to add a parameter, select on the new entry interface, and a blank row will be added at the bottom, with the parameter type defaulting to Custom.EditWhen 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 description of the External System, the default values of parameters, descriptions, and add parameters, etc.DeleteWhen 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, deletion is not allowed.Add DirectoryWhen the mouse hovers over the external system on the left side, clicking the <+> button allows you to add a new directory under that external system.After 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.ExportSelect the button to export the currently selected External System definitions and Business Objects, with support for selecting Business Objects; the exported file is not readable and cannot be modified.ImportImport external systems and business objects, commonly used for data migration between different environments.Business ObjectAddWhen creating a new business object, select the corresponding external system for the business object, and then click the button at the top right side of the interface.Open Business Object Creation InterfaceThe system supports the following source types:• Table: When the external system is "Database Connection," this option is supported, allowing you to search for database table names in the source object. The search is case-sensitive, so please ensure that the table name in the database connection is correct to enable fuzzy search.• SQL: This option is supported when the external system is "Database Connection";• File: When the external system type is "File," only "File" can be selected, supporting excel, csv, and txt (newly added). When retrieving data from txt, due to the variable format, the following additional configuration is required. Please refer to the user instructions:1.The row where the column header is located represents which row in the file corresponds to the field names, similar to the column headers in Excel.2.Default column headers. If the txt file does not have column headers, you need to manually input alternative field names, separated by commas.3.Separator, represents the character used to separate different values in this file, supports common English characters such as comma, semicolon, and space, etc.;4.Title (Number of Rows), represents the invalid region in the file, such as data descriptions or file titles, etc., will skip the set number of rows before starting to recognize the content.For example, in the txt file shown below, there are no standard column headers, so we need to fill in the default column headers, such as:ENTITY，YEAR，MONTH，VIEW，VERSION，CURRENCY…VALUEThe delimiter is the English comma ",", the first line has no actual meaning, so the number of header rows is 1.• 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: When the external system type is "Semantic Model," specific semantic models can be searched and selected for use in the source object.• Planning, Budgeting and Forecasting: When the external system type is "Planning, Budgeting and Forecasting," the application model for planning and budgeting can be selected in the source object.• Financial Consolidation: When the external system type is "Financial Consolidation," the application model for the financial consolidation can be selected in the source object;• U8 Account Balance Report: 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 the external system or business object (Parameter tab). The format for parameters is '$parameter_name$', 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 type "Table," it can be written as: YEAR = '$year$'.EditWhen 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 Data...
