Method and device for generating data report

Abstract

The invention discloses a data report generation method and a device adopting same. The method comprises the following steps: acquiring inquire statements used for generating a data report required by a user; determining associated elements, data sheet identification elements and display elements in the inquire statements; generating data extraction attribute information respectively corresponding to the associated statements, the data sheet identification elements and display elements, wherein the data extraction attribute information contains weighting scores; and if data corresponding to at least one display element can not be extracted in the data report generation processes of all generated data extraction attribute information, according to weighting scores in all data extraction attribute information, when the situation that the fault tolerance is larger than the set threshold when the data report defaults the display element which can not extract the corresponding data is determined, generating a data report of the default display element. According to the scheme, the data report not containing default display elements can be generated, and causes which lead to failures in generating the required data report are immediately and accurately located.

Description

technical field [0001] The invention relates to the technical field of computers, in particular to a method and a device for generating data reports. Background technique [0002] Self-service data reports are generally based on the data in the database, and are displayed after analyzing and extracting data based on different requirements. What is displayed on the user side is generally in the form of a data report, while the background is a database operating language. The relationship between the two is as follows: figure 1 As shown, the table on the left in the figure is the form of the displayed data report, and the table on the right is the background operation language. The self-service data report has high autonomy and flexibility, and the data display is highly effective and intuitive. Users can obtain intuitive data without mastering complex languages, and are favored by various analysis departments. [0003] The self-service data report is generally divided into t...

AI Technical Summary

Problems solved by technology

[0006] The embodiment of the present invention provides a data report generation method and its device, which are used to solve the problem in the prior art that the data report cannot be displayed when the data structure of a certain data source changes, and the maintenance and troubleshooting of the data report system more difficult questions

Images