CN117668060A

CN117668060A - Report generation and query method, device, equipment, system and storage medium

Info

Publication number: CN117668060A
Application number: CN202311709567.1A
Authority: CN
Inventors: 阮兴茂; 周宏庆; 刘晓晴; 邓林涛; 何秉根
Original assignee: Industrial and Commercial Bank of China Ltd ICBC
Current assignee: Industrial and Commercial Bank of China Ltd ICBC
Priority date: 2023-12-13
Filing date: 2023-12-13
Publication date: 2024-03-08

Abstract

The application relates to a report generation and query method, a report generation and query device, report generation and query equipment and a storage medium, which can be used in the field of financial science and technology or other related fields. The method comprises the following steps: acquiring report display requirements of a report to be displayed, which are collected by a requirement configuration platform or an operation center; the report display requirements comprise report generation requirements and/or report query requirements; selecting a target script generation mode from different candidate script generation modes according to report display requirements; generating a report generation script according to the target script generation mode; and sending the report generation script to a data processing platform to instruct the data processing platform to select a target report generation template from different candidate report generation templates according to report display requirements, and running the report generation script based on the target report generation template to generate and display a report to be displayed. By adopting the method, the research and development cost of report generation can be reduced.

Description

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

Technical Field

The present invention relates to the field of data processing technologies, and may be used in the field of financial science and technology or other related fields, and in particular, to a report generating and querying method, apparatus, device, and storage medium.

Background

With the rapid development of the big data age, the data has the characteristics of large data volume, multiple data, high updating speed and the like. In order to effectively utilize data, it is generally necessary to sort business data into data reports, thereby better providing data analysis services.

In the conventional technology, professional software research and development personnel are usually required to customize different report generation software according to report requirements of different users. However, the above-mentioned method requires high cost of research and development, and there are cases where research and development resources are wasted.

Disclosure of Invention

Based on the foregoing, it is necessary to provide a report generation and query method, device, equipment and storage medium, which can reduce the research and development cost of report generation.

In a first aspect, the present application provides a report generating method, including:

acquiring report display requirements of a report to be displayed, which are collected by a requirement configuration platform or an operation center; the report display requirements comprise report generation requirements and/or report query requirements;

selecting a target script generation mode from different candidate script generation modes according to report display requirements;

generating a report generation script according to the target script generation mode;

And sending the report generation script to a data processing platform to instruct the data processing platform to select a target report generation template from different candidate report generation templates according to report display requirements, and running the report generation script based on the target report generation template to generate and display a report to be displayed.

In one embodiment, selecting a target script generation mode from different candidate report generation modes according to report display requirements includes:

and selecting a target script generation mode from the full self-service mode, the semi-self-service mode and the research and development mode according to the report data requirement and/or the report page requirement in the report display requirement.

In one embodiment, generating a report generation script according to a target script generation mode includes:

if the target script generation mode is a full self-service mode, generating a report generation script in response to mode configuration operation in the visual service form;

if the target script generation mode is a semi-self-service mode, the report display requirement is sent to a data approver, and after the report passes the approval of the data approver, a report generation script is fed back through a data analysis party according to the report display requirement;

if the target script generation mode is a research and development mode, the report display requirement is sent to a report research and development party, and the report generation script fed back by the report research and development party according to the report display requirement is received.

In one embodiment, the target script generation mode includes a fetch script generation mode and a page script generation mode; correspondingly, according to the report data requirement and/or the report page requirement in the report display requirement, selecting a target script generation mode from the full self-service mode, the semi-self-service mode and the research and development mode, wherein the target script generation mode comprises the following steps:

selecting a fetch script generation mode from a full self-service mode, a semi-self-service mode and a research and development mode according to the number of source tables in the report data demand;

and/or the number of the groups of groups,

and determining the page complexity of the report to be displayed according to the page requirement of the report, and selecting a page script generation mode from the full self-service mode, the semi-self-service mode and the research and development mode according to the page complexity.

In one embodiment, according to the number of source tables in the report data requirement, selecting an access script generation mode from a full self-service mode, a half self-service mode and a research and development mode, wherein the method comprises the following steps:

if the number of the source tables in the report data requirement is smaller than the first preset number, selecting a full self-service mode as a fetch script generation mode;

if the number of the source tables in the report data requirement is not less than the first preset number and is less than the second preset number, selecting a semi-self-service mode as a fetch script generation mode;

If the number of the source tables in the report data requirement is not less than the second preset number, selecting a research and development mode as a fetch script generation mode;

wherein the second preset number is greater than the first preset number.

In one embodiment, selecting the page script generation mode from the full-self-service mode, the semi-self-service mode and the research and development mode according to the page complexity includes:

if the page complexity is smaller than the first preset complexity, selecting a full self-service mode as a page script generation mode;

if the page complexity is not less than the first preset complexity and is less than the second preset complexity, selecting a semi-self-service mode as a page script generation mode;

if the page complexity is not less than the second preset complexity, selecting a research and development mode as a page script generation mode;

wherein the second preset complexity is greater than the first preset complexity.

In one embodiment, determining the page complexity of the report to be displayed according to the report page requirement includes:

determining a statistical analysis range, a statistical analysis granularity and a report structure type in the report page requirement;

and determining the page complexity of the report to be displayed according to at least one of the statistical analysis range, the statistical analysis granularity and the report structure type.

In one embodiment, obtaining a report display requirement of a report to be displayed collected by a requirement configuration platform or an operation center includes:

acquiring report generation requirements of a report to be displayed, which are collected by a requirement configuration platform; and/or the number of the groups of groups,

and acquiring the report query requirement of the report to be displayed, which is collected by the operation center.

In a second aspect, the present application further provides a report generating method, which is applied to a data processing platform, including:

acquiring a report generation script of a report to be displayed, which is generated by a service management platform; the report generation script is generated by the service management platform according to the report display requirement, selecting a target script generation mode from different candidate script generation modes and based on the target script generation mode;

selecting a target report generating template from different candidate report generating templates according to report display requirements;

and running a report generation script based on the target report generation template to generate and display a report to be displayed.

In one embodiment, if the report display requirement includes a report generation requirement, selecting a target report generation template from different candidate report generation templates according to the report display requirement, including:

Determining the complexity of the access script in the report generation script;

and selecting a target report generating template from the pre-generating template and the instant generating template according to the requirement type of the report generating requirement, the source table number and the acquisition complexity of the corresponding data requirement in the report generating requirement.

In one embodiment, if the report presentation requirements include report query requirements, selecting a target report generation template from different candidate report generation templates according to the report presentation requirements, including:

determining a report to be queried in a report query requirement;

and using a candidate report generating template adopted by the report to be queried in report generation as a target report generating template.

In one embodiment, if the target report generating template is a pre-generating template, operating a report generating script based on the target report generating template to generate and display a report to be displayed, including:

generating report generating tasks corresponding to report display requirements through a dispatching center configured by the report generating tasks;

responding to a report generating task through an execution center configured by the execution center, running a fetch script in a report generating script to process data to be processed based on fields to be displayed and display field conditions in report display requirements to obtain the data to be displayed, and creating a new table;

And adding the data to be displayed into the created report so as to generate a script based on the pages in the report generation script, and displaying the created report pages.

In one embodiment, if the target report generating template is an instant generating template, operating a report generating script based on the target report generating template to generate and display a report to be displayed, including:

directly running a fetch script in a report generation script to process data to be processed based on fields to be displayed and display field conditions in report display requirements to obtain the data to be displayed;

and carrying out page display on the data to be displayed by storing database views in a database of the data source table corresponding to the report query requirement based on the page generation script in the report generation script.

In one embodiment, determining the access complexity of the access script in the report generation script includes:

and determining the access complexity of the access script according to the number of keywords of the access script in the report generation script and/or the operation complexity of the operation access script.

In a third aspect, the present application further provides a report query method, applied to an operation center, where the method includes:

Responding to report query operation, and determining report query requirements of a report to be queried;

acquiring report generation requirements adopted in generating a report to be queried, which are collected in a requirement configuration platform;

selecting a target report query mode from different candidate report query modes according to the difference between the report query requirement and the report generation requirement;

determining a target report generating template of a report to be queried when generating a report;

and displaying the report to be queried under the target report generating template based on the target report query mode.

In one embodiment, selecting a target report query mode from different candidate report query modes according to a difference between a report query requirement and a report generation requirement comprises:

if the difference between the report query requirement and the report generation requirement is smaller than a preset difference threshold, selecting a historical report query mode as a target report query mode;

and if the difference between the report query requirement and the report generation requirement is not smaller than the preset difference threshold, selecting a report regeneration mode as a target report query mode.

In one embodiment, if the target report query mode is a history report query mode, displaying the report to be queried under the target report generation template based on the target report query mode, including:

According to the query screening conditions and the fields to be queried in the report query requirements, screening data of the report to be queried;

under the condition that the target report generating template is a pre-generating template, displaying the screening result in the report to be queried; or,

and under the condition that the target report generating template is an instant generating template, displaying the screening result in the original view for generating the report to be queried.

In one embodiment, if the target report query mode is a report regeneration mode, displaying the report to be queried under the target report generation template based on the target report query mode, including:

a report exhibiting instruction is sent to a service management platform to instruct the service management platform to acquire report query requirements from a requirement configuration platform, a target script generating mode is selected from different candidate script generating modes, a report generating script is generated according to the target script generating mode, and the report generating script is sent to a data processing platform;

the report generation script is used for indicating the data processing platform to generate a template based on a target report of the report to be queried, running the report generation script, and generating and displaying the report to be queried.

In a fourth aspect, the present application further provides a report generating device configured on a service management platform, including:

the first acquisition module is used for acquiring report display requirements of the report to be displayed, which are collected by the requirement configuration platform or the operation center; the report display requirements comprise report generation requirements and/or report query requirements;

the first selection module is used for selecting a target script generation mode from different candidate script generation modes according to report display requirements;

the first generation module is used for generating a report generation script according to the target script generation mode;

the first sending module is used for sending the report generation script to the data processing platform so as to instruct the data processing platform to select a target report generation template from different candidate report generation templates according to the report display requirements, and running the report generation script based on the target report generation template to generate and display the report to be displayed.

In a fifth aspect, the present application further provides a report generating device configured on a data processing platform, including:

the second acquisition module is used for acquiring report display requirements of the report to be displayed, which are collected by the requirement configuration platform or the operation center; the report display requirements comprise report generation requirements and/or report query requirements;

The third acquisition module is used for acquiring a report generation script of a report to be displayed, which is generated by the service management platform; the report generation script is generated by the service management platform according to the report display requirement, selecting a target script generation mode from different candidate script generation modes and based on the target script generation mode;

the second selecting module is used for selecting a target report generating template from different candidate report generating templates according to report display requirements;

the second generation module is used for running a report generation script based on the target report generation template to generate and display a report to be displayed.

In a sixth aspect, the present application further provides a report query device configured in an operation center, including:

the first determining module is used for responding to report query operation and determining report query requirements of a report to be queried;

the fourth acquisition module is used for acquiring report generation requirements adopted when the report to be queried is generated and collected in the requirement configuration platform;

the third selecting module is used for selecting a target report query mode from different candidate report query modes according to the difference between the report query requirement and the report generation requirement;

the second determining module is used for determining a target report generating template of the report to be queried when the report is generated;

The first display module is used for displaying the report to be queried under the target report generating template based on the target report query mode.

In a seventh aspect, the present application further provides a report generating system, including a demand configuration platform, an operation center, a service management platform, and a data processing platform; the service management platform is respectively in communication connection with the demand configuration platform and the operation center;

the demand configuration platform is used for collecting report generation demands of the report to be displayed;

the operation center is used for collecting report query requirements of the report to be displayed;

the service management platform is used for selecting a target script generation mode from different candidate script generation modes according to report display requirements and generating report generation scripts according to the target script generation mode; the report display requirements comprise report generation requirements and/or report query requirements;

and the data processing platform is used for selecting a target report generating template from different candidate report generating templates according to report display requirements, running a report generating script based on the target report generating template, and generating and displaying a report to be displayed.

In an eighth aspect, the present application further provides a report query system, including a requirement configuration platform and an operation center that are communicatively connected to each other;

The operation center is used for responding to report query operation and determining report query requirements of a report to be queried;

the demand configuration platform is used for collecting report generation demands adopted when generating a report to be queried;

the operation center is also used for selecting a target report query mode from different candidate report query modes according to the difference between the report query requirement and the report generation requirement, determining a target report generation template of the report to be queried in report generation, and displaying the report to be queried under the target report generation template based on the target report query mode.

In a ninth aspect, the present application also provides a computer device comprising a memory and a processor, the memory storing a computer program, the processor implementing the following steps when executing the computer program:

In a tenth aspect, the present application also provides a computer device comprising a memory and a processor, the memory storing a computer program, the processor implementing the following steps when executing the computer program:

In an eleventh aspect, the present application also provides a computer device comprising a memory and a processor, the memory storing a computer program, the processor implementing the following steps when executing the computer program:

In a twelfth aspect, the present application also provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of:

In a thirteenth aspect, the present application also provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of:

In a fourteenth aspect, the present application also provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of:

In a fifteenth aspect, the present application also provides a computer program product comprising a computer program which, when executed by a processor, performs the steps of:

In a sixteenth aspect, the present application also provides a computer program product comprising a computer program which, when executed by a processor, performs the steps of:

In a seventeenth aspect, the present application also provides a computer program product comprising a computer program which, when executed by a processor, performs the steps of:

According to the report generation and query method, the device, the equipment and the storage medium, the service management platform acquires the report display requirements of the report to be displayed, which are collected by the requirement configuration platform or the operation center, and further selects a target script generation mode from different candidate script generation modes according to the report display requirements, generates a report generation script according to the target script generation mode, and then sends the report generation script to the data processing platform to instruct the data processing platform to select a target report generation template from different candidate report generation templates according to the report display requirements, and operates the report generation script based on the target report generation template to generate and display the report to be displayed. In other words, in the method, through interaction among the service management platform, the demand configuration platform, the operation center and the multiple platforms of the data processing platform, a target script generation mode and a target report generation template can be selected according to the report display demand, and a report generation script generated in the target script generation mode is operated based on the target report generation template to generate and display a report to be displayed. Therefore, in the process of generating and displaying the report, the participation of technicians can be reduced as much as possible, and the effect of reducing the research and development cost of report generation is achieved.

Drawings

In order to more clearly illustrate the embodiments of the present application or the technical solutions in the related art, the drawings that are required to be used in the embodiments or the related technical descriptions will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and other drawings may be obtained according to the drawings without inventive effort for a person having ordinary skill in the art.

Fig. 1 is a schematic structural diagram of a report generating system according to the present embodiment;

fig. 2 is a flowchart of a first report generating method according to the present embodiment;

fig. 3 is a flowchart of a second report generating method according to the present embodiment;

FIG. 4 is a flowchart of a first method for selecting a target report generating template according to the present embodiment;

FIG. 5 is a flowchart of a second method for selecting a target report generating template according to the present embodiment;

fig. 6 is a schematic flow chart of a first generation and display of a report to be displayed according to the present embodiment;

fig. 7 is a schematic flow chart of a second generation and display report to be displayed according to the present embodiment;

fig. 8 is a schematic structural diagram of a report query system according to the present embodiment;

Fig. 9 is a flowchart of a first report query method provided in this embodiment;

fig. 10 is a schematic flow chart showing a report to be queried according to the first embodiment;

fig. 11 is a flow chart illustrating a report to be queried according to a second embodiment;

FIG. 12 is an application environment diagram of a report generating and querying method provided in this embodiment;

FIG. 13 is a flowchart of a third report generating method according to the present embodiment;

fig. 14 is a flowchart of a second report query method provided in this embodiment;

fig. 15 is a block diagram of a first report generating apparatus according to the present embodiment;

fig. 16 is a block diagram of a report generating apparatus of the second type according to the present embodiment;

fig. 17 is a block diagram of a third report generating apparatus according to the present embodiment;

fig. 18 is an internal structural diagram of a computer device according to the present embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application will be further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the present application.

The report generation method provided by the embodiment of the application can be applied to a report generation system shown in fig. 1. Wherein configuration platform 102, service management platform 104, data processing platform 106, and operation center 108 are all connected by network communication. The method is applied to a service management platform 104, specifically, a demand configuration platform 102, and is used for collecting report generation demands of a report to be displayed; the operation center 108 is used for collecting report query requirements of a report to be displayed; the service management platform 104 is used for selecting a target script generation mode from different candidate script generation modes according to report display requirements, and generating report generation scripts according to the target script generation mode; the report display requirements comprise report generation requirements and/or report query requirements; and the data processing platform 106 is used for selecting a target report generating template from different candidate report generating templates according to report display requirements, running a report generating script based on the target report generating template, and generating and displaying a report to be displayed.

In an exemplary embodiment, as shown in fig. 2, a report generating method is provided, and the method is applied to the service management platform 104 in fig. 1 for illustration, and includes the following steps. Wherein:

S201, acquiring report display requirements of a report to be displayed, which are collected by a requirement configuration platform or an operation center.

The report to be displayed is a report to be displayed. The report presentation requirements include report generation requirements and/or report query requirements. In particular, report generation requirements are used to indicate what type of report needs to be generated based on what data. The report query requirement is used to indicate which type of report needs to be viewed, or which report, and which data in the report needs to be viewed. The demand configuration platform is used for receiving report display demands of a report to be displayed, and meanwhile, the demand configuration platform can also be used for carrying out platform parameter configuration for other platforms (a service management platform, an operation center and a data processing platform). The operation center is used for receiving the report query requirement when the report query requirement exists. It can be appreciated that the report presentation requirements can be uploaded by the user or automatically generated by the system.

Optionally, in this embodiment, the report generating requirement may further include at least one of data to be displayed in the report to be displayed, a page display form of the report to be displayed, and management information corresponding to the report to be displayed. Illustratively, the data to be presented may include at least one of a data source table or data type and a field to be presented, etc. The management information corresponding to the report to be displayed can comprise at least one of viewing and modifying rights of the report to be displayed and user information corresponding to the report to be displayed when the report to be displayed is generated.

Optionally, in this embodiment, the service management platform may obtain a report generation requirement of a report to be displayed, which is collected by the requirement configuration platform; and/or acquiring the report query requirement of the report to be displayed, which is collected by the operation center. Illustratively, the service management platform may obtain report generation requirements from the requirements configuration platform in real time, and obtain report query requirements from the operation center in real time. The service management platform also can collect report generation requirements in a preset period from the requirement configuration platform at regular intervals, and collect report query requirements in the preset period from the operation center at regular intervals.

In this embodiment, the report display requirements include a report generation requirement and a report query requirement, so that the application range of the report generation method is wider, and the research and development cost of report generation is further reduced.

S202, selecting a target script generation mode from different candidate script generation modes according to report display requirements.

The candidate script generation modes may be preset, and a plurality of different script generation modes may be set in advance. The target script generation mode can be a script generation mode which is determined based on the report presentation requirements and is adapted to the report presentation requirements.

Optionally, in this embodiment, the report display requirement and each candidate script generation mode may be input into a pre-trained script generation mode selection model, where the script generation mode selection model processes the received data, and outputs the target script generation mode. The method can also be used for analyzing various demand contents in the report display demand, inquiring a predetermined 'demand-script generation mode comparison table' according to the demand contents, and taking a script generation mode corresponding to the demand contents as a target script generation mode. Further, when the analyzed demand content is plural, the script generation mode corresponding to each demand content is set to be the target script generation mode with the largest number of occurrences.

It should be noted that the script generation mode selection model may be built based on a common convolutional neural network, which is not described herein. Further, the report is utilized to show the target script generation mode label corresponding to the demand sample and the sample to carry out supervised training on the script generation mode selection model, so that the mode selection accuracy of the script generation mode selection model is further improved. The specific process of performing supervised training on the script generation mode selection model is a common training mode in the field of neural network training, and will not be described herein.

S203, generating a report generation script according to the target script generation mode.

The report generation script is used for indicating how to generate the report.

Specifically, in this embodiment, after determining the target script generation mode, the service management platform generates the report generation script based on the target script generation mode. For example, each candidate scenario generation mode may correspond to a report generation scenario, and after determining the target scenario generation mode, the report generation scenario corresponding to the target scenario generation mode may be output.

S204, the report generation script is sent to the data processing platform so as to instruct the data processing platform to select a target report generation template from different candidate report generation templates according to report display requirements, and the report generation script is operated based on the target report generation template to generate and display a report to be displayed.

The data processing platform is used for generating and displaying a report to be displayed. Specifically, the data processing platform receives report display requirements and report generation scripts, further determines a target report generation template according to the report display requirements and the report generation scripts, operates the report generation scripts based on the target report generation template, and accordingly generates a report to be displayed, and displays the report to be displayed on the front-end interface.

Specifically, in this embodiment, after generating the report generation script, the service management platform sends the report generation script to the data processing platform. And further, after receiving the report generation script, the data processing platform triggers the operation of selecting a target report generation template from different candidate report generation templates, running the report generation script based on the target report generation template, and generating and displaying the report to be displayed.

It should be noted that, the report generating script and the report displaying requirement have a corresponding relationship, and the report displaying requirement and the report generating script corresponding to the report displaying requirement have the same number in an exemplary manner. That is, when there are multiple report presentation requirements, the data processing platform may determine the target report generation template according to the received report generation script and the report presentation requirements corresponding to the report generation script.

It can be appreciated that, because the demand configuration platform is also in communication with the data processing platform, the data processing platform can obtain the report presentation demand. The report display requirements may be obtained in real time after the requirement configuration platform obtains the report display requirements, or may be obtained from the requirement configuration platform after receiving a report generation script sent by the service management platform, which is not limited.

In the report generating method, the service management platform acquires the report display requirements of the report to be displayed, which are collected by the requirement configuration platform or the operation center, and further selects a target script generating mode from different candidate script generating modes according to the report display requirements, generates a report generating script according to the target script generating mode, and then sends the report generating script to the data processing platform to instruct the data processing platform to select a target report generating template from different candidate report generating templates according to the report display requirements, and operates the report generating script based on the target report generating template to generate and display the report to be displayed. In other words, in the method, through interaction among the service management platform, the demand configuration platform, the operation center and the multiple platforms of the data processing platform, a target script generation mode and a target report generation template can be selected according to the report display demand, and a report generation script generated in the target script generation mode is operated based on the target report generation template to generate and display a report to be displayed. Therefore, in the process of generating and displaying the report, the participation of technicians can be reduced as much as possible, and the effect of reducing the research and development cost of report generation is achieved.

On the basis of the technical solutions of the foregoing embodiments, further, in order to improve accuracy of the target script generation mode, so that the target script generation mode is more adapted to the report presentation requirement, in one embodiment, selecting the target script generation mode includes: and selecting a target script generation mode from the full self-service mode, the semi-self-service mode and the research and development mode according to the report data requirement and/or the report page requirement in the report display requirement.

The report data requirement is used for indicating data which needs to be contained in the report to be displayed. The report page requirement is used for indicating the display form of the report to be displayed, such as display forms of grouping statistical report, cross table, card column report and the like. The mode of generating the report to be displayed without the participation of technicians is the full self-service mode. The mode that needs the participation of data analysts (such as data analysts) to generate the report to be displayed is a semi-self-service mode. The mode that the report to be displayed can be generated only by the participation of professional research and development staff or by manual processing is the research and development mode. That is, the manual participation is from low to high to full self-service mode, semi-self-service mode and research and development mode.

Optionally, in this embodiment, a target script generating mode may be selected from a full self-service mode, a semi-self-service mode and a research and development mode according to report data requirements; the target script generation mode can be selected from the full self-service mode, the semi-self-service mode and the research and development mode according to the report page requirements; and the report data requirement and the report page requirement can be comprehensively processed, and a target script generation mode is selected from the full-self-service mode, the semi-self-service mode and the research and development mode according to the processing result. For example, the data according to which the target scenario generation mode is determined may be input into a pre-trained target scenario generation mode determination model, and the target scenario generation mode determination model processes the input data and outputs the target scenario generation mode. The target script generation mode may be selected from a full-self-service mode, a semi-self-service mode and a research and development mode according to the number and complexity of data according to which the target script generation mode is determined. It will be appreciated that the smaller the number, the lower the complexity, and the lower the manual involvement of the target script generation mode.

It should be noted that the target script generation mode determination model may be built based on a common convolutional neural network, which is not described herein. Further, at least one type of sample in the report data demand sample and the report page demand sample is utilized, the target script generation mode label corresponding to the sample carries out supervised training on the target script generation mode determining model, and the mode determining accuracy of the target script generation mode determining model is further improved. The specific process of performing supervised training on the target script generation mode determination model is a common training mode in the field of neural network training, and will not be described herein.

In the embodiment, the target script generation mode is selected according to the report data requirement and/or the report page requirement, so that the target script generation mode is more matched with the report display requirement and is more accurate.

Further, the process of generating report generation scripts is different in different target script generation modes. Specifically, if the target script generation mode is a full self-service mode, generating a report generation script in response to mode configuration operation in the visual service form; if the target script generation mode is a semi-self-service mode, the report display requirement is sent to a data approver, and after the report passes the approval of the data approver, a report generation script is fed back through a data analysis party according to the report display requirement; if the target script generation mode is a research and development mode, the report display requirement is sent to a report research and development party, and the report generation script fed back by the report research and development party according to the report display requirement is received.

Wherein the visual service form may be a visual control deployed on a service management platform page for input mode configuration operations. The data approver is a role of performing the processibility audit on the report display requirement. Alternatively, there may be only one data approver; in order to improve timeliness of data approval, a plurality of data approvers can be set, for example, different types of report display requirements can correspond to different data approvers. The data analysis party may be a role of analyzing the report presentation requirements and generating report generation scripts, and for example, the data analysis party may be a computer device corresponding to a data analyst. The report developer may be a computer device corresponding to a developing role of the report to be displayed, and for example, the report developer may be a computer device corresponding to a developer.

For example, if the target script generation mode is a full self-service mode, the service management platform may output a mode configuration input request in the visualization service form to prompt a worker to output a mode configuration operation in response to the mode configuration input request, and the service management platform generates a report generation script based on the mode configuration operation. If the target script generation mode is a semi-self-service mode, the service management platform can send the report display requirement to the data approver so as to instruct the data approver to approve the report display requirement. And after the approval of the data approver passes, the report display requirement is sent to the data analysis party so as to instruct the data analysis party to process the report display requirement and output a report generation script to the service management platform. If the target script generation mode is a research and development mode, the service management platform can send report display requirements to a report research and development party so as to instruct the report research and development party to research and develop a report generation script and feed back the report generation script to the service management platform.

In the embodiment, the specific mode of generating the report generation script corresponding to the target script generation mode under various modes is provided, so that the process of generating the report generation script is richer.

Further, to enable the report to be presented to more adapt to the report presentation requirements, in one embodiment, the target script generation mode includes a fetch script generation mode and a page script generation mode. Correspondingly, selecting the target script generation mode comprises the following steps: selecting a fetch script generation mode from a full self-service mode, a semi-self-service mode and a research and development mode according to the number of source tables in the report data demand; and/or determining the page complexity of the report to be displayed according to the report page requirement, and selecting a page script generation mode from the full-self-service mode, the semi-self-service mode and the research and development mode according to the page complexity.

The source table is a data source table containing data to be displayed. The number taking pin is used for indicating how to select data to be displayed from the source list; the access script generation mode is a mode for characterizing how the access script is generated. Wherein the mode. The page complexity characterizes the page layout complexity of the report to be displayed, namely, the complexity of the display form of the report to be displayed. The page script is used for indicating a mode of how to generate a report to be displayed according to the data to be displayed; the page script generation mode is a mode for characterizing how the page script is generated.

Specifically, in this embodiment, only the access script generation mode may be selected, only the page script generation mode may be selected, and the access script generation mode and the page script generation mode may be selected.

For example, the number of source tables may be compared to a first preset number and a second preset number, where the second preset number is greater than the first preset number, to determine the fetch script generation mode. If the number of the source tables in the report data requirement is smaller than the first preset number, selecting a full self-service mode as a fetch script generation mode; if the number of the source tables in the report data requirement is not less than the first preset number and is less than the second preset number, selecting a semi-self-service mode as a fetch script generation mode; and if the number of the source tables in the report data requirement is not less than the second preset number, selecting the research and development mode as a fetch script generation mode. The specific values of the first preset number and the second preset number may be determined by a technician according to needs or experience values, or repeatedly determined through a plurality of experiments, which are not limited in any way in the application.

In this embodiment, the number of source tables is determined according to the size relationship between the number of source tables, the first preset number and the second preset number, so that the accuracy of the selected number of source tables can be improved.

Similarly, the page complexity may be compared with a first preset complexity and a second preset complexity, where the second preset complexity is greater than the first preset complexity, to determine a page script generation mode. If the page complexity is smaller than the first preset complexity, selecting a full self-service mode as a page script generation mode; if the page complexity is not less than the first preset complexity and is less than the second preset complexity, selecting a semi-self-service mode as a page script generation mode; and if the page complexity is not less than the second preset complexity, selecting the research and development mode as a page script generation mode. The specific values of the first preset complexity and the second preset complexity may be determined by a skilled person according to needs or experience values, or repeatedly determined through a plurality of experiments, which is not limited in any way in the application.

Optionally, in this embodiment, a statistical analysis range, a statistical analysis granularity and a report structure type in the report page requirement may be determined; and determining the page complexity of the report to be displayed according to at least one of the statistical analysis range, the statistical analysis granularity and the report structure type. The report page requirement is a requirement for representing a report display form of a report to be displayed. The statistical analysis range, the statistical analysis granularity and the report structure type are all contained in the report page requirement and can be obtained by analyzing the report page requirement.

Illustratively, in this embodiment, at least one of the statistical analysis range, the statistical analysis granularity and the report structure type may be input into a pre-trained complexity determination model, and the received data is processed through the complexity determination model to output the page complexity. Or according to a preset comparison table of the statistical analysis range, the statistical analysis granularity and the report structure type and the page complexity, and based on at least one of the statistical analysis range, the statistical analysis granularity and the report structure type, the comparison table is queried to determine the page complexity.

It should be noted that the complexity determination model may be built based on a common convolutional neural network, which is not described herein. Further, at least one type of sample in the statistical analysis range sample data, the statistical analysis granularity sample data and the report structure type sample data is utilized, and the complexity label corresponding to the sample performs supervised training on the complexity determination model, so that the complexity determination accuracy of the complexity determination model is further improved. The specific process of performing supervised training on the complexity determination model is a common training method in the field of neural network training, and is not described herein.

In this embodiment, the page complexity is determined according to at least one of the statistical analysis range, the statistical analysis granularity and the report structure type, so that the page complexity is more accurate, and the accuracy of the page script generation mode is further improved.

In this embodiment, the page script generation mode is determined according to the magnitude relation between the page complexity and the first preset complexity and the second preset complexity, so that the accuracy of the selected page script generation mode can be improved.

In one exemplary embodiment, a report generation method is provided, and is described as applied to the data processing platform 106 in FIG. 1. It should be noted that, in the embodiments of the present application, parts not described in detail may be referred to the related expressions of other embodiments, which are not described herein.

The report generating method shown in fig. 3 includes the following steps. Wherein:

s301, acquiring report display requirements of a report to be displayed, which are collected by a requirement configuration platform or an operation center.

The report display requirements comprise report generation requirements and/or report query requirements.

Optionally, the process of the data processing platform for acquiring the report display requirement of the report to be displayed collected from the requirement configuration platform or the operation center is the same as that in S201, and the specific process is described in detail in S201, and is not described here.

S302, a report generation script of a report to be displayed, which is generated by the service management platform, is obtained.

And the report generation script is generated by the service management platform according to the report display requirement, selecting a target script generation mode from different candidate script generation modes and based on the target script generation mode.

Specifically, in this embodiment, the data processing platform may obtain a report generation script of a report to be displayed generated by the service management platform. The specific report generation script mode is described in detail in S203, and will not be described in detail here.

S303, selecting a target report generating template from different candidate report generating templates according to report display requirements.

The candidate report generating templates can be preset and a plurality of different report generating templates. The target report generating template can be a report generating template which is determined based on report display requirements and is matched with the report display requirements.

Optionally, in this embodiment, the report display requirement and each candidate report generating template may be input into a pre-trained report generating template selection model, where the report generating template selection model processes the received data, and outputs a target report generating template. The method can also be used for analyzing various demand contents in the report display demand, inquiring a predetermined 'demand-report generation template comparison table' according to the demand contents, and taking a report generation template corresponding to the demand contents as a target report generation template. Further, when the analyzed demand content is plural, the report generating template corresponding to each demand content is used as the target report generating template, for example, the most frequently occurring report generating template.

It should be noted that the report generating template selection model may be built based on a common convolutional neural network, which is not described herein. Further, the report is utilized to display a demand sample and each candidate report generating template sample, and the target report generating template label corresponding to the sample is used for carrying out supervised training on the report generating template selection model, so that the template selection accuracy of the report generating template selection model is further improved. The specific process of performing supervised training on the report generating template selection model is a common training mode in the field of neural network training, and is not described in detail herein.

S304, running a report generation script based on the target report generation template to generate and display a report to be displayed.

Specifically, in this embodiment, the data processing platform generates a template based on the target report, runs a report generation script, thereby generating a report to be displayed, and displays the generated report to be displayed on the front end interface of the data processing platform.

In the report generating method, the data processing platform acquires the report display requirements of the report to be displayed, which are collected by the requirement configuration platform or the operation center, and acquires the report generation script generated by the service management platform, further selects the target report generating template from different candidate report generating templates according to the report display requirements, and operates the report generation script based on the target report generating template to generate and display the report to be displayed. In other words, in the method, through interaction among the service management platform, the demand configuration platform, the operation center and the multiple platforms of the data processing platform, a target script generation mode and a target report generation template can be selected according to the report display demand, and a report generation script generated in the target script generation mode is operated based on the target report generation template to generate and display a report to be displayed. Therefore, in the process of generating and displaying the report, the participation of technicians can be reduced as much as possible, and the effect of reducing the research and development cost of report generation is achieved.

On the basis of the technical schemes of the embodiments, further, in order to enable the target report generating template to be more adaptive to report display requirements, the accuracy of the target report generating template is improved. In one embodiment, as shown in fig. 4, if the report presentation requirements include report generation requirements, the process of selecting the target report generation template includes the following steps:

s401, determining the access complexity of an access script in the report generation script.

The access complexity is used for representing the logic complexity of the acquired data in the report generation script.

Optionally, there may be a plurality of ways to determine the access complexity, and in an embodiment, the access complexity of the access script may be determined according to the number of keywords of the access script in the report generation script and/or the operation complexity of the operation access script.

Wherein, the key word can be an access field in the access script. The running complexity is used for representing the complexity of the access script in the running process of the system.

Optionally, in this embodiment, the access complexity of the access script may be determined according to the number of keywords of the access script in the report generation script. And the access complexity of the access script can be determined according to the operation complexity of the operation access script. The access complexity of the access script can be determined according to the number of keywords of the access script in the report generation script and the operation complexity of the operation access script.

In this embodiment, the keywords of the access script may be extracted, the number of the keywords may be determined, a comparison relation table of the number of the predetermined keywords and the access complexity may be queried, and the access complexity corresponding to the number of the keywords may be used as the access complexity corresponding to the access script. The method may also include judging a type of the access script, and taking the access complexity corresponding to the access script type as the access complexity corresponding to the access script based on a comparison relation table of the access script type and the access complexity. The method may further include taking the access complexity corresponding to the number of keywords as the access complexity corresponding to the access script, taking the access complexity corresponding to the access script type as the access complexity corresponding to the access script, performing weighted summation processing based on a preset weight, and taking the summation result as the access complexity corresponding to the access script.

In this embodiment, the access complexity of the access script is determined according to the number of keywords and/or the running complexity, so that the accuracy of the access complexity can be improved.

In one implementation, the fetch complexity may also be determined based on the category of the keyword, illustratively, the more categories, the higher the corresponding fetch complexity.

S402, selecting a target report generating template from the pre-generating template and the instant generating template according to the requirement type of the report generating requirement, the source table number and the access complexity of the corresponding data requirement in the report generating requirement.

The pre-generated template can be used for generating a report to be displayed with higher difficulty or longer generation time. The instant generating template can be used for generating the report to be displayed with lower difficulty or longer generating time. The target report generating template may be a template adapted to report presentation requirements.

In this embodiment, the data processing platform may comprehensively determine the target report generating template according to the requirement type of the report generating requirement, the number of source tables and the complexity of the number of access of the source tables corresponding to the data requirement in the report generating requirement. For example, a comparison table between the demand type and the report generating template, a comparison table between the number of source tables and the report generating template, and a comparison table between the access complexity and the report generating template may be preset. And respectively inquiring the corresponding comparison tables according to the demand types, the source table number and the fetch complexity, thereby determining report generating templates corresponding to each dimension, and taking the report generating templates with more occurrence times as target report generating templates. The report generating template corresponding to each dimension may be determined, and then the target report generating template may be comprehensively determined according to the predetermined weight corresponding to each dimension, for example, if the weight is higher, for example, the highest complexity of the access, the report generating template corresponding to the complexity of the access is used as the target report generating template.

In the above embodiment, if the report display requirement is a report generation requirement, the target report generation template is selected according to the complexity of the access, the type of requirement and the number of source tables, so that the target report generation template and the report display requirement are more accurate and adapted.

Accordingly, in one embodiment, as shown in fig. 5, if the report presentation requirement includes a report query requirement, the process of selecting the target report generating template includes the following steps:

s501, determining a report to be queried in a report query requirement.

The report to be queried is used for characterizing a report to be displayed for the requirement indication of report query.

It can be understood that if the report display requirement is a report query requirement, the report to be queried is a report which has been generated in the history time.

In this embodiment, the report query requirement may be resolved, so as to determine the report to be queried.

S502, using a candidate report generating template adopted by the report to be queried in report generation as a target report generating template.

The candidate report generating template adopted by the report to be queried in report generation is the target report generating template determined in report generation to be queried. The basic information of the report to be queried can be marked with report generation template information adopted in the generation of the report.

In this embodiment, the annotation information of the report to be queried may be obtained, so as to determine the target report generating template.

In the above embodiment, when the report display requirement is the report query requirement, the candidate report generating template adopted by the report to be queried in report generation is used as the target report generating template, so that the process of determining the target report generating template is simpler and adapted under the condition.

On the basis of the technical solutions of the foregoing embodiments, further, the manners of generating the report to be displayed corresponding to different target report generating templates are also different, and in one embodiment, as shown in fig. 6, if the target report generating template is a pre-generating template, generating and displaying the report to be displayed includes the following steps:

s601, generating report generating tasks corresponding to report display requirements through a self-configured dispatching center.

The scheduling center is used for generating report generating tasks based on report display requirements. The report generation task is used to instruct the execution center how to generate a report.

Specifically, in this embodiment, the scheduling center of the data processing platform may generate a corresponding report generating task according to the report display requirement. Illustratively, each type of report display requirement corresponds to a report generation task, and the scheduling center takes the report generation task corresponding to the report display requirement type as a generation result.

S602, responding to a report generation task through an execution center configured by the execution center, running an access script in a report generation script to process data to be processed based on fields to be displayed and display field conditions in report display requirements to obtain the data to be displayed, and creating a new table.

The field to be displayed and the field display condition can be obtained by analyzing the report display requirement.

Specifically, in this embodiment, after a report generating task is acquired, a report center of the data processing platform responds to the report generating task, and runs an access script in a report generating mode indicated in the report generating task, so as to acquire data to be processed. And then, processing the data to be processed based on the fields to be displayed and the display field conditions in the report display requirements to obtain the data to be displayed, and creating a new table in a report generation mode indicated in the report generation task.

S603, adding the data to be displayed into the created report, so as to display the created report page based on the page generation script in the report generation script.

Specifically, in this embodiment, the data processing platform adds the data to be displayed obtained by processing the execution center to the corresponding position in the report created by the execution center, so as to obtain a data report. And then, running a page generation script, converting the data report in a page mode indicated by the page generation script, generating a report to be displayed, and displaying the report as a created report page.

In the embodiment, when the target report generating template is the pre-generating template, the generating and displaying of the report to be displayed are completed through interaction of the scheduling center and the execution center, the scheduling center is only used for generating report generating tasks, the execution center is only used for executing the report generating tasks, the two tasks are separated clearly, parallel execution of multiple tasks can be achieved, the report generating efficiency under the condition of multiple tasks is improved, and management and maintenance of the report generating process are facilitated.

Accordingly, in one embodiment, as shown in fig. 7, if the target report generating template is an instant generating template, generating and displaying the report to be displayed includes the following steps:

s701, directly running a fetch script in a report generation script to process data to be processed based on fields to be displayed and display field conditions in report display requirements, so as to obtain the data to be displayed.

Specifically, in this embodiment, the data processing platform directly runs the access script in the report generation script, and obtains the data to be processed from the data source table, so as to process the data to be processed based on the fields to be displayed and the conditions of the fields to be displayed in the report display requirement, and obtain the data to be displayed.

S702, page display is carried out on data to be displayed by storing database views in a database of a data source table corresponding to report query requirements based on page generation scripts in the report generation scripts.

The database view may be view information corresponding to the data source table.

Specifically, in this embodiment, the data processing platform may query a database storing a data source table corresponding to a report query requirement, and use a database view corresponding to the data source table stored therein as a presentation page. And running a page generation script, and adding the data to be displayed into the display page to form a report to be displayed for display.

It should be noted that, in order to reduce the occupation of the storage space, in this embodiment, the data to be displayed and the report to be displayed may be stored in a distributed manner.

According to the embodiment, when the target report generating template is the instant generating template, the existing database view can be directly reused, and the generating speed of the report to be displayed is improved.

In another embodiment, a report query method is also provided, which can be applied to the report query system shown in fig. 8, where the operation center 108 is configured to determine a report query requirement of a report to be queried in response to a report query operation; the requirement configuration platform 102 is used for collecting report generation requirements adopted when generating a report to be queried; the operation center 108 is further configured to select a target report query mode from among different candidate report query modes according to a difference between the report query requirement and the report generation requirement, determine a target report generation template of the report to be queried when the report is generated, and display the report to be queried under the target report generation template based on the target report query mode.

It should be noted that the report generating system shown in fig. 1 and the report querying system shown in fig. 8 may be integrated into one system.

In one exemplary embodiment, a report query method is provided, and an operation center 108 in the report query system shown in fig. 8 is taken as an example to illustrate the method. It should be noted that, in the embodiments of the present application, parts not described in detail may be referred to the related expressions of other embodiments, which are not described herein.

The report query method as shown in fig. 9 includes the following steps. Wherein:

s901, determining report query requirements of a report to be queried in response to report query operation.

The report query operation may be an operation performed by a front-end presentation page of the operation center when a report query requirement exists by a user.

Specifically, because the user inputs the report query requirement and the report to be queried when performing the report query operation, in this embodiment, the operation center may directly acquire the report query requirement of the report to be queried.

It should be noted that, since the viewing and modification rights of the report to be displayed are set in the report generation requirements of each report, in this embodiment, after determining the report to be queried, whether the output end of the report query operation meets the viewable/modifiable condition is required to be checked, if yes, S802 is continuously executed, and if not, a no-right prompt message is output.

S902, acquiring report generation requirements adopted when generating a report to be queried, which are collected in a requirement configuration platform.

Specifically, in this embodiment, after determining the report to be queried, the operation center may extract the basic information of the report to be queried, and output the basic information of the report to be queried to the requirement configuration platform, so that the requirement configuration platform feeds back the report generation requirement adopted when the report to be queried is generated to the operation center after receiving the basic information of the report to be queried.

It will be appreciated that the demand configuration platform may store the report generation demand after receiving the report generation demand, and may, for example, store the report generation demand in a blockchain or may store the report generation demand in a distributed manner, which is not limited thereto.

S903, selecting a target report query mode from different candidate report query modes according to the difference between the report query requirement and the report generation requirement.

The candidate report query modes can be different preset report query modes. The target report query mode can be a report query mode which is adapted to the report query requirement. The data operation amounts and execution time lengths corresponding to different candidate report query modes are different. By way of example, candidate report query patterns may include a historical report query pattern and a report regeneration pattern. The historical report query mode is a mode taking a report generated by a report to be queried in a report generation stage as a query basis; the report regenerating mode is a mode for regenerating a new report.

Optionally, there may be a plurality of ways to determine the target report query mode, in an embodiment, at least one of the report query requirement and the report generation requirement may be input into a pre-trained requirement difference determining model, and the requirement difference determining model processes the received data and outputs a difference value. And analyzing the report query requirement and the report generation requirement to obtain corresponding requirement content, and comparing the different item numbers of the requirement content in the report query requirement and the report generation requirement of each requirement, thereby determining the difference between the report query requirement and the report generation requirement. It will be appreciated that the greater the number of items of different demand content, the greater the variance.

It should be noted that the difference determining model may be built based on a common convolutional neural network, which is not described herein. Further, at least one type of sample data in the report query demand sample and the report generation demand sample is utilized, and the difference label corresponding to the sample is used for performing supervised training on the needed difference determination model, so that the template selection accuracy of the needed difference determination model is further improved. The specific process of performing supervised training on the model requiring difference determination is a common training method in the field of neural network training, and will not be described herein.

Further, according to the corresponding relation between the predetermined difference value and the report query mode, the report query mode corresponding to the difference value is used as the target report query mode.

Another implementation manner may be selecting a target report query mode according to a relationship between a difference and a preset difference threshold, and, for example, selecting a history report query mode as the target report query mode if a difference between a report query requirement and a report generation requirement is smaller than the preset difference threshold; and if the difference between the report query requirement and the report generation requirement is not smaller than the preset difference threshold, selecting a report regeneration mode as a target report query mode. The preset difference threshold may be set by a technician according to needs or experience values, or repeatedly determined through a plurality of experiments, which is not limited in the present application.

In this embodiment, the target report query mode is determined according to the magnitude relation between the difference and the preset difference threshold, so that the target report query mode is more accurate.

S904, determining a target report generating template of the report to be queried when generating the report.

Specifically, the generated report forms are marked with corresponding target report form generating templates when the report forms are generated. In this embodiment, the annotation information of the report to be queried may be obtained, so as to determine the target report generating template during generation.

S905, displaying the report to be queried under the target report generating template based on the target report query mode.

Specifically, in this embodiment, the operation center may acquire the report to be queried based on the target report query mode, and process the report to be queried based on the target report generating template, thereby displaying the report to be queried.

In the report query method, the operation center responds to the report query operation, determines the report query requirement of the report to be queried, acquires the report generation requirement adopted when the report to be queried is generated and collected in the requirement configuration platform, and further selects a target report query mode from different candidate report query modes according to the difference between the report query requirement and the report generation requirement. And determining a target report generating template of the report to be queried when the report is generated. And further, based on the target report query mode, displaying the report to be queried under the target report generating template. According to the method, the target report query mode can be selected according to the difference between the report query requirement and the report generation requirement, and the data operation amount and the processing time length corresponding to different report query modes are different, so that unnecessary resource waste is reduced, and the report query efficiency is improved. Meanwhile, under different target report query modes, the target report generation templates in report generation are multiplexed to display the report to be queried, and template selection is not needed for the second time, so that the data operand is further reduced, and the report query efficiency is improved.

Further, on the basis of the technical solutions of the foregoing embodiments, the manners of displaying the report to be queried corresponding to the different target report query manners are also different, and in one embodiment, if the target report query manner is a history report query manner, as shown in fig. 10, displaying the report to be queried includes:

s1001, data screening is carried out on the report to be queried according to query screening conditions and fields to be queried in report query requirements.

The query screening conditions and the fields to be queried are both contained in the report query requirements, and it can be understood that the report query requirements can characterize that requirements exist for the whole report to be queried, and can also characterize that requirements exist for part of data in the report to be queried. Specifically, the query screening condition is used for determining a report to be queried, and the field to be queried is used for representing the field which should be contained in the report to be queried.

Specifically, in this embodiment, the operation center determines a report to be queried from the generated report according to the query screening condition, and performs data screening on the report to be queried according to the field to be queried.

S1002, under the condition that a target report generating template is a pre-generating template, displaying a screening result in a report to be queried; or under the condition that the target report generating template is the instant generating template, the screening result is displayed in the original view for generating the report to be queried.

Optionally, in this embodiment, the report to be queried display manners corresponding to different target report generating templates are different. If the target report generating template is a pre-generating template, the screening result is directly displayed in the report to be queried. For example, the screening result may be highlighted. Or deleting the data except the screening result in the report to be queried and displaying the deleted data. And if the target report generating template is the immediate generating template, acquiring an original view for generating the report to be queried, and adding the screening result into the original view for display.

According to the embodiment, the report to be queried can be displayed in different modes under the two conditions of pre-generating the template and immediately generating the template, so that the efficiency of displaying the report to be queried is improved.

Accordingly, in one embodiment, if the target report query mode is a report regeneration mode, as shown in fig. 11, the report to be queried is shown to include:

s1101, sending a report exhibiting instruction to the service management platform to instruct the service management platform to acquire report query requirements from the requirement configuration platform, selecting a target script generation mode from different candidate script generation modes, generating a report generation script according to the target script generation mode, and sending the report generation script to the data processing platform.

That is, when the target report query mode is a report regeneration mode, the report generation and display operation needs to be re-executed. The report display instruction is used for indicating that the service management platform currently has report generation and display requirements. The operation center sends a report exhibiting instruction to the service management platform, so that the service management platform responds to the report exhibiting instruction, obtains report query requirements from the requirement configuration platform, further selects a target script generation mode from different candidate script generation modes according to the report query requirements, generates a report generation script according to the target script generation mode, and sends the report generation script to the data processing platform. And the data processing platform selects a target report generating template from different candidate report generating templates according to report display requirements, runs a report generating script based on the target report generating template, and generates and displays a report to be displayed.

It should be noted that the process of generating report generation script by the service management platform is described in detail in steps S201 to S204. The process of generating and displaying the report to be displayed by the data processing platform is described in detail in the steps S301-S304, and will not be described here.

In the embodiment, when the target report query mode is a report regeneration mode, the report to be displayed is regenerated and displayed in response to the interaction among the report display instruction through the service management platform, the demand configuration platform, the operation center and the multiple platforms of the data processing platform, so that the existing report to be queried is prevented from being greatly modified, and the effect of reducing the research and development cost of report generation is further achieved.

In order to facilitate understanding of the solution by those skilled in the art, in one embodiment, the report generating method is applied to the report generating system shown in fig. 1, and simultaneously, the report generating method is applied to the application environment shown in fig. 12, and the report generating method provided in this embodiment is described in detail, as shown in fig. 13, and includes the following steps:

s1301, the service management platform and the data processing platform acquire the report generation requirement of the requirement configuration platform.

S1302, the service management platform selects a target script generation mode from different candidate script generation modes according to report generation requirements.

The target script generation mode is selected from a full-self-service mode, a semi-self-service mode and a research and development mode according to the number of source tables in the report query requirement and/or the report page requirement.

S1303, the service management platform generates a report generation script including a fetch script and a page script according to the target script generation mode.

S1304, the service management platform sends the report generation script to the data processing platform.

S1305, the data processing platform selects a target report generating template from different candidate report generating templates according to the report generating requirements.

S1306, the data processing platform runs a report generation script based on the target report generation template to generate and display a report to be displayed.

Optionally, if the target report generating template is a pre-generating template, generating a report generating task corresponding to the report display requirement through a dispatching center configured by the target report generating template; responding to a report generating task through an execution center configured by the execution center, running a fetch script in a report generating script to process data to be processed based on fields to be displayed and display field conditions in report display requirements to obtain the data to be displayed, and creating a new table; and adding the data to be displayed into the created report so as to generate a script based on the pages in the report generation script, and displaying the created report pages.

Optionally, if the target report generating template is the immediate generating template, directly running a fetch script in the report generating script to process the data to be processed based on the field to be displayed and the display field condition in the report display requirement to obtain the data to be displayed; and carrying out page display on the data to be displayed by storing database views in a database of the data source table corresponding to the report query requirement based on the page generation script in the report generation script.

Accordingly, in one embodiment, the report query method is applied to the report query system shown in fig. 8, and simultaneously, the report query method is applied to the application environment shown in fig. 12, so that the report query method provided in this embodiment is described in detail, as shown in fig. 14, and includes the following steps:

s1401, the operation center responds to report query operation to determine report query requirements of a report to be queried.

S1402, the operation center obtains report generation requirements adopted when generating a report to be queried, which are collected in the requirement configuration platform.

S1403, the operation center determines a target report query mode according to the difference between the report query requirement and the report generation requirement and a preset difference threshold.

Specifically, if the difference between the report query requirement and the report generation requirement is smaller than a preset difference threshold, selecting a historical report query mode as a target report query mode; and if the difference between the report query requirement and the report generation requirement is not smaller than the preset difference threshold, selecting a report regeneration mode as a target report query mode.

S1404, the operation center determines a target report generating template of the report to be queried when generating the report.

S1405, if the target report query mode is a report regeneration mode, the operation center sends a report query requirement to the service management platform and sends a report to be queried to the data processing platform.

S1406, the service management platform selects a target script generation mode from different candidate script generation modes according to the report query requirement.

S1407, the service management platform generates a report generation script comprising a fetch script and a page script according to the target script generation mode.

S1408, the service management platform sends the report generation script to the data processing platform.

S1409, the data processing platform takes the candidate report generating template of the report to be queried in report generation as a target report generating template.

S1410, the data processing platform runs a report generation script based on the target report generation template to generate and display a report to be displayed.

S1411, if the target report query mode is a historical report query mode, the operation center performs data screening on the report to be queried according to query screening conditions and fields to be queried in report query requirements.

And S1412, the operation center displays the screening result in a page generated by the report to be queried in the report generation stage based on the target report generation template.

Specifically, under the condition that the target report generating template is a pre-generated template, the screening result is displayed in the report to be queried; or under the condition that the target report generating template is the instant generating template, the screening result is displayed in the original view for generating the report to be queried.

It should be understood that, although the steps in the flowcharts related to the embodiments described above are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.

Based on the same inventive concept, the embodiment of the application also provides a first report generating device and a second report generating device for realizing the report generating method. The implementation scheme of the solution to the problem provided by the device is similar to the implementation scheme described in the method, so the specific limitation of the embodiment of the report generating device or embodiments provided below may refer to the limitation of the report generating method in the above description, and will not be repeated here.

In an exemplary embodiment, as shown in fig. 15, there is provided a first report generating apparatus including: a first acquisition module 1501, a first selection module 1502, a first generation module 1503, and a first sending module 1504, wherein:

the first obtaining module 1501 is configured to obtain a report display requirement of a report to be displayed, where the report display requirement is collected by a requirement configuration platform or an operation center.

The first selection module 1502 is configured to select a target script generation mode from different candidate script generation modes according to report presentation requirements.

A first generating module 1503, configured to generate a report generating script according to the target script generating mode.

The first sending module 1504 is configured to send a report generation script to the data processing platform, so as to instruct the data processing platform to select a target report generation template from different candidate report generation templates according to a report display requirement, and run the report generation script based on the target report generation template, so as to generate and display a report to be displayed.

In one embodiment, the first selecting module is specifically configured to select the target script generating mode from the full-self-service mode, the semi-self-service mode and the research and development mode according to the report data requirement and/or the report page requirement in the report display requirement.

In one embodiment, the first generation module includes a first generation unit, a second generation unit, and a third generation unit, wherein:

the first generation unit is used for responding to the mode configuration operation in the visual service form to generate a report generation script if the target script generation mode is a full-self-service mode;

the second generation unit is used for sending the report display requirement to the data approver if the target script generation mode is a semi-self-service mode, and feeding back a report generation script according to the report display requirement through the data analysis party after the report display requirement passes through the data approver;

And the third generation unit is used for sending the report display requirement to a report research and development party and receiving report generation scripts fed back by the report research and development party according to the report display requirement if the target script generation mode is a research and development mode.

In one embodiment, the target script generation modes include an access script generation mode and a page script generation mode; correspondingly, the first selecting module comprises a first selecting unit and a second selecting unit, wherein:

the first selecting unit is used for selecting a fetch script generating mode from a full self-service mode, a half self-service mode and a research and development mode according to the number of source tables in the report data requirement.

The second selecting unit is used for determining the page complexity of the report to be displayed according to the page requirement of the report, and selecting a page script generating mode from the full self-service mode, the semi-self-service mode and the research and development mode according to the page complexity.

In one embodiment, the first selecting unit is specifically configured to select the full self-service mode as the access script generating mode if the number of source tables in the report data requirement is smaller than a first preset number; if the number of the source tables in the report data requirement is not less than the first preset number and is less than the second preset number, selecting a semi-self-service mode as a fetch script generation mode; and if the number of the source tables in the report data requirement is not less than the second preset number, selecting the research and development mode as a fetch script generation mode.

Wherein the second preset number is greater than the first preset number.

In one embodiment, the second selecting unit is specifically configured to select the full self-service mode as the page script generating mode if the page complexity is less than the first preset complexity; if the page complexity is not less than the first preset complexity and is less than the second preset complexity, selecting a semi-self-service mode as a page script generation mode; and if the page complexity is not less than the second preset complexity, selecting the research and development mode as a page script generation mode.

In one embodiment, the method is further used for determining a statistical analysis range, a statistical analysis granularity and a report structure type in the report page requirement; and determining the page complexity of the report to be displayed according to at least one of the statistical analysis range, the statistical analysis granularity and the report structure type.

In one embodiment, the first acquisition module comprises a first acquisition unit and a second acquisition unit, wherein:

the first acquisition unit is used for acquiring the report generation requirements of the report to be displayed, which are collected by the requirement configuration platform.

The second acquisition unit is used for acquiring the report query requirement of the report to be displayed, which is collected by the operation center.

In an exemplary embodiment, as shown in fig. 16, there is further provided a second report generating apparatus, including: a second acquisition module 1601, a third acquisition module 1602, a second selection module 1603, and a second generation module 1604, wherein:

the second obtaining module 1601 is configured to obtain a report display requirement of a report to be displayed, where the report display requirement is collected by the requirement configuration platform or the operation center.

And the third obtaining module 1602 is configured to obtain a report generation script of the report to be displayed, which is generated by the service management platform.

The second selecting module 1603 is used for selecting a target report generating template from different candidate report generating templates according to report display requirements.

The second generating module 1604 is configured to run a report generating script based on the target report generating template, and generate and display a report to be displayed.

In one embodiment, if the report presentation requirement includes a report generation requirement, the second selecting module includes a first determining unit and a third selecting unit, where:

And the first determining unit is used for determining the access complexity of the access script in the report generation script.

The third selecting unit is used for selecting a target report generating template from the pre-generating template and the instant generating template according to the requirement type of the report generating requirement, the source table number and the fetch complexity of the corresponding data requirement in the report generating requirement.

In one embodiment, if the report display requirement includes a report query requirement, the second selecting module includes a second determining unit and a fourth selecting unit, where:

and the second determining unit is used for determining the report to be queried in the report query requirement.

And the fourth selecting unit is used for taking a candidate report generating template adopted by the report to be queried in report generation as a target report generating template.

In one embodiment, if the target report generating template is a pre-generating template, the second generating module includes a first display unit, a fourth generating unit, and a second display unit, where:

the first display unit is used for generating report generating tasks corresponding to report display requirements through a dispatching center configured by the first display unit.

The fourth generation unit is used for responding to the report generation task through the execution center configured by the fourth generation unit, running the access script in the report generation script, processing the data to be processed to obtain the data to be displayed based on the fields to be displayed and the display field conditions in the report display requirements, and creating a new table.

The second display unit is used for adding the data to be displayed into the created report so as to display the created report page based on the page generation script in the report generation script.

In one embodiment, if the target report generating template is an instant generating template, the second generating module includes a data processing unit and a third display unit, where:

the data processing unit is used for directly running the access script in the report generation script so as to process the data to be processed based on the fields to be displayed and the display field conditions in the report display requirements, and obtain the data to be displayed.

And the third display unit is used for generating a script based on the pages in the report generation script and displaying the pages of the data to be displayed by storing database views in the database of the data source table corresponding to the report query requirement.

In one embodiment, the first determining unit is specifically configured to determine the access complexity of the access script according to the number of keywords of the access script in the report generation script and/or the operation complexity of operating the access script.

In an exemplary embodiment, as shown in fig. 17, there is further provided a report query device, including: a first determining module 1701, a fourth obtaining module 1702, a third selecting module 1703, a second determining module 1704 and a first displaying module 1705, wherein:

The first determining module 1701 is configured to determine a report query requirement of a report to be queried in response to a report query operation.

And a fourth obtaining module 1702, configured to obtain report generation requirements adopted in generating the report to be queried, where the report generation requirements are collected in the requirement configuration platform.

And a third selecting module 1703, configured to select a target report query mode from different candidate report query modes according to a difference between the report query requirement and the report generation requirement.

And the second determining module 1704 is used for determining a target report generating template of the report to be queried when the report is generated.

The first display module 1705 is configured to display a report to be queried under the target report generating template based on the target report querying manner.

In one embodiment, the third selection module includes a fifth selection unit and a sixth selection unit, wherein:

and the fifth selecting unit is used for selecting a historical report query mode as a target report query mode if the difference between the report query requirement and the report generation requirement is smaller than a preset difference threshold value.

And the sixth selecting unit is used for selecting a report regeneration mode as a target report query mode if the difference between the report query requirement and the report generation requirement is not smaller than a preset difference threshold value.

In one embodiment, if the target report query mode is a history report query mode, the first display module includes a first filtering unit, a fourth display unit, and a fifth display unit, where:

and the first screening unit is used for screening the data of the report to be queried according to the query screening conditions and the fields to be queried in the report query requirement.

And the fourth display unit is used for displaying the screening result in the report to be queried under the condition that the target report generating template is a pre-generating template.

And the fifth display unit is used for displaying the screening result in the original view of the report to be queried when the target report generating template is the instant generating template.

In one embodiment, if the target report query mode is a report regeneration mode, the first display module is specifically configured to send a report display instruction to the service management platform, so as to instruct the service management platform to obtain a report query requirement from the requirement configuration platform, select a target script generation mode from different candidate script generation modes, generate a report generation script according to the target script generation mode, and send the report generation script to the data processing platform.

All or part of the modules in the report generation device and the report query device can be realized by software, hardware and a combination thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.

In an exemplary embodiment, a computer device, which may be a terminal, is provided, and an internal structure thereof may be as shown in fig. 18. The computer device includes a processor, a memory, an input/output interface, a communication interface, a display unit, and an input means. The processor, the memory and the input/output interface are connected through a system bus, and the communication interface, the display unit and the input device are connected to the system bus through the input/output interface. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The input/output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless mode can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program, when executed by a processor, implements a report generation and query method.

It will be appreciated by those skilled in the art that the structure shown in fig. 18 is merely a block diagram of a portion of the structure associated with the present application and is not limiting of the computer device to which the present application is applied, and that a particular computer device may include more or fewer components than shown, or may combine certain components, or have a different arrangement of components.

In one exemplary embodiment, a computer device is provided comprising a memory and a processor, the memory having stored therein a computer program, the processor when executing the computer program performing the steps of:

In an exemplary embodiment, there is also provided a computer device comprising a memory and a processor, the memory having stored therein a computer program, the processor, when executing the computer program, performing the steps of:

In one embodiment, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, performs the steps of:

In one embodiment, there is also provided a computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of:

In one embodiment, a computer program product is provided comprising a computer program which, when executed by a processor, performs the steps of:

In one embodiment, there is also provided a computer program product comprising a computer program which, when executed by a processor, performs the steps of:

Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the various embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the various embodiments provided herein may include at least one of relational databases and non-relational databases. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic units, quantum computing-based data processing logic units, etc., without being limited thereto.

The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.

The above examples only represent a few embodiments of the present application, which are described in more detail and are not to be construed as limiting the scope of the present application. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application shall be subject to the appended claims.

Claims

1. A report generation method is applied to a service management platform and is characterized by comprising the following steps:

selecting a target script generation mode from different candidate script generation modes according to the report display requirements;

and sending the report generation script to a data processing platform to instruct the data processing platform to select a target report generation template from different candidate report generation templates according to the report display requirements, and running the report generation script based on the target report generation template to generate and display the report to be displayed.

2. The method according to claim 1, wherein selecting a target script generation mode from different candidate report generation modes according to the report presentation requirements comprises:

and selecting a target script generation mode from a full-self-service mode, a semi-self-service mode and a research and development mode according to the report data requirement and/or the report page requirement in the report display requirement.

3. The method of claim 2, wherein generating report generation scripts according to the target script generation mode comprises:

if the target script generation mode is a full self-service mode, responding to mode configuration operation in the visual service form to generate the report generation script;

if the target script generation mode is a semi-self-service mode, the report display requirement is sent to a data approver, and after the data approver approves, a report generation script is fed back according to the report display requirement through a data analysis party;

And if the target script generation mode is a research and development mode, sending the report display requirement to a report research and development party, and receiving a report generation script fed back by the report research and development party according to the report display requirement.

4. The method of claim 2, wherein the target script generation mode comprises a fetch script generation mode and a page script generation mode; correspondingly, according to the report data requirement and/or the report page requirement in the report display requirement, selecting a target script generation mode from a full self-service mode, a semi-self-service mode and a research and development mode, wherein the method comprises the following steps:

selecting the number-taking script generation mode from a full-self-service mode, a semi-self-service mode and a research and development mode according to the number of source tables in the report data demand;

and/or the number of the groups of groups,

and determining the page complexity of the report to be displayed according to the report page requirement, and selecting the page script generation mode from a full-self-service mode, a semi-self-service mode and a research and development mode according to the page complexity.

5. The method of claim 4, wherein selecting the fetch script generation mode from a full-self-service mode, a semi-self-service mode, and a research and development mode according to the number of source tables in the report data requirements comprises:

If the number of the source tables in the report data requirements is smaller than a first preset number, selecting a full self-service mode as the number-taking script generation mode;

if the number of the source tables in the report data requirement is not less than the first preset number and is less than the second preset number, selecting a semi-self-service mode as the number-taking script generation mode;

if the number of the source tables in the report data requirements is not smaller than a second preset number, selecting a research and development mode as the number-taking script generation mode;

wherein the second preset number is greater than the first preset number.

6. The method of claim 4, wherein selecting the page script generation mode from a full self-service mode, a semi-self-service mode, and a development mode according to the page complexity comprises:

if the page complexity is smaller than a first preset complexity, a full self-service mode is selected as the page script generation mode;

if the page complexity is not less than the first preset complexity and is less than the second preset complexity, selecting a semi-self-service mode as the page script generation mode;

if the page complexity is not less than the second preset complexity, selecting a research and development mode as the page script generation mode;

7. The method of claim 6, wherein determining the page complexity of the report to be presented according to the report page requirement comprises:

determining a statistical analysis range, a statistical analysis granularity and a report structure type in the report page requirements;

8. The method according to any one of claims 1 to 7, wherein the obtaining the report presentation requirements of the report to be presented collected by the requirement configuration platform or the operation center includes:

9. A report generation method is applied to a data processing platform and is characterized by comprising the following steps:

Acquiring a report generation script of the report to be displayed, which is generated by a service management platform; the report generation script is generated by a service management platform according to the report display requirement, selecting a target script generation mode from different candidate script generation modes and based on the target script generation mode;

selecting a target report generating template from different candidate report generating templates according to the report display requirements;

and running the report generation script based on the target report generation template to generate and display the report to be displayed.

10. The method of claim 9, wherein if the report presentation requirements include report generation requirements, selecting a target report generation template from among different candidate report generation templates according to the report presentation requirements, comprises:

determining the access complexity of an access script in the report generation script;

and selecting a target report generating template from a pre-generating template and an instant generating template according to the requirement type of the report generating requirement, the source table number corresponding to the data requirement in the report generating requirement and the access complexity.

11. The method of claim 9, wherein if the report presentation requirements include report query requirements, selecting a target report generation template from among different candidate report generation templates according to the report presentation requirements, comprises:

Determining a report to be queried in the report query requirements;

and using the candidate report generating template adopted by the report to be queried in report generation as the target report generating template.

12. The method according to claim 9, wherein if the target report generating template is a pre-generating template, the running the report generating script based on the target report generating template generates and displays the report to be displayed, including:

generating report generating tasks corresponding to the report display requirements through a dispatching center configured by the report generating tasks;

responding to the report generating task through an execution center configured by the execution center, and running an access script in the report generating script to process data to be processed to obtain the data to be displayed based on the fields to be displayed and the display field conditions in the report display requirements, and creating a new table;

and adding the data to be displayed into the created report so as to display the created report page based on the page generation script in the report generation script.

13. The method according to claim 9, wherein if the target report generating template is an instant generating template, the generating and displaying the report to be displayed by running the report generating script based on the target report generating template includes:

Directly running a fetch script in the report generation script to process data to be processed based on fields to be displayed and display field conditions in the report display requirements to obtain the data to be displayed;

and carrying out page display on the data to be displayed by storing database views in a database of a data source table corresponding to the report query requirement based on the page generation script in the report generation script.

14. The method of claim 10, wherein determining the access complexity of the access script in the report generation script comprises:

and determining the access complexity of the access script according to the number of keywords of the access script in the report generation script and/or the operation complexity of the access script.

15. The report query method is applied to the operation center and is characterized by comprising the following steps of:

acquiring report generation requirements adopted in generating the report to be queried, wherein the report generation requirements are collected in a requirement configuration platform;

Determining a target report generating template of the report to be queried when generating a report;

16. The method of claim 15, wherein selecting a target report query from among different candidate report query types based on a difference between the report query requirement and the report generation requirement comprises:

if the difference between the report query requirement and the report generation requirement is smaller than a preset difference threshold, selecting a historical report query mode as the target report query mode;

and if the difference between the report query requirement and the report generation requirement is not smaller than a preset difference threshold, selecting a report regeneration mode as the target report query mode.

17. The method according to claim 16, wherein if the target report query mode is a history report query mode, the displaying the report to be queried based on the target report query mode under the target report generation template includes:

according to the query screening conditions and the fields to be queried in the report query requirements, carrying out data screening on the report to be queried;

Under the condition that the target report generating template is a pre-generating template, displaying a screening result in the report to be queried; or,

18. The method according to claim 16, wherein if the target report query mode is a report regeneration mode, the displaying the report to be queried based on the target report query mode under the target report generation template includes:

sending a report exhibiting instruction to a service management platform to instruct the service management platform to acquire the report query requirement from a requirement configuration platform, selecting a target script generation mode from different candidate script generation modes, generating a report generation script according to the target script generation mode, and sending the report generation script to a data processing platform;

the report generation script is used for indicating the data processing platform to generate and display the report to be queried based on the target report generation template of the report to be queried.

19. A report generating device configured in a service management platform, comprising:

the first selection module is used for selecting a target script generation mode from different candidate script generation modes according to the report display requirements;

and the first sending module is used for sending the report generation script to a data processing platform so as to instruct the data processing platform to select a target report generation template from different candidate report generation templates according to the report display requirements, and running the report generation script based on the target report generation template to generate and display the report to be displayed.

20. A report generating device configured on a data processing platform, comprising:

The third acquisition module is used for acquiring a report generation script of the report to be displayed, which is generated by the service management platform; the report generation script is generated by a service management platform according to the report display requirement, selecting a target script generation mode from different candidate script generation modes and based on the target script generation mode;

the second selecting module is used for selecting a target report generating template from different candidate report generating templates according to the report display requirements;

and the second generation module is used for operating the report generation script based on the target report generation template to generate and display the report to be displayed.

21. A report query device configured in an operation center, comprising:

22. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1-18 when executing the computer program.

23. The report generating system is characterized by comprising a demand configuration platform, an operation center, a service management platform and a data processing platform; the service management platform is respectively in communication connection with the demand configuration platform and the operation center;

the demand configuration platform is used for collecting report generation demands of a report to be displayed;

the operation center is used for collecting report query requirements of a report to be displayed;

the service management platform is used for selecting a target script generation mode from different candidate script generation modes according to report display requirements and generating report generation scripts according to the target script generation mode; the report display requirements comprise the report generation requirements and/or report query requirements;

And the data processing platform is used for selecting a target report generating template from different candidate report generating templates according to the report display requirements, running the report generating script based on the target report generating template, and generating and displaying the report to be displayed.

24. The report query system is characterized by comprising a requirement configuration platform and an operation center which are in communication connection with each other;

the requirement configuration platform is used for collecting report generation requirements adopted when the report to be queried is generated;

the operation center is further configured to select a target report query mode from different candidate report query modes according to the difference between the report query requirement and the report generation requirement, determine a target report generation template of the report to be queried when the report is generated, and display the report to be queried under the target report generation template based on the target report query mode.

25. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1-18.

26. A computer program product comprising a computer program, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1-18.