Report generation method, system, device, electronic equipment and storage medium

Abstract

The present disclosure provides a report generation method, system, device, electronic equipment and storage medium, which can be applied to the fields of computer technology and financial technology. The method comprises: in response to a report generation request, determining a plurality of report information corresponding to a report type from a report generation system based on the report type carried in the report generation request; classifying the plurality of report information based on the summary information of the report information to obtain a classification result; obtaining a plurality of original tables corresponding one-to-one to the plurality of report information based on the classification result; generating an intermediate table based on the plurality of original tables by using a preset association template corresponding to the report type; and sending the intermediate table to a second electronic equipment, so that the second electronic equipment generates a target table body based on the intermediate table, generates a target table header based on input information of a first user, and splices the target table body and the target table header to obtain a target table.

Description

Technical Field

[0001] This disclosure relates to the fields of computer technology and financial technology, and in particular to a report generation method, system, device, electronic device, storage medium and computer program product. Background Technology

[0002] Statistical reports are a survey method that provides basic statistical data regularly from the bottom up, following nationally standardized forms, indicators, and reporting deadlines. In the process of intensive business operations within enterprises, statistical reports, as the most intuitive tool for data analysis, play a role in various ways.

[0003] In related technologies, statistical reports are generally generated using report generation tools. However, when report requirements change, such as adding or deleting report items, technical personnel need to modify the code of the report generation tool to meet the changed report requirements. Therefore, the report generation methods in related technologies suffer from a lack of flexibility. Summary of the Invention

[0004] In view of the above problems, this disclosure provides a report generation method, system, device, electronic device, storage medium and computer program product.

[0005] One aspect of this disclosure provides a report generation method applied to a first electronic device. The method includes: responding to a report generation request, determining multiple report information corresponding to the report type carried in the report generation request from a report generation system; classifying the multiple report information based on summary information of the report information to obtain a classification result; obtaining multiple original tables that correspond one-to-one with the multiple report information based on the classification result; generating an intermediate table based on the multiple original tables using a preset association template corresponding to the report type; and sending the intermediate table to a second electronic device so that the second electronic device generates a target table body based on the intermediate table, generates a target table header based on input information of a first user, and concatenates the target table body and the target table header to obtain a target table.

[0006] According to embodiments of this disclosure, the summary information of the aforementioned report information includes the indicator types of the data in the report, and the indicator types include data indicator types and dimension indicator types; wherein, the classification of multiple reports based on the summary information of the aforementioned report information to obtain classification results includes: when the summary information indicates that the data in the aforementioned report contains data of the aforementioned data indicator types, determining that the classification result indicates that the report corresponding to the aforementioned report information is a data original table; and when the summary information indicates that the data in the aforementioned report does not contain data of the aforementioned data indicator types, determining that the classification result indicates that the report corresponding to the aforementioned report information is a dimension original table.

[0007] According to embodiments of this disclosure, the summary information of the aforementioned report information includes the changing patterns of the data in the report; wherein, the classification of multiple reports based on the summary information of the aforementioned report information to obtain classification results includes: when the summary information indicates that the data in the aforementioned reports has a preset changing pattern, determining that the report corresponding to the aforementioned report information is a data original table; and when the summary information indicates that the data in the aforementioned reports does not have a changing pattern, determining that the report corresponding to the aforementioned report information is a dimension original table.

[0008] According to embodiments of this disclosure, obtaining multiple original tables corresponding one-to-one with the multiple report information based on the classification results includes: for each report information, if the classification result of the report information indicates that the report corresponding to the report information is the original data table, obtaining the original table corresponding to the report information from the data warehouse; and if the classification result of the report information indicates that the report corresponding to the report information is the original dimension table, obtaining the original table corresponding to the report information based on the input information of the second user.

[0009] According to an embodiment of this disclosure, the above-mentioned generation of an intermediate table based on multiple original tables using a preset association template corresponding to the above-mentioned report type includes: generating a structured query statement based on the multiple original tables and the preset association template; and executing the structured query statement to obtain the intermediate table.

[0010] According to embodiments of this disclosure, the method further includes: associating and storing the intermediate table and the report generation request in a data warehouse; and setting an expiration time for the intermediate table.

[0011] According to an embodiment of this disclosure, the method further includes: in response to a target report generation request, matching the target report type carried in the target report generation request with the report type of an intermediate table in the data warehouse to obtain a matching result; if the matching result indicates that a target intermediate table matching the target report type exists in the data warehouse, retrieving the target intermediate table from the data warehouse; and sending the target intermediate table to the second electronic device.

[0012] Another aspect of this disclosure provides a report generation method applied to a second electronic device. The method includes: in response to receiving an intermediate table from a first electronic device, generating a target table body based on the intermediate table; generating a target table header based on input information from a first user; and concatenating the target table body and the target table header to obtain a target table. The first electronic device is configured to: in response to a report generation request, determine multiple report information corresponding to the report type carried in the report generation request from a report generation system; classify the multiple report information based on summary information of the report information to obtain a classification result; obtain multiple original tables corresponding one-to-one with the multiple report information based on the classification result; and generate an intermediate table based on the multiple original tables using a preset association template corresponding to the report type.

[0013] Another aspect of this disclosure provides a report generation system, including a first electronic device, a second electronic device, and a data warehouse, wherein: the first electronic device is configured to: in response to a report generation request, determine multiple report information corresponding to the report type carried in the report generation request from the report generation system; classify the multiple report information based on summary information of the report information to obtain a classification result; obtain multiple original tables corresponding one-to-one with the multiple report information based on the classification result; generate an intermediate table based on the multiple original tables using a preset association template corresponding to the report type; and send the intermediate table to the second electronic device; the second electronic device is configured to: in response to receiving the intermediate table from the first electronic device, generate a target table body based on the intermediate table; generate a target table header based on input information of a first user; and concatenate the target table body and the target table header to obtain a target table.

[0014] Another aspect of this disclosure provides a report generation apparatus applied to a first electronic device. The apparatus includes: a determining module, configured to, in response to a report generation request, determine multiple report information corresponding to the report type carried in the report generation request from a report generation system; a classification module, configured to classify the multiple report information based on summary information of the report information to obtain a classification result; a first obtaining module, configured to obtain multiple original tables corresponding one-to-one with the multiple report information based on the classification result; a first generating module, configured to generate an intermediate table based on the multiple original tables using a preset association template corresponding to the report type; and a first sending module, configured to send the intermediate table to a second electronic device, so that the second electronic device generates a target table body based on the intermediate table, generates a target table header based on input information from a first user, and concatenates the target table body and the target table header to obtain a target table.

[0015] Another aspect of this disclosure provides a report generation apparatus applied to a second electronic device, the apparatus comprising: a second generation module for generating a target table body based on an intermediate table received from a first electronic device; a third generation module for generating a target table header based on input information from a first user; and a splicing module for splicing the target table body and the target table header to obtain a target table.

[0016] Another aspect of this disclosure provides an electronic device, including: one or more processors; and a memory for storing one or more instructions, wherein when the one or more instructions are executed by the one or more processors, the one or more processors cause the one or more processors to perform the method as described above.

[0017] Another aspect of this disclosure provides a computer-readable storage medium storing computer-executable instructions, which, when executed, are used to implement the method described above.

[0018] Another aspect of this disclosure provides a computer program product including computer-executable instructions that, when executed, implement the method described above.

[0019] According to the report generation method, system, device, electronic device, storage medium, and computer program product provided in this disclosure, during the report generation process, the original tables required for the report generation process are determined based on the type of report to be generated, resulting in multiple report information entries. Then, based on the summary information of the report information, the data composition of the corresponding original tables is determined, and the report information is sequentially classified to obtain the original tables from different sources. After obtaining the original tables, they are assembled into intermediate tables and sent to a second electronic device. The second electronic device then modifies the intermediate tables based on the intent of the first user and concatenates them with the generated table header to finally obtain the target table. This scheme achieves the decomposition of the report generation process, and the target table can be generated based on the needs of business personnel. Therefore, it at least partially solves the problem of poor flexibility in report generation, effectively improves the flexibility of report generation, and reduces the learning cost for business personnel. Attached Figure Description

[0020] The foregoing contents, as well as other objects, features, and advantages of this disclosure, will become clearer from the following description of embodiments with reference to the accompanying drawings, in which:

[0021] Figure 1 This illustration schematically shows an exemplary system architecture to which report generation methods and apparatus can be applied according to embodiments of this disclosure;

[0022] Figure 2 A flowchart illustrating a report generation method applied to a first electronic device according to an embodiment of the present disclosure is shown schematically;

[0023] Figure 3 A flowchart illustrating a report generation method according to another embodiment of this disclosure is shown schematically;

[0024] Figure 4 This illustration schematically shows a custom report header design interface according to an embodiment of the present disclosure;

[0025] Figure 5 A flowchart illustrating a report generation method applied to a second electronic device according to an embodiment of the present disclosure is shown schematically;

[0026] Figure 6 A schematic diagram of a report generation system according to an embodiment of the present disclosure is shown.

[0027] Figure 7 A block diagram schematically illustrates a report generation apparatus applied to a first electronic device according to an embodiment of the present disclosure;

[0028] Figure 8 A block diagram schematically illustrates a report generation apparatus applied to a second electronic device according to an embodiment of the present disclosure;

[0029] Figure 9 A block diagram of an electronic device suitable for implementing a report generation method according to an embodiment of the present disclosure is shown schematically. Detailed Implementation

[0030] The embodiments of the present disclosure will now be described with reference to the accompanying drawings. However, it should be understood that these descriptions are exemplary only and are not intended to limit the scope of the disclosure. In the following detailed description, numerous specific details are set forth to provide a thorough understanding of the embodiments of the present disclosure for ease of explanation. However, it will be apparent that one or more embodiments may be practiced without these specific details. Furthermore, descriptions of well-known structures and techniques are omitted in the following description to avoid unnecessarily obscuring the concepts of the present disclosure.

[0031] The terminology used herein is for the purpose of describing particular embodiments only and is not intended to limit this disclosure. The terms “comprising,” “including,” etc., as used herein indicate the presence of the stated features, steps, operations, and / or components, but do not exclude the presence or addition of one or more other features, steps, operations, or components.

[0032] All terms used herein (including technical and scientific terms) have the meanings commonly understood by those skilled in the art, unless otherwise defined. It should be noted that the terms used herein are to be interpreted in a manner consistent with the context of this specification, and not in an idealized or overly rigid way.

[0033] When using expressions such as "at least one of A, B, and C", they should generally be interpreted in accordance with the meaning that is commonly understood by a person skilled in the art (e.g., "a system having at least one of A, B, and C" should include, but is not limited to, a system having A alone, a system having B alone, a system having C alone, a system having A and B, a system having A and C, a system having B and C, and / or a system having A, B, and C, etc.).

[0034] Faced with ever-increasing customer demands, banks need to streamline and centralize their business processes. This streamlined process requires data analysis, typically utilizing statistical reports as the most intuitive tool for data analysis.

[0035] Faced with the ever-increasing demand for business data analysis, the development of statistical reporting products requires a significant amount of technical manpower. However, the relatively fixed design patterns of these products mean that the R&D investment has a negligible impact on the overall technical architecture. Furthermore, there is an irreconcilable conflict between the flexibility required by business personnel for statistical reports and the fixed product release cycle. Existing general-purpose custom reporting tools, on the one hand, require business personnel to have a certain level of understanding of the report generation process and database knowledge, increasing the learning cost; on the other hand, the high degree of customization in these tools results in low flexibility in report generation, failing to adequately cover reporting needs with specific business characteristics.

[0036] In view of this, the present disclosure provides a report generation method, system, apparatus, electronic device, storage medium, and computer program product. The method is applied to a first electronic device and includes: responding to a report generation request, determining multiple report information corresponding to the report type from a report generation system based on the report type carried in the report generation request; classifying the multiple report information based on summary information of the report information to obtain a classification result; obtaining multiple original tables that correspond one-to-one with the multiple report information based on the classification result; generating an intermediate table based on the multiple original tables using a preset association template corresponding to the report type; and sending the intermediate table to a second electronic device so that the second electronic device can generate a target table body based on the intermediate table, generate a target table header based on input information from a first user, and concatenate the target table body and the target table header to obtain a target table.

[0037] It should be noted that the form data processing method and apparatus defined in the embodiments of this disclosure can be used in the fields of computer technology and fintech, and can also be used in any field other than computer technology and fintech. The application fields of the form data processing method and apparatus defined in the embodiments of this disclosure are not limited.

[0038] In the technical solution disclosed herein, the acquisition, storage, and application of user personal information comply with the provisions of relevant laws and regulations, necessary confidentiality measures have been taken, and there is no violation of public order and good morals.

[0039] In the technical solution disclosed herein, the user's authorization or consent is obtained before acquiring or collecting the user's personal information.

[0040] Figure 1 This illustration schematically depicts an exemplary system architecture to which report generation methods and apparatus can be applied according to embodiments of this disclosure. It should be noted that... Figure 1 The examples shown are merely examples of system architectures that can be applied to the embodiments of this disclosure, in order to help those skilled in the art understand the technical content of this disclosure, but do not mean that the embodiments of this disclosure cannot be used in other devices, systems, environments or scenarios.

[0041] like Figure 1 As shown, the system architecture 100 according to this embodiment may include a first electronic device 110, a data warehouse 120, a network 130, and second electronic devices 140 and 150.

[0042] According to embodiments of this disclosure, the first electronic device 110 and the second electronic devices 140 and 150 can be various electronic devices, including but not limited to smartphones, tablets, laptops, and desktop computers. The data warehouse 120 can be a database with the function of storing various types of data.

[0043] According to embodiments of this disclosure, the second electronic devices 140 and 150 may also include a display screen and an input device to enable interaction with the user. For example, the second electronic devices 140 and 150 may display the results of form data processing to the user via the display screen.

[0044] According to embodiments of this disclosure, a client application for real-time report transmission may be installed on the first electronic device 110, and a client application for real-time report transmission may be installed on the second electronic devices 140 and 150.

[0045] According to embodiments of this disclosure, network 130 serves as a medium for providing a communication link between the first electronic device 110 and the second electronic devices 140 and 150. Network 130 may include various connection types, such as wired and / or wireless communication links, etc. Intermediate tables generated by the first electronic devices 110 and 120 can be transmitted to the second electronic devices 140 and 150 via network 130.

[0046] It should be noted that the report generation method provided in this embodiment can generally be executed by the first electronic device 110 and the second electronic devices 140 and 150. Correspondingly, the report generation device provided in this embodiment can generally be disposed in the first electronic device 110 and the second electronic devices 140 and 150. Specifically, the first electronic device can determine report information from the data warehouse based on the report generation request, obtain the original table based on the report information, generate an intermediate table based on the original table, and send the intermediate table to the second electronic device. The second electronic device can receive the intermediate table, generate the target table body, generate the target table header according to the input information, and concatenate the target table body and the target table header to obtain the target table.

[0047] It should be understood that Figure 1 The number of first electronic devices, second electronic devices, data warehouses, and networks shown is merely illustrative. Depending on implementation needs, any number of first electronic devices, second electronic devices, data warehouses, and networks can be included.

[0048] Figure 2 A flowchart illustrating a report generation method applied to a first electronic device according to an embodiment of the present disclosure is shown schematically.

[0049] like Figure 2 As shown, the report generation method applied to the first electronic device includes operations S201 to S205.

[0050] In operation S201, in response to a report generation request, multiple report information corresponding to the report type are determined from the report generation system based on the report type carried in the report generation request.

[0051] In operation S202, based on the summary information of the report information, multiple report information are classified to obtain the classification results.

[0052] In operation S203, based on the classification results, multiple original tables are obtained that correspond one-to-one with information from multiple reports.

[0053] In operation S204, an intermediate table is generated based on multiple original tables using a preset association template corresponding to the report type.

[0054] In operation S205, an intermediate table is sent to the second electronic device so that the second electronic device can generate the target table body based on the intermediate table, generate the target table header based on the input information of the first user, and concatenate the target table body and the target table header to obtain the target table.

[0055] According to embodiments of this disclosure, the report can be a statistical report generated in a certain required format, which can serve as a more intuitive tool for data analysis.

[0056] According to embodiments of this disclosure, the report generation request may carry a report type, which may include two major dimensions: personnel and business. The personnel dimension may include sub-dimensions such as basic classification (operator number) and attribute classification (company, organization, department); the business dimension may include sub-dimensions such as basic classification (business serial number) and attribute classification (business domain, business category, business code).

[0057] According to embodiments of this disclosure, different report structures can be designed for the business characteristics of different enterprises. The report structure includes a three-layer structure of target table, intermediate table and original table. The processing of reports at different levels is handled by either technical personnel or business personnel. Corresponding operation functions can be designed according to the operating habits of different personnel, and the target table can be added or optimized by both parties in collaboration.

[0058] According to embodiments of this disclosure, the report generation system may have all database tables related to business objectives, which can serve as the original tables.

[0059] According to embodiments of this disclosure, the summary information of the report information can characterize the indicator type of the data in the report. Based on the summary information, the data composition of the corresponding original table can be determined, and the report information can be classified in sequence to obtain different classification results.

[0060] According to embodiments of this disclosure, based on different classification results, multiple original tables corresponding one-to-one with report information can be obtained from the report generation system.

[0061] According to embodiments of this disclosure, each report type can have a corresponding template, which can be pre-set and associated with each report type. Therefore, an intermediate table can be generated based on multiple original tables using a pre-set associated template corresponding to the report type.

[0062] According to embodiments of this disclosure, the target table body can be generated based on an intermediate table by defining index columns.

[0063] According to embodiments of this disclosure, the first user can be a company's business personnel. The business personnel can input the desired target table header information on a second electronic device, and the second electronic device can concatenate the target table body and the target table header to obtain the target table.

[0064] According to embodiments of this disclosure, the type of report to be generated can be determined, and the original tables required for the report generation process can be identified, resulting in multiple report information entries. Then, based on the summary information of the report information, the data composition of the corresponding original tables can be determined, and the report information can be categorized sequentially to obtain the original tables from different sources. After obtaining the original tables, they are assembled into intermediate tables and sent to a second electronic device. The second electronic device then modifies the intermediate tables based on the intent of the first user and concatenates them with the generated table header to finally obtain the target table. This process decomposes the report generation process, effectively improving the flexibility of report generation. Furthermore, the target table can be generated based on the needs of business personnel, thus reducing the learning cost for business personnel.

[0065] According to embodiments of this disclosure, the summary information of the report information includes the indicator types of the data in the report, and the indicator types include data indicator types and dimension indicator types.

[0066] According to embodiments of this disclosure, operation S202 may include the following operations:

[0067] If the summary information indicates that the data in the report contains data of the data indicator type, the classification result indicates that the report corresponding to the report information is the original data table; and if the summary information indicates that the data in the report does not contain data of the data indicator type, the classification result indicates that the report corresponding to the report information is the original dimension table.

[0068] According to embodiments of this disclosure, for any column in the original table, the data indicator type can represent whether the data in the original table is processed and finally displayed to the user, or whether the data in the original table is directly displayed to the user. Indicators that do not meet the criteria for a data indicator type can be considered as dimension indicator types.

[0069] According to embodiments of this disclosure, the original data table can represent the relationship information between stored dimension indicators and data indicators, and the original dimension table can represent the relationship information between stored dimension indicators.

[0070] According to embodiments of this disclosure, the summary information of the report includes the pattern of change in the data in the report.

[0071] According to another embodiment of this disclosure, operation S202 may also include the following operations:

[0072] When the summary information indicates that the data in the report has a preset pattern of change, the report corresponding to the classification result is determined to be the original data table; and when the summary information indicates that the data in the report does not have a pattern of change, the report corresponding to the classification result is determined to be the original dimension table.

[0073] According to embodiments of this disclosure, when the original table has a preset change pattern, the original table can be classified as a data original table, wherein the preset change pattern can characterize that the change cycle of the original table has a certain regularity; if the original table does not have a preset change pattern, the original table can be classified as a dimension original table.

[0074] According to embodiments of this disclosure, operation S203 may include the following operations:

[0075] For each report, if the classification result of the report indicates that the report corresponding to the report is a raw data table, the raw table corresponding to the report is retrieved from the data warehouse; and if the classification result of the report indicates that the report corresponding to the report is a dimension raw table, the raw table corresponding to the report is retrieved based on the input information of the second user.

[0076] According to embodiments of this disclosure, a data warehouse can be a warehouse that stores raw table data. When the raw table is determined to be a data source table, the raw table corresponding to the report information can be obtained from the data warehouse.

[0077] According to embodiments of this disclosure, the second user can be a technical staff member of the company. If the original table is determined to be a dimension original table, the technical staff member can either input agreed-upon template information to generate the original table corresponding to the report information, or retrieve the original table corresponding to the report information from the data warehouse.

[0078] According to embodiments of this disclosure, business personnel can import dimensional indicator data into the raw table generated by the agreed template information, thereby improving the flexibility of the data processing process.

[0079] According to embodiments of this disclosure, operation S204 may include the following operations:

[0080] Based on multiple original tables and preset association templates, a structured query statement is generated; and the structured query statement is executed to obtain an intermediate table.

[0081] According to embodiments of this disclosure, intermediate tables can be generated by processing original tables. The design of intermediate tables can follow the following principles: the set of intermediate tables must include all the relationships between the original tables that have display requirements, and ensure that there is no multi-table relationship processing in the processing from intermediate tables to target tables.

[0082] According to embodiments of this disclosure, the intermediate table can take into account the maximum amount of data that the first electronic device can accommodate, so as to avoid the generation of the intermediate table exceeding the upper limit that the first electronic device can process; the intermediate table can include more data indicators while meeting the requirements of the target table, so as to reduce the frequency of changes in the intermediate table due to the lack of relevant data indicators.

[0083] According to embodiments of this disclosure, the processing of intermediate tables can be carried out by technicians using a model where structured query statements are input at the front end and transferred to the data warehouse for end-of-day processing via the back-end database.

[0084] Figure 3 A flowchart illustrating a report generation method according to another embodiment of this disclosure is shown schematically.

[0085] like Figure 3 As shown, the report generation method according to another embodiment of this disclosure includes operations S301 to S305.

[0086] In operation S301, intermediate tables and report generation requests are associated and stored in the data warehouse.

[0087] In operation S302, set an expiration time for the intermediate table.

[0088] In operation S303, in response to the target report generation request, the target report type carried in the target report generation request is matched with the report type of the intermediate table in the data warehouse to obtain the matching result.

[0089] In operation S304, if the matching result indicates that a target intermediate table matching the target report type exists in the data warehouse, the target intermediate table is retrieved from the data warehouse.

[0090] In operation S305, the target intermediate table is sent to the second electronic device.

[0091] According to embodiments of this disclosure, to alleviate the computational and storage pressure on the data warehouse and backend database, an expiration time can be set for intermediate tables. For the original table data used by the custom reporting system, a cleanup cycle of no more than one month can be set to retain the minimum amount of data required for data recovery and verification.

[0092] According to the embodiments of this disclosure, a cleanup cycle of no more than six months can be set for intermediate table data generated during the process. If a longer statistical period is required for some special tables, differentiated configurations can be made. For target table data to be downloaded by appointment, the system can retain a cleanup cycle of no more than two weeks from the day after the appointment.

[0093] According to embodiments of this disclosure, the target table can be generated by processing a single intermediate table. The target table processing can be performed by business personnel on a front-end interface, through translating structured query statements and processing the intermediate table in the back-end database via application calls. The target table processing operations include generating the target table body and designing the target table header.

[0094] Figure 4 The illustration shows a schematic diagram of a custom report header design interface according to an embodiment of the present disclosure.

[0095] like Figure 4 As shown, the table header design can be drawn by defining it row by row and column by column. The table header design can include the starting row and column numbers and the ending row and column numbers, and the attribute category can be entered in the cell content column.

[0096] According to embodiments of this disclosure, a custom report header can be concatenated with the indicator section to form a target table. The target table can support both online display and scheduled download. Considering system operating pressure, the online display dataset can be less than 1000 rows, and the remaining data can be viewed in a paginated manner.

[0097] According to embodiments of this disclosure, the scheduled download instruction can be executed on the background server, and the generated report is stored in the form of a compressed file in a network-attached storage for users to download the next day.

[0098] Figure 5 A flowchart illustrating a report generation method applied to a second electronic device according to an embodiment of the present disclosure is shown schematically.

[0099] like Figure 5 As shown, the report generation method applied to the second electronic device includes operations S501 to S503.

[0100] In operation S501, in response to receiving an intermediate table from the first electronic device, a target table body is generated based on the intermediate table.

[0101] In operation S502, the target table header is generated based on the input information of the first user.

[0102] In operation S503, the target table body and the target table header are concatenated to obtain the target table.

[0103] According to an embodiment of this disclosure, a first electronic device is configured to: in response to a report generation request, determine multiple report information corresponding to the report type from a report generation system based on the report type carried in the report generation request; classify the multiple report information based on summary information of the report information to obtain a classification result; obtain multiple original tables that correspond one-to-one with the multiple report information based on the classification result; and generate an intermediate table based on the multiple original tables using a preset association template corresponding to the report type.

[0104] Figure 6 A schematic diagram of a report generation system according to an embodiment of the present disclosure is shown.

[0105] like Figure 6 As shown, the report generation system includes a first electronic device, a second electronic device, and a data warehouse.

[0106] like Figure 6 As shown, in the first electronic device, multiple report information corresponding to the report type carried in the report generation request can be determined from the data warehouse; then, the original table is obtained based on the report information; then, an intermediate table is generated based on the original table and sent to the second electronic device. In the second electronic device, the intermediate table sent from the first electronic device can be received, and the target table body can be generated; then, the target table header can be generated based on the input information of the first user; finally, the target table body and the target table header are concatenated to obtain the target table. The data warehouse can store the association between the intermediate table and the report generation request.

[0107] According to embodiments of this disclosure, during the initialization phase of the report generation system, historical versions of statistical report data can be stored in a data warehouse to form an initial data warehouse.

[0108] According to embodiments of this disclosure, data from historical versions of statistical reports can be used for data in the original table and intermediate table, and a preset association template can be updated to avoid repeatedly processing the original table and intermediate table.

[0109] According to embodiments of this disclosure, the target table can be modified or added, and such modification or addition can be performed by business personnel.

[0110] Figure 7 A block diagram schematically illustrates a report generation apparatus applied to a first electronic device according to an embodiment of the present disclosure.

[0111] like Figure 7 As shown, the report generation device 700 applied to the first electronic device includes a determination module 710, a classification module 720, a first acquisition module 730, a first generation module 740, and a first sending module 750.

[0112] The determination module 710 is used to respond to a report generation request and determine multiple report information corresponding to the report type from the report generation system based on the report type carried in the report generation request.

[0113] The classification module 720 is used to classify multiple reports based on the summary information of the report information to obtain a classification result.

[0114] The first acquisition module 730 is used to acquire multiple original tables that correspond one-to-one with the multiple report information based on the classification results.

[0115] The first generation module 740 is used to generate an intermediate table based on multiple original tables using a preset association template corresponding to the report type.

[0116] The first sending module 750 is used to send the intermediate table to the second electronic device, so that the second electronic device can generate a target table body based on the intermediate table, generate a target table header based on the input information of the first user, and concatenate the target table body and the target table header to obtain the target table.

[0117] According to embodiments of this disclosure, the classification module 720 includes a first determining unit and a second determining unit.

[0118] The first determining unit is used to determine, when the summary information indicates that the data in the report contains data of the data indicator type, that the classification result indicates that the report corresponding to the report information is the original data table.

[0119] The second determining unit is used to determine that the report corresponding to the classification result is the original table of the dimension when the data in the summary information report does not contain data of the data indicator type.

[0120] According to embodiments of this disclosure, the classification module 720 further includes a third determining unit and a fourth determining unit.

[0121] The third determining unit is used to determine the original data table as the report corresponding to the classification result information when the data in the summary information report has a preset change pattern.

[0122] The fourth determination unit is used to determine the original dimension table of the report corresponding to the classification result information when the data in the summary information report does not show a pattern of change.

[0123] According to embodiments of this disclosure, the first acquisition module 730 includes a first acquisition unit and a second acquisition unit.

[0124] The first acquisition unit is used to acquire the original table corresponding to each report information from the data warehouse when the classification result of the report information indicates that the report corresponding to the report information is the original data table.

[0125] The second acquisition unit is used to acquire the original table corresponding to the report information based on the input information of the second user, when the classification result of the report information indicates that the report corresponding to the report information is a dimension original table.

[0126] According to embodiments of this disclosure, the first generation module 740 includes a generation unit and an execution unit.

[0127] The generation unit is used to generate structured query statements based on multiple original tables and preset association templates.

[0128] The execution unit is used to execute structured query statements and obtain intermediate tables.

[0129] According to embodiments of this disclosure, the report generation device applied to the first electronic device further includes an association module, a setting module, a matching module, a second acquisition module, and a second sending module.

[0130] The association module is used to associate and store intermediate tables and report generation requests in the data warehouse.

[0131] The settings module is used to set expiration times for intermediate tables.

[0132] The matching module is used to respond to the target report generation request by matching the target report type carried in the target report generation request with the report type of the intermediate table in the data warehouse to obtain the matching result.

[0133] The second acquisition module is used to acquire the target intermediate table from the data warehouse if the matching result indicates that a target intermediate table matching the target report type exists in the data warehouse.

[0134] The second sending module is used to send the target intermediate table to the second electronic device.

[0135] Figure 8 A block diagram schematically illustrates a report generation apparatus applied to a second electronic device according to an embodiment of the present disclosure.

[0136] like Figure 8 As shown, the report generation device 800 applied to the second electronic device includes a second generation module 810, a third generation module 820, and a splicing module 830.

[0137] The second generation module 810 is used to generate the target table body based on the intermediate table received from the first electronic device.

[0138] The third generation module 820 is used to generate the target table header based on the input information of the first user.

[0139] The splicing module 830 is used to splice the target table body and the target table header to obtain the target table.

[0140] Any one or more of the modules, submodules, units, and subunits according to embodiments of the present disclosure, or at least part of the functions of any one or more of them, can be implemented in one module. Any one or more of the modules, submodules, units, and subunits according to embodiments of the present disclosure can be implemented by dividing them into multiple modules. Any one or more of the modules, submodules, units, and subunits according to embodiments of the present disclosure can be at least partially implemented as hardware circuitry, such as Field Programmable Gate Arrays (FPGAs), Programmable Logic Arrays (PLAs), Systems-on-Chip, Systems-on-Substrate, Systems-on-Package, Application-Specific Integrated Circuits (ASICs), or implemented in hardware or firmware by any other reasonable means of integrating or packaging circuitry, or implemented in software, hardware, or firmware, or in any suitable combination of any of these three implementation methods. Alternatively, one or more of the modules, submodules, units, and subunits according to embodiments of the present disclosure can be at least partially implemented as computer program modules, which, when run, can perform corresponding functions.

[0141] For example, any plurality of the determining module 710, classifying module 720, first acquiring module 730, first generating module 740, and first sending module 750 can be combined into one module / unit / subunit, or any one of these modules / units / subunits can be split into multiple modules / units / subunits. Alternatively, at least part of the functionality of one or more of these modules / units / subunits can be combined with at least part of the functionality of other modules / units / subunits and implemented in one module / unit / subunit. According to embodiments of the present disclosure, at least one of the determining module 710, classifying module 720, first acquiring module 730, first generating module 740, and first sending module 750 can be at least partially implemented as hardware circuitry, such as a field-programmable gate array (FPGA), a programmable logic array (PLA), a system-on-a-chip, a system-on-a-substrate, a system-on-package, an application-specific integrated circuit (ASIC), or implemented in hardware or firmware by any other reasonable means of integrating or packaging the circuitry, or implemented in software, hardware, or firmware, or in any suitable combination of any of these three implementation methods. Alternatively, at least one of the determining module 710, the classifying module 720, the first acquiring module 730, the first generating module 740, and the first sending module 750 may be implemented at least partially as a computer program module, which can perform corresponding functions when the computer program module is run.

[0142] It should be noted that the report generation device part in the embodiments of this disclosure corresponds to the report generation method part in the embodiments of this disclosure. For a detailed description of the report generation device part, please refer to the report generation method part, which will not be repeated here.

[0143] Figure 9 A block diagram of an electronic device suitable for implementing a report generation method according to an embodiment of the present disclosure is shown schematically. Figure 9 The electronic device shown is merely an example and should not be construed as limiting the functionality and scope of the embodiments disclosed herein.

[0144] like Figure 9As shown, a computer electronic device 900 according to an embodiment of the present disclosure includes a processor 901, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 902 or a program loaded from a storage portion 908 into a random access memory (RAM) 903. The processor 901 may include, for example, a general-purpose microprocessor (e.g., a CPU), an instruction set processor and / or an associated chipset and / or a special-purpose microprocessor (e.g., an application-specific integrated circuit (ASIC)), etc. The processor 901 may also include onboard memory for caching purposes. The processor 901 may include a single processing unit or multiple processing units for performing different actions of the method flow according to an embodiment of the present disclosure.

[0145] RAM 903 stores various programs and data required for the operation of electronic device 900. Processor 901, ROM 902, and RAM 903 are interconnected via bus 904. Processor 901 performs various operations of the method flow according to embodiments of the present disclosure by executing programs in ROM 902 and / or RAM 903. It should be noted that the programs may also be stored in one or more memories other than ROM 902 and RAM 903. Processor 901 may also perform various operations of the method flow according to embodiments of the present disclosure by executing programs stored in said one or more memories.

[0146] According to embodiments of this disclosure, the electronic device 900 may further include an input / output (I / O) interface 905, which is also connected to a bus 904. The electronic device 900 may also include one or more of the following components connected to the I / O interface 905: an input section 906 including a keyboard, mouse, etc.; an output section 907 including a cathode ray tube (CRT), liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 908 including a hard disk, etc.; and a communication section 909 including a network interface card such as a LAN card, modem, etc. The communication section 909 performs communication processing via a network such as the Internet. A drive 910 is also connected to the I / O interface 905 as needed. A removable medium 911, such as a disk, optical disk, magneto-optical disk, semiconductor memory, etc., is installed on the drive 910 as needed so that computer programs read from it can be installed into the storage section 908 as needed.

[0147] According to embodiments of this disclosure, the method flow according to embodiments of this disclosure can be implemented as a computer software program. For example, embodiments of this disclosure include a computer program product comprising a computer program carried on a computer-readable storage medium, the computer program containing program code for performing the methods shown in the flowchart. In such embodiments, the computer program can be downloaded and installed from a network via communication section 909, and / or installed from removable medium 911. When the computer program is executed by processor 901, it performs the functions defined in the system of embodiments of this disclosure. According to embodiments of this disclosure, the systems, devices, apparatuses, modules, units, etc., described above can be implemented by computer program modules.

[0148] This disclosure also provides a computer-readable storage medium, which may be included in the device / apparatus / system described in the above embodiments; or it may exist independently and not assembled into the device / apparatus / system. The computer-readable storage medium carries one or more programs that, when executed, implement the method according to the embodiments of this disclosure.

[0149] According to embodiments of this disclosure, the computer-readable storage medium can be a non-volatile computer-readable storage medium. Examples include, but are not limited to: portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof. In this disclosure, the computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.

[0150] For example, according to embodiments of this disclosure, a computer-readable storage medium may include the ROM 902 and / or RAM 903 described above and / or one or more memories other than ROM 902 and RAM 903.

[0151] Embodiments of this disclosure also include a computer program product comprising a computer program containing program code for performing the methods provided in the embodiments of this disclosure. When the computer program product is run on an electronic device, the program code is used to enable the electronic device to implement the report generation method provided in the embodiments of this disclosure.

[0152] When the computer program is executed by the processor 901, it performs the functions defined in the system / apparatus of this disclosure embodiments. According to embodiments of this disclosure, the systems, apparatuses, modules, units, etc., described above can be implemented by computer program modules.

[0153] In one embodiment, the computer program may rely on a tangible storage medium such as an optical storage device or a magnetic storage device. In another embodiment, the computer program may also be transmitted and distributed in the form of signals over a network medium, and downloaded and installed via the communication section 909, and / or installed from a removable medium 911. The program code contained in the computer program can be transmitted using any suitable network medium, including but not limited to: wireless, wired, etc., or any suitable combination thereof.

[0154] According to embodiments of this disclosure, program code for executing the computer programs provided in embodiments of this disclosure can be written in any combination of one or more programming languages. Specifically, these computational programs can be implemented using high-level procedural and / or object-oriented programming languages, and / or assembly / machine languages. Programming languages ​​include, but are not limited to, languages ​​such as Java, C++, Python, "C", or similar programming languages. The program code can execute entirely on the user's computing device, partially on the user's device, partially on a remote computing device, or entirely on a remote computing device or server. In cases involving remote computing devices, the remote computing device can be connected to the user's computing device via any type of network, including a local area network (LAN) or a wide area network (WAN), or it can be connected to an external computing device (e.g., via the Internet using an Internet service provider).

[0155] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of the present disclosure. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in a block diagram or flowchart, and combinations of blocks in a block diagram or flowchart, may be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions. Those skilled in the art will understand that the features recited in the various embodiments and / or claims of this disclosure can be combined and / or combined in various ways, even if such combinations or combinations are not expressly described in this disclosure. In particular, the features described in the various embodiments and / or claims of this disclosure may be combined and / or combined in various ways without departing from the spirit and teachings of this disclosure. All such combinations and / or combinations fall within the scope of this disclosure.

[0156] The embodiments of this disclosure have been described above. However, these embodiments are for illustrative purposes only and are not intended to limit the scope of this disclosure. Although various embodiments have been described above, this does not mean that the measures in the various embodiments cannot be used advantageously in combination. The scope of this disclosure is defined by the appended claims and their equivalents. Various substitutions and modifications can be made by those skilled in the art without departing from the scope of this disclosure, and all such substitutions and modifications should fall within the scope of this disclosure.

Claims

1. A report generation method, applied to a first electronic device, the method comprising: In response to a report generation request, based on the report type carried in the report generation request, multiple report information corresponding to the report type are determined from the report generation system; Based on the summary information of the report information, multiple reports are classified to obtain classification results; Based on the classification results, obtain multiple original tables that correspond one-to-one with the multiple report information; Using a preset association template corresponding to the report type, an intermediate table is generated based on multiple original tables; as well as The intermediate table is sent to the second electronic device so that the second electronic device can generate the target table body based on the intermediate table, generate the target table header based on the input information of the first user, and concatenate the target table body and the target table header to obtain the target table. The summary information of the report information includes the indicator types of the data in the report, and the indicator types include data indicator types and dimension indicator types; The step of classifying multiple reports based on the summary information of the report information to obtain classification results includes: When the summary information indicates that the data in the report contains data of the data indicator type, the classification result indicates that the report corresponding to the report information is the original data table; and If the summary information indicates that the data in the report does not contain data of the data indicator type, then the classification result indicates that the report corresponding to the report information is a dimension original table. The summary information of the report includes the pattern of data change in the report; The step of classifying multiple reports based on the summary information of the report information to obtain classification results includes: When the summary information indicates that the data in the report has a preset pattern of change, the classification result indicates that the report corresponding to the report information is the original data table; and If the summary information indicates that the data in the report does not have a pattern of change, then the classification result indicates that the report corresponding to the report information is a dimension original table. The step of obtaining multiple original tables that correspond one-to-one with the multiple report information based on the classification results includes: For each of the aforementioned report information, if the classification result of the report information indicates that the report corresponding to the report information is the original data table, then the original table corresponding to the report information is retrieved from the data warehouse; and If the classification result of the report information indicates that the report corresponding to the report information is the original table of the dimension, the original table corresponding to the report information is obtained based on the input information of the second user.

2. The method according to claim 1, wherein, The step of generating an intermediate table based on multiple original tables using a preset association template corresponding to the report type includes: Based on the multiple original tables and the preset association template, a structured query statement is generated; and Execute the structured query statement to obtain the intermediate table.

3. The method according to claim 1, further comprising: The intermediate table and the report generation request are associated and stored in the data warehouse; as well as Set an expiration time for the intermediate table.

4. The method according to claim 3, further comprising: In response to a target report generation request, the target report type carried in the target report generation request is matched with the report type of the intermediate table in the data warehouse to obtain a matching result; If the matching result indicates that a target intermediate table matching the target report type exists in the data warehouse, the target intermediate table is retrieved from the data warehouse. as well as The target intermediate table is sent to the second electronic device.

5. A report generation method, applied to a second electronic device, the method comprising: In response to receiving an intermediate table from a first electronic device, a target table body is generated based on the intermediate table; Generate the target table header based on the input information from the first user; as well as The target table body and the target table header are concatenated to obtain the target table; The first electronic device is configured as follows: In response to a report generation request, based on the report type carried in the report generation request, multiple report information corresponding to the report type are determined from the report generation system; Based on the summary information of the report information, multiple reports are classified to obtain classification results; Based on the classification results, obtain multiple original tables that correspond one-to-one with the information in the multiple reports; and Using a preset association template corresponding to the report type, an intermediate table is generated based on multiple original tables; The summary information of the report information includes the indicator types of the data in the report, and the indicator types include data indicator types and dimension indicator types; The step of classifying multiple reports based on the summary information of the report information to obtain classification results includes: When the summary information indicates that the data in the report contains data of the data indicator type, the classification result indicates that the report corresponding to the report information is the original data table; and If the summary information indicates that the data in the report does not contain data of the data indicator type, then the classification result indicates that the report corresponding to the report information is a dimension original table. The summary information of the report includes the pattern of data change in the report; The step of classifying multiple reports based on the summary information of the report information to obtain classification results includes: When the summary information indicates that the data in the report has a preset pattern of change, the classification result indicates that the report corresponding to the report information is the original data table; and If the summary information indicates that the data in the report does not have a pattern of change, then the classification result indicates that the report corresponding to the report information is a dimension original table. The step of obtaining multiple original tables that correspond one-to-one with the multiple report information based on the classification results includes: For each of the aforementioned report information, if the classification result of the report information indicates that the report corresponding to the report information is the original data table, then the original table corresponding to the report information is retrieved from the data warehouse; and If the classification result of the report information indicates that the report corresponding to the report information is the original table of the dimension, the original table corresponding to the report information is obtained based on the input information of the second user.

6. A report generation system, comprising a first electronic device, a second electronic device, and a data warehouse, wherein: The first electronic device is configured as follows: In response to a report generation request, based on the report type carried in the report generation request, multiple report information corresponding to the report type are determined from the report generation system; Based on the summary information of the report information, multiple reports are classified to obtain classification results; Based on the classification results, obtain multiple original tables that correspond one-to-one with the multiple report information; Using a preset association template corresponding to the report type, an intermediate table is generated based on multiple original tables; as well as Send the intermediate table to the second electronic device; The summary information of the report information includes the indicator types of the data in the report, and the indicator types include data indicator types and dimension indicator types; The step of classifying multiple reports based on the summary information of the report information to obtain classification results includes: When the summary information indicates that the data in the report contains data of the data indicator type, the classification result indicates that the report corresponding to the report information is the original data table; and If the summary information indicates that the data in the report does not contain data of the data indicator type, then the classification result indicates that the report corresponding to the report information is a dimension original table. The summary information of the report includes the pattern of data change in the report; The step of classifying multiple reports based on the summary information of the report information to obtain classification results includes: When the summary information indicates that the data in the report has a preset pattern of change, the classification result indicates that the report corresponding to the report information is the original data table; and If the summary information indicates that the data in the report does not have a pattern of change, then the classification result indicates that the report corresponding to the report information is a dimension original table. The step of obtaining multiple original tables that correspond one-to-one with the multiple report information based on the classification results includes: For each of the aforementioned report information, if the classification result of the report information indicates that the report corresponding to the report information is the original data table, then the original table corresponding to the report information is retrieved from the data warehouse; and If the classification result of the report information indicates that the report corresponding to the report information is the original table of the dimension, the original table corresponding to the report information is obtained based on the input information of the second user. The second electronic device is configured as follows: In response to receiving an intermediate table from the first electronic device, a target table body is generated based on the intermediate table; Generate the target table header based on the input information from the first user; and The target table body and the target table header are concatenated to obtain the target table.

7. A report generation device, disposed in a first electronic device, the device comprising: The determination module is used to respond to a report generation request and, based on the report type carried in the report generation request, determine multiple report information corresponding to the report type from the report generation system. The classification module is used to classify multiple report information items based on the summary information of the report information to obtain classification results; The first acquisition module is used to acquire multiple original tables that correspond one-to-one with the multiple report information based on the classification results; The first generation module is used to generate an intermediate table based on multiple original tables using a preset association template corresponding to the report type. as well as The first sending module is used to send the intermediate table to the second electronic device, so that the second electronic device can generate a target table body based on the intermediate table, generate a target table header based on the input information of the first user, and concatenate the target table body and the target table header to obtain the target table; The summary information of the report information includes the indicator types of the data in the report, and the indicator types include data indicator types and dimension indicator types; The step of classifying multiple reports based on the summary information of the report information to obtain classification results includes: When the summary information indicates that the data in the report contains data of the data indicator type, the classification result indicates that the report corresponding to the report information is the original data table; and If the summary information indicates that the data in the report does not contain data of the data indicator type, then the classification result indicates that the report corresponding to the report information is a dimension original table. The summary information of the report includes the pattern of data change in the report; The step of classifying multiple reports based on the summary information of the report information to obtain classification results includes: When the summary information indicates that the data in the report has a preset pattern of change, the classification result indicates that the report corresponding to the report information is the original data table; and If the summary information indicates that the data in the report does not have a pattern of change, then the classification result indicates that the report corresponding to the report information is a dimension original table. The step of obtaining multiple original tables that correspond one-to-one with the multiple report information based on the classification results includes: For each of the aforementioned report information, if the classification result of the report information indicates that the report corresponding to the report information is the original data table, then the original table corresponding to the report information is retrieved from the data warehouse; and If the classification result of the report information indicates that the report corresponding to the report information is the original table of the dimension, the original table corresponding to the report information is obtained based on the input information of the second user.

8. A report generation device, disposed in a second electronic device, the device comprising: The second generation module is used to generate a target table body based on the intermediate table received from the first electronic device in response to receiving the intermediate table. The third generation module is used to generate the target table header based on the input information of the first user; as well as The splicing module is used to splice the target table body and the target table header to obtain the target table; The first electronic device is configured as follows: In response to a report generation request, based on the report type carried in the report generation request, multiple report information corresponding to the report type are determined from the report generation system; Based on the summary information of the report information, multiple reports are classified to obtain classification results; Based on the classification results, obtain multiple original tables that correspond one-to-one with the information in the multiple reports; and Using a preset association template corresponding to the report type, an intermediate table is generated based on multiple original tables; The summary information of the report information includes the indicator types of the data in the report, and the indicator types include data indicator types and dimension indicator types; The step of classifying multiple reports based on the summary information of the report information to obtain classification results includes: When the summary information indicates that the data in the report contains data of the data indicator type, the classification result indicates that the report corresponding to the report information is the original data table; and If the summary information indicates that the data in the report does not contain data of the data indicator type, then the classification result indicates that the report corresponding to the report information is a dimension original table. The summary information of the report includes the pattern of data change in the report; The step of classifying multiple reports based on the summary information of the report information to obtain classification results includes: When the summary information indicates that the data in the report has a preset pattern of change, the classification result indicates that the report corresponding to the report information is the original data table; and If the summary information indicates that the data in the report does not have a pattern of change, then the classification result indicates that the report corresponding to the report information is a dimension original table. The step of obtaining multiple original tables that correspond one-to-one with the multiple report information based on the classification results includes: For each of the aforementioned report information, if the classification result of the report information indicates that the report corresponding to the report information is the original data table, then the original table corresponding to the report information is retrieved from the data warehouse; and If the classification result of the report information indicates that the report corresponding to the report information is the original table of the dimension, the original table corresponding to the report information is obtained based on the input information of the second user.

9. An electronic device, comprising: One or more processors; Storage device for storing one or more programs. When the one or more programs are executed by the one or more processors, the one or more processors perform the method according to any one of claims 1 to 4 or claim 5.

10. A computer-readable storage medium having executable instructions stored thereon, which, when executed by a processor, cause the processor to perform the method according to any one of claims 1 to 4 or claim 5.

11. A computer program product comprising a computer program that, when executed by a processor, implements the method according to any one of claims 1 to 4 or claim 5.

Images