Change report filling method, storage medium, equipment, program product and device

Abstract

The invention belongs to the technical field of variable report data processing, and provides a variable report filling method, a storage medium, equipment, a program product and a device. The change report filling method comprises the following steps: determining a change area according to a predefined format of a change report; according to a preset filling requirement, a data storage table in a corresponding format is created for the change area of each category in a matched mode, and a corresponding access model is constructed for each cell in the change area in a matched mode; executing the access operation of each access model, storing the extracted report data into the data storage table matched with the corresponding change area, and further determining the total amount of the change row / column data; and dynamically expanding the total row / column number of the corresponding change report according to the total amount of the change row / column data, and filling the report data in the data storage table into the row / column of the corresponding change area to obtain the filled change report. According to the method, data in different sub-reports are compared and analyzed from a cross multi-dimensional angle.

Description

Technical Field

[0001] The present invention belongs to the technical field of variable report data processing, and in particular relates to a method for filling out a variable report, a storage medium, a device, a program product, and a device. Background Technique

[0002] The statements in this part only provide background technical information related to the present invention and do not necessarily constitute prior art.

[0003] Reports are not only used to collect data but also for summarization and statistical analysis. Most current report systems with non-fixed rows and columns are only used for displaying query analysis results, do not support filling out forms, nor structured storage, and thus cannot be used as a data source for other analyses. For example, in an evaluation system for the work content of each stage of a project, each unit has more than one project (row dimension), and each project has multiple implementation stages (column dimension). After obtaining project information, project work content, and construction conditions from the business system, not only multi-dimensional display is required, but also scoring and evaluation are needed. The scored and evaluated results stored in a structured manner can also be continuously used for performance analysis.

[0004] To solve the problem of form filling in reports, the prior art provides a method for filling and summarizing variable reports based on standard coding, which uses standard coding to uniformly standardize the criteria for the data to be collected. However, the report data is still filled in manually, resulting in low filling efficiency; and it does not support the situation where both the number of rows and columns change simultaneously, thus failing to achieve the purpose of comparing and analyzing the data of different sub-reports from a cross multi-dimensional perspective. Summary of the Invention

[0005] To solve the above technical problems, the present invention provides a method for filling out a variable report, a storage medium, a device, a program product, and a device. It realizes automatic filling of report data through a data extraction model and also supports supplementary filling of the collected data, that is, it supports reports with only row / column changes and also reports with both row and column changes, and can realize comparing and analyzing the data in different sub-reports from a cross multi-dimensional perspective.

[0006] To achieve the above object, the present invention adopts the following technical solutions:

[0007] The first aspect of the present invention provides a method for filling out a variable report.

[0008] In one or more embodiments, a method for filling out a variable report is provided, including:

[0009] Determine a variable area according to the predefined format of the variable report; the variable area includes three types: a variable row area, a variable column area, and an intersection area;

[0010] According to the preset reporting requirements, create a data storage table in the corresponding format for each type of changed area and construct a corresponding data extraction model for each cell in the changed area;

[0011] Execute the data extraction operation of each data extraction model, store the extracted report data in the data storage table matched by the corresponding changed area, and then determine the total amount of changed row / column data;

[0012] Dynamically expand the total number of rows / columns of the corresponding changed report according to the total amount of changed row / column data, and then fill the report data in the data storage table into the rows / columns of the corresponding changed area to obtain the completed changed report.

[0013] After the data extraction is completed, additional rows or columns can be filled in manually. The changed row area, changed column area, and cross area are automatically coded respectively, and the data of different areas are stored in the data table according to the automatically coded structure.

[0014] As an implementation method, the format of the data storage table created by matching the changed row area is:

[0015] Format row code, data row code, and value column;

[0016] Or / and the format of the data storage table created by matching the changed column area is:

[0017] Format column code, data column code, and value column.

[0018] As an implementation method, the format of the data storage table created by matching the cross area is:

[0019] Format row code, data row code, format column code, data column code, and value column.

[0020] As an implementation method, the data extraction model constructed by matching each cell in the cross area consists of a data row code, a data column code, and a value column.

[0021] As an implementation method, the data extraction model constructed by matching each cell in the changed row area consists of a data row code and a value column;

[0022] Or / and the data extraction model constructed by matching each cell in the changed column area consists of a data column code and a value column.

[0023] As an implementation method, fill the report data in the data storage table corresponding to the changed row area into the changed row area in the order of row coordinates and data row codes;

[0024] Fill the report data in the data storage table corresponding to the changed column area into the changed column area in the order of column coordinates and data column codes;

[0025] Fill the report data in the data storage table corresponding to the cross region into the cross region in the order of row coordinates, data row codes, column coordinates, and data column codes.

[0026] The second aspect of the present invention provides a variable report filling device.

[0027] In one or more embodiments, a variable report filling device includes:

[0028] A region determination module, which is used to determine a variable region according to the predefined format of the variable report; the variable region includes three categories: variable row region, variable column region, and cross region;

[0029] A region configuration module, which is used to match and create a data storage table with a corresponding format for each type of variable region according to the preset filling requirements, and match and construct a corresponding data extraction model for each cell in the variable region;

[0030] A data extraction operation module, which is used to execute the data extraction operations of each data extraction model, store the extracted report data into the data storage table matched by the corresponding variable region, and then determine the total amount of variable row / column data;

[0031] A data filling module, which is used to dynamically expand the total number of rows / columns of the corresponding variable report according to the total amount of variable row / column data, and then fill the report data in the data storage table into the rows / columns of the corresponding variable region to obtain a filled variable report.

[0032] The third aspect of the present invention provides a computer-readable storage medium.

[0033] A computer-readable storage medium, on which a computer program is stored, and when the program is executed by a processor, it implements the steps in the variable report filling method as described above.

[0034] The fourth aspect of the present invention provides a computer program product.

[0035] A computer program product includes computer programs / instructions, and when the computer programs / instructions are executed by a processor, they implement the steps in the variable report filling method as described above.

[0036] The fifth aspect of the present invention provides an electronic device.

[0037] An electronic device includes a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the program, it implements the steps in the variable report filling method as described above.

[0038] Compared with the prior art, the beneficial effects of the present invention are as follows:

[0039] (1) According to the preset filling requirements, the present invention creates a data storage table in a corresponding format for each type of variable area and constructs a corresponding data extraction model for each cell in the variable area. Then, the report data extracted by each data extraction model is stored in the data storage table matched with the corresponding variable area, and the report data in the data storage table is filled into the rows / columns of the corresponding variable area. Finally, a completed variable report is obtained. It realizes automatic filling of report data through the data extraction model, achieves centralized storage of data, and lays a foundation for subsequent data analysis.

[0040] (2) Based on the row and column variable table obtained by the data extraction model, the present invention can also continue to manually supplement and enter the filling. The variable areas in the variable report of the present invention include three types: variable row area, variable column area, and intersection area. This makes the variable report filling method of the present invention support not only reports with only row / column changes but also reports with both row and column changes, achieving the purpose of creating complex reports for repeated use once and being able to compare and analyze data of different sub-reports from the cross-multi-dimensional perspective.

[0041] (3) The present invention provides a method for supporting data extraction, filling, and summarization of a variable report with neither fixed rows nor fixed columns. It standardizes the collected data by uniformly encoding the cells, enabling traceability and positioning of the data in each cell, thereby achieving the purpose of cross-multi-dimensional comparison and analysis of business data in a report. Moreover, the analysis results support supplementary filling and can be used again for other-dimensional analysis. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] The specification drawings constituting a part of the present invention are used to provide a further understanding of the present invention. The schematic embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation to the present invention.

[0043] Figure 1 is a flowchart of the variable report filling method according to an embodiment of the present invention;

[0044] Figure 2 is a schematic diagram of the variable report format and storage according to an embodiment of the present invention;

[0045] Figure 3 is a schematic diagram of the structure of the variable report filling device according to an embodiment of the present invention;

[0046] Figure 4 is a schematic diagram of an electronic device according to an embodiment of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0047] The present invention will be further described below in conjunction with the drawings and embodiments.

[0048] It should be noted that the following detailed description is exemplary and is intended to provide further illustration of the present invention. Unless otherwise specified, all technical and scientific terms used herein have the same meaning as commonly understood by those of ordinary skill in the technical field to which the present invention pertains.

[0049] It should be noted that the terms used herein are merely for describing specific embodiments and are not intended to limit the exemplary embodiments according to the present invention. As used herein, unless the context clearly indicates otherwise, the singular forms are also intended to include the plural forms. In addition, it should be understood that when the terms "comprise" and / or "include" are used in this specification, they specify the presence of features, steps, operations, devices, components, and / or combinations thereof.

[0050] Figure 1 It is a schematic flowchart of a method for filling out a variable statement in an embodiment of the present invention. As Figure 1 shown, the method for filling out the variable statement in this embodiment may include the following steps S101 to S104.

[0051] S101. Determine the variable area according to the predefined format of the variable statement; the variable area includes three types: variable row area, variable column area, and cross area.

[0052] In the specific implementation process, the variable statement consists of several rows and several columns of cells.

[0053] When defining the variable statement format, mark the cells corresponding to the variable row area, variable column area, and cross area, record the format row code (such as row coordinates) corresponding to the variable row area, record the format column code (such as column coordinates) corresponding to the variable column area, and record the format row code and format column code (such as row coordinates and column coordinates) corresponding to the cross area.

[0054] When defining the report format, only the variable row or variable column can be set, or both the row and column can be set to be variable. At the same time, each cell in the data filling area should be numbered, such as A3, D1, etc. As shown in Table 1, the third row of the report is set as the variable row, column D is set as the variable column, A3, B3, C3 are in the variable row area, D1, D2 are in the variable column area, and D3 is in the cross area.

[0055] Table 1 Predefined Variable Statement

[0056] A B C D E 1 D1 2 D2 3 A3 B3 C3 D3 4 5

[0057] The variable regions in the variable statement of this embodiment include three categories: variable row regions, variable column regions, and cross regions. This enables the method for filling in the variable statement of the present invention to support not only statements with only row / column changes but also statements with both row and column changes, achieving the purpose of creating complex statements for repeated use and enabling comparative analysis of data from different sub-statements from cross-multidimensional perspectives.

[0058] S102. According to the preset filling requirements, create a data storage table with a corresponding format for each type of variable region and construct a corresponding data extraction model for each cell in the variable region.

[0059] Figure 2 The variable table format and storage principle are given. In Figure 2 the format of the variable statement includes a format row dictionary and a format column dictionary, and the format row codes and format column codes are respectively stored in the format row dictionary and the format column dictionary.

[0060] In this embodiment, the format of the data storage table created by matching the variable row region is: format row code, data row code, and value columns (create as many value columns as there are cells).

[0061] The format of the data storage table created by matching the variable column region is: format column code, data column code, and value columns (create as many value columns as there are cells).

[0062] The format of the data storage table created by matching the cross region is: format row code, data row code, format column code, data column code, and value columns (create as many value columns as there are cells).

[0063] It should be noted here that the value columns can be specifically set according to the actual situation.

[0064] In this embodiment, as Figure 2 shown, the data extraction model constructed for each cell in the cross region consists of a data row code, a data column code, and a value column. The data extraction model constructed for each cell in the variable row region consists of a data row code and a value column. The data extraction model constructed for each cell in the variable column region consists of a data column code and a value column.

[0065] For example, cells A3, B3, and C3 in Table 1 only need to be expanded multiple lines in the vertical direction. The data extraction model needs to define the row dimension (generate data row codes according to the row dimension. For example, if the row dimension is the supplier number, the row code is the actual value of the supplier) and the data columns. Cells D1 and D2 in Table 1 only need to be expanded multiple columns in the horizontal direction. The data extraction model needs to define the column dimension (generate data column codes according to the column dimension. For example, if the column dimension is the project number, the column code is the actual value of the project number) and the data columns. The cross-region D3 needs to be expanded both vertically and horizontally. It is necessary to define both the row dimension (corresponding to the data row code) and the column dimension (corresponding to the data column code), and also define the data columns. Based on the actual implementation, the data extraction model can add dimensions such as data extraction conditions and grouping conditions to make the data extraction more flexible and achieve data extraction only when needed.

[0066] Data Extraction Model Configuration for the Variable Report in Table 2

[0067] A B C D E 1 Data Extraction Model Two 2 Data Extraction Model Two 3 Data Extraction Model One Data Extraction Model One Data Extraction Model One Data Extraction Model Three 4 5

[0068] Tables 3, 4, and 5 show the specific formats of Data Extraction Model 1, Data Extraction Model 2, and Data Extraction Model 3.

[0069] Data Extraction Model 1 in Table 3

[0070]

[0071] Data Extraction Model 2 in Table 4

[0072] Levi Project Number Numeric Column Project Name, Year

[0073] Data Extraction Model 3 in Table 5

[0074] Row Dimension Supplier Number Levi Project Number Numeric Column Balance

[0075] In some alternative embodiments, the data extraction model can be implemented using data extraction SQL, which consists of a dimensional region, a statistical region, data extraction conditions, grouping conditions, and sorting conditions. Among them, the dimensional region, that is, the fields for grouping, is divided into a row dimension and a column dimension; the statistical region, that is, the result fields to be displayed in the report; the data extraction conditions, that is, the filtering conditions; the grouping conditions, that is, the further screening of the data after grouping; the sorting conditions, that is, the display effect.

[0076] S103. Perform the data extraction operations of each data extraction model, store the extracted report data in the data storage table matching the corresponding variable region, and then determine the total amount of variable row / column data. Tables 6, 7, and 8 show the specific formats of the data storage tables for the variable row region, the data storage tables for the variable column region, and the data storage tables for the cross region.

[0077] Data Storage Table for the Variable Row Region in Table 6

[0078]

[0079] Data storage table for the changed column area in Table 7

[0080] Format Column Code Data Column Code (Levi) Project Balance Year L000004 000000001 Project A 2024 L000004 000000002 Project B 2023 L000004 000000003 Project C 2022

[0081] Data storage table for the intersection area in Table 8

[0082]

[0083]

[0084] S104. Dynamically expand the total number of rows / columns of the corresponding changed report according to the total amount of changed row / column data, and then fill the report data in the data storage table into the rows / columns of the corresponding changed area to obtain the completed changed report.

[0085] After the data extraction model performs calculations, the report data is stored in the data table created when defining the report format. The specific cell to which the report data belongs is determined according to the format row and column coordinates and the data row and column coordinates. For only the area of the changed row and the intersection area, according to the obtained two-dimensional data set, fill horizontally and vertically starting from the cell in the upper left corner of the area. For the area of only the changed column, it is necessary to transpose the queried data rows for filling.

[0086] Specifically, fill the report data in the data storage table corresponding to the changed row area into the changed row area in the order of row coordinates and data row codes; fill the report data in the data storage table corresponding to the changed column area into the changed column area in the order of column coordinates and data column codes; fill the report data in the data storage table corresponding to the intersection area into the intersection area in the order of row coordinates, data row codes, column coordinates, and data column codes. The completed changed report is shown in Table 9.

[0087] Table 9 Completed changed report

[0088]

[0089]

[0090] When the report after data extraction is completed, additional rows or columns can be filled in manually. The changed row area, changed column area, and intersection area are automatically coded respectively, and the data in different areas is stored in the data table according to the automatically coded structure.

[0091] In this embodiment, by structuring the storage of the row-column cross-change table and flexibly configuring the data extraction model, the creation of complex reports can be reused once, without missing any data. It can not only be filled through the data extraction model but also supports manual filling. For example, for financial multi-aid accounting reports and statistical multi-dimensional statistical tables, after creation, each unit can fill in based on one table, achieving centralized data storage and laying a foundation for subsequent data analysis.

[0092] Figure 3 It is a schematic structural diagram of a variable report filling device in an embodiment of the present invention. This embodiment corresponds to Figure 1 the variable report filling method of Figure 3 As shown, the variable report filling device in this embodiment may include:

[0093] A region determination module 301, which is used to determine the variable region according to the predefined format of the variable report; the variable region includes three types: variable row region, variable column region, and cross region;

[0094] A region configuration module 302, which is used to match and create a data storage table in the corresponding format for each type of variable region according to the preset filling requirements, and match and construct a corresponding data extraction model for each cell in the variable region;

[0095] A data extraction operation module 303, which is used to execute the data extraction operations of each data extraction model, store the extracted report data into the data storage table matched by the corresponding variable region, and then determine the total amount of variable row / column data;

[0096] A data filling module 304, which is used to dynamically expand the total number of rows / columns of the corresponding variable report according to the total amount of variable row / column data, and then fill the report data in the data storage table into the rows / columns of the corresponding variable region to obtain the filled variable report.

[0097] It should be noted here that Figure 3 each module in the variable report filling device in Figure 1 corresponds one by one to each step in the variable report filling method in

[0098] Refer to Figure 4 , a schematic diagram of an electronic device is given. It should be noted that Figure 4 the electronic device 400 shown is only an example and should not bring any restrictions to the functions and usage scope of the embodiments of the present invention.

[0099] Such as Figure 4As shown, the electronic device 400 includes a central processing unit (CPU) 401, which can perform various appropriate actions and processes according to programs stored in a read-only memory (ROM) 402 or programs loaded from a storage section 408 into a random access memory (RAM) 403. In the RAM 403, various programs and data required for system operations are also stored. The central processing unit 401, the ROM 402, and the RAM 403 are connected to each other via a bus 404. An input / output (I / O) interface 405 is also connected to the bus 404.

[0100] The following components are connected to the I / O interface 405: an input section 406 including a keyboard, a mouse, etc.; an output section 407 including, for example, a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 408 including a hard disk, etc.; and a communication section 409 including a network interface card such as a local area network (LAN) card, a modem, etc. The communication section 409 performs communication processing via a network such as the Internet. A drive 410 is also connected to the I / O interface 405 as needed. A removable medium 411, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 410 as needed so that a computer program read from it can be installed into the storage section 408 as needed.

[0101] When the central processing unit 401 in the electronic device of this embodiment executes the program, it implements the steps in the Figure 1 variable statement filling method as shown.

[0102] Specifically, according to an embodiment of the present application, the process described above with reference to the flowchart can be implemented as a computer software program. For example, an embodiment of the present application includes a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program includes program codes for executing Figure 1 the method as shown. In such an embodiment, the computer program can be downloaded and installed from a network through the communication section 409, and / or installed from the removable medium 411. When the computer program is executed by the central processing unit 401, various functions defined in the device of the present application are executed.

[0103] Among them, Figure 1 the computer program instructions corresponding to the method as shown can also be stored in a computer-readable memory that can guide a computer or other programmable data processing device to work in a specific manner, so that the instructions stored in the computer-readable memory generate a manufactured article including an instruction device, and the instruction device implements the functions specified in Figure 1 one process or multiple processes and / or Figure 1 one block or multiple blocks.

[0104] Those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be completed by instructing relevant hardware through a computer program. The program can be stored in a computer-readable storage medium. When the program is executed, it can include the processes of the embodiments of the above various methods. Among them, the storage medium can be a magnetic disk, an optical disk, a read-only memory (ROM), or a random access memory (RAM), etc.

[0105] The above are only the preferred embodiments of the present invention and are not intended to limit the present invention. For those skilled in the art, the present invention can have various changes and modifications. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included within the protection scope of the present invention.

Claims

1. A method for filling out a variable statement, characterized in that, including: Determine the changed area according to the predefined format of the change report; the changed area includes three categories: changed row area, changed column area, and intersection area; According to the preset filling requirements, create a data storage table with a corresponding format for each category of changed area and construct a corresponding data extraction model for each cell in the changed area; Execute the data extraction operation of each data extraction model, store the extracted report data into the data storage table matched by the corresponding changed area, and then determine the total amount of changed row / column data; Dynamically expand the total number of rows / columns of the corresponding change report according to the total amount of changed row / column data, and then fill the report data in the data storage table into the rows / columns of the corresponding changed area to obtain the completed change report.

2. The method for filling out the change statement according to claim 1, characterized in that, The format of the data storage table created by matching the changed row area is: Format row code, data row code, and value column; Or / and the format of the data storage table created by matching the changed column area is: Format column code, data column code, and value column.

3. The method for filling in the change statement according to claim 1, characterized in that The format of the data storage table created by matching the intersection area is: Format row code, data row code, format column code, data column code, and value column.

4. The method for filling in the change statement according to claim 1, characterized in that The data extraction model constructed by matching each cell in the intersection area consists of a data row code, a data column code, and a value column.

5. The method for filling in the change statement according to claim 1, wherein The data extraction model constructed by matching each cell in the changed row area consists of a data row code and a value column; Or / and the data extraction model constructed by matching each cell in the changed column area consists of a data column code and a value column.

6. The method for filling in the change statement according to claim 1, wherein, Fill the report data in the data storage table corresponding to the changed row area into the changed row area in the order of row coordinates and data row codes; Fill the report data in the data storage table corresponding to the changed column area into the changed column area in the order of column coordinates and data column codes; Fill the report data in the data storage table corresponding to the intersection area into the intersection area in the order of row coordinates, data row codes, column coordinates, and data column codes.

7. A variable statement filling device, characterized in that, including: An area determination module, which is used to determine the changed area according to the predefined format of the change report; the changed area includes three categories: changed row area, changed column area, and intersection area; An area configuration module, which is used to create a data storage table with a corresponding format for each category of changed area and construct a corresponding data extraction model for each cell in the changed area according to the preset filling requirements; A data extraction operation module, which is used to execute the data extraction operation of each data extraction model, store the extracted report data into the data storage table matched by the corresponding changed area, and then determine the total amount of changed row / column data; A data filling module, which is used to dynamically expand the total number of rows / columns of the corresponding change report according to the total amount of changed row / column data, and then fill the report data in the data storage table into the rows / columns of the corresponding changed area to obtain the completed change report.

8. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the program is executed by a processor, it implements the steps in the change report filling method described in any one of claims 1-6.

9. A computer program product comprising a computer program / instructions, characterized in that, When the computer program / instructions are executed by a processor, it implements the steps in the change report filling method described in any one of claims 1-6.

10. An electronic device, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, characterized in that, When the processor executes the program, it implements the steps in the method for filling in the change report according to any one of claims 1-6.

Images