Report data generating method and system

[0033] Example one

[0034] The embodiment of the present invention provides a method for generating report data, figure 1 Is a flowchart of a method for generating report data according to an embodiment of the present invention, such as figure 1 As shown, the report data generation method includes:

[0035] Data source configuration step 101: Create or modify a data source, and set data source information and database connection information in the data source;

[0036] Unit mapping configuration step 102: Set report unit information and accounting unit information, and configure unit mapping information according to the data source, report unit information and accounting unit information;

[0037] Financial extraction formula scheme configuration step 103: select a financial extraction formula scheme and report according to the report instance, and generate a financial extraction formula according to the selected financial extraction formula scheme and report;

[0038] Data extraction step 104: Receive access conditions including business plan, year, period, unit range, and report range selected by the user, and the financial extraction selected from the financial extraction formula scheme according to the access conditions for data extraction The formula scheme extracts data according to the access conditions and the financial extraction formula scheme used for data extraction, fills in the reports in the report range, and generates report data.

[0039] As can be seen from the above description, in the embodiment of the present invention, after configuring the relevant data source, mapping relationship, and financial extraction formula for the report, extract data from the report according to the configured information, and fill the data into the report. . With the aid of the above process, the embodiment of the present invention can realize the docking of report data and financial data without the need for development and joint debugging of both parties, thereby simplifying the process of docking report data and financial data.

[0040] The specific implementation process of each step of the method for generating report data in the embodiment of the present invention will be described in detail below with reference to the accompanying drawings.

[0041] figure 2 It is a flowchart of the data source configuration steps according to the embodiment of the present invention. As described above, the data source configuration step 101 includes: creating or modifying a data source, and setting data source information and database connection information in the data source. Such as figure 2 As shown, in specific implementation, the data source configuration step 101 of the embodiment of the present invention includes: creating, modifying, or deleting a data source, and setting data source information and database connection information, thereby realizing the configuration process of the data source, It is used to maintain the accounting data source used in data extraction and perspective query. In a preferred embodiment, the process of setting the data source is that the data source can be set and maintained according to different database types, accounting software types, and accounting software versions. The setting of database connection information includes selecting or setting the IP address, name and other information of the database. At the same time, in the embodiment of the present invention, the connection test function can also be used to test whether the current database connection information is correct, that is, whether it can be connected to the database. If the test result is that it can be connected to the database, it means that the connection is passed and the data source configuration process is completed; if the test result is that it cannot be connected to the database, it means that there is a problem with the connection. You need to reset the database connection information and perform the connection function again. Test until the test result shows that it can communicate with the database.

[0042] image 3 It is a flowchart of the unit mapping configuration steps according to the embodiment of the present invention. As described above, the unit mapping configuration step 102 includes: setting report unit information and accounting unit information, and configuring unit mapping according to the data source, report unit information and accounting unit information information. Such as image 3 As shown, in the specific implementation, the unit mapping configuration step 102 of the embodiment of the present invention is to set the report unit information and accounting unit information, and select the data source (accounting data source) configured in the above data source configuration step 101 , Realize the setting of the mapping relationship between the report unit information and the accounting unit information, thereby establishing new unit mapping information (for example, the name and unit code of the report unit correspond to the name and code of the accounting unit), or It is to modify the existing unit mapping information, or delete some existing unit mapping information that is not used in this data extraction process, so as to ensure the accuracy of the unit mapping information in the subsequent data extraction process Sex. In a preferred embodiment, the process of configuring unit mapping information also includes: maintaining data sources for access and perspective queries, financial extraction formula schemes used in access and perspective queries, and other affiliates closely related to accounting data information.

[0043] Figure 4 It is a flowchart of the configuration steps of the financial extraction formula scheme according to the embodiment of the present invention. As described above, the financial extraction formula scheme configuration step 103 includes: selecting the financial extraction formula scheme and report according to the report instance, and according to the selected financial extraction formula scheme And report generation financial extraction formula. Such as Figure 4 As shown, in the specific implementation, the financial extraction formula scheme configuration step 103 of the embodiment of the present invention is to first create a new financial extraction formula scheme according to the target of data extraction in this report, or modify an existing financial extraction formula scheme, or delete Some financial extraction formulas that have nothing to do with the data extraction of this report. The process of establishing a new financial extraction formula scheme or modifying an existing financial extraction formula scheme includes: First, select the report instance related to this data extraction, and select the corresponding financial extraction formula scheme according to the report instance , And then choose which report to describe financially. After completing the selection of the above-mentioned corresponding information, generate the financial extraction formula according to the above-mentioned selection. The process of generating a financial extraction formula specifically includes: creating one or more financial extraction formulas to meet the requirements for financial description of the selected report; or modifying the original financial extraction formula to meet the financial description of the selected report. Description requirements; or create a new part of the financial extraction formula, and modify the other part of the financial extraction formula to meet the requirements for financial description of the selected statement. In the process of creating or modifying the financial extraction formula, some financial extraction formulas that do not meet the requirements for financial description of the selected report may be deleted according to the situation.

[0044] The financial extraction formula scheme configuration realizes the process of configuring the financial extraction formula according to different formula schemes. When extracting financial data, users can select different formula schemes according to the unit to adapt to inconsistent accounting calibers such as inconsistent accounting subjects.

[0045] After the above steps, the process of configuring the data source, unit mapping information and financial extraction formula scheme is completed, which is ready for the actual financial data extraction. In the following, the process of extracting financial data is described in detail.

[0046] Figure 5 It is a flowchart of the data extraction step according to the embodiment of the present invention. As described above, the data extraction step 104 includes: receiving the access conditions selected by the user including the business plan, year, period, unit range, and report range, and according to the said Access conditions The financial extraction formula scheme for data extraction selected from the financial extraction formula schemes, extract data according to the access conditions and the financial extraction formula scheme for data extraction, and fill in the report range Report to generate report data. Such as Figure 5 As shown, in the specific implementation, the data extraction step 104 of the embodiment of the present invention is the process of extracting data from the report. First, some basic information of the report needs to be determined, such as: business plan, year, period, and unit range. Information is determined according to the user's choice. After the user selects and sets the above information, it is also necessary to determine the scope of the report for data extraction, so that the user can select the report for data extraction and fill in the report scope. In the embodiment of the present invention, the conditions including the above-mentioned business plan, year, period, unit range, and report range are defined as access conditions.

[0047] After determining the access conditions, the user can select the financial extraction formula scheme for this data extraction from the financial extraction formula schemes configured in step 103 above. In step 104 of the embodiment of the present invention, the access conditions selected by the user and the financial extraction formula scheme for data extraction are received.

[0048] In a preferred embodiment, the user can also select whether the current data extraction includes data that has not been booked in the current period in the accounting system while selecting the financial extraction formula scheme.

[0049] In a preferred embodiment, before starting data extraction, it can also include a step of judging data extraction authority, that is, to determine whether a certain report user has the authority to perform the data extraction step, only if the user has the authority to perform the data extraction step If the user does not have permission to perform the data extraction step, it will only be prompted that he has no permission.

[0050] After receiving the access conditions and financial extraction formulas related to data extraction, the actual data extraction step is carried out, and the extracted data is filled into the report selected by the user to generate the report data.

[0051] In a preferred embodiment, during data extraction, the extracted data can also be judged, whether the data extraction is successful, and the corresponding judgment result is displayed.

[0052] So far, the process of extracting data from the report and generating report data is completed.

[0053] In summary, the method for generating report data according to the embodiment of the present invention simplifies the process of connecting report data and financial data, and improves the efficiency of data extraction.

[0054] In practical applications, in the data extraction process of step 104, each time the data is extracted, it is necessary to select the access conditions and the financial formula extraction plan, and then perform the data extraction step separately. It can be seen that when a larger amount of data needs to be processed When reporting information, if data extraction is still performed according to the above step 104, the operation steps are cumbersome, the workload is large, and the efficiency is low.

[0055] Therefore, in order to improve the efficiency of data extraction and reduce the waiting time of users, the embodiment of the present invention also provides a planned task data extraction step 105. Figure 6A and Figure 6B Is a flowchart of the steps of extracting planned task data according to an embodiment of the present invention, such as Figure 6A and Figure 6B As shown, the planned task data extraction step 105 includes: receiving the name of the planned task, the planned execution time and the planned execution frequency set by the user; receiving the access conditions set by the user and the selection from the financial extraction formula scheme according to the access conditions Financial extraction formula plan for data extraction; extract data according to plan execution time, plan execution frequency, access conditions and financial extraction formula plan for data extraction, fill in the reports in the report range, and generate report data.

[0056] In the planned task data extraction step 105 of the embodiment of the present invention, it is possible to receive the user’s setting of the name, execution time and execution frequency of the planned task according to actual application conditions. , Unit range, and report range access conditions, and receive the corresponding financial extraction formula plan set by the user. It should be noted that although in the embodiment of the present invention, the setting of the name, execution time, and execution frequency of the receiving scheduled task is described first, it is not used to limit the setting of the access conditions of the receiving user and the corresponding settings. The sequence of setting the financial extraction formula scheme. In practical applications, the user can also first set the access conditions and the corresponding financial extraction formula scheme, and then set the planned task name, execution time and execution frequency, which is one of the two In theory, the time can be performed simultaneously, and there is no restriction on the sequence. In the embodiment of the present invention, only the actual operation of the user when setting the above information is considered, and the description is described in the sequence. After receiving the above settings made by the user, you can automatically complete the data extraction, fill in the report, and generate the data according to the financial extraction formula plan according to the execution time and execution frequency set by the user, and in the case of meeting the set access conditions Report data. It can be seen that through the data extraction step of the planned task, a large number of report data extraction processes can be set, and data extraction can be completed automatically, which simplifies the operation steps, reduces the workload of data extraction, and improves efficiency.

[0057] It should be noted that in the data extraction step 105 of the planned task, in the access conditions set by the user, the units included in the unit range and the reports included in the report range may be one or more. When there are multiple reports, in the actual data extraction process, multiple units and multiple reports need to be divided into a single report of a single unit before data extraction. So as to ensure one-to-one correspondence between reports and unit information, avoiding confusion.

[0058] In a preferred embodiment, during data extraction, the extracted data can also be judged, whether the data extraction is successful, and the corresponding judgment result is displayed.

[0059] In addition to generating corresponding report data according to report information, the report data generation method of the embodiment of the present invention can also perform perspective query on the report in the access conditions selected by the user, and can perform perspective query on real-time data in different accounting databases. The corresponding detailed information realizes accurate grasp and monitoring of financial data.

[0060] The perspective query step is a process of thoroughly analyzing a certain report that meets the access conditions set by the user based on the configuration of the above data source, unit mapping, and financial extraction formula.

[0061] Figure 7 Is a flowchart of the perspective query steps according to an embodiment of the present invention, such as Figure 7 As shown, the perspective query steps include:

[0062] Step a: Determine whether the unit in the unit range is a summary unit; the perspective query process is to realize the process of displaying the corresponding subject detailed information for the indicators in the report. Therefore, for each condition, you need to query the specific After basic information (such as: grassroots units), query the basic information, and finally display the corresponding detailed information. The summary unit generally refers to the upper-level unit information of, for example, a group or a higher-level management unit. Therefore, to implement the perspective query step of the present invention, it is first necessary to determine whether a unit within the unit range is a summary unit. When the unit is a non-aggregated unit, proceed to step b; when the unit is a summary unit, you need to receive the specific unit (non-aggregated unit) selected by the user first, and then proceed to step b.

[0063] Step b: When the unit is a non-summary unit, judge whether the index attribute of the report in the report scope is a calculation index; when it is determined in step a that the unit is a non-summary unit (ie, a basic unit), then the index in the report The attributes are judged. The indicators in the report are generally divided into calculated indicators and non-calculated indicators. Non-calculated indicators are specific indicator information required for perspective query, and calculated indicators are non-calculated indicators through certain calculations (such as +/-/×/÷ operations). , It should be noted that the calculation process here is to illustrate the definition of the calculation index, not to limit the specific calculation process. In practical applications, the calculation process of the calculation index obtained from the non-calculation index is not limited to the above +/-/ ×/÷ operation). Therefore, it is also necessary to judge the attributes of the indicators. When the indicator attribute is a non-computer indicator, proceed to step c. If the indicator attribute is a calculated indicator, you need to penetrate the indicator layer by layer to generate a non-calculated indicator, and then proceed to step c.

[0064] Step c: When the index attribute is a non-calculated index, display account detail information or auxiliary accounting detail information according to the subject nature of the non-calculated index, and generate accounting voucher information based on the account detail information or auxiliary accounting detail information. When it is determined that the unit is a non-summary unit, and the attribute of the indicator in the report is a non-calculated indicator, you can perform a perspective query based on the account nature of the non-calculated indicator, thereby displaying the information of the account balance table, the account details, and Generate accounting voucher information. Subjects can be divided into subjects without auxiliary accounting and subjects with auxiliary accounting according to their nature. According to the above division, account details or auxiliary accounting details can be displayed through perspective query.

[0065] The above-mentioned auxiliary accounting refers to the setting of accounts for more detailed accounting according to accounting items. However, accounting items are different from general detailed subjects. They are more flexible and convenient. An accounting item can be linked to multiple subjects. In addition, a single accounting item can be set for an accounting title, or multiple accounting items can be selected. For example, the accounts receivable can be set to both transaction accounting and department accounting at the same time to facilitate financial management.

[0066] In a preferred embodiment, before the perspective query is performed on the report, it may also include a step of determining the permissions of the perspective query, that is, to determine whether a certain report user has the permission to perform the perspective query step, only when the user has the permission to perform the perspective query The perspective query starts only when the step has the permission; if the user does not have the permission to execute the perspective query step, the perspective query is prohibited.

[0067] The above is the specific content and steps of the report data generation method of the embodiment of the present invention. Through the report data generation method, data integration and application in the true sense are provided, and while efficiently integrating data, it also allows financial related data The transformation from business data to management data has become easy, and its main advantages are:

[0068] (1) Provide a complete data traceability track through a complete metadata management mechanism;

[0069] (2) A unified export model of financial data has been realized, the data quality of the statements has been improved, the reporting workload of the grassroots units has been reduced, and the work efficiency has been improved;

[0070] (3) Through the perspective query of real-time financial data, the management and control of financial data has been greatly strengthened.

[0071] Example two

[0072] The embodiment of the present invention also provides a report data generation system, Picture 8 Is a schematic diagram of the structure of a report data generation system according to an embodiment of the present invention, such as Picture 8 As shown, the report data generation system includes: a data source configuration unit 1, a unit mapping configuration unit 2, a financial extraction formula scheme configuration unit 3, and a data extraction unit 4.

[0073] Data source configuration unit 1, used to create or modify a data source, and set the data source information and database connection information in the data source;

[0074] The embodiment of the present invention uses the data source configuration unit 1 to create, modify, or delete a data source, and set the data source information and database connection information, so as to realize the configuration process of the data source, which is used to maintain data extraction and perspective query. The source of the accounting data. In a preferred embodiment, the process of setting the data source is that the data source can be set and maintained according to different database types, accounting software types, and accounting software versions. The setting of database connection information includes selecting or setting the IP address, name and other information of the database. At the same time, in the embodiment of the present invention, the connection test function can also be used to test whether the current database connection information is correct, that is, whether it can be connected to the database. If the test result is that it can be connected to the database, it means that the connection is passed and the data source configuration process is completed; if the test result is that it cannot be connected to the database, it means that there is a problem with the connection. You need to reset the database connection information and perform the connection function again. Test until the test result shows that it can communicate with the database.

[0075] Unit mapping configuration unit 2, used to set report unit information and accounting unit information, and configure unit mapping information according to the data source, report unit information and accounting unit information;

[0076] The unit mapping configuration is to configure the report unit information and accounting unit information, and select the data source (accounting data source) configured by the above data source configuration unit 1, to realize the mapping relationship between the report unit information and the accounting unit information Make settings to create new unit mapping information (for example, the name of the report unit and its unit code correspond to the name and code of the accounting unit), or modify the existing unit mapping information, or delete some Existing unit mapping information, but not used in this data extraction process, so as to ensure the accuracy of the unit mapping information in the subsequent data extraction process. In a preferred embodiment, the process of configuring unit mapping information also includes: maintaining data sources for access and perspective queries, financial extraction formula schemes used in access and perspective queries, and other affiliates closely related to accounting data information.

[0077] The financial extraction formula scheme configuration unit 3 is used to select the financial extraction formula scheme and report according to the report instance, and generate the financial extraction formula according to the selected financial extraction formula scheme and the report;

[0078] In the embodiment of the present invention, the financial extraction formula scheme configuration unit 3 first creates a new financial extraction formula scheme according to the goal of this report data extraction, or modifies an existing financial extraction formula scheme, and deletes some that are irrelevant to this report data extraction Financial extraction formula scheme. The process of establishing a new financial extraction formula scheme or modifying an existing financial extraction formula scheme specifically includes: First, select the report instance related to this data extraction, and select the corresponding financial extraction formula scheme according to the report instance. Then select which report to perform financial description, and after completing the selection of the above-mentioned corresponding information, according to the above-mentioned selection, the financial extraction formula scheme configuration unit 3 generates a financial extraction formula. The process of generating financial extraction formulas includes: creating one or more financial extraction formulas to meet the requirements for financial description of the selected statements; or modifying the original financial extraction formulas to meet the financial requirements for the selected statements Description requirements; or create a new part of the financial extraction formula, and modify the other part of the financial extraction formula to meet the requirements for financial description of the selected statement. In the process of creating or modifying the financial extraction formula, some financial extraction formulas that do not meet the requirements for financial description of the selected report may be deleted according to the situation.

[0079] The embodiment of the present invention realizes the process of configuring the financial extraction formula according to different formula schemes through the financial extraction formula scheme configuration unit 3. When extracting financial data, the user can select different formula schemes according to the unit to adapt to, for example, the inconsistency of accounting subjects. Wait for inconsistent accounting calibers.

[0080] After the financial extraction formula scheme configuration unit 3 completes the configuration of the financial extraction formula scheme, it completes the process of configuring the data source, unit mapping information and the financial extraction formula scheme, which is ready for actual financial data extraction. Hereinafter, the above-mentioned data extraction unit 4 will be described in detail.

[0081] Picture 9 Is a schematic diagram of the structure of a data extraction unit according to an embodiment of the present invention, such as Picture 9 As shown, the data extraction unit 4 includes: an access condition and financial extraction formula plan receiving module 41 and a report data generating module 42.

[0082] Access conditions and financial extraction formula plan receiving module 41, used to receive the access conditions including business plan, year, period, unit range, and report range selected by the user, and extract from the financial formula plan according to the access conditions The selected financial extraction formula scheme for data extraction;

[0083] In the process of extracting data from a report, you first need to determine some basic information of the report, such as: business plan, year, period, and unit range, and this information is determined according to the user's choice. After the user selects and sets the above information, it is also necessary to determine the scope of the report for data extraction, so that the user can select the report for data extraction and fill in the report scope. In the embodiment of the present invention, the conditions including the above-mentioned business plan, year, period, unit range, and report range are defined as access conditions. In the embodiment of the present invention, the access condition selected by the user is received through the access condition and financial extraction formula plan receiving module 41. After determining the access conditions, the user can select the financial extraction formula scheme for this data extraction from the financial extraction formula schemes configured by the financial extraction formula scheme configuration unit 3 above.

[0084] In the embodiment of the present invention, the aforementioned access condition and financial extraction formula scheme receiving module 41 receives the aforementioned access condition selected by the user and the financial extraction formula scheme for data extraction.

[0085] In a preferred embodiment, the user can also select whether the current data extraction includes data that has not been booked in the current period in the accounting system while selecting the financial extraction formula scheme.

[0086] After the access conditions and financial extraction formula scheme receiving module 41 receives the access conditions and financial extraction formula schemes related to data extraction, the actual data extraction step is performed through the report data generation module 42, and the actual data extraction steps are performed according to the access conditions and usage. The financial extraction formula solution for data extraction extracts data, fills the extracted data into the report selected by the user, and generates report data.

[0087] In summary, the report data generation system of the embodiment of the present invention simplifies the process of connecting report data and financial data, and improves the efficiency of data extraction.

[0088] In practical applications, through the data extraction process completed by the above-mentioned data extraction unit 4, each time the data is extracted, it is necessary to select the access conditions and the financial formula extraction scheme, and then perform the data extraction steps separately. It can be seen that when necessary When processing a relatively large amount of report information, if data is still extracted by the aforementioned data extraction unit 4, the operation steps are cumbersome, the workload is relatively large, and the efficiency is low.

[0089] Therefore, in order to improve the efficiency of data extraction and reduce the waiting time of users, the report data generation system of the embodiment of the present invention further includes: a planned task data extraction unit 5, such as Picture 10 Shown. Picture 11 Is a structural diagram of a planned task data extraction unit according to an embodiment of the present invention, such as Picture 11 As shown, the planned task data extraction unit 5 includes: a planned task information receiving module 51, an access condition and financial extraction formula plan receiving module 52, and a report data generating module 53.

[0090] In the embodiment of the present invention, the planned task name, planned execution time, and planned execution frequency set by the user can be received through the planned task information receiving module 51; and the access conditions and financial extraction formula plan receiving module 52 can receive the user-set containing services The access conditions of the plan, year, period, unit range, and statement scope, and the financial extraction formula scheme selected from the financial extraction formula schemes according to the access conditions for data extraction. It should be noted that, although in the embodiment of the present invention, the scheduled task information receiving module 51 receives the scheduled task name, execution time, and execution frequency. The setting description is first, but it is not used to limit the relationship between access conditions and financial extraction formulas. The plan receiving module 52 receives the user's setting of access conditions and the sequence of setting the corresponding financial extraction formula plan. In practical applications, the user can also first set the access conditions and the corresponding financial extraction formula plan, and then Set the name of the planned task, the execution time and the execution frequency. The two can be carried out at the same time in theory, and there is no restriction on the sequence. In the embodiment of the present invention, it is only considered that the user actually sets the above information The operation conditions are described in order.

[0091] After receiving the above settings made by the user through the plan task information receiving module 51 and the access condition and financial extraction formula receiving module 52, the report data generation module 53 is used to meet the execution time and frequency set by the user. In the case of setting access conditions, data extraction is automatically completed according to the financial extraction formula scheme. It can be seen that through the data extraction step of the planned task, a large number of report data extraction processes can be set, and data extraction can be completed automatically, which simplifies the operation steps, reduces the workload of data extraction, and improves efficiency.

[0092] It should be noted that, in the access conditions set by the user received by the access conditions and financial extraction formula plan receiving module 52, the units included in the unit range and the reports included in the report range may be one or more. When there are multiple units and reports, in the actual data extraction process, multiple units and multiple reports need to be divided into single reports of a single unit before data extraction. So as to ensure one-to-one correspondence between reports and unit information, avoiding confusion.

[0093] The report data generation system of the embodiment of the present invention can not only generate corresponding report data according to the report information, but also perform perspective query on the reports in the access conditions selected by the user, and can perform perspective query on the real-time data in different accounting databases. The corresponding detailed information realizes accurate grasp and monitoring of financial data.

[0094] Picture 12 Is another structural diagram of the report data generation system according to the embodiment of the present invention, such as Picture 12 As shown, the report data generation system further includes: a perspective query unit 6.

[0095] Figure 13 Is a structural diagram of a perspective query unit according to an embodiment of the present invention, such as Figure 13 As shown, the perspective query unit 6 includes: a summary unit judgment module 61, an index attribute judgment module 62, an accounting voucher information generation module 63, and a non-calculation index generation module 64.

[0096] The summary unit judgment module 61 is used to judge whether the unit in the unit range is a summary unit; the perspective query process is to realize the process of displaying the corresponding subject detailed information for the indicators in the report. Therefore, for each condition , When you need to inquire specific basic information (such as: grassroots units), inquire about the basic information, and finally display the corresponding detailed information. The summary unit generally refers to the upper-level unit information of, for example, a group or a higher-level management unit. Therefore, to implement the perspective query step of the present invention, it is first necessary to determine whether a unit within the unit range is a summary unit.

[0097] The index attribute judgment module 62 is used to judge whether the index attribute of the report in the report scope is a calculation index; the premise for the index attribute judgment module 62 to judge the index attribute is: when the unit is judged by the summary unit judgment module 61 The judgment is only when it is a non-aggregated unit; and when the unit is a summary unit, it is necessary to first receive the specific unit (non-aggregated unit) selected by the user through the above access conditions and financial extraction formula program receiving module 41, and then make the judgment . The indicators in the report are generally divided into calculated indicators and non-calculated indicators. Non-calculated indicators are specific indicator information required for perspective query, and calculated indicators are non-calculated indicators through certain calculations (such as +/-/×/÷ operations). , It should be noted that the calculation process here is to illustrate the definition of the calculation index, not to limit the specific calculation process. In practical applications, the calculation process of the calculation index obtained from the non-calculation index is not limited to the above +/-/ ×/÷ operation). Therefore, it is also necessary to judge the attributes of the indicators. When the indicator attribute is a non-computer indicator, the accounting voucher information generation module 63 can be used for perspective query; if the indicator attribute is a calculated indicator, the non-calculated indicator generation module 64 needs to penetrate the indicator layer by layer. After generating the non-calculating index according to the calculated index, the perspective query is performed by the accounting voucher information generating module 63.

[0098] The accounting voucher information generating module 63 is configured to display subject detailed information or auxiliary accounting detailed information according to the subject nature of the non-calculating index, and generate accounting voucher information according to the subject detailed information or auxiliary accounting detailed information. When it is determined that the unit is a non-summary unit, and the attribute of the indicator in the report is a non-calculated indicator, you can perform a perspective query based on the account nature of the non-calculated indicator, thereby displaying the information of the account balance table, the account details, and Generate accounting voucher information. Subjects can be divided into subjects without auxiliary accounting and subjects with auxiliary accounting according to their nature. According to the above division, account details or auxiliary accounting details can be displayed through perspective query.

[0099] The above-mentioned auxiliary accounting refers to the setting of accounts for more detailed accounting according to accounting items. However, accounting items are different from general detailed subjects. They are more flexible and convenient. An accounting item can be linked to multiple subjects. In addition, a single accounting item can be set for an accounting title, or multiple accounting items can be selected. For example, accounts receivable (1131) can be set to both transaction accounting and department accounting at the same time to facilitate financial management.

[0100] The above is the specific content and steps of the report data generation method of the embodiment of the present invention. The report data generation system provides true data integration and application, and while efficiently integrating data, it also allows financial related data The transformation from business data to management data has become easy, and its main advantages are:

[0101] (1) Provide a complete data traceability track through a complete metadata management mechanism;

[0102] (2) A unified export model of financial data has been realized, the data quality of the statements has been improved, the reporting workload of the grassroots units has been reduced, and the work efficiency has been improved;

[0103] (3) Through the perspective query of real-time financial data, the management and control of financial data has been greatly strengthened.

[0104] The method and system for generating report data in the embodiment of the present invention will be specifically described below in conjunction with a specific embodiment.

[0105] In a preferred embodiment, the report data generation method and system of the present invention can be specifically applied to an enterprise financial data center (EFDC) system. The system structure diagram of the enterprise financial data center system is as follows Figure 14 Shown. The corporate financial data center system has a complete set of financial extraction formula systems built on abstract and in line with industry standard financial models. This formula system facilitates the realization of financial data modeling; and shields the accounting systems of different vendors and versions The difference simplifies the learning cost of users; through this formula system, the indicators in the reporting system or decision support system can be converted into the access rules for the accounting system, and the corporate financial data center system has a matching formula system Formula registration parser and formula management functions can form different formula schemes for different statistical analysis software. The specific financial extraction formula (access formula) is shown in Table 1:

[0106] Table I

[0107]

[0108]

[0109] The system management platform in the enterprise financial data center system includes six functions including organization mapping management, multiple data source management, financial extraction formula management, log management, user management, and system options. The corporate financial data center effectively manages the metadata required for corporate financial data integration through the system management platform to prepare for corporate financial data integration.

[0110] Figure 15 It is the overall flow chart of the report data processing of the enterprise financial data center system according to the embodiment of the present invention, such as Figure 15 As shown, the enterprise financial data center system completes management of the metadata related to financial data through multi-data source management, unit mapping management, financial extraction formula management, etc., for the automatic extraction and conversion of financial data, and perspective query for corporate financial affairs. The data integration application model has laid a solid foundation.

[0111] Multi-data source management (data source configuration), which is equivalent to the data source configuration steps in the embodiment of the present invention, is used to maintain the function of data extraction and the accounting data source used in the perspective query. Users can maintain data sources according to different database types, accounting software types, and accounting software versions in the multi-data source management, and can test whether the current connection information is correct through the connection test function.

[0112] Unit mapping management (unit mapping configuration), which is equivalent to the unit mapping information configuration step in the embodiment of the present invention, is used to maintain the unit (reporting unit) in the analysis and statistics system that calls the enterprise financial data center and the unit (accounting unit) in the accounting system ) Mapping relationship, access and perspective data sources, formula schemes used in access and perspective, and other ancillary information closely related to the accounting software.

[0113] Financial extraction formula management (financial extraction formula configuration), which is equivalent to the financial extraction formula scheme configuration step of the embodiment of the present invention, provides the function of describing the financial extraction formula for indicators in the statistical analysis system, and passes and performs the financial extraction formula according to Different formula schemes are managed, and users can select different formula schemes according to the unit when extracting financial data to adapt to the inconsistent accounting calibers such as inconsistent accounting subjects.

[0114] The data extraction function is equivalent to the data extraction step of the embodiment of the present invention. The authority management of the data extraction function is to judge whether a certain report user has the authority to use the data extraction function. If the user is not authorized to use the data extraction function, A prompt without permission is displayed.

[0115] In practical applications, as shown in the following table (Table 2), the enterprise financial data center system has a variety of accounting software adapters. Through these adapters, the enterprise financial data center system can realize data extraction and perspective query of a variety of mainstream accounting software. , And can be flexibly extended as needed.

[0116] Table II

[0117] Serial number

[0118] After the accounting data source, unit mapping, and financial extraction formula have been configured, the enterprise financial data center system begins to perform the data extraction function. The data extraction function is to convert the financial data from the business logic preset in the above accounting software adapter. The accounting system is extracted into the corporate financial data center system, and then processed into a specific format result through the conversion rules described in the financial extraction formula, and then provided to the statistical analysis system; the process of financial data extraction mainly includes: report scope selection function, financial Extract formula selection function and extract data function.

[0119] The report scope selection function is used to select the scope of the report extraction. The user can select which data report to extract this time by checking the form. The report selected here must use the same financial extraction formula scheme for data extraction:

[0120] The financial extraction formula scheme selection function is used to select the financial extraction formula scheme that has been maintained in the system. In addition, the user can also choose here whether the data extraction includes the data that has not been booked in the current period in the accounting system :

[0121] With the data extraction function, after the data extraction is started, the system will give a progress bar to identify the data extraction progress. After the data extraction is completed, the report selected by the user is filled and the report data is generated, and the system will give a prompt that the data extraction is completed.

[0122] In practical applications, through the above data extraction function, each time data is extracted, it is necessary to select the access conditions and financial formula extraction plan, and then perform the data extraction steps separately. It can be seen that when a larger number of reports need to be processed For information, if data is still extracted through the above data extraction function, the operation steps are cumbersome, the workload is large, and the efficiency is low. In order to reduce the impact of data access on the efficiency of accounting software and reduce the waiting time of users, the enterprise financial data center system also provides a task plan function for data extraction.

[0123] In the scheduled task function, the user can select the execution time of the scheduled task, business plan, unit scope, report scope, formula plan, and whether to include unbilled accounts. After the above information is selected and set, the system will specify Automatically complete data extraction within time. It should be noted that in the scheduled task function, in the access conditions set by the user, the unit included in the unit range and the report included in the report range may be one or more. When there are multiple units and reports At this time, in the actual data extraction process, multiple units and multiple reports need to be divided into single reports of a single unit before data extraction. So as to ensure one-to-one correspondence between reports and unit information, avoiding confusion.

[0124] The above-mentioned enterprise financial data center system can not only generate corresponding report data according to the report information, but also perform perspective query on the reports in the access conditions selected by the user. It can perform perspective query on the real-time data in different accounting databases and generate corresponding Detailed information to accurately grasp and monitor financial data.

[0125] The permission management of perspective query is to judge whether a report user has the permission to use the perspective query function. When the user is not authorized to use the perspective query function, the system will prohibit him from using the perspective query function.

[0126] Perspective query is based on the accounting data source, unit mapping, and financial extraction formulas have been configured, according to the perspective context provided by the statistical analysis system, through the above accounting software adapter to query the financial data that meets the requirements in the accounting system, and then follow the perspective The preset process and table sample in the query show the function of perspective results.

[0127] In practical applications, the enterprise financial data center system also has an extraction engine optimizer, which can preprocess a large number of financial extraction formulas-according to the type of financial extraction formula, the type of extracted data, etc., the financial extraction formula will be classified and aggregated , Forming a few classification formula groups, and then forming access sentences for several classification formula groups, and then extracting data from the financial-related system database; this greatly reduces the number and frequency of database access, thereby improving data extraction The efficiency of this greatly improves the speed of data extraction.

[0128] Through the above-mentioned enterprise financial data center system, it provides real data integration and application, and while efficiently integrating data, it also makes it easy to transform financial-related data from business data to management data. Its main advantage is :

[0129] (1) Provide a complete data traceability track through a complete metadata management mechanism;

[0130] (2) A unified export model of financial data has been realized, the data quality of the statements has been improved, the reporting workload of the grassroots units has been reduced, and the work efficiency has been improved;

[0131] (3) Through the perspective query of real-time financial data, the management and control of financial data has been greatly strengthened.