Report generation method and device, electronic equipment, medium and computer program product

By obtaining configuration information from similar users, and combining configuration checks and complexity checks, the generation problems caused by cumbersome configurations and errors in traditional report generation methods are solved, and fast and stable custom report generation is achieved.

CN119250045APending Publication Date: 2025-01-03CHINA CONSTRUCTION BANK +1
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411322080.2
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-09-23
Publication Date
2025-01-03

AI Technical Summary

Technical Problem

Traditional report generation methods require users to manually configure each report configuration item. The configuration process is cumbersome and time-consuming, and it is easy to cause report generation failure or slow generation speed due to configuration errors, and even system crashes.

Method used

By obtaining similar users of the target user, and providing recommended configuration information based on the configuration information of similar users, the user only needs to directly adopt or make a little modification to complete the configuration, and perform configuration checksum verification of the target configuration information to ensure that it is Comply with set configuration rules and complexity requirements to generate custom reports.

Benefits of technology

Shorten the report configuration time, avoid report generation failures and system crashes caused by configuration errors, and improve the efficiency and stability of report generation.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119250045A_ABST
    Figure CN119250045A_ABST
Patent Text Reader

Abstract

The invention provides a report generation method and device, electronic equipment, a medium and a computer program product, and the method comprises the steps: for any report configuration item, responding to a monitored configuration triggering operation of a target user on the report configuration item, and obtaining a similar user of the target user; determining recommended configuration information of the report configuration item according to the configuration information of the similar user on the report configuration item; determining target configuration information of the report configuration item based on recommended configuration information selected by the target user and / or configuration information input by the target user for the report configuration item; performing configuration verification and complexity verification on the target configuration information to determine whether the target configuration information meets a set configuration rule and a set complexity requirement corresponding to the report configuration item; and responding to the condition that the target configuration information accords with the set configuration rule and the set complexity requirement, and generating a self-defined report based on the target configuration information. The problem that a user can only manually configure report configuration items is solved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to a report generation method, device, electronic device, medium and computer program product. Background Art

[0002] In the current era of informatization and digitalization, reports are becoming increasingly important as an important tool for data analysis and decision support. However, traditional report generation methods often require users to manually configure each report configuration item, which is cumbersome and time-consuming. Summary of the invention

[0003] The present application aims to solve one of the technical problems in the related art at least to some extent.

[0004] To this end, the first aspect of the present application is to propose a report generation method.

[0005] The second aspect of the present application is to provide a report generating device.

[0006] A third aspect of the present application is to provide an electronic device.

[0007] A fourth aspect of the present application is to provide a non-transitory computer-readable storage medium.

[0008] A fifth aspect of the present application is to provide a computer program product.

[0009] To achieve the above-mentioned purpose, the first embodiment of the present application proposes a report generation method, comprising:

[0010] For any report configuration item, in response to monitoring a configuration triggering operation of the target user on the report configuration item, obtaining similar users of the target user;

[0011] Determining recommended configuration information of the report configuration item according to the configuration information of the similar users on the report configuration item;

[0012] Determining target configuration information of the report configuration item based on the recommended configuration information selected by the target user and / or the configuration information input by the target user for the report configuration item;

[0013] Performing configuration verification and complexity verification on the target configuration information to determine whether the target configuration information complies with the setting configuration rules and setting complexity requirements corresponding to the report configuration item;

[0014] In response to the target configuration information meeting the set configuration rule and the set complexity requirement, a custom report is generated based on the target configuration information.

[0015] To achieve the above-mentioned purpose, the second embodiment of the present application proposes a report generation device, including:

[0016] An acquisition module, configured to acquire similar users of any report configuration item in response to monitoring a configuration triggering operation of the target user on the report configuration item;

[0017] A first determining module, configured to determine recommended configuration information of the report configuration item according to configuration information of the similar users on the report configuration item;

[0018] A second determination module, configured to determine target configuration information of the report configuration item based on the recommended configuration information selected by the target user and / or the configuration information input by the target user for the report configuration item;

[0019] A verification module, used to perform configuration verification and complexity verification on the target configuration information to determine whether the target configuration information complies with the set configuration rules and set complexity requirements corresponding to the report configuration item;

[0020] A generating module is used to generate a custom report based on the target configuration information in response to the target configuration information meeting the set configuration rule and the set complexity requirement.

[0021] To achieve the above-mentioned purpose, the third aspect of the present application provides an electronic device, including:

[0022] A processor, and a memory communicatively connected to the processor;

[0023] The memory stores computer-executable instructions;

[0024] The processor executes the computer-executable instructions stored in the memory to implement the report generation method described in the first aspect.

[0025] In order to achieve the above-mentioned purpose, the fourth aspect of the present application proposes a non-transitory computer-readable storage medium storing computer instructions, wherein the computer instructions are used to enable a computer to execute the report generation method described in the first aspect.

[0026] In order to achieve the above-mentioned purpose, the fifth aspect of the present application proposes a computer program product, including a computer program, which implements the report generation method described in the first aspect when executed by a processor.

[0027] For any report configuration item, in response to monitoring the configuration trigger operation of the target user on the report configuration item, the application obtains similar users of the target user; determines the recommended configuration information of the report configuration item based on the configuration information of the similar users on the report configuration item; determines the target configuration information of the report configuration item based on the recommended configuration information selected by the target user and / or the configuration information input by the target user for the report configuration item; performs configuration verification and complexity verification on the target configuration information to determine whether the target configuration information complies with the set configuration rules and set complexity requirements corresponding to the report configuration item; generates a custom report based on the target configuration information in response to the target configuration information complying with the set configuration rules and set complexity requirements. The application provides users with recommended configuration information, and users only need to directly adopt or slightly modify it to complete the configuration, which solves the problem that users can only manually configure the report configuration items and shortens the configuration time. In addition, the application performs configuration verification and complexity verification on the target configuration information, which can avoid the problem of report generation failure due to configuration errors, and avoid the problem of slow report generation or system crash due to overly complex configuration.

[0028] Additional aspects and advantages of the present application will be given in part in the description below, and in part will become apparent from the description below, or will be learned through the practice of the present application. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] The above and / or additional aspects and advantages of the present application will become apparent and easily understood from the following description of the embodiments in conjunction with the accompanying drawings, in which:

[0030] Figure 1 A flowchart of a report generation method provided in an embodiment of the present application;

[0031] Figure 2 A flowchart of another report generation method provided in an embodiment of the present application;

[0032] Figure 3 A flowchart of another report generation method provided in an embodiment of the present application;

[0033] Figure 4 A flowchart of another report generation method provided in an embodiment of the present application;

[0034] Figure 5 A structural diagram of a report generation device provided in an embodiment of the present application;

[0035] Figure 6 A schematic diagram of the structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0036] Embodiments of the present application are described in detail below, and examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are intended to be used to explain the present application, and should not be construed as limiting the present application.

[0037] It should be noted that the acquisition, transmission, storage, use, and processing of data (including but not limited to user device information, user personal information, etc.) in the technical solution of this application comply with the relevant provisions of relevant laws and regulations.

[0038] A report generation method, apparatus, electronic device, medium, and computer program product according to an embodiment of the present application are described below with reference to the accompanying drawings.

[0039] Embodiment 1:

[0040] Figure 1 The following is a flow chart of a report generation method provided in an embodiment of the present application. Figure 1 As shown, the method comprises the following steps:

[0041] Step 101 : for any report configuration item, in response to monitoring a configuration triggering operation of a target user on the report configuration item, obtaining similar users of the target user.

[0042] Among them, report configuration items refer to setting items used to define various attributes, functions and display methods of reports during the report generation process. These report configuration items allow users to flexibly customize various aspects of the report according to specific needs to ensure that the report can meet different data analysis and decision support needs. In the embodiment of the present application, the report configuration items may include configuration items such as report name configuration items, data source configuration items, report field configuration items, field association configuration items, field sorting configuration items, filter condition configuration items, and report style configuration items.

[0043] The configuration trigger operation of the report configuration item by the user indicates that the user starts to customize the report configuration item to ensure that the report can accurately reflect the required data information. In the embodiment of the present application, the configuration trigger operation may refer to a click operation on the report customization interface, a keyboard shortcut operation, and the like.

[0044] Similar users of the target user may refer to users who are similar to the target user in terms of user behavior, user attributes, etc. In the embodiment of the present application, user behavior may refer to historical report configuration behavior, usage behavior for a certain application, etc.; user attributes may refer to various parameters and tags used to describe user characteristics and user preferences.

[0045] As an example, user similarity between users may be calculated based on user behaviors and user attributes; and similar users of the target user may be obtained based on the user similarity.

[0046] Step 102: Determine recommended configuration information of the report configuration item based on configuration information of similar users on the report configuration item.

[0047] After obtaining the configuration information of similar users for the report configuration items, a set amount of configuration information may be selected from the obtained configuration information based on user similarity as recommended configuration information.

[0048] In order to enable users to quickly locate appropriate configuration information, reduce configuration time, and improve user experience, the recommended configuration information can be sorted based on user similarity to obtain a configuration information recommendation list, and the configuration information recommendation list can be provided to the user, that is, the configuration information recommendation list can be displayed in the report customization interface.

[0049] Step 103: Determine target configuration information of the report configuration item based on the recommended configuration information selected by the target user and / or the configuration information input by the target user for the report configuration item.

[0050] When configuring a report configuration item, the user can directly select the recommended configuration information as the target configuration information of the report configuration item, or directly manually enter the configuration information to obtain the target configuration information of the report configuration item. After selecting the recommended configuration information, the user can manually modify it based on the recommended configuration information to obtain the target configuration information of the report configuration item.

[0051] This application provides users with recommended configuration information based on user characteristics. Users only need to directly adopt or make slight modifications to complete the configuration without having to start from scratch, thus avoiding the trouble of repeated configuration and improving the user's configuration efficiency.

[0052] It should be noted that different report configuration items correspond to different configuration information (including recommended configuration information and target recommended information). For example, the configuration information of the data source configuration item is the data source, the configuration information of the report field configuration item is the report field, the configuration information of the filter condition configuration item is the filter condition, and the configuration information of the field association mode configuration item is the field association mode. Among them, when there are multiple data sources, the user can configure the field association mode configuration item. As an example, the field association mode includes inner join, left join, right join and outer join.

[0053] In order to enable users to instantly view the report generation effect, adjust and optimize the report layout in a timely manner, and ensure that the generated report meets expectations, as an example, this application also provides a real-time preview function.

[0054] Step 104 , performing configuration verification and complexity verification on the target configuration information to determine whether the target configuration information complies with the setting configuration rules and setting complexity requirements corresponding to the report configuration items.

[0055] The purpose of checking the target configuration information is to ensure the accuracy of the configuration information and avoid report generation failures due to configuration errors. The purpose of checking the complexity of the target configuration information is to avoid inefficient report generation due to overly complex configurations, and to avoid excessive consumption of system resources due to overly complex configurations when system resources are tight, which in turn affects the stable generation of reports and even causes system crashes.

[0056] It should be noted that in addition to configuration verification and complexity verification, the dependencies between report configuration items can also be verified to ensure that all related configuration items are correctly configured.

[0057] Step 105 , in response to the target configuration information meeting the set configuration rule and the set complexity requirement, generating a custom report based on the target configuration information.

[0058] When the target configuration information passes the configuration check and complexity check, a report generation task can be generated based on the target configuration information, and the report generation task can be assigned to a report generation server according to the load balancing algorithm to generate a custom report. Among them, the report generation server can pre-calculate and store complex query results, reduce the need for real-time calculations through views, and cache the results of frequent queries to reduce the number of database accesses. In addition, for the generated custom reports, the report generation server can use page caching technology to store the custom reports in the cache to quickly respond to the same report generation task.

[0059] As an example, in response to the target configuration information not complying with the set configuration rules, and / or in response to the target configuration information not complying with the set complexity requirements, corresponding prompt information or correction suggestions are generated to provide the user with instant feedback and help the user quickly understand the problems in the configuration process.

[0060] For any report configuration item, in response to monitoring the configuration trigger operation of the target user on the report configuration item, the application obtains similar users of the target user; determines the recommended configuration information of the report configuration item based on the configuration information of the similar users on the report configuration item; determines the target configuration information of the report configuration item based on the recommended configuration information selected by the target user and / or the configuration information input by the target user for the report configuration item; performs configuration verification and complexity verification on the target configuration information to determine whether the target configuration information complies with the set configuration rules and set complexity requirements corresponding to the report configuration item; generates a custom report based on the target configuration information in response to the target configuration information complying with the set configuration rules and set complexity requirements. The application provides users with recommended configuration information, and users only need to directly adopt or slightly modify it to complete the configuration, which solves the problem that users can only manually configure the report configuration items and shortens the configuration time. In addition, the application performs configuration verification and complexity verification on the target configuration information, which can avoid the problem of report generation failure due to configuration errors, and avoid the problem of slow report generation or system crash due to overly complex configuration.

[0061] Embodiment 2:

[0062] Figure 2 A flow chart of a report generation method provided by another embodiment of the present application is shown as follows: Figure 2 As shown, the method comprises the following steps:

[0063] Step 201 : for any report configuration item, in response to monitoring a configuration triggering operation of a target user on the report configuration item, obtaining similar users of the target user.

[0064] Step 202: Determine recommended configuration information of the report configuration item based on configuration information of similar users on the report configuration item.

[0065] Wherein, in the case where the report configuration item is a report field configuration item, the recommended configuration information is a recommended report field.

[0066] Step 203: when the report configuration item is a report field configuration item, in response to the target user configuring the target report field for the report field configuration item, obtaining the associated field of the target report field.

[0067] The target report field is a recommended report field selected by the target user or a report field input by the target user for a report field configuration item.

[0068] The target report field can be understood as the report field finally determined by the target user based on the recommended report field and / or the input report field.

[0069] As an example, data mining technology can be used to identify the correlation between fields, and based on the correlation, the associated fields of the target report fields can be determined; and / or, the associated fields of the target report fields can be determined based on set field association rules, such as "if field A is selected, field B is also required"; and / or, the associated fields of the target report fields can be determined based on the content characteristics of the fields, such as the description or purpose of the fields.

[0070] As another example, historical configuration information of a report field configuration item is obtained, where the historical configuration information includes a target report field; the target report field is combined with other report fields in the historical configuration information to obtain multiple field combinations, and the number of occurrences of each field combination in the historical configuration information is obtained; a target field combination whose number of occurrences is greater than a set threshold value is obtained, and other report fields in the target field combination are used as associated fields of the target report field.

[0071] By automatically analyzing and comparing historical configuration information, the present application can intelligently identify which fields are frequently used with target report fields, so that target users can quickly obtain commonly used field combinations related to target report fields, reduce the time and cost of manual analysis, and improve the configuration efficiency of report fields.

[0072] Step 204: Determine target configuration information of the report field configuration item according to the target report field and / or the associated field selected by the target user.

[0073] When the associated fields are provided to the target user, the user can determine whether to adopt the associated fields or whether to modify the associated fields, thereby determining the target configuration information of the report field configuration item. Specifically, when the target user does not adopt the associated fields, the target report field is determined as the target configuration information of the report field configuration item; when the target user directly adopts the associated fields, the target report field and the associated fields are determined as the target configuration information of the report field configuration item; when the target user adopts and modifies the associated fields, the target report field and the modified associated fields are determined as the target configuration information of the report field configuration item.

[0074] This application provides users with associated fields, which lowers the user's usage threshold. Users can directly adopt the recommended associated fields, or make fine adjustments based on these associated fields, so as to quickly complete the configuration of report fields.

[0075] Step 205 , performing configuration verification and complexity verification on the target configuration information to determine whether the target configuration information complies with the setting configuration rules and setting complexity requirements corresponding to the report configuration items.

[0076] Step 206 , in response to the target configuration information meeting the set configuration rule and the set complexity requirement, generating a custom report based on the target configuration information.

[0077] It should be noted that the execution process of step 201, step 202, step 205 and step 206 can be implemented in any way in the embodiments of the present application, and the embodiments of the present application do not limit this and will not be repeated.

[0078] In the case where the report configuration item is a report field configuration item, the application obtains the associated fields of the target report field in response to the target user configuring the target report field for the report field configuration item; and determines the target configuration information of the report field configuration item according to the target report field and / or the associated fields selected by the target user. The application provides the user with associated fields, and the user can directly adopt the recommended associated fields, or make fine adjustments based on these associated fields, so as to quickly complete the configuration of the report field.

[0079] Embodiment three:

[0080] Figure 3 A flow chart of a report generation method provided by another embodiment of the present application is shown as follows: Figure 3 As shown, the method comprises the following steps:

[0081] Step 301 : For any report configuration item, in response to monitoring a configuration triggering operation of a target user on the report configuration item, obtaining similar users of the target user.

[0082] Step 302: Determine recommended configuration information of the report configuration item based on configuration information of similar users on the report configuration item.

[0083] Step 303: Determine target configuration information for the report configuration item based on the recommended configuration information selected by the target user and / or the configuration information input by the target user for the report configuration item.

[0084] Step 304, obtain the regular expression corresponding to the set configuration rule, and match the target configuration information with the regular expression to determine whether the target configuration information complies with the set configuration rule; determine the configuration complexity of the target configuration information, and compare the configuration complexity with the set complexity threshold to confirm whether the target configuration information complies with the set complexity requirement.

[0085] The configuration rules are set to monitor whether the target configuration information of the report configuration item complies with the predefined format and range, etc. For example, the configuration rules may be set such as "the value of the report configuration item must be between the range X and Y" or "the value of the report configuration item must be an integer".

[0086] When manually checking the target configuration information, it is easy to make mistakes. By setting the regular expression corresponding to the configuration rules for automatic verification, not only does it reduce the need for manual inspection, but it also significantly reduces the errors caused by human negligence. In addition, the set configuration rules may change, and the use of regular expressions can flexibly adjust the verification logic to adapt to the new rule requirements.

[0087] When performing complexity verification on target configuration information, the configuration complexity of the target configuration information is compared with a set complexity threshold, the verification process is simple, and the efficiency of complexity verification is improved.

[0088] As an example, the number of characters in the target configuration information may be obtained, and the configuration complexity of the target configuration information may be determined based on the number of characters.

[0089] Step 305 , in response to the target configuration information meeting the set configuration rule and the set complexity requirement, generating a custom report based on the target configuration information.

[0090] The process of generating a custom report often involves operations such as data aggregation, calculation, and formatting. Any error or exception in any operation may result in erroneous data being reported in the final generated report. In order to prevent erroneous data from affecting the accuracy of the final custom report, as an example, after determining the target configuration information of each report configuration item, a report generation transaction is generated based on the target configuration information of each report configuration item; the report generation transaction is executed to generate a custom report.

[0091] Using transaction management technology, the operations corresponding to the target configuration information of each report configuration item can be executed as a whole, which can ensure that these operations are either all successful or all failed, thereby improving the reliability of the operation. In addition, encapsulating multiple operations in a transaction can simplify the report generation process and improve the efficiency and accuracy of report generation. At the same time, transaction management technology can also provide a rollback mechanism to undo all operations when problems occur during report generation, avoiding data inconsistency caused by the success of some operations and the failure of others.

[0092] Some errors may occur during the report generation process, resulting in report generation failure. In order to reduce the probability of report generation failure and improve the fault tolerance of the present application, as an example, the method also includes: performing error monitoring in the process of generating a custom report based on the target configuration information; in response to monitoring error information, determining the error type according to the error information, and providing a corresponding recovery strategy for the target user according to the error type.

[0093] Among them, the report generation process can be error monitored based on logs or exception capture mechanisms.

[0094] As an example, the error types include database connection failure, network connection failure, data format error, etc. The recovery strategy for database connection failure is automatic recovery based on a retry mechanism or prompting the user to contact an administrator, the recovery strategy for network connection failure is prompting the user to check the network connection or try again later, and the recovery strategy for data format error is prompting the user to check and correct the input data.

[0095] The present application obtains the regular expression corresponding to the set configuration rule, and matches the target configuration information with the regular expression to determine whether the target configuration information complies with the set configuration rule; determines the configuration complexity of the target configuration information, and compares the configuration complexity with the set complexity threshold to confirm whether the target configuration information complies with the set complexity requirement. By setting the regular expression corresponding to the configuration rule for automated verification, not only the need for manual inspection is reduced, but also the errors caused by human negligence are significantly reduced. In addition, the configuration complexity of the target configuration information is compared with the set complexity threshold, the verification process is simple, and the efficiency of complexity verification is improved.

[0096] Embodiment 4:

[0097] In order to clearly explain how to determine the configuration complexity of the target configuration information in the above embodiment, the present disclosure proposes another report generation method.

[0098] Figure 4 A flow chart of a report generation method provided by another embodiment of the present application is shown as follows: Figure 4 As shown, in Figure 3 Based on the illustrated embodiment, step 304 includes the following steps:

[0099] Step 401 : when the report configuration item is a report field configuration item, the configuration complexity is determined based on the field attributes of each report field and the total number of report fields in the target configuration information.

[0100] The report configuration items include data source configuration items, and the target configuration information corresponding to the data source configuration items is the target data source. The field attribute is used to indicate whether the report field is a source field, that is, whether the report field is a field in the target data source.

[0101] The field attributes of report fields and the total number of report fields are key factors affecting report generation time. Specifically, data retrieval based on report fields is a basic step in generating reports. When a report contains a large number of fields, the amount of data that the system needs to retrieve from the data source increases accordingly, which directly leads to a longer data retrieval time, and thus makes the overall report generation time longer. Furthermore, field attributes determine the efficiency of data acquisition. If the report field is a source field, that is, its data is directly stored in the target data source, the system can quickly retrieve and obtain the data, and the report generation is also faster; on the contrary, the data of non-source fields cannot be directly obtained and needs to be calculated or processed additionally. This process not only increases the complexity of data acquisition, but also prolongs the overall report generation time. Based on this, according to the field attributes of each report field in the target configuration information and the total number of report fields, the complexity of the target configuration information can be comprehensively and accurately evaluated.

[0102] As an example, based on the field attributes of each report field in the target configuration information, determine whether each report field is a source field in the target data source; determine the field score of each report field based on the judgment result, and obtain a first complexity score based on the field score of each report field; obtain a second complexity score based on the total number of report fields; and determine the configuration complexity based on the first complexity score and the second complexity score.

[0103] In an embodiment of the present application, a correlation between a complexity score and configuration complexity may be set. As an example, a positive correlation is set between the complexity score and configuration complexity, that is, the higher the complexity score, the more complex the configuration of the target configuration information; wherein, for a report field, if the report field is a source field, the field score of the report field is M, and if the report field is a non-source field, the field score of the report field is N, wherein M is less than N.

[0104] As an example, the total score of the field scores of each report field can be calculated, and the total score can be used as the first complexity score; the second complexity score can be determined based on a preset mapping relationship between the number of report fields and the complexity score; the total score of the first complexity score and the second complexity score can be used as the configuration complexity of the target configuration information, or the complexity level can be determined based on the total score of the first complexity score and the second complexity score, and the complexity level can be used as the configuration complexity of the target configuration information.

[0105] By calculating the complexity scores for field attributes and the total number of fields respectively, the configuration complexity evaluation process can be quantified, avoiding the uncertainty caused by subjective judgment, and making the evaluation results more objective and reliable.

[0106] Step 402: when the report configuration item is a filtering condition configuration item, the filtering time required for filtering data based on the filtering condition in the target configuration information is obtained, and the configuration complexity is determined according to the filtering time.

[0107] As an example, the historical time of data filtering based on the filtering condition may be obtained, and based on the historical time, the filtering time required for data filtering based on the filtering condition may be determined.

[0108] Screening time is a quantifiable indicator that directly reflects the complexity of the data screening process and indirectly reflects the complexity of the report generation process. Therefore, the complexity of the target configuration information can be accurately evaluated based on the screening time. In addition, the configuration complexity can be converted into a specific value based on the screening time, thereby avoiding the uncertainty caused by subjective judgment and making the evaluation of configuration complexity more accurate and reliable.

[0109] In the case where the report configuration item is a report field configuration item, the present application determines the configuration complexity based on the field attributes of each report field and the total number of report fields in the target configuration information; in the case where the report configuration item is a filtering condition configuration item, the filtering time required for data filtering based on the filtering conditions in the target configuration information is obtained, and the configuration complexity is determined based on the filtering time. In the case where the report configuration item is a report field configuration item, the field attributes of the report fields and the total number of report fields are key factors affecting the report generation time. The complexity of the target configuration information can be comprehensively and accurately evaluated based on the field attributes of the report fields and the total number of report fields. In the case where the report configuration item is a filtering condition configuration item, the filtering time directly reflects the complexity of the data filtering process and indirectly reflects the complexity of the report generation process. Therefore, the complexity of the target configuration information can be accurately evaluated based on the filtering time.

[0110] Embodiment five:

[0111] Figure 5 A structural diagram of a report generation device provided in an embodiment of the present application is shown in FIG. Figure 5 As shown, including:

[0112] An acquisition module 501 is used for acquiring similar users of a target user for any report configuration item in response to monitoring a configuration trigger operation of the target user on the report configuration item;

[0113] A first determining module 502, configured to determine recommended configuration information of the report configuration item according to configuration information of similar users on the report configuration item;

[0114] A second determination module 503 is used to determine target configuration information of the report configuration item based on the recommended configuration information selected by the target user and / or the configuration information input by the target user for the report configuration item;

[0115] Verification module 504, used to perform configuration verification and complexity verification on the target configuration information to determine whether the target configuration information complies with the setting configuration rules and setting complexity requirements corresponding to the report configuration items;

[0116] The generating module 505 is configured to generate a custom report based on the target configuration information in response to the target configuration information meeting the set configuration rule and the set complexity requirement.

[0117] Optionally, when the report configuration item is a report field configuration item, the recommended configuration information is a recommended report field, and the second determination module 503 is used to: when the report configuration item is a report field configuration item, in response to the target user configuring the target report field for the report field configuration item, obtain the associated field of the target report field; wherein the target report field is the recommended report field selected by the target user or the report field input by the target user for the report field configuration item; determine the target configuration information of the report field configuration item based on the target report field and / or the associated field selected by the target user.

[0118] Optionally, the second determination module 503 is used to: obtain historical configuration information of the report field configuration item, the historical configuration information including the target report field; combine the target report field with other report fields in the historical configuration information to obtain multiple field combinations, and obtain the number of occurrences of each field combination in the historical configuration information; obtain the target field combination whose number of occurrences is greater than a set number threshold, and use the other report fields in the target field combination as associated fields of the target report field.

[0119] Optionally, the verification module 504 is used to: obtain a regular expression corresponding to the set configuration rule, and match the target configuration information with the regular expression to determine whether the target configuration information complies with the set configuration rule; determine the configuration complexity of the target configuration information, and compare the configuration complexity with the set complexity threshold to confirm whether the target configuration information complies with the set complexity requirement.

[0120] Optionally, the verification module 504 is used to: when the report configuration item is a report field configuration item, determine the configuration complexity based on the field attributes of each report field and the total number of report fields in the target configuration information; when the report configuration item is a filtering condition configuration item, obtain the filtering time required for data filtering based on the filtering conditions in the target configuration information, and determine the configuration complexity based on the filtering time.

[0121] Optionally, the report configuration item includes a data source configuration item, and the target configuration information corresponding to the data source configuration item is the target data source. The verification module 504 is used to: determine whether each report field is a source field in the target data source based on the field attributes of each report field in the target configuration information; determine the field score of each report field according to the judgment result, and obtain a first complexity score based on the field score of each report field; obtain a second complexity score based on the total number of report fields; and determine the configuration complexity based on the first complexity score and the second complexity score.

[0122] Optionally, the generating module 505 is used to: after determining the target configuration information of each report configuration item, generate a report generating transaction based on the target configuration information of each report configuration item; and execute the report generating transaction to generate a custom report.

[0123] Optionally, the device also includes an error monitoring module, which is used to: perform error monitoring during the process of generating a custom report based on the target configuration information; in response to monitoring error information, determine the error type based on the error information, and provide a corresponding recovery strategy for the target user based on the error type.

[0124] It should be noted that the above explanation of the method embodiment is also applicable to the device of this embodiment, and will not be repeated here.

[0125] Embodiment six:

[0126] Figure 6 A schematic diagram of the structure of an electronic device provided for an embodiment of the present application. Among them, the electronic device 600 in this embodiment is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workbenches, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present disclosure described and / or required herein.

[0127] like Figure 6 As shown, the electronic device 600 includes: a memory 610, a processor 620, and computer instructions stored in the memory 610 and executable on the processor 620.

[0128] When the processor 620 executes the instructions, the report generation method provided in the above embodiment is implemented.

[0129] Furthermore, the electronic device 600 further includes:

[0130] The communication interface 630 is used for communication between the memory 610 and the processor 620 .

[0131] The memory 610 is used to store computer instructions that can be executed on the processor 620 .

[0132] The memory 610 may include a high-speed RAM memory, and may also include a non-volatile memory (non-volatile memory), such as at least one disk memory.

[0133] The processor 620 is used to implement the report generation method of the above embodiment when executing the program.

[0134] If the memory 610, the processor 620 and the communication interface 630 are implemented independently, the communication interface 630, the memory 610 and the processor 620 can be connected to each other through a bus and communicate with each other. The bus can be an Industry Standard Architecture (ISA) bus, a Peripheral Component (PCI) bus or an Extended Industry Standard Architecture (EISA) bus. The bus can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Figure 6 Only one thick line is used in the diagram, but this does not mean that there is only one bus or only one type of bus.

[0135] Optionally, in a specific implementation, if the memory 610, the processor 620 and the communication interface 630 are integrated on a chip, the memory 610, the processor 620 and the communication interface 630 can communicate with each other through an internal interface.

[0136] The processor 620 may be a central processing unit (CPU), or an application specific integrated circuit (ASIC), or one or more integrated circuits configured to implement the embodiments of the present application.

[0137] In order to implement the above embodiments, the present application also proposes a non-transitory computer-readable storage medium storing computer instructions, where the computer instructions are used to enable a computer to execute the above method.

[0138] In order to implement the above embodiments, the present application also proposes a computer program product, including a computer program, which implements the above method when executed by a processor.

[0139] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "example", "specific example", or "some examples" etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present application. In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner. In addition, those skilled in the art may combine and combine the different embodiments or examples described in this specification and the features of the different embodiments or examples, without contradiction.

[0140] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Therefore, the features defined as "first" and "second" may explicitly or implicitly include at least one of the features. In the description of this application, the meaning of "plurality" is at least two, such as two, three, etc., unless otherwise clearly and specifically defined.

[0141] Any process or method description in a flowchart or otherwise described herein may be understood to represent a module, fragment or portion of code comprising one or more executable instructions for implementing the steps of a custom logical function or process, and the scope of the preferred embodiments of the present application includes alternative implementations in which functions may not be performed in the order shown or discussed, including performing functions in a substantially simultaneous manner or in the reverse order depending on the functions involved, which should be understood by technicians in the technical field to which the embodiments of the present application belong.

[0142] The logic and / or steps represented in the flowchart or otherwise described herein, for example, can be considered as an ordered list of executable instructions for implementing logical functions, and can be embodied in any computer-readable medium for use by an instruction execution system, device or apparatus (such as a computer-based system, a system including a processor, or other system that can fetch instructions from an instruction execution system, device or apparatus and execute the instructions), or in combination with these instruction execution systems, devices or apparatuses. For the purpose of this specification, "computer-readable medium" can be any device that can contain, store, communicate, propagate or transmit a program for use by an instruction execution system, device or apparatus, or in combination with these instruction execution systems, devices or apparatuses. More specific examples of computer-readable media (a non-exhaustive list) include the following: an electrical connection with one or more wires (electronic device), a portable computer disk box (magnetic device), a random access memory (RAM), a read-only memory (ROM), an erasable and programmable read-only memory (EPROM or flash memory), a fiber optic device, and a portable compact disk read-only memory (CDROM). In addition, the computer-readable medium may even be paper or other suitable medium on which the program is printed, since the program may be obtained electronically, for example, by optically scanning the paper or other medium and then editing, interpreting or processing in other suitable ways if necessary, and then stored in a computer memory.

[0143] It should be understood that the various parts of the present application can be implemented by hardware, software, firmware or a combination thereof. In the above-mentioned embodiments, multiple steps or methods can be implemented by software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented by hardware, as in another embodiment, it can be implemented by any one of the following technologies known in the art or their combination: a discrete logic circuit having a logic gate circuit for implementing a logic function for a data signal, a dedicated integrated circuit having a suitable combination of logic gate circuits, a programmable gate array (PGA), a field programmable gate array (FPGA), etc.

[0144] A person skilled in the art may understand that all or part of the steps in the method for implementing the above-mentioned embodiment may be completed by instructing related hardware through a program, and the program may be stored in a computer-readable storage medium, which, when executed, includes one or a combination of the steps of the method embodiment.

[0145] In addition, each functional unit in each embodiment of the present application can be integrated into a processing module, or each unit can exist physically separately, or two or more units can be integrated into one module. The above-mentioned integrated module can be implemented in the form of hardware or in the form of a software functional module. If the integrated module is implemented in the form of a software functional module and sold or used as an independent product, it can also be stored in a computer-readable storage medium. The above-mentioned storage medium can be a read-only memory, a disk or an optical disk, etc.

[0146] It should be noted that in the embodiments of the present application, certain software, components, models and other existing solutions in the industry may be mentioned, and they should be regarded as exemplary. Their purpose is only to illustrate the feasibility of implementing the technical solution of the present application, but it does not mean that the applicant has or will necessarily use the solution.

[0147] Although the embodiments of the present application have been shown and described above, it can be understood that the above embodiments are exemplary and cannot be understood as limitations on the present application. Ordinary technicians in this field can change, modify, replace and modify the above embodiments within the scope of the present application.

Claims

1. A report generation method, characterized in that: The following steps are involved: For any report configuration item, in response to monitoring a configuration triggering operation of the target user on the report configuration item, obtaining similar users of the target user; Determining recommended configuration information of the report configuration item according to the configuration information of the similar users on the report configuration item; Determining target configuration information of the report configuration item based on the recommended configuration information selected by the target user and / or the configuration information input by the target user for the report configuration item; Performing configuration verification and complexity verification on the target configuration information to determine whether the target configuration information complies with the setting configuration rules and setting complexity requirements corresponding to the report configuration item; In response to the target configuration information meeting the set configuration rule and the set complexity requirement, a custom report is generated based on the target configuration information.

2. The method according to claim 1, characterized in that In the case where the report configuration item is a report field configuration item, the recommended configuration information is a recommended report field, and the determining the target configuration information of the report configuration item based on the recommended configuration information selected by the target user and / or the configuration information input by the target user for the report configuration item includes: In a case where the report configuration item is a report field configuration item, in response to the target user configuring a target report field for the report field configuration item, acquiring an associated field of the target report field; The target report field is a recommended report field selected by the target user or a report field input by the target user for the report field configuration item; The target configuration information of the report field configuration item is determined according to the target report field and / or the associated field selected by the target user.

3. The method according to claim 2, characterized in that The step of obtaining the associated field of the target report field includes: Acquire historical configuration information of the report field configuration item, wherein the historical configuration information includes the target report field; Combining the target report field with other report fields in the historical configuration information to obtain a plurality of field combinations, and obtaining the number of occurrences of each of the field combinations in the historical configuration information; A target field combination whose occurrence times is greater than a set times threshold is obtained, and other report fields in the target field combination are used as associated fields of the target report field.

4. The method according to claim 1, characterized in that The performing configuration verification and complexity verification on the target configuration information to determine whether the target configuration information complies with the setting configuration rules and setting complexity requirements corresponding to the report configuration item includes: Obtaining a regular expression corresponding to the set configuration rule, and matching the target configuration information with the regular expression to determine whether the target configuration information complies with the set configuration rule; The configuration complexity of the target configuration information is determined, and the configuration complexity is compared with a set complexity threshold to confirm whether the target configuration information meets the set complexity requirement.

5. The method according to claim 4, characterized in that The determining the configuration complexity of the target configuration information includes: In the case where the report configuration item is a report field configuration item, determining the configuration complexity based on field attributes of each report field and the total number of report fields in the target configuration information; In the case where the report configuration item is a filtering condition configuration item, the filtering time required for data filtering based on the filtering condition in the target configuration information is obtained, and the configuration complexity is determined according to the filtering time.

6. The method according to claim 5, characterized in that The report configuration item includes a data source configuration item, the target configuration information corresponding to the data source configuration item is a target data source, and the determining of the configuration complexity based on the field attributes of each report field and the total number of report fields in the target configuration information includes: Based on the field attributes of each report field in the target configuration information, determining whether each report field is a source field in the target data source; Determine a field score of each report field according to the judgment result, and obtain a first complexity score based on the field score of each report field; Obtaining a second complexity score according to the total number of report fields; The configuration complexity is determined based on the first complexity score and the second complexity score.

7. The method according to claim 1, characterized in that The generating a custom report based on the target configuration information includes: After determining the target configuration information of each of the report configuration items, generating a report generation transaction based on the target configuration information of each of the report configuration items; Execute the report generation transaction to generate the custom report.

8. The method according to claim 1, characterized in that The method further comprises: In the process of generating the custom report based on the target configuration information, performing error monitoring; In response to detecting the error information, determining the error type according to the error information, and providing a corresponding recovery strategy for the target user according to the error type.

9. A report generation device, characterized in that: include: An acquisition module, configured to acquire similar users of any report configuration item in response to monitoring a configuration triggering operation of the target user on the report configuration item; A first determining module, configured to determine recommended configuration information of the report configuration item according to configuration information of the similar users on the report configuration item; A second determination module, configured to determine target configuration information of the report configuration item based on the recommended configuration information selected by the target user and / or the configuration information input by the target user for the report configuration item; A verification module, used to perform configuration verification and complexity verification on the target configuration information to determine whether the target configuration information complies with the set configuration rules and set complexity requirements corresponding to the report configuration item; A generating module is used to generate a custom report based on the target configuration information in response to the target configuration information meeting the set configuration rule and the set complexity requirement.

10. An electronic device, characterized in that: include: A processor, and a memory communicatively connected to the processor; The memory stores computer-executable instructions; The processor executes the computer-executable instructions stored in the memory to implement the method according to any one of claims 1 to 8.

11. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-executable instructions, which are used to implement the method according to any one of claims 1 to 8 when executed by a processor.

12. A computer program product, characterized in that The invention comprises a computer program which, when executed by a processor, implements the method according to any one of claims 1 to 8.