Report generation method, device, electronic device and computer readable medium

Abstract

The present invention discloses a report generation method, device, electronic device and computer-readable medium, and relates to the field of big data technology. A specific implementation of the method includes: performing demand analysis and report design on original reports from different data sources to determine the report items, report indicators and analysis dimensions of the target report; determining the data source and data acquisition logic of the report items in the target report according to the report indicators and analysis dimensions; using a data extraction tool to extract the corresponding original data from the data source and load it into a report database according to the data source and data acquisition logic; using a visualization tool connected to the report database to obtain report data from the report database, and displaying it according to the report style configured for the target report. This implementation can integrate data from different data sources, quickly generate visual reports suitable for different demand parties, and improve the efficiency of report generation.

Description

Technical Field

[0001] The present invention relates to the field of big data technology, and in particular to a report generation method, device, electronic device and computer-readable medium. Background Art

[0002] Due to differences in management systems, transaction conditions, and usage, the digital housing systems in various cities have local characteristics in their reporting needs. There are certain differences in reporting styles and indicator calibers, resulting in a large number of reports in the digital housing systems of various cities, which are unable to be interconnected. Their data are in an isolated state, and it is impossible to form a digital housing data resource center. Summary of the invention

[0003] In view of this, an embodiment of the present invention provides a report generation method, device, electronic device and computer-readable medium. The method can integrate data from different data sources by performing report analysis, data tracing, data extraction and visual loading on original reports from different data sources, and quickly generate visual reports suitable for different demand parties, thereby improving report generation efficiency.

[0004] To achieve the above objective, according to one aspect of an embodiment of the present invention, a report generation method is provided.

[0005] A report generation method according to an embodiment of the present invention comprises: performing demand analysis and report design on original reports from different data sources to determine report items, report indicators and analysis dimensions of a target report;

[0006] Determine the data source and data acquisition logic of the report items in the target report based on the report indicators and analysis dimensions;

[0007] According to the data source and data acquisition logic, use the data extraction tool to extract the corresponding raw data from the data source and load it into the report database;

[0008] Use the visualization tool connected to the report database to obtain report data from the report database and display it according to the report style configured for the target report.

[0009] Optionally, perform requirements analysis on original reports from different data sources, including:

[0010] Disassemble the original reports from different data sources to obtain data items;

[0011] Define and merge data items to obtain corresponding report items.

[0012] Optionally, the original report includes a single-column report and a matrix report;

[0013] The original reports from different data sources are disassembled to obtain data items, including:

[0014] Obtain the column header of the single-line report in the original report from different data sources, and use the column header of the single-line report as the data item;

[0015] The row header and column header of the matrix report in the original report from different data sources are obtained, and the combination of the row header and column header of the matrix report is used as a data item.

[0016] Optionally, report design, including:

[0017] Compare the report items of the original report with the report items obtained from the demand analysis, confirm that they are consistent, and use the original report as the target report;

[0018] Separate the report indicators and analysis dimensions of the target report from the preset report template.

[0019] Optionally, the method further comprises:

[0020] Design the data architecture of the report database; the data architecture includes the source layer, detail layer and theme layer. The source layer is used to store raw data. The detail layer is obtained by preprocessing the raw data of the source layer according to the specified granularity. The theme layer is obtained by mapping the data of the detail layer or the source layer.

[0021] Use data extraction tools to extract the corresponding raw data from the data source and load it into the reporting database, including:

[0022] Use data extraction tools to extract corresponding raw data from the data source, and load the raw data into the source layer of the report database; the data source is used to store data housing data.

[0023] Optionally, obtain report data from a report database, including:

[0024] According to the report indicators and analysis dimensions, the corresponding report data is queried from the subject layer of the report database.

[0025] Optionally, the method further comprises:

[0026] Write test cases based on report indicators as test granularity;

[0027] Use test cases to verify report data and obtain verification data.

[0028] To achieve the above objective, according to another aspect of an embodiment of the present invention, a report generating device is provided.

[0029] A report generation device according to an embodiment of the present invention includes: an analysis and design module for performing demand analysis and report design on original reports from different data sources to determine report items, report indicators and analysis dimensions of a target report;

[0030] The data tracing module is used to determine the data source and data acquisition logic of the report items in the target report based on the report indicators and analysis dimensions;

[0031] The extraction and loading module is used to extract the corresponding raw data from the data source and load it into the report database using the data extraction tool according to the data source and data acquisition logic;

[0032] The report display module is used to obtain report data from the report database using a visualization tool connected to the report database, and display it according to the report style configured for the target report.

[0033] Optionally, the analysis and design module is also used to

[0034] Disassemble the original reports from different data sources to obtain data items;

[0035] Define and merge data items to obtain corresponding report items.

[0036] Optionally, the original report includes a single-column report and a matrix report;

[0037] The analysis and design module is further used to obtain the column header of the single-line report in the original report from the different data sources, and use the column header of the single-line report as the data item; and

[0038] The row header and column header of the matrix report in the original report from different data sources are obtained, and the combination of the row header and column header of the matrix report is used as a data item.

[0039] Optionally, the analysis and design module is also used to

[0040] Compare the report items of the original report with the report items obtained from the demand analysis, confirm that they are consistent, and use the original report as the target report;

[0041] Separate the report indicators and analysis dimensions of the target report from the preset report template.

[0042] Optionally, the device further comprises:

[0043] The architecture design module is used to design the data architecture of the report database; the data architecture includes the source layer, detail layer and theme layer. The source layer is used to store the original data. The detail layer is obtained by preprocessing the original data of the source layer according to the specified granularity. The theme layer is obtained by mapping the data of the detail layer or the source layer.

[0044] The extraction and loading module is also used to use the data extraction tool to extract the corresponding original data from the data source, and load the original data into the source layer of the report database; wherein the data source is used to store data housing data.

[0045] Optionally, the report display module is also used to

[0046] According to the report indicators and analysis dimensions, the corresponding report data is queried from the subject layer of the report database.

[0047] Optionally, the device further comprises:

[0048] The report verification module is used to write test cases based on report indicators as the test granularity; and

[0049] Use test cases to verify report data and obtain verification data.

[0050] To achieve the above objective, according to another aspect of an embodiment of the present invention, an electronic device is provided.

[0051] An electronic device according to an embodiment of the present invention includes: one or more processors; a 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 implement a report generation method according to an embodiment of the present invention.

[0052] To achieve the above objective, according to another aspect of the embodiments of the present invention, a computer readable medium is provided.

[0053] A computer-readable medium according to an embodiment of the present invention stores a computer program, and when the program is executed by a processor, a report generation method according to an embodiment of the present invention is implemented.

[0054] To achieve the above objective, according to another aspect of an embodiment of the present invention, a computer program product is provided.

[0055] A computer program product according to an embodiment of the present invention includes a computer program, and when the program is executed by a processor, a report generation method according to an embodiment of the present invention is implemented.

[0056] One embodiment of the above invention has the following advantages or beneficial effects: by performing report analysis, data tracing, data extraction and visual loading on original reports from different data sources, data from different data sources can be integrated to quickly generate visual reports suitable for different demand parties, thereby improving report generation efficiency. By disassembling the original report, defining data items and merging data items, it is ensured that the report items obtained meet business needs while being practical and non-redundant.

[0057] By disassembling the single-column report and the matrix report, the accuracy and completeness of the disassembled data items are guaranteed. By comparing the original report with the report items obtained from the demand analysis and splitting the report template, the conversion of report items to report indicators and analysis dimensions is realized, and an indicator system is constructed. By designing a report database including the source layer, data exchange with the business database is realized without affecting business processing.

[0058] Query report data from the subject layer of the report database so that the acquired data is processed and summarized, which is convenient for quickly realizing visual reports of various data. By verifying the queried report data, the accuracy of the data is guaranteed to meet user needs.

[0059] The further effects of the above-mentioned non-conventional optional manner will be described below in conjunction with the specific implementation manner. BRIEF DESCRIPTION OF THE DRAWINGS

[0060] The accompanying drawings are used to better understand the present invention and do not constitute an improper limitation of the present invention.

[0061] Figure 1 is a schematic diagram of the main steps of the report generation method according to the first embodiment of the present invention;

[0062] Figure 2 is a schematic diagram of the system architecture of the report generation method according to the second embodiment of the present invention;

[0063] Figure 3 It is a schematic diagram of the main process of the report generation method of the second embodiment of the present invention;

[0064] Figure 4 It is a schematic diagram of the main process of the report generation method of the third embodiment of the present invention;

[0065] Figure 5 is a schematic diagram of the main modules of the report generating device according to an embodiment of the present invention;

[0066] Figure 6 is an exemplary system architecture diagram to which embodiments of the present invention may be applied;

[0067] Figure 7 It is a schematic diagram of the structure of a computer system suitable for implementing an electronic device of an embodiment of the present invention. DETAILED DESCRIPTION

[0068] The following is a description of exemplary embodiments of the present invention in conjunction with the accompanying drawings, including various details of the embodiments of the present invention to facilitate understanding, which should be considered as merely exemplary. Therefore, it should be recognized by those of ordinary skill in the art that various changes and modifications may be made to the embodiments described herein without departing from the scope and spirit of the present invention. Similarly, for clarity and conciseness, the description of well-known functions and structures is omitted in the following description.

[0069] The acquisition, storage, use, and processing of data in the technical solution of this application comply with the relevant provisions of national laws and regulations.

[0070] Embodiment 1

[0071] Figure 1 FIG. 1 is a schematic diagram of the main steps of the report generation method according to the first embodiment of the present invention. Figure 1 As shown, the report generation method of the first embodiment of the present invention mainly includes the following steps:

[0072] Step S101: Perform demand analysis and report design on the original reports from different data sources to determine the report items, report indicators and analysis dimensions of the target report. The demand analysis process includes: disassembling the original reports from different data sources to obtain data items; then defining and merging the data items to obtain corresponding report items. Data item definition means defining the business meaning and business scope of the data items, and data item merging means removing duplicate and meaningless data items.

[0073] The report design process includes: comparing the report items of the original report with the report items obtained from the demand analysis, confirming the consistency of the comparison, and taking the original report as the target report; splitting the report indicators and analysis dimensions of the target report from the preset report template. Report indicators are indicators that support report analysis, which can explain the concept of overall quantitative characteristics and the synthesis of their values; analysis dimensions such as time dimension, space dimension, product dimension, etc.

[0074] Step S102: Determine the data source and data acquisition logic of the report items in the target report based on the report indicators and analysis dimensions. This step is used to trace the data source, that is, to clarify the data source and data acquisition logic (i.e., caliber). For example, if the report indicator is indicator 1 and the analysis dimension is time, the data source is the storage location of the report item data that meets indicator 1 and the time dimension; the data acquisition logic is the logic of how to obtain the report item data.

[0075] Step S103: According to the data source and data acquisition logic, use the data extraction tool to extract the corresponding original data from the data source and load it into the report database. Use a data extraction tool, such as an ETL (Extract-Transform-Load) tool, to extract, transform, and load the original data from the data source into the report database according to the data source and data acquisition logic.

[0076] Step S104: Use a visualization tool connected to the report database to obtain report data from the report database and display it according to the report style configured for the target report. Connect a visualization tool, such as a BI (Business Intelligence) tool, Echarts, Excel, etc., to the report database. After the connection is completed, use the visualization tool to obtain report data from the report database, and then display the report data according to the report style configured for the target report.

[0077] This embodiment provides a report generation method, which solves the problem that data from different data sources are in data islands and general reports cannot be quickly generated. At the same time, with the help of visualization tools, visual reports of various data are realized, thereby improving the efficiency of report generation.

[0078] Embodiment 2

[0079] Figure 2 Schematic diagram of the system architecture of the report generation method of the second embodiment of the present invention. Figure 2 As shown, the report generation method of the embodiment of the present invention is implemented by a report analysis module, a model design and development module, and a report development module. Among them, the report design module is used to perform demand analysis and report design on original reports from different data sources, as well as data tracing, to obtain a report list, an indicator list, and indicator tracing.

[0080] The model design and development module is used to design the data architecture of the report database, perform ETL development based on the data architecture, and obtain the report database and model script. The report development module is used to use BI tools to develop reports, and after data verification, perform report deployment, testing, and acceptance. Among them, BI tools are business intelligence analysis tools that are used to effectively integrate existing data in the enterprise, quickly and accurately provide reports and provide decision-making basis, helping enterprises make wise business operation decisions.

[0081] Figure 3 FIG. 1 is a schematic diagram of the main process of the report generation method according to the second embodiment of the present invention. Figure 3 As shown, the report generation method of the second embodiment of the present invention mainly includes the following steps:

[0082] Step S301: Perform demand analysis and report design on original reports from different data sources to determine the report items, report indicators and analysis dimensions of the target report. Original reports include single-column reports and matrix reports, where a single-column report refers to a report in which the first column is a report item and other columns are value types; a matrix report refers to a report in which the first column and the report header together constitute the report item.

[0083] Demand analysis includes the process of automatically disassembling original reports from different data sources to obtain data items, and the process of defining and merging data items to obtain report items. The implementation process of automatically disassembling original reports from different data sources is as follows: obtain the column headers of single-column reports from original reports from different data sources, and use the column headers of single-column reports as data items; obtain the row headers and column headers of matrix reports from original reports from different data sources, and use the combination of the row headers and column headers of the matrix report as data items.

[0084] Defining data items includes defining the business meaning and business scope of data items. Business scope refers to the standard used for statistical data of data items. For example, the business scope of returning home to buy property in XX city is determined by ID card, and the issuing authority on the ID card must be from another place, or the first 4 digits of the ID card must be from this city. Defining business scope can ensure that the reports developed in the subsequent data can meet the needs of business personnel.

[0085] Merging data items means removing duplicate data items and meaningless data items. Meaningless here means having no practical effect on business analysis. In an embodiment, the deduplication function of Excel can be used to achieve data item merging.

[0086] Report design is to compare the report items of the original report with the report items obtained from the demand analysis, determine whether the comparison is consistent, and use the original report as the target report; split the report indicators and analysis dimensions of the target report from the preset report template, and define the meaning of the report indicators, statistical caliber, and data acquisition logic.

[0087] In a preferred embodiment, if there are identical data items in multiple original reports, the identical data items are merged; for different data items, the data items can be split and then the target report can be designed according to the same statistical granularity. In addition, for special reports, such as reports specific to a certain region, it is determined whether to use them as target reports according to their importance.

[0088] Step S302: Determine the data source and data acquisition logic of the report items in the target report according to the report indicators and analysis dimensions. Determine the data source and data acquisition logic of the report items in the target report according to the report indicators and analysis dimensions.

[0089] Step S303: Design the data architecture of the report database, and develop the ETL tool based on the data architecture of the report database. The data architecture of the report database includes the source layer, detail layer, and subject layer, where the source layer is used to store the original data and interact with the business database; the detail layer is obtained by preprocessing the original data of the source layer according to the specified granularity; the subject layer is obtained by mapping the data of the detail layer or the source layer, and is used to summarize to the granularity required by the target report.

[0090] Develop ETL tools based on the data architecture of the reporting database, that is, use database connection (DB-LINK) technology to establish a connection between the reporting database and the business database, run batch jobs in the reporting database, and then use the Oracle database's SqlLoad method and loading tool to load source data to load the data in the business database into the reporting database.

[0091] Step S304: According to the data source and data retrieval logic, use the ETL tool to extract the corresponding original data from the data source and load it into the report database. Use the developed ETL tool to extract, transform, and load the original data from the data source into the source layer of the report database according to the data source and data retrieval logic.

[0092] Step S305: Use the BI tool connected to the report database to obtain report data from the report database and verify the report data. Connect the template designer of the BI tool to the corresponding report database, and then query the corresponding report data from the subject layer of the report database according to the report indicators and analysis dimensions. After filtering the report data, perform data verification to confirm the correctness of the report and the satisfaction of the function.

[0093] In the embodiment, it is necessary to write test cases in advance with report indicators as the test granularity. When data verification is required, the report data is verified using the test case to obtain verification data. When writing test cases, positive and negative test cases can be written and designed based on report requirements from the perspectives of report style, functionality, data accuracy, authority, etc., with report indicators as the test granularity.

[0094] Step S306: After verification, the BI tool displays the report data according to the report style configured for the target report. Configure the report style of the target report on the BI tool, fill in the verified report data according to the report style, and perform visual display. This embodiment designs and develops a general report suitable for different data sources, and can quickly generate the required report style, thereby improving the efficiency of report generation.

[0095] Figure 4 FIG. 1 is a schematic diagram of the main process of the report generation method according to the third embodiment of the present invention. Figure 4As shown, the report generation method of the second embodiment of the present invention mainly includes the following steps:

[0096] Step S401: Conduct demand analysis and report design on the original reports of the digital housing system in various cities to determine the report items, report indicators and analysis dimensions of the target report. The digital housing system covers the entire life cycle of housing business links such as "construction, sale, management, and collection", and can timely make up for the shortcomings and deficiencies of housing information management. The target report can standardize the reports related to digital housing in various cities, integrate them into standard reports for use by various cities, and output relevant indicators of digital housing.

[0097] The demand analysis includes the process of automatically disassembling the original reports of the digital housing systems of various cities to obtain data items, and the process of defining and merging the data items to obtain report items. In the embodiment, the automatic disassembly can be implemented using the Xlrd module written in Python language.

[0098] Report design is to compare the report items of the original reports of various cities with the report items obtained from the demand analysis. If the two are completely consistent, the original report will be directly used as the target report. The report indicators and analysis dimensions of the target report are separated from the preset report template, and the meaning, statistical caliber and data acquisition logic of the report indicators are defined. The report template is pre-built based on business experience, including multiple report indicators and analysis dimensions, and is used to generate a template for the target report.

[0099] In a preferred embodiment, if there are the same data items in the original reports of various cities, the same data items are merged; for different data items, the data items can be split and the target report can be designed according to the same statistical granularity. In addition, for special reports, such as reports unique to a certain city, it is determined whether to use them as target reports according to their importance.

[0100] Step S402: Determine the data source and data acquisition logic of the report items in the target report according to the report indicators and analysis dimensions. Determine the data source and data acquisition logic of the report items in the target report according to the report indicators and analysis dimensions.

[0101] Step S403: Design the data architecture of the report database and develop ETL tools based on the data architecture of the report database. In order not to affect the application business processing, the report uses a separate report database, and a layer of source data is added to the report database to exchange data with the business database.

[0102] In an embodiment, the data architecture of the report database includes a source layer, a detail layer, and a theme layer. Among them, the source layer is used to store raw data and interact with the business database, which can solve the problems of data synchronization and increment. The detail layer is obtained by preprocessing the raw data of the source layer according to the specified granularity. The preprocessing includes data cleaning and avoids data granularity confusion. The theme layer is obtained by mapping the data of the detail layer or the source layer, and is used to process and summarize the data to the granularity required for the target report according to the report style, report indicators and analysis dimensions.

[0103] Step S404: According to the data source and data acquisition logic, use the ETL tool to extract the corresponding original data from the data source and load it into the report database. The specific implementation of this step is shown in step S304, which will not be described here.

[0104] Step S405: Use the BI tool connected to the report database to obtain report data from the report database and verify the report data. Connect the template designer of the BI tool to the corresponding report database, and then set parameters from different dimensions according to the report requirements and pass them to the theme layer to achieve queries with different parameter values, and then perform parameter filtering and generate report data according to the required data range.

[0105] After generating report data, write and design positive and negative test cases based on report requirements, from the perspectives of report style, functionality, data accuracy, permissions, etc., with report indicators as the test granularity. When data verification is required, use positive and negative test cases to verify the report data, obtain the verification results, and export the verification results.

[0106] Step S406: After verification, the BI tool displays the report data according to the report style configured for the target report. Configure the report style of the target report on the BI tool, fill in the verified report data according to the report style, and display it visually. This embodiment breaks the data silos of digital housing systems in various cities, designs and develops universal digital housing reports suitable for different cities, establishes a digital housing data resource center, and can quickly generate the required report style with the help of BI tools, thereby improving the efficiency of report generation.

[0107] Figure 5 FIG. 1 is a schematic diagram of the main modules of the report generation device according to an embodiment of the present invention. Figure 5 As shown, the report generation device 500 of the embodiment of the present invention mainly includes:

[0108] The analysis and design module 501 is used to perform demand analysis and report design on the original reports from different data sources to determine the report items, report indicators and analysis dimensions of the target report. The demand analysis process includes: respectively disassembling the original reports from different data sources to obtain data items; then performing data item definition and data item merging on the data items to obtain corresponding report items. Data item definition means defining the business meaning and business scope of the data items, and data item merging means removing duplicate and meaningless data items.

[0109] The report design process includes: comparing the report items of the original report with the report items obtained from the demand analysis, confirming that the comparison is consistent, and using the original report as the target report; splitting the report indicators and analysis dimensions of the target report from the preset report template. Report indicators are indicators that support report analysis, and analysis dimensions include time dimension, space dimension, product dimension, etc.

[0110] The data tracing module 502 is used to determine the data source and data acquisition logic of the report items in the target report according to the report indicators and analysis dimensions. This module is used to trace the data, that is, to clarify the data source and data acquisition logic (i.e., caliber). For example, if the report indicator is indicator 1 and the analysis dimension is time, the data source is the storage location of the report item data that meets indicator 1 and the time dimension; the data acquisition logic is the logic of how to obtain the report item data.

[0111] The extraction and loading module 503 is used to extract the corresponding raw data from the data source and load it into the report database using a data extraction tool according to the data source and data acquisition logic. Using a data extraction tool, such as an ETL tool, the raw data is extracted, converted, and loaded into the report database from the data source according to the data source and data acquisition logic.

[0112] The report display module 504 is used to use a visualization tool connected to the report database to obtain report data from the report database and display it according to the report style configured for the target report. A visualization tool, such as a BI tool, Echarts, Excel, etc., is connected to the report database. After the connection is completed, the visualization tool is used to obtain report data from the report database, and then the report data is displayed according to the report style configured for the target report.

[0113] In addition, the report generation device 500 of the embodiment of the present invention may also include: an architecture design module and a report verification module ( Figure 5 The architecture design module is used to design the data architecture of the report database; the data architecture includes a source layer, a detail layer and a theme layer, the source layer is used to store the original data, the detail layer is obtained by preprocessing the original data of the source layer according to the specified granularity, and the theme layer is obtained by mapping the data of the detail layer or the source layer.

[0114] The report verification module is used to write test cases based on report indicators as the test granularity; and to use the test cases to verify the report data to obtain verification data.

[0115] From the above description, it can be seen that by performing report analysis, data tracing, data extraction and visual loading on original reports from different data sources, it is possible to integrate data from different data sources and quickly generate visual reports suitable for different demand parties, thereby improving report generation efficiency.

[0116] Figure 6 An exemplary system architecture 600 is shown to which the report generating method or the report generating apparatus according to the embodiment of the present invention can be applied.

[0117] like Figure 6 As shown, system architecture 600 may include terminal devices 601, 602, 603, network 604 and server 605. Network 604 is used to provide a medium for communication links between terminal devices 601, 602, 603 and server 605. Network 604 may include various connection types, such as wired, wireless communication links or optical fiber cables, etc.

[0118] Users can use terminal devices 601, 602, 603 to interact with server 605 through network 604 to receive or send messages, etc. Terminal devices 601, 602, 603 can be various electronic devices with display screens and supporting web browsing, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, etc.

[0119] The server 605 may be a server that provides various services, such as a background management server that provides support for the original reports sent by the user using the terminal devices 601, 602, and 603. The background management server may perform demand analysis, report design, determine the data source and data acquisition logic of the report items, extract the original data and load it into the report database, and perform visual display, etc. on the received original reports, and feed back the processing results (such as display results) to the terminal device.

[0120] It should be noted that the report generation method provided in the embodiment of the present invention is generally executed by the server 605 , and accordingly, the report generation device is generally disposed in the server 605 .

[0121] It should be understood that Figure 6 The number of terminal devices, networks and servers in the embodiment is only for illustration. Any number of terminal devices, networks and servers may be provided according to implementation requirements.

[0122] According to an embodiment of the present invention, the present invention also provides an electronic device, a computer-readable medium and a computer program product.

[0123] The electronic device of the present invention comprises: one or more processors; a 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 implement a report generation method of an embodiment of the present invention.

[0124] The computer-readable medium of the present invention stores a computer program, and when the program is executed by a processor, a report generation method according to an embodiment of the present invention is implemented.

[0125] The computer program product of the present invention comprises a computer program, and when the program is executed by a processor, a report generation method of an embodiment of the present invention is implemented.

[0126] Reference below Figure 7 , which shows a schematic diagram of the structure of a computer system 700 of an electronic device suitable for implementing an embodiment of the present invention. Figure 7 The terminal device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.

[0127] like Figure 7 As shown, the computer system 700 includes a central processing unit (CPU) 701, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 702 or a program loaded from a storage part 708 into a random access memory (RAM) 703. In the RAM 703, various programs and data required for the operation of the system 700 are also stored. The CPU 701, the ROM 702, and the RAM 703 are connected to each other via a bus 704. An input / output (I / O) interface 705 is also connected to the bus 704.

[0128] The following components are connected to the I / O interface 705: an input section 706 including a keyboard, a mouse, etc.; an output section 707 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 708 including a hard disk, etc.; and a communication section 709 including a network interface card such as a LAN card, a modem, etc. The communication section 709 performs communication processing via a network such as the Internet. A drive 710 is also connected to the I / O interface 705 as needed. A removable medium 711, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 710 as needed, so that a computer program read therefrom is installed into the storage section 708 as needed.

[0129] In particular, according to the embodiments disclosed in the present invention, the process described above with reference to the flowchart can be implemented as a computer software program. For example, the embodiments disclosed in the present invention include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program includes a program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from the network through the communication part 709, and / or installed from the removable medium 711. When the computer program is executed by the central processing unit (CPU) 701, the above-mentioned functions defined in the system of the present invention are executed.

[0130] It should be noted that the computer-readable medium shown in the present invention may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present invention, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, device or device. In the present invention, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, which carries a computer-readable program code. This propagated data signal may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer-readable signal media may also be any computer-readable medium other than computer-readable storage media, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer-readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, optical cable, RF, etc., or any suitable combination of the above.

[0131] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present invention. In this regard, each box in the flow chart or block diagram can represent a module, a program segment, or a part of a code, and the above-mentioned module, program segment, or a part of a code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order from the order marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram or flow chart, and the combination of the boxes in the block diagram or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0132] The modules involved in the embodiments of the present invention may be implemented in software or hardware. The modules described may also be provided in a processor. For example, they may be described as follows: a processor includes an analysis and design module, a data traceability module, an extraction and loading module, and a report display module. Among them, the names of these modules do not constitute a limitation on the module itself in certain cases. For example, the analysis and design module may also be described as a "module for performing demand analysis and report design on original reports from different data sources to determine the report items, report indicators, and analysis dimensions of the target report."

[0133] As another aspect, the present invention also provides a computer-readable medium, which may be included in the device described in the above embodiment; or it may exist independently without being assembled into the device. The above computer-readable medium carries one or more programs, and when the above one or more programs are executed by a device, the device includes: performing demand analysis and report design on original reports from different data sources to determine the report items, report indicators and analysis dimensions of the target report; determining the data source and data acquisition logic of the report items in the target report according to the report indicators and analysis dimensions; using a data extraction tool to extract the corresponding original data from the data source and load it into the report database according to the data source and data acquisition logic; using a visualization tool connected to the report database to obtain report data from the report database, and displaying it according to the report style configured for the target report.

[0134] According to the technical solution of the embodiment of the present invention, by performing report analysis, data tracing, data extraction and visual loading on original reports from different data sources, it is possible to integrate data from different data sources and quickly generate visual reports suitable for different demand parties, thereby improving report generation efficiency.

[0135] The above specific implementations do not constitute a limitation on the protection scope of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may occur depending on design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. A report generation method, characterized in that: include: Conduct demand analysis and report design for original reports from different data sources to determine the report items, report indicators and analysis dimensions of the target report; The demand analysis of the original reports from different data sources includes: respectively disassembling the original reports from different data sources to obtain data items; defining and merging the data items to obtain corresponding report items; The original reports from different data sources are respectively disassembled to obtain data items, including: obtaining column headers of single-column reports from original reports from different data sources, and using the column headers of the single-column reports as data items; obtaining row headers and column headers of matrix reports from original reports from different data sources, and using the combination of row headers and column headers of the matrix reports as data items; the original reports include single-column reports and matrix reports; The report design includes: comparing the report items of the original report with the report items obtained from the demand analysis, determining that the comparison is consistent, and using the original report as the target report; splitting the report indicators and analysis dimensions of the target report from the preset report template; Determine the data source and data acquisition logic of the report items in the target report according to the report indicators and the analysis dimensions; Design a data architecture for a report database; wherein the data architecture includes a source layer, a detail layer, and a theme layer, wherein the source layer is used to store raw data, the detail layer is obtained by preprocessing the raw data of the source layer according to a specified granularity, and the theme layer is obtained by mapping the data of the detail layer or the source layer; According to the data source and the data acquisition logic, using a data extraction tool to extract the corresponding original data from the data source and loading it into a report database, including: using a data extraction tool to extract the corresponding original data from the data source, and loading the original data into a source layer of a report database; wherein the data source is used to store data housing data; Using a visualization tool connected to the report database, report data is obtained from the report database and displayed in accordance with the report style configured for the target report.

2. The method according to claim 1, characterized in that The obtaining report data from the report database includes: According to the report indicators and the analysis dimensions, corresponding report data are queried from the subject layer of the report database.

3. The method according to claim 1 or 2, characterized in that: The method further comprises: Write test cases based on the report indicators as the test granularity; The report data is verified using the test case to obtain verification data.

4. A report generation device, characterized in that: include: The analysis and design module is used to perform demand analysis and report design on original reports from different data sources to determine the report items, report indicators and analysis dimensions of the target report; The analysis and design module is also used to respectively disassemble the original reports from different data sources to obtain data items; perform data item definition and data item merging on the data items to obtain corresponding report items; The analysis and design module is further used to obtain the column headers of the single-column report in the original reports from different data sources, and use the column headers of the single-column report as data items; and obtaining row headers and column headers of matrix reports in original reports from different data sources, and using the combination of the row headers and column headers of the matrix report as a data item; the original report includes a single-column report and a matrix report; The analysis and design module is further used to compare the report items of the original report with the report items obtained by the demand analysis, determine whether the comparison is consistent, and use the original report as the target report; split the report indicators and analysis dimensions of the target report from the preset report template; A data tracing module, used to determine the data source and data acquisition logic of the report items in the target report according to the report indicators and the analysis dimensions; An architecture design module is used to design the data architecture of the report database; wherein the data architecture includes a source layer, a detail layer and a theme layer, the source layer is used to store raw data, the detail layer is obtained by preprocessing the raw data of the source layer according to a specified granularity, and the theme layer is obtained by mapping the data of the detail layer or the source layer; An extraction and loading module, used to extract the corresponding original data from the data source using a data extraction tool and load it into a report database according to the data source and the data acquisition logic; The extraction and loading module is also used to extract the corresponding original data from the data source using a data extraction tool, and load the original data into the source layer of the report database; wherein the data source is used to store data housing data; The report display module is used to obtain report data from the report database using a visualization tool connected to the report database, and display the report data in accordance with the report style configured for the target report.

5. The device according to claim 4, characterized in that The report display module is also used According to the report indicators and the analysis dimensions, corresponding report data are queried from the subject layer of the report database.

6. The device according to claim 4 or 5, characterized in that The device also includes: A report verification module, used to write test cases with the report indicators as the test granularity; and The report data is verified using the test case to obtain verification data.

7. An electronic device, characterized in that: include: one or more processors; a 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 implement the method according to any one of claims 1 to 3.

8. A computer readable medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the method according to any one of claims 1 to 3 is implemented.

9. A computer program product, comprising a computer program, characterized in that When the program is executed by a processor, the method according to any one of claims 1 to 3 is implemented.

Images