Custom report generation method and device, electronic equipment and storage medium

Abstract

The invention provides a self-defined report generation method and device, electronic equipment and a storage medium, and the method comprises the steps: receiving configuration information of a self-defined index set by a user, generating a calculation function corresponding to the self-defined index based on the configuration information, and then generating a self-defined report according to the calculation function, receiving a report generation request, determining one or more target data tables based on the dependency indexes, and obtaining parameter values of the dependency indexes from the target data tables so as to call a calculation function to calculate the parameter values to determine index values of the user-defined indexes, each row of data in the target data table comprises only one index item and a parameter value of the index item, and then displaying the index value of the user-defined index based on user-defined report configuration in the report generation request. And the personalized data display requirement of the user is met. And the flexibility of the system is improved, so that the accuracy and efficiency of data management are improved.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a method, device, electronic device and storage medium for generating a custom report. Background Art

[0002] Existing data management systems generally rely on a fixed report structure, which means that the specific data items and layout to be displayed in the report are preset at the beginning of the design. Although this fixed model can ensure the consistency and standardization of information presentation, it is obviously insufficient in flexibility and is difficult to adapt to the diverse needs of different user groups for data presentation and analysis. With the development of business and the deepening of data application, users' personalized needs are becoming increasingly prominent. Fixed report structures often cannot respond to these changes in a timely manner, resulting in users may needing additional manual operations to obtain the required information, reducing work efficiency. 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 purpose of this application is to propose a custom report generation method to meet the user's personalized data display needs.

[0005] The second objective of the present application is to provide a custom report generation device.

[0006] The third objective of the present application is to provide an electronic device.

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

[0008] A fifth object 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 method for generating a custom report, including:

[0010] Receive configuration information of a custom indicator set by a user, wherein the configuration information includes an indicator name, calculation rules, and dependent indicators, and generate a calculation function corresponding to the custom indicator based on the configuration information;

[0011] Receive a report generation request, determine a target data table based on dependent indicators, and obtain parameter values ​​of dependent indicators from the target data table to call a calculation function to calculate the parameter values ​​and determine the indicator value of the custom indicator, wherein there are one or more target data tables, and each row of data in the target data table contains only one indicator item and the parameter value of the indicator item;

[0012] Based on the custom report configuration in the report generation request, the indicator value of the custom indicator is displayed. To achieve the above purpose, the second embodiment of the present application proposes a custom report generation device, including:

[0013] A receiving module, used to receive configuration information of a custom indicator set by a user, wherein the configuration information includes an indicator name, calculation rules, and dependent indicators, and to generate a calculation function corresponding to the custom indicator based on the configuration information;

[0014] A determination module is used to receive a report generation request, determine a target data table based on dependent indicators, and obtain parameter values ​​of dependent indicators from the target data table to call a calculation function to calculate the parameter values ​​and determine the indicator value of the custom indicator, wherein there are one or more target data tables, and each row of data in the target data table contains only one indicator item and the parameter value of the indicator item;

[0015] The display module is used to display the indicator values ​​of the custom indicators based on the custom report configuration in the report generation request.

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

[0017] at least one processor; and

[0018] a memory communicatively connected to at least one processor; wherein,

[0019] The memory stores instructions that can be executed by at least one processor. The instructions are executed by the at least one processor so that the at least one processor can execute the method of the above embodiment.

[0020] To achieve the above objectives, the fourth aspect of the present application proposes a computer-readable storage medium storing computer instructions, wherein the computer instructions are used to enable a computer to execute the method according to the above embodiment.

[0021] To achieve the above objectives, the fifth aspect of the present application proposes a computer program product, including a computer program, which implements the method of the above embodiment when executed by a processor.

[0022] The custom report generation method, device, electronic device and storage medium provided by the present application receive the configuration information of the custom indicator set by the user, wherein the configuration information includes the indicator name, calculation rules, and dependent indicators, and generates the calculation function corresponding to the custom indicator based on the configuration information, and then receives the report generation request, determines the target data table based on the dependent indicator, and obtains the parameter value of the dependent indicator from the target data table, so as to call the calculation function to calculate the parameter value and determine the indicator value of the custom indicator, wherein the target data table is one or more, and each row of data in the target data table contains only one indicator item and the parameter value of the indicator item, and then, based on the custom report configuration in the report generation request, displays the indicator value of the custom indicator. Thus, it supports users to set custom indicators and calculation rules, dependent indicators, etc. of custom indicators, and the calculation rules are used to calculate the indicator value of custom indicators. It overcomes the problem that the system needs to modify the system code when the indicator changes in the hard-coded way, resulting in poor flexibility of the system, and cannot quickly adapt to business changes, and cannot meet the personalized data display needs of users. It improves the flexibility of the system, thereby improving the accuracy and efficiency of data management.

[0023] 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

[0024] 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:

[0025] Figure 1 A flowchart of a method for generating a custom report provided in an embodiment of the present application;

[0026] Figure 2 A flowchart of another method for generating a custom report provided in an embodiment of the present application;

[0027] Figure 3 A schematic diagram of the structure of a custom report generating device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0028] The 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.

[0029] The following describes a method and device for generating a custom report according to an embodiment of the present application with reference to the accompanying drawings.

[0030] The custom report generation method of the embodiment of the present application is executed by the custom report generation device provided in the embodiment of the present application. The device can be configured in a computer device or a terminal device to meet the user's personalized data display needs.

[0031] Figure 1 A flowchart of a method for generating a custom report provided in an embodiment of the present application.

[0032] like Figure 1 As shown, the custom report generation method includes the following steps:

[0033] Step 101, receiving configuration information of a custom indicator set by a user, wherein the configuration information includes an indicator name, calculation rules, and dependent indicators, and generating a calculation function corresponding to the custom indicator based on the configuration information.

[0034] In this application, an indicator library can be pre-set in the system, and the indicator library contains multiple indicators that can be queried, and the indicator values ​​corresponding to the indicators are contained in the database. The indicators contained in the indicator library can be displayed on the client interface, and then the user can select some of the indicators and make them the most dependent indicators.

[0035] At the same time, users can enter the indicator name of the custom indicator in the client, select the preset mathematical operators available, and determine the relationship between the mathematical operators and the dependent indicators, so as to generate the calculation rules of the custom indicator.

[0036] For example, define a custom indicator: net premium, the dependent indicators are gross premium and claims, and the mathematical operator between gross premium and claims is +, then the calculation rule for net premium is: net premium = gross premium + claims.

[0037] In this application, the configuration information of the custom indicator set by the user can be saved in the system for use in subsequent calculations. Alternatively, the use permissions can be set for the custom indicator to ensure data security.

[0038] Step 102, receiving a report generation request, determining a target data table based on dependent indicators, and obtaining parameter values ​​of dependent indicators from the target data table to call a calculation function to calculate the parameter values ​​and determine the indicator values ​​of the custom indicators, wherein there are one or more target data tables, and each row of data in the target data table contains only one indicator item and the parameter value of the indicator item.

[0039] Exemplarily, Table 1 is a target data table, and each row of Table 1 contains only one indicator item and a parameter value corresponding to the indicator item.

[0040] Table 1

[0041] mechanism Data time suject Account value ×× Branch 2024-06-01 Premium 20 ×× Branch 2024-06-01 indemnity 22 ×× Branch 2024-06-01 Premium 21 ×× Branch 2024-06-01 indemnity 23 ×× Branch 2024-06-01 Comprehensive cost rate 24

[0042] In the present application, a user can send a report generation request to a custom report generation device through a client. Thus, the custom report generation device can receive the report generation request. In the case where there is one target data table, the data table where each indicator is stored can be pre-set in the system, and then the target data table where the dependent indicator is stored can be queried to determine. Then, the parameter value of the dependent indicator can be obtained from the target data table, so as to call the calculation function to calculate the parameter value and determine the indicator value of the custom indicator.

[0043] Generally, business systems use different column names to distinguish different business data, as shown in Table 2. Each row of data in Table 2 contains the specific value of the premium and the specific value of the deposit, that is, it contains the indicator values ​​of two indicators:

[0044] Table 2

[0045] mechanism Data time Premium indemnity ×× Branch 2024-06-01 20 22 ×× Branch 2024-06-01 21 23

[0046] If new business data, such as comprehensive cost and comprehensive expense data in the financial field, is needed, the only way is to add columns to the original table to form a wide table or add a new table by data subject. Managing data in this way brings two problems. First, the underlying data storage structure has been changing with the changes in the business. Second, the upper-level report calculation and presentation logic also have to change due to the changes in the data storage structure, and the development side is unable to cope with it.

[0047] Based on the storage structure of the target data table in this application, the change of the data storage structure is realized from adding a new column header and a new table to adding a new row in a table with a fixed column header, without changing the table structure, and only a new row of records needs to be inserted into the table, which can ensure the stability of the underlying storage structure and avoid redevelopment of the upper-level software and changes in the data table structure.

[0048] Optionally, the target data table can be split into multiple tables to avoid performance bottlenecks when the data volume is large and improve efficiency. In the case of multiple target data tables, the target data table is determined based on the dependency index, including: determining the preset characters associated with the dependency index, and generating the name of the target data table based on the preset characters. After that, the routing of the data query table can be completed based on the name of the target data table.

[0049] For example, the property insurance data and life insurance data can be stored in different tables, the preset field associated with the property insurance is cx, and the preset field associated with the life insurance data is sx. The table names of the indicator data tables all contain dimvalue. Then the name of the target data table corresponding to the August property insurance data is dimvalue_8_cx, ​​and the name of the target data table corresponding to the September life insurance data is dimvalue_9_sx.

[0050] Optionally, the target data table can also be a partition table. In the system, the data can be horizontally partitioned in advance according to the organization, data time, etc. as the distribution key. After the partition, the data scale of the sub-table can be effectively controlled. Different partition tables can be distributed on different distributed nodes, and there is an association between different distribution keys and the distributed nodes where they are located. After that, the data in the partition table can be read, written, and processed concurrently to improve data processing efficiency.

[0051] In addition, when the target data table is also a partitioned table, before determining the target data table based on the dependent indicator and obtaining the parameter value of the dependent indicator from the target data table, the method also includes: determining the storage location of the target data table based on the distribution key in the report generation request, so as to obtain the parameter value of the dependent indicator from the target data table based on the storage location.

[0052] Furthermore, the same node may have multiple partition tables. After determining the storage location of the target data table based on the distribution key in the report generation request, the preset characters associated with the dependent indicator can be determined, so as to generate the name of the target data table based on the preset characters, so as to find the target data table from the storage location according to the name of the target data table, so as to obtain the parameter value of the dependent indicator from the target data table.

[0053] Step 103: Based on the custom report configuration in the report generation request, the indicator value of the custom indicator is displayed.

[0054] In this application, users can be supported to set the format of custom reports, such as the number of rows and columns of a custom report, the relationship between each row and column and a custom indicator or other indicators to be displayed, the color and header of a custom report, etc. After the client obtains the format information of the custom report set by the user, it generates a custom report configuration and sets the custom report configuration in the report generation request.

[0055] Afterwards, the automatic report generation device can obtain the indicator values ​​of the indicators to be displayed (including custom indicators), and generate a table to be displayed according to the custom report configuration to display the indicator values ​​of the custom indicators.

[0056] Optionally, the user's access rights to the indicators to be displayed can also be determined. When the access rights to any indicator to be displayed are prohibited, the indicator values ​​of other indicators to be displayed and custom indicators other than any indicator to be displayed are displayed, thereby improving data security.

[0057] In this application, the configuration information of the custom indicator set by the user is received, wherein the configuration information includes the indicator name, calculation rules, and dependent indicators, and the calculation function corresponding to the custom indicator is generated based on the configuration information, and then, a report generation request is received, the target data table is determined based on the dependent indicator, and the parameter value of the dependent indicator is obtained from the target data table, so as to call the calculation function to calculate the parameter value and determine the indicator value of the custom indicator, wherein the target data table is one or more, and each row of data in the target data table contains only one indicator item and the parameter value of the indicator item, and then, based on the custom report configuration in the report generation request, the indicator value of the custom indicator is displayed. Thus, users are supported to set custom indicators and calculation rules, dependent indicators, etc. of custom indicators, and the calculation rules are used to calculate the indicator value of custom indicators. It overcomes the problem that the system code needs to be modified when the indicator changes in the hard-coded way, resulting in poor flexibility of the system, and the problem that it cannot quickly adapt to business changes, and it cannot meet the personalized data display needs of users. The flexibility of the system is improved, thereby improving the accuracy and efficiency of data management.

[0058] Figure 2 A flowchart of a method for generating a custom report provided in an embodiment of the present application.

[0059] like Figure 2 As shown, the custom report generation method includes the following steps:

[0060] Step 201, receiving configuration information of a custom indicator set by a user, wherein the configuration information includes an indicator name, calculation rules, and dependent indicators, and generating a calculation function corresponding to the custom indicator based on the configuration information.

[0061] Step 202: Receive a report generation request and determine a target data table based on dependency indicators.

[0062] In the present application, the specific implementation process of step 201-step 202 can be found in the detailed description of any embodiment of the present application, and will not be repeated here.

[0063] Step 203: based on the verification rules associated with each indicator in the target data table, verify the indicator value corresponding to each indicator to remove abnormal indicator values.

[0064] In this application, the verification rules associated with different indicators can be different, and the verification rules associated with each indicator can be set in advance in the system. Afterwards, based on the verification rules associated with each indicator in the target data table, the indicator value corresponding to each indicator is verified. If a certain indicator value fails the verification, the indicator item and the indicator value can be deleted. This ensures the reliability of the data and the accuracy of the generated report.

[0065] For example, a verification rule for association of different indicators is shown in Table 3:

[0066] Table 3

[0067]

[0068] Among them, RL01, RL02, and RL03 are built-in rules, and the non-empty check functions that implement non-empty check, non-negative check, and precision check can be pre-set in the system. Thereafter, when the target data table contains premiums, the corresponding check function can be called to check the premiums contained in the target data table.

[0069] RL04 configures the verification formula to implement complex business rule verification between indicator values. If configured as above, it should verify whether direct compensation + indirect compensation > comprehensive cost is established.

[0070] Optionally, the user can set the verification rules to be used for generating the report, and the client can configure the verification rules set by the user in the report generation request and send it to the automatic report generation device. Thus, the automatic report generation device verifies the data in the data target data table based on the verification rules configured in the report generation request.

[0071] Step 204, obtaining the parameter value of the dependent indicator from the target data table to call the calculation function to calculate the parameter value to determine the indicator value of the custom indicator, wherein there are one or more target data tables, and each row of data in the target data table contains only one indicator item and the parameter value of the indicator item.

[0072] Step 205: Based on the custom report configuration in the report generation request, the indicator value of the custom indicator is displayed.

[0073] In the present application, the specific implementation process of step 204-step 205 can be found in the detailed description of any embodiment of the present application, and will not be repeated here.

[0074] In this application, the configuration information of the custom indicator set by the user is received, wherein the configuration information includes the indicator name, calculation rules, and dependent indicators, and the calculation function corresponding to the custom indicator is generated based on the configuration information, and then, a report generation request is received, the target data table is determined based on the dependent indicators, and the indicator values ​​corresponding to each indicator are verified based on the verification rules associated with each indicator in the target data table to remove abnormal indicator values, and then, the parameter values ​​of the dependent indicators are obtained from the target data table, and the calculation function is called to calculate the parameter values ​​to determine the indicator values ​​of the custom indicators, wherein there are one or more target data tables, and each row of data in the target data table contains only one indicator item and the parameter value of the indicator item, so as to display the indicator value of the custom indicator based on the custom report configuration in the report generation request. This ensures the reliability of the data, meets the personalized data display needs of users, improves the flexibility of the system, and thus improves the accuracy and efficiency of data management.

[0075] In order to implement the above embodiment, the present application also proposes a custom report generation device.

[0076] Figure 3 A schematic diagram of the structure of a custom report generation device provided in an embodiment of the present application.

[0077] like Figure 3 As shown, the custom report generation device includes a receiving module 310 , a determining module 320 , and a display module 330 .

[0078] The receiving module 310 is used to receive the configuration information of the custom indicator set by the user, wherein the configuration information includes the indicator name, calculation rules, and dependent indicators, and generate a calculation function corresponding to the custom indicator based on the configuration information;

[0079] The determination module 320 is used to receive a report generation request, determine a target data table based on dependent indicators, and obtain parameter values ​​of dependent indicators from the target data table to call a calculation function to calculate the parameter values ​​and determine the indicator value of the custom indicator, wherein there are one or more target data tables, and each row of data in the target data table contains only one indicator item and the parameter value of the indicator item;

[0080] The display module 330 is used to display the indicator value of the custom indicator based on the custom report configuration in the report generation request.

[0081] Furthermore, in a possible implementation of the embodiment of the present application, a verification module is also included, which is used to:

[0082] Based on the verification rules associated with each indicator in the target data table, the indicator values ​​corresponding to each indicator are verified to remove abnormal indicator values.

[0083] Further, in a possible implementation of the embodiment of the present application, when there are multiple target data tables, the determination module 320 is used to:

[0084] Determine the preset characters associated with the dependent indicator to generate the name of the target data table based on the preset characters.

[0085] Furthermore, in a possible implementation of the embodiment of the present application, the target data table is a partition table, and the device further includes a positioning module, which is used to:

[0086] The storage location of the target data table is determined based on the distribution key in the report generation request, so as to obtain the parameter value of the dependent indicator from the target data table based on the storage location.

[0087] Furthermore, in a possible implementation of the embodiment of the present application, the display module 330 is used to:

[0088] Determine the user's access rights to the metrics to be displayed;

[0089] When the access permission of any indicator to be displayed is prohibited, the indicator values ​​of other indicators to be displayed and custom indicators except any indicator to be displayed are displayed.

[0090] Furthermore, in a possible implementation of the embodiment of the present application, a screening module is also included, which is used to:

[0091] Obtain the preset monitoring requirements and determine the monitoring data dimensions associated with the monitoring requirements;

[0092] Filter call data based on monitoring data dimensions.

[0093] Furthermore, in a possible implementation of the embodiment of the present application, the attribute information includes a custom attribute, and the custom attribute is used to indicate the classification of the target object or the classification of the call link.

[0094] Furthermore, in a possible implementation of the embodiment of the present application, the device further includes a visualization module, which is used to:

[0095] Determine a visualization parameter corresponding to each node based on the attribute information of each node, and determine a visualization parameter of each edge based on the attribute information of each edge, wherein the visualization parameter includes color, size, shape, and line thickness;

[0096] Visualize the graph database based on visualization parameters.

[0097] Furthermore, in a possible implementation of the embodiment of the present application, the visualization module is used to:

[0098] Get the target attribute value corresponding to the custom attribute;

[0099] Matching the target attribute value with the attribute value of the custom attribute corresponding to each node or each edge to determine the target visualization object from the node or edge;

[0100] The graph database is visualized based on the visualization parameters corresponding to the target visualization object.

[0101] It should be noted that the above explanations of the embodiment of the method for generating a custom report are also applicable to the device for generating a custom report of this embodiment, and will not be described in detail here.

[0102] In this application, the configuration information of the custom indicator set by the user is received, wherein the configuration information includes the indicator name, calculation rules, and dependent indicators, and the calculation function corresponding to the custom indicator is generated based on the configuration information, and then, a report generation request is received, the target data table is determined based on the dependent indicator, and the parameter value of the dependent indicator is obtained from the target data table, so as to call the calculation function to calculate the parameter value and determine the indicator value of the custom indicator, wherein the target data table is one or more, and each row of data in the target data table contains only one indicator item and the parameter value of the indicator item, and then, based on the custom report configuration in the report generation request, the indicator value of the custom indicator is displayed. Thus, users are supported to set custom indicators and calculation rules, dependent indicators, etc. of custom indicators, and the calculation rules are used to calculate the indicator value of custom indicators. It overcomes the problem that the system code needs to be modified when the indicator changes in the hard-coded way, resulting in poor flexibility of the system, and the problem that it cannot quickly adapt to business changes, and it cannot meet the personalized data display needs of users. The flexibility of the system is improved, thereby improving the accuracy and efficiency of data management.

[0103] In order to implement the above embodiments, the present application also proposes an electronic device, comprising: 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 provided by the above embodiments.

[0104] In order to implement the above embodiments, the present application also proposes a computer-readable storage medium, in which computer-executable instructions are stored. When the computer-executable instructions are executed by a processor, they are used to implement the methods provided by the above embodiments.

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

[0106] The collection, storage, use, processing, transmission, provision and disclosure of user personal information involved in this application are in compliance with relevant laws and regulations and do not violate public order and good morals.

[0107] It should be noted that personal information from users should be collected for legitimate and reasonable purposes and should not be shared or sold outside of these legitimate uses. In addition, such collection / sharing should be carried out after receiving the user's informed consent, including but not limited to notifying the user to read the user agreement / user notice and sign the agreement / authorization including authorization of relevant user information before the user uses the function. In addition, any necessary steps should be taken to protect and safeguard access to such personal information data and ensure that others who have access to personal information data comply with its privacy policy and procedures.

[0108] This application is expected to provide an implementation scheme for users to selectively block the use or access of personal information data. That is, this application is expected to provide hardware and / or software to prevent or block access to such personal information data. Once the personal information data is no longer needed, risks can be minimized by limiting data collection and deleting data. In addition, when applicable, personal identifiers are removed from such personal information to protect the privacy of users.

[0109] In the description of the aforementioned embodiments, 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.

[0110] 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.

[0111] 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.

[0112] 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.

[0113] 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.

[0114] 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.

[0115] In addition, each functional unit in each embodiment of the present application may be integrated into a processing module, or each unit may exist physically separately, or two or more units may be integrated into one module. The above-mentioned integrated module may 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 may also be stored in a computer-readable storage medium.

[0116] The storage medium mentioned above may be a read-only memory, a magnetic disk or an optical disk, etc. 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 limiting the present application. A person of ordinary skill in the art may change, modify, replace and modify the above embodiments within the scope of the present application.

Claims

1. A method for generating a custom report, characterized in that: The method comprises: Receive configuration information of a custom indicator set by a user, wherein the configuration information includes an indicator name, calculation rules, and dependent indicators, and generate a calculation function corresponding to the custom indicator based on the configuration information; Receive a report generation request, determine a target data table based on the dependent indicator, and obtain a parameter value of the dependent indicator from the target data table, so as to call the calculation function to calculate the parameter value to determine the indicator value of the custom indicator, wherein there are one or more target data tables, and each row of data in the target data table contains only one indicator item and the parameter value of the indicator item; Based on the custom report configuration in the report generation request, the indicator value of the custom indicator is displayed.

2. The method according to claim 1, characterized in that Before obtaining the parameter value of the dependent indicator from the target data table, the method further includes: Based on the verification rules associated with each indicator in the target data table, the indicator values ​​corresponding to each indicator are verified to remove abnormal indicator values.

3. The method according to claim 1, characterized in that In the case where there are multiple target data tables, determining the target data table based on the dependency index includes: The preset characters associated with the dependency indicator are determined to generate a name of the target data table based on the preset characters.

4. The method according to any one of claims 1 to 3, characterized in that: The target data table is a partition table. Before determining the target data table based on the dependency index and obtaining the parameter value of the dependency index from the target data table, the method further includes: The storage location of the target data table is determined based on the distribution key in the report generation request, so as to obtain the parameter value of the dependent indicator from the target data table based on the storage location.

5. The method according to claim 1, characterized in that The displaying of the indicator value of the custom indicator based on the custom report configuration in the report generation request includes: Determining the user's access rights to the indicator to be displayed; When the access permission of any indicator to be displayed is prohibited, the indicator values ​​of other indicators to be displayed and the custom indicators except the indicator to be displayed are displayed.

6. A custom report generation device, characterized in that: The device comprises: A receiving module, configured to receive configuration information of a custom indicator set by a user, wherein the configuration information includes an indicator name, calculation rules, and dependent indicators, and to generate a calculation function corresponding to the custom indicator based on the configuration information; A determination module, used to receive a report generation request, determine a target data table based on the dependent indicator, and obtain a parameter value of the dependent indicator from the target data table, so as to call the calculation function to calculate the parameter value to determine the indicator value of the custom indicator, wherein there are one or more target data tables, and each row of data in the target data table contains only one indicator item and the parameter value of the indicator item; A display module is used to display the indicator value of the custom indicator based on the custom report configuration in the report generation request.

7. The device according to claim 6, characterized in that Also includes a verification module for: Based on the verification rules associated with each indicator in the target data table, the indicator values ​​corresponding to each indicator are verified to remove abnormal indicator values.

8. The device according to claim 6, characterized in that In the case where there are multiple target data tables, the determining module is used to: The preset characters associated with the dependency indicator are determined to generate a name of the target data table based on the preset characters.

9. The device according to any one of claims 6 to 8, characterized in that: The target data table is a partition table, and the device further includes a positioning module, which is used to: The storage location of the target data table is determined based on the distribution key in the report generation request, so as to obtain the parameter value of the dependent indicator from the target data table based on the storage location.

10. The device according to claim 6, characterized in that The display module is used for: Determining the user's access rights to the indicator to be displayed; When the access permission of any indicator to be displayed is prohibited, the indicator values ​​of other indicators to be displayed and the custom indicators except the indicator to be displayed are displayed.

11. 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 5.

12. 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 5 when executed by a processor.

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

Images