A report configuration method, device, equipment and storage medium

Abstract

The embodiment of the present invention discloses a report configuration method, device, equipment and storage medium. The method includes: when a configuration trigger event of the report configuration is monitored, the configuration object corresponding to the configuration trigger event is obtained, and the data source identifier of each candidate data source associated with the configuration object is displayed; a data source trigger operation on the data source identifier is received, and the candidate data source corresponding to the data source trigger operation is used as the target data source, and the report identifier associated with the target data source is displayed; a report trigger operation on the report identifier is received, and data is read in the target data source with the data reading strategy corresponding to the report trigger operation, and a configured report is obtained based on the reading result. The technical solution of the embodiment of the present invention simplifies the report configuration process through a configuration method, thereby achieving the effect of automatically, quickly and conveniently configuring a configured report that matches the configuration object.

Description

Technical Field

[0001] The embodiments of the present invention relate to the field of computer applications, and in particular to a report configuration method, device, equipment and storage medium. Background Art

[0002] With the continuous development of society, the era of big data has arrived. When faced with a large amount of data, reports are the preferred way to display data analysis results. Currently, it is mainly the operation and maintenance personnel who select the corresponding data according to business needs, analyze the selected data, and then display the analysis results through reports.

[0003] In the process of realizing the present invention, the inventors found that the prior art has the following technical problems: the existing report acquisition process is relatively complicated and the application convenience is relatively poor. Summary of the invention

[0004] The embodiments of the present invention provide a report configuration method, apparatus, device and storage medium to achieve the effect of automatically obtaining a configured report corresponding to a configuration object in a configured manner.

[0005] In a first aspect, an embodiment of the present invention provides a report configuration method, which may include:

[0006] When a configuration trigger event of the report configuration is detected, a configuration object corresponding to the configuration trigger event is obtained, and the data source identifiers of each candidate data source associated with the configuration object are displayed;

[0007] receiving a data source trigger operation for a data source identifier, taking a candidate data source corresponding to the data source trigger operation as a target data source, and displaying a report identifier associated with the target data source;

[0008] A report trigger operation for a report identifier is received, data is read from a target data source using a data reading strategy corresponding to the report trigger operation, and a configured report is obtained based on the reading result.

[0009] In a second aspect, an embodiment of the present invention further provides a report configuration device, which may include:

[0010] The data source identification display module is used to obtain the configuration object corresponding to the configuration trigger event when the configuration trigger event of the report configuration is monitored, and display the data source identification of each candidate data source associated with the configuration object;

[0011] A report identification display module is used to receive a data source trigger operation on a data source identification, take a candidate data source corresponding to the data source trigger operation as a target data source, and display a report identification associated with the target data source;

[0012] The report configuration module is used to receive a report trigger operation for a report identifier, read data in a target data source using a data reading strategy corresponding to the report trigger operation, and obtain a configured report based on the reading result.

[0013] In a third aspect, an embodiment of the present invention further provides a report configuration system, which may include:

[0014] one or more processors;

[0015] A memory for storing one or more programs;

[0016] When one or more programs are executed by one or more processors, the one or more processors implement the report configuration method provided by any embodiment of the present invention.

[0017] In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium having a computer program stored thereon, and when the computer program is executed by a processor, the report configuration method provided by any embodiment of the present invention is implemented.

[0018] The technical solution of the embodiment of the present invention can display the data source identifiers of each candidate data source associated with the configuration object by acquiring the configuration object corresponding to the configuration trigger event of the monitored report configuration, so that the configuration object can determine the candidate data source that it can select from the displayed data source identifier; receive the data source trigger operation on the data source identifier, take the candidate data source corresponding to the data source trigger operation as the target data source, and display the report identifier associated with the target data source, so that the configuration object can determine from the displayed report identifier which report attributes the configured report that can be configured based on the selected target data source has; and then receive the report trigger operation on the report identifier, read the data in the target data source with the data reading strategy corresponding to the report trigger operation, and obtain the configured report corresponding to the configuration of the configuration object based on the reading result. The above technical solution can configure a configured report that meets the business needs of the configuration object according to the received trigger operation acting on the corresponding identifier, and it simplifies the report configuration process through the configuration method, thereby achieving the effect of automatically, quickly and conveniently configuring a configured report that matches the configuration object. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] Figure 1 is a flow chart of a report configuration method in Embodiment 1 of the present invention;

[0020] Figure 2 is a flow chart of a report configuration method in Embodiment 2 of the present invention;

[0021] Figure 3 This is a flowchart of an optional example of a report configuration method in Embodiment 2 of the present invention;

[0022] Figure 4 is a flow chart of a report configuration method in Embodiment 3 of the present invention;

[0023] Figure 5 This is a flowchart of an optional example of a report configuration method in Embodiment 3 of the present invention;

[0024] Figure 6 is a flow chart of a report configuration method in Embodiment 4 of the present invention;

[0025] Figure 7a This is a first structural diagram of an optional example of a report configuration method in Embodiment 4 of the present invention;

[0026] Figure 7b This is a second structural diagram of an optional example of a report configuration method in Embodiment 4 of the present invention;

[0027] Figure 8 It is a structural block diagram of a report configuration device in Embodiment 5 of the present invention;

[0028] Fig. 9 It is a structural diagram of a report configuration system in Embodiment 6 of the present invention. DETAILED DESCRIPTION

[0029] The present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It is to be understood that the specific embodiments described herein are only used to explain the present invention, rather than to limit the present invention. It is also necessary to explain that, for ease of description, only parts related to the present invention, rather than all structures, are shown in the accompanying drawings.

[0030] Before introducing the embodiments of the present invention, the application scenarios of the embodiments of the present invention are first exemplified: In order to realize data analysis of each business system, an optional solution is to develop report generation logic for each business system respectively, and the report generation logic may include data processing logic and interface rendering logic, wherein the data processing logic may be implemented by the business server in the business system for obtaining business data from the corresponding business data source and processing the obtained business data; the interface rendering logic may be implemented by the business client in the business system for displaying the data processing results in the form of reports based on the corresponding business needs. Obviously, the data processing process and / or interface rendering process in the above optional solution are relatively scattered, that is, the developers of each business system need to develop their own report generation logic respectively, and the repeated logic development process work greatly reduces the sensitivity of the data and greatly increases the development pressure of the developers.

[0031] In order to solve the above problems, the embodiments of the present invention propose a report configuration method that can be applied to a report configuration system. The report configuration system can be integrated in a report configuration device, and the report configuration device can include a report configuration server and / or a report configuration terminal. The report configuration method can realize the report generation function of the business system that is connected to the report configuration system in a configured manner, which makes it unnecessary for developers of each business system to develop their own report generation logic separately, solving the problem of low data sensitivity and high development pressure. The specific implementation process of the report configuration method is described as follows. It should be noted that in the following explanation process, for ease of understanding, the exemplary descriptions below are all based on the number of order transactions as an example, which is not a specific limitation on the report configuration process.

[0032] Embodiment 1

[0033] Figure 1 This is a flow chart of a report configuration method provided in the first embodiment of the present invention. This embodiment is applicable to the case where a configured report matching a configuration object is automatically configured based on a configuration method. The method can be executed by the report configuration device provided in the embodiment of the present invention, and the device can be implemented by software and / or hardware, and the device can be integrated in a report configuration system.

[0034] See also Figure 1 The method of the embodiment of the present invention specifically includes the following steps:

[0035] S110: When a configuration triggering event of a report configuration is monitored, a configuration object corresponding to the configuration triggering event is obtained, and a data source identifier of each candidate data source associated with the configuration object is displayed.

[0036] Among them, the configuration trigger event can be an event triggered by the configuration object for obtaining a configured report that matches the business needs to be met in a configured manner, such as an event triggered when the configuration object touches the report configuration identifier in the report configuration system, and another example is an event triggered when the configuration object calls the report configuration interface in the report configuration system through a business system that communicates with the report business system, etc. The configuration object can be a user with report configuration authority under a business department in the business system that has report configuration requirements, and it can also be a user with report configuration authority in the report configuration system, and the business department can be understood as a tenant. In actual applications, optionally, the number of tenants that can be connected to the report configuration system can be at least one, and / or the number of configuration objects in each tenant can also be at least one, which is not specifically limited here.

[0037] Since the report configuration system can be connected to multiple business systems in communication, and for each business system, the business data source used to store each business data in the business system may also be different, that is, the business data source associated with each configuration object is different, so the candidate data source associated with the configuration object corresponding to the configuration trigger event can be obtained, and the candidate data source can be the above-mentioned business data source, or it can be a data source constructed based on the business data obtained from the above-mentioned business data source, etc. Further, each candidate data source has a data source identifier corresponding to itself, so the data source identifier of each candidate data source can be displayed in the report configuration interface, so that the configuration object can determine the candidate data source that it can select based on the data source identifier in the report configuration interface. On this basis, optionally, the candidate data source can be represented in multiple forms, such as MySQL, ES, Hbase, etc., among which ES is more suitable for the embodiment of the present invention because of its strong aggregation.

[0038] S120: Receive a data source trigger operation for a data source identifier, use a candidate data source corresponding to the data source trigger operation as a target data source, and display a report identifier associated with the target data source.

[0039] Among them, the data source trigger operation can be a trigger operation received by the report configuration system and acted on at least one of the data source identifiers. The candidate data source corresponding to the data source trigger operation can be a data source on which the configuration object needs to perform data analysis on the candidate data stored therein. For the convenience of subsequent description, such a data source can be referred to as a target data source.

[0040] Furthermore, there may be differences between the report attributes of the configured reports configured based on different target data in different target data sources. The report attributes may be the dimensions, indicators, presentation forms, etc. of the configured report and the attributes related to the detailed information of the configured report, wherein the dimensions may indicate the data analysis results under what dimensions the configured report is, such as the spatial dimension, the time dimension, the item dimension, etc.; the indicators may indicate the data analysis results under what indicators the configured report is, such as the number of completed orders, the amount of completed orders, the number of returned orders, etc.; the presentation form may indicate the form in which the configured report is displayed, such as a bar chart, a pie chart, etc. Exemplarily, if each target data in a target data source includes when an order is completed, then the configured report obtained thereby may be the number of completed orders under the time dimension; further exemplary, if each target data in a target data source includes when and where an order is completed, then the configured report obtained thereby may be the number of completed orders under the time dimension, or the number of completed orders on the spatial dimension, etc. Accordingly, each report identifier associated with the target data source may be displayed on the report configuration interface, and the report identifier may present report properties of a configured report that may be generated based on the selected target data source.

[0041] S130: Receive a report triggering operation for a report identifier, read data in a target data source using a data reading strategy corresponding to the report triggering operation, and obtain a configured report based on the reading result.

[0042] Among them, the report trigger operation can be a trigger operation received by the report configuration system and acting on at least one of the report identifiers. Since there are differences in the report attributes of the configured reports to be configured corresponding to different report identifiers, the difference can come from the different target data required by the configured report during the configuration process. For example, if the configured report is the number of orders completed every day this month, the target data related to the number of orders completed every day this month can be read from the target data source during the data reading process. Based on this, the data reading strategy corresponding to the report trigger operation can be obtained, that is, the data reading strategy corresponding to the triggered report identifier is obtained. The data reading strategy can be a strategy related to which target data is read from the target data source, and then based on the data reading strategy, data can be read from the target data source, and the corresponding configured report can be configured based on the reading results of each target data. In actual applications, optionally, the data reading strategy can be expressed by a data query statement that can be acted on the target data source, that is, data can be read in the target data source based on the corresponding data query statement.

[0043] It should be noted that, for the business system that needs to display business data in the form of graphical or tabular reports, the configuration objects in the business system can be configured to produce configured reports that meet business needs by performing trigger operations such as dragging and dropping on the report configuration interface in the report configuration system described in the embodiment of the present invention. It is no longer necessary for the developers of each business system to develop their own report configuration logic separately. This can be done by the developers of the report configuration system once to meet the report generation needs of each business system connected to the report configuration system, thereby achieving the effect of automatic configuration of reports for multiple business systems / business departments / configuration objects.

[0044] The technical solution of the embodiment of the present invention can display the data source identifiers of each candidate data source associated with the configuration object by acquiring the configuration object corresponding to the configuration trigger event of the monitored report configuration, so that the configuration object can determine the candidate data source that it can select from the displayed data source identifier; receive the data source trigger operation on the data source identifier, take the candidate data source corresponding to the data source trigger operation as the target data source, and display the report identifier associated with the target data source, so that the configuration object can determine from the displayed report identifier which report attributes the configured report that can be configured based on the selected target data source has; and then receive the report trigger operation on the report identifier, read the data in the target data source with the data reading strategy corresponding to the report trigger operation, and obtain the configured report corresponding to the configuration of the configuration object based on the reading result. The above technical solution can configure a configured report that meets the business needs of the configuration object according to the received trigger operation acting on the corresponding identifier, and it simplifies the report configuration process through the configuration method, thereby achieving the effect of automatically, quickly and conveniently configuring a configured report that matches the configuration object.

[0045] On this basis, an optional technical solution is that, due to the different business requirements of the business system where each configuration object is located, for the same target data source associated with different configuration objects, it may not be possible to directly generate a configured report that meets the business requirements based on the target data stored therein. Accordingly, after taking the candidate data source corresponding to the data source trigger operation as the target data source, it may also include: obtaining the data aggregation strategy associated with the configuration object, and aggregating the data to be aggregated in the target data source based on the data aggregation strategy, and updating the target data source based on the second aggregation result obtained thereby.

[0046] Among them, the data aggregation strategy can be a strategy for aggregating which target data (i.e., data to be aggregated) in the target data source based on what aggregation method is set to meet the business needs of the configuration object. It can be a strategy pre-developed by the developers of the report configuration system according to the corresponding business needs, or it can be a strategy pre-developed by the developers of the business system and sent to the report configuration system after completion. For example, the developers of the business system can write SQL according to their own business needs and send the SQL to the report configuration system so that the report configuration system performs data reading operations according to the SQL. Further, the aggregated data (i.e., the second aggregation result) aggregated based on the data aggregation strategy can be data that can be directly used to generate configured reports that meet business needs. Exemplarily, assuming that the target data in the target data source is the number of orders completed per day, and the business demand is to count the number of orders completed per month in this year, the number of orders completed in each month of this year can be aggregated to obtain the number of orders completed in each month. It should be noted that there may be differences between the data aggregation strategies associated with different configuration objects, which means that the target data source may include aggregated data corresponding to each configuration object. These aggregated data can be stored in the target data source based on different indexes, so that the aggregated data matching the configuration object can be quickly read from the target data source based on the index. The above technical solution aggregates the data to be aggregated in the target data source through the data aggregation strategy associated with the configuration object. In this way, after reading the data from the target data source updated based on the solution, a configured report that meets the business needs of the configuration object can be directly generated.

[0047] Embodiment 2

[0048] Figure 2 It is a flow chart of a report configuration method provided in the second embodiment of the present invention. This embodiment is optimized based on the above-mentioned technical solutions. In this embodiment, optionally, each candidate data source can be updated through the following steps: obtaining the data storage device associated with the candidate data source, and the data acquisition information of the configuration object for the data storage device; using the data acquisition information as the basis for data acquisition, periodically acquiring incremental data from the data storage device based on a preset time interval, and / or acquiring incremental data corresponding to a message change event from a preset message queue; storing the incremental data in the candidate data source to update the candidate data source. The explanations of the terms that are the same or corresponding to the above-mentioned embodiments are not repeated here.

[0049] See also Figure 2 The method of this embodiment may specifically include the following steps:

[0050] S210: Acquire a data storage device corresponding to the candidate data source, and configure the object to acquire data for the data storage device.

[0051] Among them, considering that as the business system continues to run, the business data associated with it is also continuously updated, then the candidate data source used to store the business data or the processing results of the business data also needs to be continuously updated. To this end, the data storage device associated with the candidate data source and the data acquisition information of the configuration object relative to the data storage device can be obtained. The data storage device can be a device for storing candidate data related to the candidate data source, such as a remote file server, a relational database, a search device, etc.; the data acquisition information can be the information required to obtain the business data associated with the configuration object from the data storage device, such as an account password, etc. Therefore, the subsequent report configuration system can obtain the business data associated with the business system where the configuration object is located from the data storage device based on the data acquisition information, thereby achieving the effect of remote data access.

[0052] S220. Using the data acquisition information as a basis for data acquisition, periodically acquire incremental data from a data storage device based on a preset time interval, and / or acquire incremental data corresponding to a message change event from a preset message queue.

[0053] Among them, when updating the candidate data source, one optional scheme is to update based on the business data (i.e., incremental data) that has changed in the data storage device between this update and the last update. Therefore, the incremental data can be obtained from the data storage device based on the data acquisition information, so that the incremental data can be subsequently stored in the candidate data source to realize the update of the candidate data source.

[0054] On this basis, taking into account that some business systems have lower requirements for the real-time performance of reports, such as generating a configured report today related to the number of completed orders yesterday, incremental data can be obtained in an offline manner. For example, incremental data is obtained periodically based on a preset time interval, that is, incremental data is automatically extracted from a data storage device associated with the candidate data source at every preset time interval.

[0055] Correspondingly, considering that some business systems have high requirements for the real-time performance of reports, such as generating a configured report related to the number of orders placed at the previous moment at the current moment, incremental data can be obtained online. For example, when the business data changes, the business system can synchronize the changed business data (i.e., incremental data) to the preset message queue, that is, synchronize the changed business data to the preset message queue in an incremental manner. The preset message queue can be a pre-set queue for storing messages, such as a KAFKA queue. At this time, the business system is the producer of the preset message queue. Therefore, when the report configuration system detects a message change event originating from the preset message queue, it can obtain the incremental data corresponding to the message change event from the preset message queue. At this time, the report configuration system is the consumer of the preset message queue.

[0056] S230: Store the incremental data in the candidate data source to update the candidate data source.

[0057] S240: When a configuration triggering event of the report configuration is monitored, a configuration object corresponding to the configuration triggering event is obtained, and a data source identifier of each candidate data source associated with the configuration object is displayed.

[0058] S250: Receive a data source trigger operation for a data source identifier, use a candidate data source corresponding to the data source trigger operation as a target data source, and display a report identifier associated with the target data source.

[0059] S260: Receive a report triggering operation for a report identifier, read data in a target data source using a data reading strategy corresponding to the report triggering operation, and obtain a configured report based on the reading result.

[0060] The technical solution of the embodiment of the present invention obtains data information of the data storage device corresponding to the candidate data source through the obtained configuration object, reads incremental data from the data storage device based on an offline or online method, and stores the incremental data in the candidate data source, thereby achieving real-time or scheduled update of the candidate data source, and further ensuring the effectiveness of the configured reports subsequently configured based on the target data source in the candidate data source.

[0061] On this basis, an optional technical solution takes into account that the business data in the data storage device is usually very scattered data. For example, it may be specific to the number of orders completed per second, the number of orders completed for a certain family, etc. However, the data required for the configured report is usually data with certain statistical significance, such as the number of orders completed per day, the number of orders completed in XX city, etc. Therefore, storing the incremental data in the candidate data source can specifically include: obtaining the attribute information of each incremental data and the pre-set aggregation dimension respectively; determining the data to be aggregated that meets the aggregation dimension from each incremental data according to the attribute information, and aggregating each data to be aggregated; and storing the first aggregation result obtained in this way in the storage location corresponding to the aggregation dimension in the candidate data source.

[0062] Among them, the attribute information can indicate the detailed information of the incremental data, such as the number of orders completed for which item at what time and where. The aggregation dimension can indicate the dimension on which the incremental data needs to be aggregated, such as the time dimension, the space dimension, the item dimension, etc. Therefore, according to the attribute information, the data to be aggregated that meets the aggregation dimension can be determined from each incremental data, that is, the incremental data corresponding to the attribute information matching the aggregation dimension is taken as the data to be aggregated, and then these data to be aggregated are aggregated to obtain the first aggregation result. Exemplarily, assuming that the aggregation dimension is the number of orders completed from XX to XX and in XX area, then the incremental data whose time information in the attribute information is within the time range of XX to XX and whose location information belongs to XX area can be taken as the data to be aggregated, and these data to be aggregated are aggregated together to obtain the number of orders completed from XX to XX and in XX area. Further, in order to quickly obtain the candidate data under a certain aggregation dimension from the candidate data source later, the first aggregation result can be stored in the storage location corresponding to the aggregation dimension in the candidate data source, and different storage locations can be represented by different indexes.

[0063] In order to better understand the specific implementation process of storing the business data from the data storage device to the candidate data source and aggregating the target data in the target data source, the following is an exemplary description of it with reference to a specific example. Figure 3, the above data storage process can be understood as a data processing process. In offline processing, the incremental data in the RMDB business table A and / or TXT business data B can be captured based on the worker periodicity. Since the primary key of the incremental data can reflect its attribute information, the incremental data with the primary key matching the aggregation dimension can be aggregated, and the first aggregation result (i.e., the first aggregation result) obtained thereby can be uniformly processed into the ES wide table. Correspondingly, in online processing, the report configuration system can consume RMDB incremental data and / or PREESTO incremental data from the KAFKA queue, and then start the FLINK task of the business system to process the consumed incremental data into ES. In other words, whether it is online processing or offline processing, the incremental data acquired remotely can be processed according to the aggregation dimension matching the business requirements, and the processing results can be landed in the ES wide table according to different aggregation dimensions, thereby realizing the update of the candidate data source. Furthermore, when the target data source is selected, the data to be aggregated in the target data source (i.e., a certain ES wide table) can be aggregated based on the pre-configured data aggregation strategy associated with the configuration object, thereby achieving the effect of secondary aggregation.

[0064] Embodiment 3

[0065] Figure 4 It is a flow chart of a report configuration method provided in the third embodiment of the present invention. This embodiment is optimized based on the above-mentioned technical solutions. In this embodiment, optionally, the report identifier includes an indicator identifier and a dimension identifier, and a report trigger operation for the report identifier is received, and data is read in the target data source with a data reading strategy corresponding to the report trigger operation, which may include: receiving an indicator trigger operation for the indicator identifier and a dimension trigger operation for the dimension identifier, and reading data in the target data source with a data reading strategy corresponding to the indicator trigger operation and the dimension trigger operation; and / or, the report identifier includes a report display identifier, and after the configured report is obtained based on the reading result, the above-mentioned report configuration method may also include: receiving a display trigger operation for the report display identifier, and displaying the configured report with a report display strategy corresponding to the display trigger operation; and / or, the report identifier includes a report comparison identifier, and after the configured report is obtained based on the reading result, the above-mentioned report configuration method may also include: receiving a comparison trigger operation for the report comparison identifier, and determining the report to be compared in each configured report with a report comparison strategy corresponding to the comparison trigger operation, and displaying each report to be compared on the same report configuration interface. Among them, the explanation of the terms that are the same or corresponding to the above-mentioned embodiments is not repeated here.

[0066] See also Figure 4 The method of this embodiment may specifically include the following steps:

[0067] S310: When a configuration triggering event of the report configuration is monitored, a configuration object corresponding to the configuration triggering event is obtained, and a data source identifier of each candidate data source associated with the configuration object is displayed.

[0068] S320: Receive a data source trigger operation for a data source identifier, use a candidate data source corresponding to the data source trigger operation as a target data source, and display a report identifier associated with the target data source.

[0069] S330, the report identifier includes an indicator identifier and a dimension identifier, receives an indicator trigger operation for the indicator identifier and a dimension trigger operation for the dimension identifier; reads data in the target data source using a data reading strategy corresponding to the indicator trigger operation and the dimension trigger operation; and obtains a configured report based on the reading result.

[0070] Among them, the dimension identifier can indicate the data analysis result under which dimension the configured report is, such as the data analysis result under the spatial dimension, time dimension, item dimension and other dimensions; the indicator identifier can indicate the data analysis result under which indicator the configured report is, such as the data analysis result under the indicators such as the number of completed orders, the amount of completed orders, and the number of returned orders. The indicator trigger operation can be a trigger operation received by the report configuration system that acts on at least one indicator identifier among the indicator identifiers, and the dimension trigger operation can be a trigger operation received by the report configuration system that acts on at least one dimension identifier among the dimension identifiers. Data is read in the target data source based on the data reading strategy corresponding to the indicator trigger operation and the dimension trigger operation, that is, the target data under the indicator corresponding to the indicator trigger operation and the dimension corresponding to the dimension trigger operation is read from the target data source.

[0071] S340: The report identifier includes a report display identifier, a display trigger operation for the report display identifier is received, and the configured report is displayed using a report display policy corresponding to the display trigger operation.

[0072] Among them, the report display identifier can be used to indicate the display mode of the configured report, such as a bar chart, a pie chart, etc., and the display trigger operation can be a trigger operation received by the report configuration system and acting on at least one of the report display identifiers. The report display policy corresponding to the display trigger operation can also be understood as the report display policy corresponding to the report display identifier. Since the configured report can indicate the data analysis results under what dimension and what indicator, the specific display mode of the data analysis results can be determined by the report display policy, that is, the configured report can be displayed based on the report display policy.

[0073] S350, the report identifier includes a report comparison identifier, receiving a comparison trigger operation on the report comparison identifier, determining the reports to be compared in each configured report using a report comparison strategy corresponding to the comparison trigger operation, and displaying each report to be compared on the same report configuration interface.

[0074] Among them, the report comparison mark can be used to indicate which configured reports are to be compared and displayed, and the comparison trigger operation can be a trigger operation received by the report configuration system and acting on at least one of the report comparison marks. The report comparison strategy corresponding to the comparison trigger operation can be understood as the report comparison strategy corresponding to the report comparison mark, based on which the reports to be compared can be determined from the configured reports, and each report to be compared can be displayed on the same report configuration interface, and each report configuration interface can display at least one configured report, so that the configuration object can browse each report to be compared from the report configuration interface at the same time. Exemplarily, assuming that the report comparison mark is an mark for comparing a first report with the number of orders completed this month and a second report with the number of orders completed last month, then based on the corresponding report comparison strategy, the first report and the second report can be determined from the configured reports, and the first report and the second report can be displayed on the same report configuration interface.

[0075] It should be noted that, for the report configuration method described in the embodiment of the present invention, at least one of S330-S330 can be optionally executed. For example, after S330 is used to obtain the configured report, the process ends; for example, after S330 is used to obtain the configured report, the configured report can be displayed based on S340, and the process ends; for example, after S330 is used to obtain the configured report, the report to be compared can be displayed based on S350, and the process ends; and so on, no specific limitation is made here.

[0076] The technical solution of the embodiment of the present invention reads data in the target data source by using a data reading strategy corresponding to the received indicator trigger operation for the indicator identifier and the dimension trigger operation for the dimension identifier, thereby obtaining target data matching the required indicators and dimensions; and / or, the report identifier includes a report display identifier, receives a display trigger operation for the report display identifier, and displays the configured report with the report display strategy corresponding to the display trigger operation, thereby achieving the effect of configuring the display method of the configured report; and / or, the report identifier includes a report comparison identifier, receives a comparison trigger operation for the report comparison identifier, determines the reports to be compared in each configured report with the report comparison strategy corresponding to the comparison trigger operation, and displays each report to be compared on the same report configuration interface, thereby achieving the effect of configuring the display content of the report configuration interface.

[0077] In order to better understand the specific implementation process of the above steps, the report configuration method of this embodiment is exemplarily described below with reference to specific examples. Figure 5 As shown, the business department where the configuration object is located is called a tenant. The tenant can be understood as a department that needs to use the report configuration system to display the configured report and apply it to the business system. On this basis, when the report configuration system monitors the join trigger event of the tenant joining, it can review the tenant and obtain the data acquisition information (such as account password) of the data storage device submitted by the tenant after the review is passed. The report configuration system creates an index of the tenant's ES wide table based on the business needs provided by the tenant. The index is the index of the ES wide table corresponding to the tenant, and based on the published data processing tasks, it obtains incremental data from the data storage device with the help of data acquisition information, aggregates the incremental data, and stores the first aggregation result obtained in the ES wide table. Further, when the report configuration system monitors the add trigger event added by the user role, it obtains the user corresponding to the add trigger event and the role of the user, where the user is an object in the tenant, and the role is the permission of the object, such as some objects are configuration objects with report configuration permissions, some objects are display objects with report display permissions, and so on.

[0078] Further, according to the sequentially received data source trigger operation, indicator trigger operation, display trigger operation and comparison trigger operation, the data source is selected, the indicator is configured, the report is configured, and the panel (i.e., the report configuration interface) is configured in sequence. In addition, the panel visible permissions and the data open interface (i.e., the interface to be called) can also be configured according to the sequentially received permission trigger operation and interface trigger operation. The interface to be called can be a report configuration interface and / or a report display interface, so that objects with corresponding permissions can browse to the panel and business systems with corresponding permissions can call the data open interface to implement the report configuration function and the report display function. In the above technical solution, the user only needs to drag and drop the indicator label and dimension label on the report configuration interface, and the report configuration system can generate a configured report based on the target data corresponding to the indicator label and the dimension label. The above report configuration system supports multi-tenant, multi-user, multi-role, data isolation and functional isolation, and it can enable tenants to manage the users and roles under their own tenants, as well as the permission control of the data open interface to which they belong.

[0079] Embodiment 4

[0080] Figure 6It is a flow chart of a report configuration method provided in the fourth embodiment of the present invention. This embodiment is optimized based on the above-mentioned technical solutions. In this embodiment, optionally, the above-mentioned report configuration method may also include: when a display trigger event for report display is monitored, reading the data to be displayed from the target data source at the triggering moment of the display trigger event based on the data reading strategy; generating a report to be displayed based on the read data to be displayed, and displaying the report to be displayed. Among them, the explanations of the terms that are the same or corresponding to the above-mentioned embodiments are not repeated here.

[0081] See also Figure 6 The method of this embodiment may specifically include the following steps:

[0082] S410: When a configuration triggering event of the report configuration is monitored, a configuration object corresponding to the configuration triggering event is obtained, and a data source identifier of each candidate data source associated with the configuration object is displayed.

[0083] S420: Receive a data source trigger operation for a data source identifier, use a candidate data source corresponding to the data source trigger operation as a target data source, and display a report identifier associated with the target data source.

[0084] S430: Receive a report triggering operation for a report identifier, read data in a target data source using a data reading strategy corresponding to the report triggering operation, and obtain a configured report based on the reading result.

[0085] S440: When a display triggering event for report display is detected, the data to be displayed is read from the target data source at the triggering moment of the display triggering event based on the data reading strategy.

[0086] Among them, the display trigger event can be an event triggered by a display object for displaying a configured report, such as an event triggered when the display object touches the report display identifier in the report configuration system, an event triggered when the display object calls the report display interface in the report configuration system through the business system, etc. The display object can be a user with report display authority under a business department in a business system that has a report display requirement, or it can be a user with report display authority in the report configuration system.

[0087] The triggering moment is the moment when the display triggering event is triggered. Since the target data source may be continuously updated, in order to ensure the timeliness of the configured report displayed to the display object, the target data source at the triggering moment can be obtained, and the data to be displayed can be read from the target data source based on the data reading strategy obtained in the above configuration method.

[0088] S450: Generate a report to be displayed based on the read data to be displayed, and display the report to be displayed.

[0089] Among them, a report to be displayed is generated based on the read data to be displayed, and the report to be displayed is displayed. In practical applications, optionally, the report to be displayed can be displayed based on the report display strategy obtained in a configured manner, or the corresponding report to be displayed can be displayed on the same report configuration interface based on the report comparison strategy. Optionally, when displaying the report to be displayed, the object authority of the display object corresponding to the display trigger event can be obtained, and whether there is an interface to be called corresponding to the display object can be determined according to the object authority; if so, the business system connected to the interface to be called is obtained, and the report to be displayed is sent to the business system based on the interface to be called, so that the business system displays the received report to be displayed. The reason for this setting is that some display objects have the need to display the report to be displayed directly on the business system where they are located, which makes it no longer necessary to log in to the report configuration system, and only needs to browse the report to be displayed in the business system that they often log in, thereby improving the convenience of operation. That is, the report configuration system can provide an interface to be called so as to provide query services for the business system through the calling interface.

[0090] The technical solution of the embodiment of the present invention reads the data to be displayed from the target data source at the triggering moment of the display triggering event of the report display through a data reading strategy, and displays the report to be displayed generated based on the read data to be displayed, thereby achieving the effect of displaying the report to be displayed that meets the display requirements.

[0091] In order to better understand the specific implementation process of the above steps, the structure of the report configuration system used to execute the report configuration method in this embodiment is exemplarily described below with reference to specific examples. Figure 7a As shown in the figure, the report configuration system can support business data from various data storage devices, such as business data from remote file servers, relational databases, search devices, etc. The business data can be accessed through the data acquisition information provided when the business system is connected to the report configuration system. The accessed business data is processed in a secondary incremental manner according to business needs, and the processed data is landed in the ES cluster according to different dimensions. In addition, the report configuration system can also provide different data source interfaces (DataProvider, i.e., the interface to be called, such as Figure 7aThe data provider in the report configuration system is provided for the rest of the business systems to call. The report configuration system can also configure the data set according to the target data source selected by the configuration object, and read the corresponding target data from the target data source according to the ES aggregate function SQL based on the indicators and dimensions selected by the configuration object. In particular, the report configuration system can support multiple tenants, multiple users and multiple roles, and tenants can manage the users and roles under their own tenants, thereby achieving the effects of data isolation and functional isolation. The above-mentioned report configuration system realizes the full configurability of the graphical display of reports. Developers only need to focus on the business logic and data extraction and processing of wide tables, and then dynamically generate configured reports by dragging and dropping indicators and dimensions on the report configuration page by users with configuration permissions in the received tenants. In addition, the reports to be compared can be integrated in the panel to authorize users with corresponding permissions to query.

[0092] like Figure 7b As shown, the above-mentioned report configuration system may include the following functions: access management: when a tenant applies to join the report configuration system, the report configuration system audits the tenant and checks the business data; user role: the tenant sets the role (i.e., authority) of the user within the tenant; data source management: the candidate data source where the candidate data required for report configuration is located; processing task management: offline or online data processing of each business data, which may include the task currently being processed and the tasks that have been processed historically; report configuration management: configuration of various indicators and dimensions; panel management: a collection of each report to be compared, showing the comparison between at least two reports to be compared; data set management: aggregation of each business data to generate data sets under different indicators of different dimensions.

[0093] Embodiment 5

[0094] Figure 8 This is a structural block diagram of a report configuration device provided in Embodiment 5 of the present invention. The device is used to execute the report configuration method provided in any of the above embodiments. The device and the report configuration method of the above embodiments belong to the same inventive concept. For details not described in detail in the embodiment of the report configuration device, please refer to the embodiment of the above report configuration method. Figure 8 The device may specifically include: a data source identification display module 510, a report identification display module 520 and a report configuration module 530.

[0095] The data source identification display module 510 is used to obtain the configuration object corresponding to the configuration trigger event when the configuration trigger event of the report configuration is monitored, and display the data source identification of each candidate data source associated with the configuration object;

[0096] The report identification display module 520 is used to receive a data source trigger operation on a data source identification, take a candidate data source corresponding to the data source trigger operation as a target data source, and display a report identification associated with the target data source;

[0097] The report configuration module 530 is used to receive a report trigger operation for a report identifier, read data from a target data source using a data reading strategy corresponding to the report trigger operation, and obtain a configured report based on the reading result.

[0098] Optionally, based on the above device, the device may further include:

[0099] A data acquisition information acquisition module, used to acquire data storage devices corresponding to candidate data sources, and data acquisition information of the configuration object for the data storage devices;

[0100] An incremental data acquisition module is used to obtain incremental data from a data storage device based on a preset time interval based on the data acquisition information, and / or to obtain incremental data corresponding to a message change event from a preset message queue;

[0101] The data source update module is used to store the incremental data into the candidate data source to update the candidate data source.

[0102] On this basis, the optional data source update module may specifically include:

[0103] An aggregation dimension acquisition module is used to respectively obtain the attribute information of each incremental data and the pre-set aggregation dimension; a data first aggregation module is used to determine the data to be aggregated that meets the aggregation dimension from each incremental data according to the attribute information, and aggregate each data to be aggregated to obtain a first aggregation result; a data storage module is used to store the first aggregation result in a storage location corresponding to the aggregation dimension in the candidate data source.

[0104] Optionally, the report configuration module may further include:

[0105] The data re-aggregation module is used to obtain the data aggregation strategy associated with the configuration object after taking the candidate data source corresponding to the data source trigger operation as the target data source, aggregate the data to be aggregated in the target data source based on the data aggregation strategy, and obtain a second aggregation result; update the target data source based on the second aggregation result.

[0106] Optionally, the report identifier includes an indicator identifier and a dimension identifier. The report configuration module 530 may specifically include:

[0107] An operation receiving unit, used to receive an indicator triggering operation for an indicator identifier and a dimension triggering operation for a dimension identifier; a reading result updating unit, used to read data in a target data source using a data reading strategy corresponding to the indicator triggering operation and the dimension triggering operation;

[0108] And / or, the report identifier includes a report display identifier, and the report configuration module may further include:

[0109] A first report display module is used to receive a display trigger operation for a report display identifier after obtaining a configured report based on the reading result, and display the configured report using a report display policy corresponding to the display trigger operation;

[0110] And / or, the report identifier includes a report comparison identifier, and the report configuration module may further include:

[0111] The second report display module is used to receive a comparison trigger operation on a report comparison identifier after obtaining a configured report based on the reading result, determine the reports to be compared in each configured report with a report comparison strategy corresponding to the comparison trigger operation, and display each report to be compared on the same report configuration interface.

[0112] Optionally, the report configuration module may further include:

[0113] The data reading module is used to read the data to be displayed from the target data source at the triggering moment of the display triggering event based on the data reading strategy when the display triggering event of the report display is detected;

[0114] The third report display module is used to generate a report to be displayed based on the read data to be displayed, and display the report to be displayed.

[0115] On this basis, optionally, the third report display module may include:

[0116] An interface determination unit, used to obtain the object authority of the display object corresponding to the display triggering event, and determine whether there is a to-be-called interface corresponding to the display object according to the object authority;

[0117] The third report display unit is used to obtain the business system associated with the interface to be called, and send the report to be displayed to the business system based on the interface to be called, so that the business system displays the received report to be displayed.

[0118] The report configuration device provided in the fifth embodiment of the present invention can obtain the configuration object corresponding to the configuration trigger event of the monitored report configuration through the data source identification display module, and can display the data source identification of each candidate data source associated with the configuration object, so that the configuration object can determine the candidate data source that it can select from the displayed data source identification; the report identification display module receives the data source trigger operation on the data source identification, takes the candidate data source corresponding to the data source trigger operation as the target data source, and displays the report identification associated with the target data source, so that the configuration object can determine from the displayed report identification which report attributes the configured report that can be configured based on the selected target data source has; the report configuration module receives the report trigger operation on the report identification, reads data in the target data source with the data reading strategy corresponding to the report trigger operation, and obtains the configured report corresponding to the configuration of the configuration object based on the reading result. The above device can configure a configured report that meets the business needs of the configuration object according to the received trigger operation acting on the corresponding identification, and simplifies the report configuration process through the configuration mode, thereby achieving the effect of automatically, quickly and conveniently configuring a configured report that matches the configuration object.

[0119] The report configuration device provided in the embodiment of the present invention can execute the report configuration method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.

[0120] It is worth noting that in the embodiment of the above-mentioned report configuration device, the various units and modules included are only divided according to functional logic, but are not limited to the above-mentioned division, as long as the corresponding functions can be achieved; in addition, the specific names of the functional units are only for the convenience of distinguishing each other, and are not used to limit the scope of protection of the present invention.

[0121] Embodiment 6

[0122] Fig. 9 A structural diagram of a report configuration system provided in Embodiment 6 of the present invention is shown in FIG. Fig. 9 As shown, the report configuration system includes a memory 610, a processor 620, an input device 630, and an output device 640. The number of the processor 620 in the report configuration system can be one or more. Fig. 9 A processor 620 is used as an example; the memory 610, the processor 620, the input device 630 and the output device 640 in the report configuration system can be connected via a bus or other means, Fig. 9 Take the connection via bus 650 as an example.

[0123] The memory 610, as a computer-readable storage medium, can be used to store software programs, computer executable programs and modules, such as program instructions / modules corresponding to the report configuration method in the embodiment of the present invention (for example, the data source identification display module 510, the report identification display module 520 and the report configuration module 530 in the report configuration device). The processor 620 executes various functional applications and data processing of the report configuration system by running the software programs, instructions and modules stored in the memory 610, that is, implements the above-mentioned report configuration method.

[0124] The memory 610 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system and at least one application required for a function; the data storage area may store data created according to the use of the report configuration system, etc. In addition, the memory 610 may include a high-speed random access memory, and may also include a non-volatile memory, such as at least one disk storage device, a flash memory device, or other non-volatile solid-state storage device. In some instances, the memory 610 may further include a memory remotely arranged relative to the processor 620, and these remote memories may be connected to the device via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0125] The input device 630 may be used to receive input digital or character information and generate key signal input related to user settings and function control of the device. The output device 640 may include a display device such as a display screen.

[0126] Embodiment 7

[0127] Embodiment 7 of the present invention provides a storage medium including computer executable instructions, wherein the computer executable instructions are used to execute a report configuration method when executed by a computer processor, the method comprising:

[0128] When a configuration trigger event of the report configuration is detected, a configuration object corresponding to the configuration trigger event is obtained, and the data source identifiers of each candidate data source associated with the configuration object are displayed;

[0129] receiving a data source trigger operation for a data source identifier, taking a candidate data source corresponding to the data source trigger operation as a target data source, and displaying a report identifier associated with the target data source;

[0130] A report trigger operation for a report identifier is received, data is read from a target data source using a data reading strategy corresponding to the report trigger operation, and a configured report is obtained based on the reading result.

[0131] Of course, the computer executable instructions of a storage medium including computer executable instructions provided by an embodiment of the present invention are not limited to the operations of the method described above, and can also execute related operations in the report configuration method provided by any embodiment of the present invention.

[0132] Through the above description of the implementation methods, the technicians in the relevant field can clearly understand that the present invention can be implemented by means of software and necessary general hardware, and of course it can also be implemented by hardware, but in many cases the former is a better implementation method. Based on this understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as a computer floppy disk, read-only memory (ROM), random access memory (RAM), flash memory (FLASH), hard disk or optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, server, or network device, etc.) to execute the methods described in each embodiment of the present invention.

[0133] Note that the above are only preferred embodiments of the present invention and the technical principles used. Those skilled in the art will understand that the present invention is not limited to the specific embodiments described herein, and that various obvious changes, readjustments and substitutions can be made by those skilled in the art without departing from the scope of protection of the present invention. Therefore, although the present invention has been described in more detail through the above embodiments, the present invention is not limited to the above embodiments, and may include more other equivalent embodiments without departing from the concept of the present invention, and the scope of the present invention is determined by the scope of the appended claims.

Claims

1. A report configuration method, characterized in that: include: When a configuration triggering event of the report configuration is monitored, a configuration object corresponding to the configuration triggering event is obtained, and a data source identifier of each candidate data source associated with the configuration object is displayed; receiving a data source trigger operation for the data source identifier, taking the candidate data source corresponding to the data source trigger operation as a target data source, and displaying a report identifier associated with the target data source; receiving a report triggering operation for each of the report identifiers, reading data in the target data source using a data reading strategy corresponding to the report triggering operation, and obtaining a configured report based on the reading result, wherein the data reading strategy corresponds to the triggered report identifier in each of the report identifiers; After taking the candidate data source corresponding to the data source trigger operation as the target data source, the method further includes: Acquire a data aggregation strategy associated with the configuration object, and aggregate the data to be aggregated in the target data source based on the data aggregation strategy to obtain a second aggregation result; The target data source is updated based on the second aggregation result, so that after reading the second aggregation result from the target data source, a configured report that meets the business requirements of the configuration object is generated based on the read second aggregation result.

2. The method according to claim 1, characterized in that Each of the candidate data sources is updated through the following steps: Acquire a data storage device corresponding to the candidate data source, and data acquisition information of the configuration object for the data storage device; Taking the data acquisition information as a basis for data acquisition, regularly acquiring incremental data from the data storage device based on a preset time interval, and / or acquiring the incremental data corresponding to a message change event from a preset message queue; The incremental data is stored in the candidate data source to update the candidate data source.

3. The method according to claim 2, characterized in that The storing the incremental data in the candidate data source includes: Respectively obtaining attribute information of each incremental data and a preset aggregation dimension; Determine, from each of the incremental data, data to be aggregated that meets the aggregation dimension according to the attribute information, and aggregate each of the data to be aggregated to obtain a first aggregation result; The first aggregation result is stored in a storage location corresponding to the aggregation dimension in the candidate data source.

4. The method according to claim 1, characterized in that The report identifier includes an indicator identifier and a dimension identifier, and the receiving of a report trigger operation for each of the report identifiers and reading data from the target data source using a data reading strategy corresponding to the report trigger operation include: Receiving an indicator triggering operation for each of the indicator identifiers and a dimension triggering operation for each of the dimension identifiers, and reading data in the target data source using a data reading strategy corresponding to the indicator triggering operation and the dimension triggering operation; And / or, the report identifier includes a report display identifier, and after the configured report is obtained based on the reading result, the method further includes: receiving a display triggering operation for each of the report display identifiers, and displaying the configured report using a report display strategy corresponding to the display triggering operation; And / or, the report identifier includes a report comparison identifier, and after obtaining the configured report based on the reading result, further comprising: A comparison trigger operation for each of the report comparison identifiers is received, a report to be compared in each of the configured reports is determined using a report comparison strategy corresponding to the comparison trigger operation, and each of the reports to be compared is displayed on the same report configuration interface.

5. The method according to claim 1, characterized in that Also includes: When a display triggering event of report display is detected, the data to be displayed is read from the target data source at the triggering moment of the display triggering event based on the data reading strategy; A report to be displayed is generated based on the read data to be displayed, and the report to be displayed is displayed.

6. The method according to claim 5, characterized in that The displaying of the report to be displayed includes: Acquire the object permission of the display object corresponding to the display triggering event, and determine whether there is a to-be-called interface corresponding to the display object according to the object permission; If so, the business system associated with the interface to be called is obtained, and the report to be displayed is sent to the business system based on the interface to be called, so that the business system displays the received report to be displayed.

7. A report configuration device, characterized in that: include: A data source identification display module is used to obtain a configuration object corresponding to the configuration triggering event when a configuration triggering event of the report configuration is monitored, and to display the data source identification of each candidate data source associated with the configuration object; A report identification display module, used to receive a data source trigger operation on the data source identification, take the candidate data source corresponding to the data source trigger operation as a target data source, and display the report identification associated with the target data source; A report configuration module, configured to receive a report triggering operation for each of the report identifiers, read data in the target data source using a data reading strategy corresponding to the report triggering operation, and obtain a configured report based on the reading result; wherein the data reading strategy corresponds to the triggered report identifier in each of the report identifiers; The data re-aggregation module is used to obtain the data aggregation strategy associated with the configuration object after taking the candidate data source corresponding to the data source trigger operation as the target data source, aggregate the data to be aggregated in the target data source based on the data aggregation strategy, and obtain a second aggregation result; update the target data source based on the second aggregation result, so as to generate a configured report that meets the business needs of the configuration object based on the second aggregation result read from the target data source after reading the second aggregation result.

8. A report configuration system, characterized in that: include: one or more processors; A memory for storing one or more programs; When the one or more programs are executed by the one or more processors, the one or more processors implement the report configuration method as described in any one of claims 1 to 6.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the report configuration method according to any one of claims 1 to 6 is implemented.

Images