Financial supervision report generation method and device, storage medium and electronic equipment

Abstract

The invention provides a financial supervision report generation method and apparatus, a storage medium and an electronic device. The method comprises the steps of obtaining a form file and a data file set imported by a user; reading an initial report corresponding to the form file; determining a target cell in each cell of the initial report; obtaining a business rule defined based on a data description language from the cell data of each target cell; according to the business rule and the data file set of each target cell, determining each piece of source data corresponding to each target cell, and obtaining a data processing result corresponding to each target cell through data processing; and replacing the cell data of each target cell with a data processing result corresponding to the target cell, and generating a financial supervision report based on the initial report subjected to data replacement. By applying the method provided by the invention, the finally generated financial supervision report can be changed by adjusting the content of the initial report, and the flexibility of service adjustment can be improved.

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a method and device for generating a financial regulatory report, a storage medium and an electronic device. Background Art

[0002] In the financial industry, financial institutions need to submit financial regulatory reports to financial regulatory agencies on a regular basis. Financial regulatory reports are statistical reports of financial regulatory data to achieve financial supervision. Therefore, financial institutions need to regularly compile financial regulatory data in accordance with the data content required by financial supervision, thereby generating financial regulatory reports.

[0003] At present, financial institutions usually build a traditional business system by deploying servers and setting up databases, and define the format and data processing logic of financial regulatory reports in the business code of the business system to provide business support for generating financial regulatory reports. When it is necessary to generate financial regulatory reports, the business system processes the data according to the data processing logic and outputs the financial regulatory report in a predetermined format.

[0004] In actual business scenarios, financial regulatory requirements for financial regulatory data often change, and the content of the financial regulatory reports that need to be submitted needs to be adaptively changed. Using the existing method of generating financial regulatory reports, when the content of the financial regulatory reports changes, business personnel need to communicate with technical personnel, and technical personnel will develop, test, and launch the business system according to the needs. Only then can business personnel use the business system to generate financial regulatory reports that meet the needs. The business adjustment cycle is long, the efficiency is low, and it is impossible to flexibly adapt to the changes in the needs of financial regulatory reports. Summary of the invention

[0005] In view of this, an embodiment of the present invention provides a method for generating financial regulatory reports to solve the problem that when the report format or content needs to be changed, a series of operations such as business development, testing, and going online need to be performed on the business system again, and the business adjustment cycle is long, the efficiency is low, and the flexibility is poor.

[0006] The embodiment of the present invention also provides a device for generating a financial regulatory report to ensure the actual implementation and application of the above method.

[0007] To achieve the above objectives, the embodiments of the present invention provide the following technical solutions:

[0008] A method for generating a financial regulatory report, comprising:

[0009] When receiving an instruction to generate a report, obtaining a table file and a data file set imported by a user from a local storage space; the data file set includes at least one data file;

[0010] Read the content of the table file to obtain an initial report corresponding to the table file; the initial report is a report set according to the data report requirements of financial regulatory data;

[0011] In each cell of the initial report, at least one target cell is determined; each of the target cells corresponds to each financial regulatory data indicator to be processed;

[0012] For each of the target cells, a business rule defined based on a data description language is obtained from the current cell data, and the business rule is used as the business rule corresponding to the target cell, wherein the business rule represents the business scope of the financial regulatory data indicator corresponding to the target cell;

[0013] Performing data analysis on the business rules corresponding to each of the target cells to obtain data screening rules and data processing rules corresponding to each of the target cells;

[0014] For each of the target cells, based on the data screening rule corresponding to the target cell, a target data file is determined in the data file set, and each source data corresponding to the target cell is determined based on the target data file;

[0015] For each of the target cells, based on the data processing rule corresponding to the target cell, data processing is performed on each source data corresponding to the target cell to obtain a data processing result corresponding to the target cell;

[0016] Replacing the cell data of each target cell with the data processing result corresponding to the target cell to obtain an initial report after data replacement;

[0017] Based on the initial report after data replacement, a financial regulatory report corresponding to the instruction is generated.

[0018] In the above method, optionally, determining at least one target cell in each cell of the initial report includes:

[0019] Determine whether the user has specified a cell range to be processed;

[0020] If the user has specified a cell range to be processed, determining a target cell range specified by the user;

[0021] Determine, among the cells of the initial report, cells that match the target cell range;

[0022] A cell matching the target cell range is used as the target cell.

[0023] The above method may optionally further include:

[0024] If the user does not specify a cell range to be processed, then for each cell of the initial report, determining whether the cell meets the preset parsing condition;

[0025] The cells in the initial report that meet the parsing condition are used as the target cells.

[0026] In the above method, optionally, determining the target data file in the data file set based on the data screening rule corresponding to the target cell includes:

[0027] Determine a data source identifier corresponding to the data screening rule;

[0028] Determining whether each of the data files matches the data source identifier;

[0029] The data file matching the data source identifier is used as the target data file.

[0030] In the above method, optionally, determining each source data corresponding to the target cell based on the target data file includes:

[0031] Determine a target binary file corresponding to the target data file; the target binary file is a binary file obtained by performing file format conversion on the target data file;

[0032] Determine a data access expression corresponding to the data screening rule;

[0033] Based on the data access expression, data is screened in the target binary file to obtain data of each file;

[0034] The respective file data are used as respective source data corresponding to the target cell.

[0035] The above method may optionally further include:

[0036] In the case where a rule check is required for the table file, determining each business rule recorded in the initial report;

[0037] According to the preset rule checking strategy, each business rule recorded in the initial report is checked to obtain the rule checking result corresponding to the table file.

[0038] The above method may optionally further include:

[0039] The log data is collected in real time, the operation is monitored through the log data, and the log data is recorded.

[0040] A device for generating a financial regulatory report, comprising:

[0041] A file acquisition unit, configured to acquire a table file and a data file set imported by a user from a local storage space when receiving an instruction to generate a report; the data file set includes at least one data file;

[0042] A table reading unit, used to read the content of the table file to obtain an initial report corresponding to the table file; the initial report is a report set according to the data report requirements of financial regulatory data;

[0043] A first determination unit is used to determine at least one target cell in each cell of the initial report; each of the target cells corresponds to each financial regulatory data indicator to be processed;

[0044] A rule acquisition unit, configured to acquire, for each of the target cells, a business rule defined based on a data description language from the current cell data, and use the business rule as the business rule corresponding to the target cell, wherein the business rule represents the business scope of the financial regulatory data indicator corresponding to the target cell;

[0045] A rule parsing unit, used to perform data parsing on the business rules corresponding to each of the target cells, and obtain data screening rules and data processing rules corresponding to each of the target cells;

[0046] A second determining unit is used to determine, for each of the target cells, a target data file in the data file set based on a data screening rule corresponding to the target cell, and determine each source data corresponding to the target cell based on the target data file;

[0047] A data processing unit, configured to perform data processing on each source data corresponding to each target cell based on a data processing rule corresponding to the target cell, to obtain a data processing result corresponding to the target cell;

[0048] A data replacement unit, used to replace the cell data of each target cell with the data processing result corresponding to the target cell, so as to obtain an initial report after data replacement;

[0049] A report generation unit is used to generate a financial regulatory report corresponding to the instruction based on the initial report after data replacement.

[0050] A storage medium includes stored instructions, wherein when the instructions are executed, the device where the storage medium is located is controlled to execute the above-mentioned method for generating financial regulatory reports.

[0051] An electronic device includes a memory and one or more instructions, wherein the one or more instructions are stored in the memory and configured to be executed by one or more processors to execute the above-mentioned method for generating financial regulatory reports.

[0052] A method for generating a financial regulatory report based on the above-mentioned embodiment of the present invention includes: when receiving an instruction to generate a report, obtaining a table file and a data file set imported by a user from a local storage space; the data file set includes at least one data file; reading the content of the table file to obtain an initial report corresponding to the table file; the initial report is a report set according to the data report requirements of financial regulatory data; in each cell of the initial report, at least one target cell is determined; each target cell corresponds to each financial regulatory data indicator to be processed; for each target cell, a business rule defined based on a data description language is obtained from the current cell data, and the business rule is used as the business rule corresponding to the target cell, and the business rule characterizes the financial regulatory corresponding to the target cell The business scope of the data indicator; the business rules corresponding to each target cell are analyzed to obtain the data screening rules and data processing rules corresponding to each target cell; for each target cell, based on the data screening rules corresponding to the target cell, the target data file is determined in the data file set, and the source data corresponding to the target cell is determined based on the target data file; for each target cell, based on the data processing rules corresponding to the target cell, the source data corresponding to the target cell is processed to obtain the data processing result corresponding to the target cell; the cell data of each target cell is replaced with the data processing result corresponding to the target cell to obtain the initial report after data replacement; based on the initial report after data replacement, the financial regulatory report corresponding to the current instruction is generated. The method provided by the embodiment of the present invention can generate a financial regulatory report through the table file and data file set imported by the user. The platform can obtain the business rules associated with the financial regulatory data indicator to be processed by parsing the initial report in the table file, and obtain the required data from the data file for data processing to obtain the corresponding financial regulatory data indicator, and fill it into the corresponding cell of the initial report, that is, replace the data of the cell recording the business rules in the initial report with the financial regulatory data indicator processed based on the business rules. Business personnel can design the initial form according to the reporting requirements of financial regulatory data, and enter the corresponding business rules based on the data description language for the cells that need to record the financial regulatory data indicators to be processed. When the content requirements of the financial regulatory report change, the business personnel only need to update the content of the initial report according to the requirements, and the platform can generate a financial regulatory report that meets the requirements based on the updated initial report. Business adjustments are less time-consuming and more efficient, and can flexibly adapt to changes in the requirements of financial regulatory reports. Secondly, the business rules in the initial report are defined in the data description language. Business personnel only need to set business rules based on the business scope of the financial regulatory data indicators they have mastered and based on natural language expressions, which can improve the convenience of business work.In addition, the report generation process can be handled by local devices, without the need to build a traditional business system, and the cost of business development and operation and maintenance is low. BRIEF DESCRIPTION OF THE DRAWINGS

[0053] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on the provided drawings without paying creative work.

[0054] Figure 1 A method flow chart of a method for generating a financial regulatory report provided by an embodiment of the present invention;

[0055] Figure 2 A schematic diagram of an initial report provided by an embodiment of the present invention;

[0056] Figure 3 Another method flow chart of a method for generating a financial regulatory report provided by an embodiment of the present invention;

[0057] Figure 4 A schematic diagram of the structure of a device for generating a financial regulatory report provided by an embodiment of the present invention;

[0058] Figure 5 A schematic diagram of the structure of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0059] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0060] In this application, the terms "comprises", "comprising" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device comprising a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, an element defined by the sentence "comprising a ..." does not exclude the presence of other identical elements in the process, method, article or device comprising the element.

[0061] An embodiment of the present invention provides a method for generating a financial regulatory report. The method can be applied to a report generation system. The execution subject can be a processor of a deployment tool. The method flow chart of the method is as follows: Figure 1 As shown, including:

[0062] S101: when receiving an instruction to generate a report, obtaining a table file and a data file set imported by a user from a local storage space; the data file set includes at least one data file;

[0063] In the method provided by the embodiment of the present invention, when a user needs to generate a financial regulatory report, the table file of the pre-set initial report and the required data file can be imported into the report generation system, and the corresponding function control can be triggered in the front-end interface to send an instruction for instructing to generate a report based on the corresponding table file and data file. In the specific implementation process, it can also be configured to trigger the instruction for instructing to generate a report in a timed trigger or other manner. The table file and data file imported by the user will be stored in the local storage space.

[0064] When the processor receives an instruction to generate a report, it can obtain the table file and data file set associated with the instruction and pre-imported by the user from the local storage space. The data files included in the data file set are the source data files required for the processing of financial regulatory data. In the specific implementation process, there may be multiple data files required, or there may be only one, depending on the actual business situation. The table file can be a file generated based on various reporting software.

[0065] S102: Read the content of the table file to obtain an initial report corresponding to the table file; the initial report is a report set according to the data report requirements of financial regulatory data;

[0066] In the method provided by the embodiment of the present invention, the processor can read the table content in the table file to obtain the initial table (i.e., initial report) stored in the file. The initial table is a report designed in advance by business personnel based on the data report requirements of financial regulatory data. Specifically, the table format and header and other contents can be designed as needed. For cells that need to be filled with financial regulatory data indicators to be processed, the corresponding business rules can be defined in the data description language (DDL) according to the business scope of the financial regulatory data indicators. The business rules can be composed of business terms and operators for financial regulatory data. The business scope of financial regulatory data indicators refers to the formulation of unified data statistical standards from a business perspective. The content described in the business rules may include elements such as data sources, data conditions, and statistical dimensions. For example Figure 2In the table shown, the table header contents such as "Indicators", "Various Loans", "Current Period", "Compared to the Beginning of the Year", "Compared to the Same Period", "Earth 1", "Branch 1" are set according to actual needs, while the cells corresponding to "Current Period-Branch 1" have entered the business rules corresponding to the corresponding financial regulatory data indicators.

[0067] It should be noted that Figure 2 The table shown is only a brief schematic table provided to better illustrate the method provided in an embodiment of the present invention. It does not show the overall initial table in the actual business scenario, nor does it limit the table format or content of the financial regulatory data table in the actual implementation process.

[0068] S103: Determine at least one target cell in each cell of the initial report; each target cell corresponds to each financial regulatory data indicator to be processed;

[0069] In the method provided by the embodiment of the present invention, the processor can identify each cell in the initial report according to a preset identification method, and identify the cells that need to be analyzed and processed, that is, the cells that record the business rules corresponding to the corresponding financial regulatory data indicators, and use these cells as target cells. The specific method of determining the target cell can be set according to actual needs, for example, the range of the target cell can be specified by the user, or the target cell can be automatically identified.

[0070] In a specific implementation process, the number of target cells, that is, the number of cells that record corresponding business rules and need to be processed currently, can be only one or more, depending on the actual business situation.

[0071] S104: For each of the target cells, obtain a business rule defined based on a data description language from the current cell data, and use the business rule as the business rule corresponding to the target cell, wherein the business rule represents the business scope of the financial regulatory data indicator corresponding to the target cell;

[0072] In the method provided by the embodiment of the present invention, the corresponding data content is read from the cell data of each target cell. The current cell data is the business rules defined based on the data description language. The business rules describe the business scope of the corresponding financial regulatory data indicators, for example Figure 2 The contents of the cell corresponding to this issue - Branch 1.

[0073] S105: performing data analysis on the business rules corresponding to each of the target cells to obtain data screening rules and data processing rules corresponding to each of the target cells;

[0074] In the method provided in the embodiment of the present invention, a business rule parsing algorithm is pre-set in the report generation system, which is based on the business characteristics of financial regulatory data and the operation mechanism of various operators, and can obtain data screening rules that characterize data screening conditions and data processing rules that characterize data processing methods based on business rule parsing.

[0075] The processor can perform data analysis on the business rules corresponding to each current target cell based on a preset analysis algorithm, thereby obtaining data screening rules and data processing rules corresponding to each target cell. Figure 2 The data screening rules corresponding to the cell corresponding to this period-branch 1 may include "general ledger data, institution name = A, data type = various loans-netting balance", "general ledger data, institution name = B, data type = various loans-netting balance", "general ledger data, institution name = C, data type = various loans-netting balance", "general ledger data, institution name = B, data type = discount and buyout rediscount_netting balance", etc. The data processing rules are composed of various operators and corresponding operands, for example, they can be: (various loans of institution A-netting balance) + (various loans of institution B-netting balance) + (various loans of institution C-netting balance) - (discount and buyout rediscount_netting balance of institution B)...

[0076] S106: for each of the target cells, based on the data screening rule corresponding to the target cell, determining a target data file in the data file set, and determining each source data corresponding to the target cell based on the target data file;

[0077] In the method provided by the embodiment of the present invention, for each target cell, the data source file of the data processing process of the current target cell can be identified in various data files according to its corresponding data screening rules, the identified data source file is used as the target data file, and the basic data required for data processing is searched in the target data file according to its corresponding data screening rules, and the basic data obtained by the search is used as the source data corresponding to the current target cell. Figure 2 The cell corresponding to this period-branch 1, its corresponding target data file can be a data file associated with "general ledger data", and its corresponding source data are the data in the target data file, such as the netting balance of various loans of institution A, the netting balance of various loans of institution B, the netting balance of various loans of institution C, and the netting balance of discount and buyout rediscount of institution B.

[0078] It should be noted that in the specific implementation process, the data processing process of a single financial regulatory data indicator may involve only one or more data source files. Therefore, the target data file associated with the target cell may be only one or more. If there are multiple target data files, the source data corresponding to the target cell can be determined based on all target data files.

[0079] S107: For each of the target cells, based on the data processing rule corresponding to the target cell, perform data processing on each source data corresponding to the target cell to obtain a data processing result corresponding to the target cell;

[0080] In the method provided by the embodiment of the present invention, based on the data processing rules corresponding to each target cell, each source data corresponding to each target cell is processed to obtain the data processing result corresponding to each target cell. The data processing result corresponding to each target cell is the financial regulatory data indicator corresponding to the target cell.

[0081] S108: replacing the cell data of each target cell with the data processing result corresponding to the target cell, so as to obtain an initial report after data replacement;

[0082] In the method provided by the embodiment of the present invention, the cell data of each target cell in the initial report is replaced by the corresponding business rules with the data processing results corresponding to the target cell. After completing the data replacement process of all target cells, the current report is used as the initial report after data replacement. It can be understood that the initial report after data replacement is a report obtained by deleting the business rules recorded in each target cell on the basis of the initial report and filling the data processing results corresponding to each target cell into the target cell.

[0083] S109: Generate a financial regulatory report corresponding to the instruction based on the initial report after data replacement.

[0084] In the method provided by the embodiment of the present invention, the processor generates a financial regulatory report corresponding to the instruction for generating the report based on the initial report after data replacement. Specifically, the initial report after data replacement can be formatted in a unified manner according to a preset text format, and the cell data in the initial report after data replacement can be formatted in a unified manner, such as unifying the font, font size, spacing and other elements. The report after formatting is exported, and the exported report is used as the currently generated financial regulatory report.

[0085] Based on the method provided by the embodiment of the present invention, when receiving an instruction to generate a report, the table file and data file set imported by the user are obtained from the local storage space; the content of the table file is read to obtain an initial report; at least one target cell is determined in each cell of the initial report; for each target cell, a business rule defined based on a data description language is obtained from the current cell data, and the business rule is used as the business rule corresponding to the target cell; data is parsed for the business rule corresponding to each target cell to obtain the data screening rule and data processing rule corresponding to each target cell; for each target cell, based on the data screening rule corresponding to the target cell, the target data file is determined in the data file set, and the source data corresponding to the target cell is determined based on the target data file; for each target cell, based on the data processing rule corresponding to the target cell, the source data corresponding to the target cell is processed to obtain the data processing result corresponding to the target cell; the cell data of each target cell is replaced with the data processing result corresponding to the target cell to obtain the initial report after data replacement; based on the initial report after data replacement, a financial regulatory report is generated. By applying the method provided by the embodiment of the present invention, a financial regulatory report can be generated through the table file and data file set imported by the user. By parsing the initial report in the table file, the platform can obtain the business rules associated with the financial regulatory data indicators to be processed, and then obtain the required data from the data file for data processing to obtain the corresponding financial regulatory data indicators, which are then filled into the corresponding cells of the initial report, that is, the data of the cells recording the business rules in the initial report are replaced with the financial regulatory data indicators processed based on the business rules. Business personnel can design the initial table according to the report requirements of financial regulatory data, and enter the corresponding business rules based on the data description language for the cells that need to record the financial regulatory data indicators to be processed. When the content requirements of the financial regulatory report change, the business personnel only need to update the content of the initial report according to the requirements, and the platform can generate a financial regulatory report that meets the requirements based on the updated initial report. Business adjustments are less time-consuming and more efficient, and can flexibly adapt to changes in the requirements of financial regulatory reports. Secondly, the business rules in the initial report are defined in a data description language. Business personnel only need to set business rules based on the business caliber of the financial regulatory data indicators they have mastered and based on natural language expressions, which can improve the convenience of business work. In addition, the report generation process can be processed by local devices, without the need to build a traditional business system, and the cost of business development and operation and maintenance is low.

[0086] exist Figure 1 Based on the method shown, Figure 3As shown, in the method provided by the embodiment of the present invention, the process of determining at least one target cell in each cell of the initial report mentioned in step S103 includes:

[0087] S201: Determine whether the user has specified a cell range to be processed;

[0088] In the method provided by the embodiment of the present invention, the user can pre-specify the cell range in the initial report that needs to be processed and records the business rules through the report generation system.

[0089] When determining the target cell, the processor may first determine whether the user has specified a cell range to be processed for the current initial report.

[0090] S202: Determine the target cell range specified by the user;

[0091] In the method provided by the embodiment of the present invention, if the user has specified a cell range to be processed, the target cell range specified by the user is determined. For example, the target cell range can be set by the values ​​or value ranges of the row and column numbers of the cells.

[0092] S203: Determine, among the cells of the initial report, cells that match the target cell range;

[0093] In the method provided by the embodiment of the present invention, matching cells are searched in each cell of the initial report through the target cell range. For example, the cell row number and column number in the target cell range can be used to select the cells in each cell of the initial report that match the specified cell row number and column number as the cells that match the target cell range.

[0094] S204: taking cells matching the target cell range as the target cells.

[0095] In the method provided by the embodiment of the present invention, each cell matching the target cell range is used as the target cell.

[0096] Based on the method provided in the embodiment of the present invention, the user can specify the cells that need to be processed in the initial report, that is, the cells where the financial regulatory data indicators that currently need to be processed based on business rules are located can be specified, which is conducive to meeting the user's personalized data processing needs and further improving the user experience.

[0097] On the basis of the method provided in the above embodiment, the method provided in the embodiment of the present invention further includes:

[0098] S205: for each cell of the initial report, determining whether the cell meets a preset parsing condition;

[0099] In the method provided by the embodiment of the present invention, a parsing condition for identifying whether a cell needs to be parsed can be preset. For example, the presence of content described in a specific data description language in the cell data can be used as a parsing condition.

[0100] In the method provided by the embodiment of the present invention, in the process of determining the target cell, if the user does not specify the cell range to be processed, the cell data of each cell of the initial report is traversed to determine whether each cell identification meets the preset parsing condition.

[0101] S206: taking the cells in the initial report that meet the parsing condition as the target cells.

[0102] In the method provided by the embodiment of the present invention, in the process of traversing each cell, if the current cell meets the parsing condition, the cell is used as the target cell, so that all cells meeting the parsing condition in the initial report are used as the target cells.

[0103] Based on the method provided by the embodiment of the present invention, the cells to be processed in the initial report can be automatically identified, that is, the cells where the financial regulatory data indicators that need to be processed based on business rules are located. Users can also realize the automatic generation of financial regulatory reports without specifying cells, which is conducive to improving the convenience of work.

[0104] exist Figure 1 On the basis of the method shown, in the method provided by the embodiment of the present invention, the process of determining the target data file in the data file set based on the data screening rule corresponding to the target cell mentioned in step S106 includes:

[0105] Determine a data source identifier corresponding to the data screening rule;

[0106] In the method provided by the embodiment of the present invention, the corresponding data source identifier can be determined by identifying the content of the data screening rule. For example, if the data screening rule contains keywords of the source file, such as keywords of the file name, the keywords representing the source file are used as the data source identifier. If the keywords of the source file are not mentioned in the data screening rule, the key fields of the required source data (that is, the data to be searched) can be used as the data source identifier.

[0107] Determining whether each of the data files matches the data source identifier;

[0108] The data file matching the data source identifier is used as the target data file.

[0109] In the method provided by the embodiment of the present invention, the file information related to each data file can be compared with the data source identifier according to the meaning represented by the data source identifier to identify whether each data file matches the data source identifier. For example, if the data source identifier is a keyword of the source file, then the file name of each data file is matched with the data source identifier, that is, whether there is content identical to the data source identifier in the file name is identified. If the file name of the data file matches the data source identifier, then the data file is considered to match the data source identifier. If the data source identifier is a keyword of the source data, then the data content of the data file can be matched with the data source identifier to identify whether the data corresponding to the data source identifier is recorded in the data file. If the data content of the data file matches the data source identifier, then the data file is considered to match the data source identifier. Finally, the data file that matches the data source identifier is used as the target data file.

[0110] It should be noted that, in a specific implementation process, there may be only one data source identifier or there may be multiple data source identifiers. If there are multiple data source identifiers, their corresponding target data files may be determined respectively.

[0111] exist Figure 1 On the basis of the method shown, in the method provided by the embodiment of the present invention, the process of determining each source data corresponding to the target cell based on the target data file mentioned in step S106 includes:

[0112] Determine a target binary file corresponding to the target data file; the target binary file is a binary file obtained by performing file format conversion on the target data file;

[0113] In the method provided by the embodiment of the present invention, the report generation system can convert the imported data files into binary files in advance.

[0114] In the process of determining each source data corresponding to the target cell, a binary file obtained by performing file format conversion on the target data file may be obtained, and the binary file may be used as the target binary file.

[0115] Determine a data access expression corresponding to the data screening rule;

[0116] In the method provided by the embodiment of the present invention, a data access expression for accessing a file can be constructed based on a data screening rule to perform data retrieval in the file.

[0117] Based on the data access expression, data is screened in the target binary file to obtain data of each file;

[0118] The respective file data are used as respective source data corresponding to the target cell.

[0119] In the method provided by the embodiment of the present invention, based on the data access expression, the file data meeting the data condition is screened in the target binary file to obtain the screened file data, and the screened file data is used as the source data corresponding to the current target cell.

[0120] exist Figure 1 On the basis of the method shown, the method provided in the embodiment of the present invention further includes:

[0121] In the case where a rule check is required for the table file, determining each business rule recorded in the initial report;

[0122] In the method provided by the embodiment of the present invention, the report generation system can perform automatic rule checking on the table file after the user imports the table file, or the user can trigger the corresponding function control through the front-end interface and send an instruction to instruct the table file to perform rule checking.

[0123] When the processor determines that a rule check needs to be performed on the spreadsheet file, the processor may parse the data of each cell of the initial report to determine the various business rules recorded therein.

[0124] According to the preset rule checking strategy, each business rule recorded in the initial report is checked to obtain the rule checking result corresponding to the table file.

[0125] In the method provided in the embodiment of the present invention, a rule check can be performed on each business rule recorded in the initial report according to a preset rule detection strategy. For example, it can be checked whether the business vocabulary in the business rule is incorrect, etc., to obtain the detection result of each business rule. The detection results of each business rule constitute the rule check result corresponding to the table file.

[0126] Based on the method provided in the embodiment of the present invention, rule detection can be performed on the initial report pre-set by the user, assisting the user to find out whether the setting of business rules is accurate, which is conducive to improving the execution reliability of the financial regulatory report generation process and can further improve the user experience.

[0127] exist Figure 1 On the basis of the method shown, the method provided in the embodiment of the present invention further includes:

[0128] The log data is collected in real time, the operation is monitored through the log data, and the log data is recorded.

[0129] In the method provided by the embodiment of the present invention, in the process of generating financial regulatory reports in response to instructions, log data generated by each operation can be collected in real time, and by analyzing the log data, it is monitored whether there are abnormal operations. At the same time, the log data can be recorded to facilitate log auditing.

[0130] Based on the method provided in the embodiment of the present invention, operations can be monitored in real time through log data, which is conducive to timely discovering abnormal behaviors and then ensuring the security of the data processing process.

[0131] In order to better illustrate the method provided by the embodiment of the present invention, based on the methods provided by the previous embodiments and in combination with actual application scenarios, the embodiment of the present invention provides another method for generating financial regulatory reports. The method provided by the embodiment of the present invention is applied to the file generation scenario of financial regulatory reports. Financial regulatory reports are statistical reports submitted in accordance with the form, content, time and other requirements specified by financial regulatory agencies. The method provided by the embodiment of the present invention can be implemented based on a report generation system, and the deployment of the report generation system can be specifically implemented by executable files and configuration files, and the system can be run locally.

[0132] In the embodiment of the present invention, business personnel can design the report format according to the requirements, and define the corresponding business rules using the data description language for the financial regulatory data indicators that need to be processed, so as to edit the initial report of the financial regulatory data report to be generated. The report file and the source data file of the initial report are provided to the system, and these files can be Excel format files or other types of table files.

[0133] The system can convert a large number of source data files containing basic business data into binary files that can be quickly recognized by Pandas, and then use semantic recognition to identify the rule definitions in the initial report, dynamically organize them into data processing conditions through relevance and similarity, and after the file legality check is passed, perform data processing based on the data processing conditions, and fill the financial regulatory data indicators obtained from the data processing into the corresponding positions in the initial report. After adjusting the format of the report, the final financial regulatory report is output.

[0134] The specific implementation of the method provided by the embodiment of the present invention mainly includes processes such as rule definition, rule checking and data generation.

[0135] Rule definition: Business personnel use language and business vocabulary to describe the business rules corresponding to the financial regulatory data indicators of the financial regulatory report, that is, the business caliber, which can specifically include data sources, data conditions, statistical dimensions and methods, etc. Business personnel directly design the format and describe the business rules in the report, which is intuitive and easy to operate, and does not require special training and learning costs.

[0136] The report prepared by the business personnel can be shown as follows Figure 2 As shown, the system has no restrictions on the report format, content, and distribution of cells that need to calculate data. The cells that need to calculate data can be defined using a data description language, and the system automatically identifies, calculates, and fills them.

[0137] Rule check: The system can perform basic checks on the format and business scope of source data files and preprocess them into binary files. It can also test reports designed by business personnel to check whether the business rules defined therein have incorrect business vocabulary and data source business scope.

[0138] Data generation: For the cells that define business rules in the initial report that business personnel can provide, data processing is performed based on the business rules and source data files to obtain the corresponding financial regulatory data indicators, and the business rules in the cells are replaced with the corresponding financial regulatory data indicators. Then the data format in the report is unified and the final report is exported as a financial regulatory report. Business personnel can obtain a report that has been processed based on business rules and filled with corresponding financial regulatory data indicators based on the report they designed.

[0139] Furthermore, a log monitoring module can be deployed in the system provided by the embodiment of the present invention to monitor data processing events and abnormal behaviors in the operation of the system, and record relevant logs for auditing. This is conducive to ensuring the security of the data processing flow of the system, timely discovering and responding to potential data anomalies, abnormal operation of the operation flow and illegal behaviors, and maintaining the accuracy and efficiency of data processing.

[0140] The method provided in the embodiment of the present invention designs a description language for specific financial indicators, data operations and calculation logic applicable to the field of financial regulatory reports. Such a language includes specific grammatical and semantic rules, and can accurately implement the needs and operations in the field of financial regulatory data processing. After the system receives the report request submitted by the business personnel, it can automatically identify the business phrases, operators and field values ​​in each cell and construct a data access expression. According to the business rules, multi-source data can be quickly processed and financial regulatory reports can be generated with one click.

[0141] In the embodiment of the present invention, business personnel can directly submit various source data files to the system, and directly use data files such as XLS, XLSX, CSV, TXT, DAT, etc. The system can automatically convert data files into binary files that meet the data processing requirements. Binary data files can be directly loaded during data processing without using a database method, which can reduce database maintenance, data import and other links. The reports prepared by business personnel can naturally serve as notes for each data, and no separate annotations are required.

[0142] Based on the method provided by the embodiment of the present invention, business rules are defined in the financial regulatory data language, which can effectively explain the various elements of the business rules, including names, business rule descriptions, expressions, data processing dimensions, etc., and make business rules independent of data and programs. Data indicators can be conveniently described through centralized management, so that the use system is truly oriented to field business personnel. Business personnel only need to use industry terms and operation symbols to write business rules. The system generates the required financial regulatory reports through the business rules in the initial report submitted by the business personnel. When the content requirements of the financial regulatory report change, the business personnel only need to adjust the content of the initial report as needed, without the need to redevelop the system, which can effectively improve the flexibility of business adjustments. In addition, the system provided by the embodiment of the present invention can be run by local devices, the system architecture is simple, and the development and operation and maintenance costs of the system are low.

[0143] and Figure 1 Corresponding to the method for generating a financial regulatory report shown in FIG. 1 , an embodiment of the present invention further provides a device for generating a financial regulatory report, for Figure 1 The specific implementation of the method shown in is shown in the structural diagram Figure 4 As shown, including:

[0144] The file acquisition unit 301 is used to acquire the table file and the data file set imported by the user from the local storage space when receiving the instruction to generate the report; the data file set includes at least one data file;

[0145] The table reading unit 302 is used to read the content of the table file to obtain an initial report corresponding to the table file; the initial report is a report set according to the data report requirements of financial regulatory data;

[0146] A first determining unit 303 is used to determine at least one target cell in each cell of the initial report; each of the target cells corresponds to each financial regulatory data indicator to be processed;

[0147] A rule acquisition unit 304 is used to acquire, for each of the target cells, a business rule defined based on a data description language from the current cell data, and use the business rule as the business rule corresponding to the target cell, wherein the business rule represents the business scope of the financial regulatory data indicator corresponding to the target cell;

[0148] A rule parsing unit 305 is used to perform data parsing on the business rules corresponding to each of the target cells to obtain data screening rules and data processing rules corresponding to each of the target cells;

[0149] A second determining unit 306 is configured to determine, for each of the target cells, a target data file in the data file set based on a data screening rule corresponding to the target cell, and determine each source data corresponding to the target cell based on the target data file;

[0150] A data processing unit 307 is used to process each source data corresponding to each target cell based on a data processing rule corresponding to the target cell to obtain a data processing result corresponding to the target cell;

[0151] A data replacement unit 308, used to replace the cell data of each target cell with the data processing result corresponding to the target cell, so as to obtain an initial report after data replacement;

[0152] The report generation unit 309 is used to generate a financial regulatory report corresponding to the instruction based on the initial report after data replacement.

[0153] By applying the device provided by the embodiment of the present invention, a financial regulatory report can be generated through a table file and a data file set imported by a user. The platform can obtain the business rules associated with the financial regulatory data indicators to be processed by parsing the initial report in the table file, and obtain the required data from the data file for data processing to obtain the corresponding financial regulatory data indicators, which are filled into the corresponding cells of the initial report, that is, the data of the cells recording the business rules in the initial report are replaced with the financial regulatory data indicators processed based on the business rules. Business personnel can design the initial table according to the report requirements of the financial regulatory data, and enter the corresponding business rules based on the data description language for the cells that need to record the financial regulatory data indicators to be processed. When the content requirements of the financial regulatory report change, the business personnel only need to update the content of the initial report according to the requirements, and the platform can generate a financial regulatory report that meets the requirements based on the updated initial report. The business adjustment is less time-consuming and more efficient, and can flexibly adapt to the changes in the requirements of the financial regulatory report. Secondly, the business rules in the initial report are defined in a data description language, and the business personnel only need to set the business rules based on the business caliber of the financial regulatory data indicators they have mastered and based on the expression of natural language, which can improve the convenience of business work. In addition, the report generation process can be handled by local devices, without the need to build a traditional business system, and the cost of business development and operation and maintenance is low.

[0154] exist Figure 4 Based on the device shown, the device provided by the embodiment of the present invention can be further expanded into multiple units. The function of each unit can refer to the description of each embodiment provided in the above-mentioned method for generating financial regulatory reports, and no further examples will be given here.

[0155] An embodiment of the present invention further provides a storage medium, which includes stored instructions, wherein when the instructions are executed, the device where the storage medium is located is controlled to execute the above-mentioned method for generating financial regulatory reports.

[0156] The embodiment of the present invention further provides an electronic device, the structural diagram of which is shown in FIG. Figure 5 As shown, it specifically includes a memory 401 and one or more instructions 402, wherein the one or more instructions 402 are stored in the memory 401 and are configured to be executed by one or more processors 403 to perform the following operations:

[0157] When receiving an instruction to generate a report, obtaining a table file and a data file set imported by a user from a local storage space; the data file set includes at least one data file;

[0158] Read the content of the table file to obtain an initial report corresponding to the table file; the initial report is a report set according to the data report requirements of financial regulatory data;

[0159] In each cell of the initial report, at least one target cell is determined; each of the target cells corresponds to each financial regulatory data indicator to be processed;

[0160] For each of the target cells, a business rule defined based on a data description language is obtained from the current cell data, and the business rule is used as the business rule corresponding to the target cell, wherein the business rule represents the business scope of the financial regulatory data indicator corresponding to the target cell;

[0161] Performing data analysis on the business rules corresponding to each of the target cells to obtain data screening rules and data processing rules corresponding to each of the target cells;

[0162] For each of the target cells, based on the data screening rule corresponding to the target cell, a target data file is determined in the data file set, and each source data corresponding to the target cell is determined based on the target data file;

[0163] For each of the target cells, based on the data processing rule corresponding to the target cell, data processing is performed on each source data corresponding to the target cell to obtain a data processing result corresponding to the target cell;

[0164] Replacing the cell data of each target cell with the data processing result corresponding to the target cell to obtain an initial report after data replacement;

[0165] Based on the initial report after data replacement, a financial regulatory report corresponding to the instruction is generated.

[0166] Each embodiment in this specification is described in a progressive manner, and the same or similar parts between the embodiments can refer to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the system or system embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can refer to the partial description of the method embodiment. The system and system embodiments described above are merely schematic, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Ordinary technicians in this field can understand and implement it without creative work.

[0167] Professionals may further appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in the above description according to function. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professionals and technicians may use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.

[0168] The above description of the disclosed embodiments enables one skilled in the art to implement or use the present invention. Various modifications to these embodiments will be apparent to one skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present invention. Therefore, the present invention will not be limited to the embodiments shown herein, but rather to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for generating a financial regulatory report, characterized in that: include: When receiving an instruction to generate a report, obtaining the table file and data file set imported by the user from the local storage space; The data file set includes at least one data file; Read the content of the table file to obtain an initial report corresponding to the table file; The initial report is a report set according to the data report requirements of financial regulatory data; In each cell of the initial report, at least one target cell is determined; each of the target cells corresponds to each financial regulatory data indicator to be processed; For each of the target cells, a business rule defined based on a data description language is obtained from the current cell data, and the business rule is used as the business rule corresponding to the target cell, wherein the business rule represents the business scope of the financial regulatory data indicator corresponding to the target cell; Performing data analysis on the business rules corresponding to each of the target cells to obtain data screening rules and data processing rules corresponding to each of the target cells; For each of the target cells, based on the data screening rule corresponding to the target cell, a target data file is determined in the data file set, and each source data corresponding to the target cell is determined based on the target data file; For each of the target cells, based on the data processing rule corresponding to the target cell, data processing is performed on each source data corresponding to the target cell to obtain a data processing result corresponding to the target cell; Replacing the cell data of each target cell with the data processing result corresponding to the target cell to obtain an initial report after data replacement; Based on the initial report after data replacement, a financial regulatory report corresponding to the instruction is generated.

2. The method for generating a financial regulatory report according to claim 1, characterized in that: Determining at least one target cell in each cell of the initial report includes: Determine whether the user has specified a cell range to be processed; If the user has specified a cell range to be processed, determining a target cell range specified by the user; Determine, among the cells of the initial report, cells that match the target cell range; A cell matching the target cell range is used as the target cell.

3. The method for generating a financial regulatory report according to claim 2, characterized in that: Also includes: If the user does not specify a cell range to be processed, then for each cell of the initial report, determining whether the cell meets the preset parsing condition; The cells in the initial report that meet the parsing condition are used as the target cells.

4. The method for generating a financial regulatory report according to claim 1, characterized in that: The step of determining a target data file in the data file set based on the data screening rule corresponding to the target cell includes: Determine a data source identifier corresponding to the data screening rule; Determining whether each of the data files matches the data source identifier; The data file matching the data source identifier is used as the target data file.

5. The method for generating a financial regulatory report according to claim 1, characterized in that: The determining, based on the target data file, each source data corresponding to the target cell includes: Determine a target binary file corresponding to the target data file; the target binary file is a binary file obtained by performing file format conversion on the target data file; Determine a data access expression corresponding to the data screening rule; Based on the data access expression, data is screened in the target binary file to obtain data of each file; The respective file data are used as respective source data corresponding to the target cell.

6. The method for generating a financial regulatory report according to claim 1, characterized in that: Also includes: In the case where a rule check is required for the table file, determining each business rule recorded in the initial report; According to the preset rule checking strategy, each business rule recorded in the initial report is checked to obtain the rule checking result corresponding to the table file.

7. The method for generating a financial regulatory report according to claim 1, characterized in that: Also includes: The log data is collected in real time, the operation is monitored through the log data, and the log data is recorded.

8. A device for generating financial regulatory reports, characterized in that: include: A file acquisition unit, configured to acquire a table file and a data file set imported by a user from a local storage space when receiving an instruction to generate a report; the data file set includes at least one data file; A table reading unit, used to read the content of the table file to obtain an initial report corresponding to the table file; The initial report is a report set according to the data report requirements of financial regulatory data; A first determination unit is used to determine at least one target cell in each cell of the initial report; each of the target cells corresponds to each financial regulatory data indicator to be processed; A rule acquisition unit, configured to acquire, for each of the target cells, a business rule defined based on a data description language from the current cell data, and use the business rule as the business rule corresponding to the target cell, wherein the business rule represents the business scope of the financial regulatory data indicator corresponding to the target cell; A rule parsing unit, used to perform data parsing on the business rules corresponding to each of the target cells, and obtain data screening rules and data processing rules corresponding to each of the target cells; A second determining unit is used to determine, for each of the target cells, a target data file in the data file set based on a data screening rule corresponding to the target cell, and determine each source data corresponding to the target cell based on the target data file; A data processing unit, configured to perform data processing on each source data corresponding to each target cell based on a data processing rule corresponding to the target cell, to obtain a data processing result corresponding to the target cell; A data replacement unit, used to replace the cell data of each target cell with the data processing result corresponding to the target cell, so as to obtain an initial report after data replacement; A report generation unit is used to generate a financial regulatory report corresponding to the instruction based on the initial report after data replacement.

9. A storage medium, characterized in that: The storage medium includes stored instructions, wherein when the instructions are executed, the device where the storage medium is located is controlled to execute the method for generating financial regulatory reports according to any one of claims 1 to 7.

10. An electronic device, characterized in that: It comprises a memory and one or more instructions, wherein the one or more instructions are stored in the memory and are configured to be executed by one or more processors to perform the method for generating financial regulatory reports as described in any one of claims 1 to 7.

Images