CN113760280A

CN113760280A - Report configuration method, device, equipment and storage medium

Info

Publication number: CN113760280A
Application number: CN202110063654.9A
Authority: CN
Inventors: 王北永
Original assignee: Xi'an Jingxundi Supply Chain Technology Co ltd
Current assignee: Xi'an Jingxundi Supply Chain Technology Co ltd
Priority date: 2021-01-18
Filing date: 2021-01-18
Publication date: 2021-12-07

Abstract

The embodiment of the invention discloses a report configuration method, a report configuration device, report configuration equipment and a storage medium. The method comprises the following steps: when a configuration trigger event of report configuration is monitored, acquiring a configuration object corresponding to the configuration trigger event, and displaying data source identifications of all candidate data sources associated with the configuration object; receiving data source triggering operation on the data source identification, taking a candidate data source corresponding to the data source triggering operation as a target data source, and displaying a report identification associated with the target data source; and receiving report triggering operation of the report identification, reading data in the target data source by using a data reading strategy corresponding to the report triggering operation, and obtaining a configured report based on a reading result. According to the technical scheme of the embodiment of the invention, the report configuration process is simplified through a configuration mode, so that the effect of automatically, quickly and conveniently configuring the configured report matched with the configuration object is achieved.

Description

Report configuration method, device, equipment and storage medium

Technical Field

The embodiment of the invention relates to the field of computer application, in particular to a report configuration method, a report configuration device, report configuration equipment and a storage medium.

Background

With the continuous development of society, a big data age has come. When facing a lot of data, the report is the preferred way to show the data analysis result. At present, operation and maintenance personnel mainly select corresponding data according to business requirements, analyze the selected data and display the analysis result through a report.

In the process of implementing the invention, the inventor finds that the following technical problems exist in the prior art: the existing report obtaining process is complicated, and the application convenience is poor.

Disclosure of Invention

The embodiment of the invention provides a report configuration method, a report configuration device, a report configuration equipment and a report configuration storage medium, which are used for realizing the effect of automatically obtaining a configured report corresponding to a configuration object in a configuration mode.

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

when a configuration trigger event of report configuration is monitored, acquiring a configuration object corresponding to the configuration trigger event, and displaying data source identifications of all candidate data sources associated with the configuration object;

receiving data source triggering operation on the data source identification, taking a candidate data source corresponding to the data source triggering operation as a target data source, and displaying a report identification associated with the target data source;

and receiving report triggering operation of the report identification, reading data in the target data source by using a data reading strategy corresponding to the report triggering operation, and obtaining a configured report based on a reading result.

In a second aspect, an embodiment of the present invention further provides a report configuration apparatus, which may include:

the data source identifier display module is used for acquiring a configuration object corresponding to the configuration trigger event when the configuration trigger event of the report configuration is monitored, and displaying the data source identifier of each candidate data source associated with the configuration object;

the report identifier display module is used for receiving data source triggering operation of the data source identifier, taking a candidate data source corresponding to the data source triggering operation as a target data source and displaying a report identifier associated with the target data source;

and the report configuration module is used for receiving report triggering operation of the report identifier, reading data in the target data source by using a data reading strategy corresponding to the report triggering operation, and obtaining a configured report based on a reading result.

In a third aspect, an embodiment of the present invention further provides a report configuration system, which may 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 provided by any embodiment of the invention.

In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the report configuration method provided in any embodiment of the present invention.

According to the technical scheme of the embodiment of the invention, the data source identification of each candidate data source associated with the configuration object can be displayed by acquiring the configuration object corresponding to the monitored configuration triggering event of the report configuration, so that the configuration object can determine the candidate data source which can be selected by the configuration object from the displayed data source identification; receiving data source triggering operation on the data source identification, taking a candidate data source corresponding to the data source triggering operation as a target data source, and displaying a report identification associated with the target data source so that a configuration object can determine which report attributes a configured report which can be configured based on the selected target data source has from the displayed report identification; and further receiving report triggering operation of the report identification, reading data in the target data source by using a data reading strategy corresponding to the report triggering operation, and obtaining a configured report corresponding to the configuration of the configuration object based on a reading result. According to the technical scheme, the configured report meeting the business requirements of the configuration object can be configured according to the received trigger operation acting on the corresponding identifier, and the report configuration process is simplified in a configuration mode, so that the effect of automatically, quickly and conveniently configuring the configured report matched with the configuration object is achieved.

Drawings

FIG. 1 is a flowchart of a report configuration method according to a first embodiment of the present invention;

FIG. 2 is a flowchart of a report configuration method according to a second embodiment of the present invention;

FIG. 3 is a flowchart of an alternative example of a report configuration method according to a second embodiment of the present invention;

FIG. 4 is a flowchart of a report configuration method according to a third embodiment of the present invention;

FIG. 5 is a flowchart of an alternative example of a report configuration method in the third embodiment of the present invention;

FIG. 6 is a flowchart of a report configuring method according to a fourth embodiment of the present invention;

fig. 7a is a first structural diagram of an alternative example of a report configuration method in the fourth embodiment of the present invention;

fig. 7b is a second structural diagram of an alternative example of a report configuration method in the fourth embodiment of the present invention;

fig. 8 is a block diagram illustrating a structure of a report configuring apparatus according to a fifth embodiment of the present invention;

fig. 9 is a schematic structural diagram of a report configuration system in the sixth embodiment of the present invention.

Detailed Description

The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.

Before the embodiment of the present invention is described, an application scenario of the embodiment of the present invention is exemplarily described: in order to implement data analysis of each service system, an alternative scheme is to respectively develop a report generation logic of each service system, where the report generation logic may include a data processing logic and an interface rendering logic, where the data processing logic may be a logic implemented by a service server in the service system and used to acquire service data from a corresponding service data source and process the acquired service data; the interface rendering logic may be logic implemented by a business client in the business system for displaying data processing results in a report form based on corresponding business requirements. Obviously, the data processing process and/or the interface rendering process in the above alternative are relatively dispersed, that is, developers of each business system need to respectively develop respective report generation logics, and the repeated logic development process works, so that the sensitivity of data is greatly reduced, and the development pressure of the developers is greatly increased.

In order to solve the above problem, embodiments of the present invention provide a report configuration method applicable to a report configuration system, where the report configuration system may be integrated in a report configuration device, and the report configuration device may 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 in communication connection with the report configuration system in a configuration mode, so that developers of each business system do not need to respectively develop respective report generation logics, and the problems of low data sensitivity and high development pressure are solved. The specific implementation process of the report configuration method is as follows. It should be noted that, in the following description, for convenience of understanding, the following exemplary description is given by taking the order amount as an example, and is not a specific limitation to the report configuration process.

Example one

Fig. 1 is a flowchart of a report configuration method according to an embodiment of the present invention. The embodiment can be applied to the situation that the configured report matched with the configuration object is automatically configured based on the configuration mode. The method can be executed by the report configuration device provided by the embodiment of the invention, the device can be realized by software and/or hardware, and the device can be integrated on a report configuration system.

Referring to fig. 1, the method of the embodiment of the present invention specifically includes the following steps:

s110, when a configuration trigger event of report configuration is monitored, acquiring a configuration object corresponding to the configuration trigger event, and displaying data source identifications of candidate data sources related to the configuration object.

The configuration triggering event may be an event triggered by the configuration object and used for obtaining, in a configuration manner, a configured report matched with the service requirement to be met by the configuration object, for example, an event triggered when the configuration object touches a report configuration identifier in a report configuration system, or an event triggered when the configuration object calls a report configuration interface in the report configuration system through a service system in communication connection with the report service system, and the like, where the configuration object may be a user with report configuration permission in a certain service department in which the report configuration requirement exists in the service system, or may be a user with report configuration permission in the report configuration system, and the service department may be understood as a tenant. In practical applications, optionally, the number of tenants that can be accessed into the report configuration system may be at least one, and/or the number of configuration objects in each tenant may also be at least one, which is not specifically limited herein.

Because the report configuration system may be in communication connection with a plurality of service systems, and for each service system, the service data sources for storing each service data in the service system may also have a difference, that is, the service data sources associated with each configuration object have a difference, a candidate data source associated with the configuration object corresponding to the configuration trigger event may be obtained, where the candidate data source may be the service data source, a data source constructed based on the service data obtained from the service data source, or the like. Furthermore, each candidate data source has a data source identifier corresponding to the candidate data source, so that 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 which can be selected by the configuration object based on the data source identifier in the report configuration interface. On this basis, the candidate data source may optionally be represented in various forms, such as MySQL, ES, Hbase, etc., where ES is more suitable for the embodiment of the present invention due to its stronger aggregation.

S120, receiving data source triggering operation of the data source identification, taking the candidate data source corresponding to the data source triggering operation as a target data source, and displaying the report identification associated with the target data source.

The data source triggering operation may be a triggering operation received by the report configuration system and acting on at least one data source identifier in the data source identifiers, the candidate data source corresponding to the data source triggering operation may be a data source for which the configuration object needs to perform data analysis on the candidate data stored therein, and for convenience of subsequent expression, such a data source may be referred to as a target data source.

Further, there may be differences between report attributes of configured reports configured based on different target data in different target data sources, where the report attributes may be attributes of dimensions, indexes, presentation forms, and the like of the configured reports related to detail information of the configured reports, where the dimensions may represent data analysis results in what dimensions the configured reports are, such as spatial dimensions, temporal dimensions, item dimensions, and the like; the indexes can show data analysis results under what indexes the configured report is, such as order transaction amount, order return amount and the like; the presentation form can indicate the form by which the configured report is presented, such as a bar graph, a pie graph, and the like. For example, if each target data in a target data source includes at what time an order is completed, the configured report may be the amount of orders committed in the time dimension; as another example, if each target data in a target data source includes at what time and where an order is to be completed, the configured report may be the amount of orders in the time dimension, the amount of orders in the space dimension, and so on. Accordingly, each report identifier associated with the target data source can be displayed on the report configuration interface, and the report identifier can present the report attributes of the configured report which can be generated based on the selected target data source.

S130, receiving report triggering operation of the report identification, reading data in the target data source by using a data reading strategy corresponding to the report triggering operation, and obtaining a configured report based on a reading result.

The report triggering operation may be a triggering operation received by the report configuration system and acting on at least one of the report identifiers, and because there is a difference in report attributes of the configured report to be configured corresponding to different report identifiers, the difference may be derived from a difference in target data required by the configured report in the configuration process, for example, if the configured report is an order transaction number of each day in this month, target data related to the order transaction number of each day in this month may be read from the target data source in the data reading process. Accordingly, a data reading policy corresponding to the report triggering operation, that is, a data reading policy corresponding to the triggered report identifier may be obtained, where the data reading policy may be a policy related to which target data is read from the target data source, and further, based on the data reading policy, data may be read from the target data source, and based on the reading result of each target data, a corresponding configured report may be configured. In practical applications, optionally, the data reading policy may be represented by a data query statement operable on the target data source, that is, data reading may be performed in the target data source based on the corresponding data query statement.

It should be noted that, in the above technical solution, for the business system that needs to display the business data in the form of a report, such as a graphical report, a tabulated report, etc., the configuration object in the business system can configure the configured report meeting the business requirement by performing the trigger operation of dragging on the report configuration interface in the report configuration system according to the embodiment of the present invention, and it is no longer necessary for the developer of each business system to separately develop the respective report configuration logic, so that the developer of the report configuration system can completely perform one-time development to meet the report generation requirement of each business system accessing to the report configuration system, thereby achieving the effect of automatic report configuration of the multi-business system/business department/configuration object

On this basis, an optional technical solution is that, because the business requirements of the business system in which each configuration object is located are different, for the same target data source associated with different configuration objects, a configured report meeting the business requirements may not be directly generated based on the target data stored therein. Accordingly, after the candidate data source corresponding to the data source triggering operation is taken as the target data source, the method may further include: and acquiring a data aggregation strategy associated with the configuration object, 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 by the aggregation.

The data aggregation policy may be a policy set for meeting a business requirement of the configuration object, where the policy is based on what aggregation manner to aggregate target data (i.e., data to be aggregated) in a target data source, and may be a policy developed in advance by a developer of the report configuration system according to a corresponding business requirement, or a policy developed in advance by a developer of the business system and then sent to the report configuration system, for example, the developer of the business system may write SQL according to its own business requirement and send the SQL to the report configuration system, so that the report configuration system performs data reading operation according to the SQL. Further, the aggregated data (i.e., the second aggregated result) aggregated based on the data aggregation policy may be data that may be directly used to generate a configured report that satisfies the business requirements. For example, it is assumed that the target data in the target data source is daily order amount of bargain, and the service requirement is statistical order amount of bargain of each month in the current year, so that the order amount of bargain belonging to the same month in the current year can be aggregated, thereby obtaining the order amount of bargain of each month. It should be noted that there may be a difference between the data aggregation policies associated with different configuration objects, which means that the target data source may include aggregated data corresponding to the configuration objects, and these aggregated data may be stored in the target data source based on different indexes, so that the aggregated data matching the configuration objects may be quickly read from the target data source based on the indexes in the following. According to the technical scheme, the data to be aggregated in the target data source is aggregated through the data aggregation strategy associated with the configuration object, so that the configured report meeting the business requirement of the configuration object can be directly generated after data reading is subsequently performed on the target data source updated based on the scheme.

Example two

Fig. 2 is a flowchart of a report configuration method provided in the second embodiment of the present invention. The present embodiment is optimized based on the above technical solutions. In this embodiment, optionally, each candidate data source may be updated through the following steps: acquiring data storage equipment associated with the candidate data source and data acquisition information of the configuration object aiming at the data storage equipment; the method comprises the steps that data acquisition information is used as a data acquisition basis, incremental data are acquired from a data storage device at regular time based on a preset time interval, and/or the incremental data corresponding to a message change event from a preset message queue are acquired; and storing the incremental data into the candidate data source to update the candidate data source. Explanations of the same or corresponding terms as those of the above embodiments are omitted.

Referring to fig. 2, the method of the present embodiment may specifically include the following steps:

s210, acquiring data storage devices corresponding to the candidate data sources and data acquisition information of the configuration object aiming at the data storage devices.

In consideration of that, as the service system continues to operate, the service data associated with the service system is continuously updated, the candidate data source for storing the service data or the processing result of the service data also needs to be continuously updated. To this end, a data storage device associated with the candidate data source, which may be a device for storing data related to candidate data in the candidate data source, such as a remote file server, a relational database, a search device, or the like, and data acquisition information of the configuration object with respect to the data storage device may be acquired; the data acquisition information may be information required to acquire service data associated with the configuration object from a data storage device, such as an account password and the like. Therefore, the subsequent report configuration system can acquire the service data associated with the service system where the configuration object is located from the data storage device based on the data acquisition information, and therefore the effect of remote data access is achieved.

And S220, acquiring incremental data from the data storage device at regular time based on a preset time interval by taking the data acquisition information as a data acquisition basis, and/or acquiring the incremental data corresponding to the message change event from the preset message queue.

When the candidate data source is updated, one alternative is to update the candidate data source based on the service data (i.e., the incremental data) that changes in the data storage device during the current update and the last update, so that the incremental data can be acquired from the data storage device based on the data acquisition information, so as to store the incremental data into the candidate data source subsequently to update the candidate data source.

On the basis, considering that some business systems have low requirements on report instantaneity, such as configured reports related to yesterday's order amount are generated today, the incremental data can be obtained on an off-line basis, and illustratively, the incremental data is obtained regularly on the basis of a preset time interval, that is, the incremental data is automatically extracted from the data storage device associated with the candidate data source at preset time intervals.

Correspondingly, considering that some business systems have high requirements for report real-time performance, for example, a configured report related to the number of orders in the current time is generated at the current time, incremental data may be obtained in an online manner, for example, when business data changes, the business system may synchronize the changed business data (i.e., the incremental data) to a preset message queue, that is, synchronize the changed business data to the preset message queue in an incremental manner, where the preset message queue may be a preset queue for storing messages, such as a KAFKA queue, and at this time, the business system is a producer of the preset message queue. Therefore, when the report configuration system monitors the message change event from the preset message queue, the report configuration system can acquire the incremental data corresponding to the message change event from the preset message queue, and at this moment, the report configuration system is a consumer of the preset message queue.

And S230, storing the incremental data into the candidate data source to update the candidate data source.

S240, when the configuration trigger event of the report configuration is monitored, acquiring a configuration object corresponding to the configuration trigger event, and displaying the data source identification of each candidate data source associated with the configuration object.

And S250, receiving data source triggering operation of the data source identification, taking the candidate data source corresponding to the data source triggering operation as a target data source, and displaying the report identification associated with the target data source.

S260, receiving report triggering operation of the report identification, reading data in the target data source by using a data reading strategy corresponding to the report triggering operation, and obtaining a configured report based on a reading result.

According to the technical scheme of the embodiment of the invention, the acquired configuration object reads the incremental data from the data storage equipment on the basis of an off-line mode or an on-line mode aiming at the data acquisition information of the data storage equipment corresponding to the candidate data source, and stores the incremental data into the candidate data source, so that the effect of updating the candidate data source in real time or at regular time is realized, and the effectiveness of the configured report configured on the basis of the target data source in the candidate data source is further ensured.

On this basis, an alternative solution, considering that the business data in the data storage device is usually very scattered data, which may be, for example, the number of orders per second, the number of orders specific to a certain household, and so on. However, the data required for the configured report is typically data having some statistical significance, such as the amount of orders for each day, the amount of orders for city XX, and so on. Therefore, storing the incremental data into the candidate data source may specifically include: respectively acquiring attribute information of each incremental data and preset aggregation dimension; determining data to be aggregated which meets the aggregation dimensionality from the incremental data according to the attribute information, and aggregating the data to be aggregated; and storing the obtained first aggregation result to a storage position corresponding to the aggregation dimension in the candidate data source.

The attribute information may indicate details of the incremental data, such as the amount of the order for which item it is at what time and where. The aggregation dimension may indicate which dimension, such as a time dimension, a space dimension, an item dimension, etc., the incremental data needs to be aggregated over. Therefore, the data to be aggregated meeting the aggregation dimension can be determined from the incremental data according to the attribute information, that is, the incremental data corresponding to the attribute information matched with the aggregation dimension is used as the data to be aggregated, and then the data to be aggregated are aggregated to obtain a first aggregation result. For example, assuming that the aggregation dimension is from XX time-XX time and the order amount of the XX area, incremental data in which the time information in the attribute information is within the time range from XX time-XX time and the position information belongs to the XX area may be used as data to be aggregated, and the data to be aggregated is aggregated to obtain the order amount of the deal from XX time-XX time and the XX area. Further, in order to subsequently and quickly acquire candidate data under a certain aggregation dimension from the candidate data source, the first aggregation result may be stored in a storage location corresponding to the aggregation dimension in the candidate data source, and different storage locations may be represented by different indexes.

In order to better understand the above 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 description is made by way of example with reference to specific examples. For example, referring to fig. 3, the data storage process may be understood as a data processing process, in the offline processing, incremental data in the RMDB service table a and/or the TXT service data B may be captured at regular time based on worker, and since a primary key of the incremental data may embody its attribute information, each incremental data having a primary key matching an aggregation dimension may be aggregated, and a first aggregation result (i.e., a first aggregation result) obtained thereby may be processed into the ES wide table in a unified manner. Accordingly, in online processing, the report configuration system can consume the 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 the ES. In other words, whether online processing or offline processing is performed, the incremental data acquired remotely can be processed according to the aggregation dimension matched with the service requirement, and the processing result falls into the ES broad table according to different aggregation dimensions, so that the candidate data source is updated. Further, when the target data source is selected, the data to be aggregated in the target data source (i.e. a certain ES wide table) may be aggregated based on a pre-configured data aggregation policy associated with the configuration object, thereby achieving the effect of secondary aggregation.

EXAMPLE III

Fig. 4 is a flowchart of a report configuration method provided in the third embodiment of the present invention. The present embodiment is optimized based on the above technical solutions. In this embodiment, optionally, the report identifier includes an index identifier and a dimension identifier, and receiving a report triggering operation on the report identifier, and performing data reading in the target data source by using a data reading policy corresponding to the report triggering operation may include: receiving an index triggering operation on an index identifier and a dimension triggering operation on a dimension identifier, and reading data in a target data source by using a data reading strategy corresponding to the index triggering operation and the dimension triggering operation; and/or the report mark comprises a report display mark, and after the configured report is obtained based on the reading result, the report configuration method further comprises the following steps: receiving a display triggering operation of the report display identifier, and displaying the configured report by using a report display strategy corresponding to the display triggering operation; and/or the report identifier includes a report comparison identifier, and after the configured report is obtained based on the reading result, the report configuration method may further include: and receiving comparison triggering operation of the report comparison identifier, determining the report to be compared in each configured report according to the report comparison strategy corresponding to the comparison triggering operation, and displaying each report to be compared on the same report configuration interface. The same or corresponding terms as those in the above embodiments are not explained in detail herein.

Referring to fig. 4, the method of this embodiment may specifically include the following steps:

s310, when a configuration trigger event of report configuration is monitored, acquiring a configuration object corresponding to the configuration trigger event, and displaying data source identifications of candidate data sources related to the configuration object.

S320, receiving data source triggering operation of the data source identification, taking the candidate data source corresponding to the data source triggering operation as a target data source, and displaying the report identification associated with the target data source.

S330, the report mark comprises an index mark and a dimension mark, and the index triggering operation of the index mark and the dimension triggering operation of the dimension mark are received; reading data in a target data source by using a data reading strategy corresponding to the index triggering operation and the dimension triggering operation; and obtaining a configured report based on the reading result.

The dimension identification can show data analysis results under the dimensions of the configured report, such as data analysis results under dimensions of space dimension, time dimension, article dimension and the like; the index mark can show the data analysis result under what index the configured report is, such as the data analysis result under the index of order transaction amount, order return amount, and the like. The index triggering operation may be a triggering operation received by the report configuration system and acting on at least one of the index identifiers, and the dimension triggering operation may be a triggering operation received by the report configuration system and acting on at least one of the dimension identifiers. And reading data in the target data source based on the data reading strategies corresponding to the index triggering operation and the dimension triggering operation, namely reading the target data under the index corresponding to the index triggering operation and the dimension corresponding to the dimension triggering operation from the target data source.

And S340, the report mark comprises a report display mark, the display triggering operation of the report display mark is received, and the configured report is displayed by the report display strategy corresponding to the display triggering operation.

The report display identifier may be used to indicate a display mode of the configured report, such as a histogram, a pie chart, or the like, and the display triggering operation may be a triggering operation that is received by the report configuration system and acts on at least one report display identifier in each report display identifier. The report display policy corresponding to the display trigger operation may also be understood as a report display policy corresponding to the report display identifier, and since the configured report may represent the data analysis result in what dimension and what index, the specific display manner of the data analysis result may be determined by the report display policy, that is, the configured report may be displayed based on the report display policy.

And S350, the report mark comprises a report comparison mark, the comparison triggering operation of the report comparison mark is received, the report to be compared in each configured report is determined according to the report comparison strategy corresponding to the comparison triggering operation, and each report to be compared is displayed on the same report configuration interface.

The report comparison identifier may be used to indicate which configured reports are to be displayed in a comparison manner, and the comparison triggering operation may be a triggering operation received by the report configuration system and acting on at least one report comparison identifier in the report comparison identifiers. The report comparison strategy corresponding to the comparison triggering operation can be understood as a report comparison strategy corresponding to the report comparison identifier, the report to be compared can be determined from the configured reports based on the report comparison strategy, the reports to be compared are 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 simultaneously browse the reports to be compared from the report configuration interface. For example, assuming that the report comparison flag is a flag for comparing a first report with the amount of order committed in the current month with a second report with the amount of order committed in the previous month, the first report and the second report may be determined from the configured reports based on the corresponding report comparison policy, and the first report and the second report may be displayed on the same report configuration interface.

It should be noted that, for the report configuration method according to the embodiment of the present invention, at least one of S330-S330 may be optionally executed, for example, after the configured report is obtained in S330, the process is ended; for example, after the configured report is obtained in S330, the configured report may be displayed based on S340, and the process is ended; for example, after the configured report is obtained in S330, the report to be compared may be displayed based on S350, and the process is ended; etc., and are not specifically limited herein.

According to the technical scheme of the embodiment of the invention, data reading is carried out in a target data source by using a data reading strategy corresponding to the received index triggering operation on the index identification and the received dimension triggering operation on the dimension identification, so that target data matched with the required index and dimension are obtained; and/or the report mark comprises a report display mark, the display trigger operation of the report display mark is received, and the configured report is displayed by the report display strategy corresponding to the display trigger operation, so that the effect of configuring the display mode of the configured report is realized; and/or the report mark comprises a report comparison mark, the comparison triggering operation of the report comparison mark is received, the report to be compared in each configured report is determined according to the report comparison strategy corresponding to the comparison triggering operation, and each report to be compared is displayed on the same report configuration interface, so that the effect of configuring the display content of the report configuration interface is realized.

In order to better understand the specific implementation process of the above steps, the following describes an exemplary report configuration method according to this embodiment with reference to specific examples. Illustratively, as shown in fig. 5, the business department where the configuration object is located is called a tenant, and the tenant can understand that the configured report needs to be displayed by the report configuration system and applied to the business system. On this basis, when monitoring a join trigger event for a tenant to join, the report configuration system can perform auditing on the tenant, and acquire data acquisition information (such as an account password) of the data storage device submitted by the tenant after the auditing is passed. The report configuration system creates an index of an ES wide table of a tenant through service requirements provided by the tenant, wherein the index is the index of the ES wide table corresponding to the tenant, acquires incremental data from a data storage device by means of data acquisition information based on a published data processing task, aggregates the incremental data, and stores a first aggregation result obtained by the aggregation into the ES wide table. Further, when an addition trigger event added by the monitored user role is detected, the report configuration system acquires the user corresponding to the addition trigger event and the role of the user, wherein the user is an object in the tenant, and the role is the authority of the object, for example, some objects are configuration objects with report configuration authority, some objects are display objects with report display authority, and the like.

Further, the data source, the configuration index, the configuration report and the configuration panel (namely a report configuration interface) are sequentially selected according to the sequentially received data source triggering operation, index triggering operation, display triggering operation and comparison triggering operation. In addition, the visible authority and the data open interface (namely, the interface to be called) of the panel can be configured according to the sequentially received authority triggering operation and interface triggering operation, and the interface to be called can be a report configuration interface and/or a report display interface, so that an object with corresponding authority can browse the panel and a business system with corresponding authority can call the data open interface to realize a report configuration function and a report display function. According to the technical scheme, after the user drags the index label and the dimension label on the report configuration interface, the report configuration system can generate the configured report based on the target data corresponding to the index label and the dimension label. The report configuration system supports multi-tenant, multi-user and multi-role, data isolation and function isolation, and enables the tenant to manage users and roles under the tenant and authority control of a data open interface to which the tenant belongs.

Example four

Fig. 6 is a flowchart of a report configuration method provided in the fourth embodiment of the present invention. The present embodiment is optimized based on the above technical solutions. In this embodiment, optionally, the report configuration method may further include: when a display trigger event of report display is monitored, reading data to be displayed from a target data source at the trigger moment of the display trigger event based on a data reading strategy; and generating a report to be displayed based on the read data to be displayed, and displaying the report to be displayed. The same or corresponding terms as those in the above embodiments are not explained in detail herein.

Referring to fig. 6, the method of this embodiment may specifically include the following steps:

s410, when a configuration trigger event of report configuration is monitored, acquiring a configuration object corresponding to the configuration trigger event, and displaying data source identifications of candidate data sources related to the configuration object.

And S420, receiving data source triggering operation of the data source identification, taking the candidate data source corresponding to the data source triggering operation as a target data source, and displaying the report identification associated with the target data source.

S430, receiving report triggering operation of the report identification, reading data in the target data source by using a data reading strategy corresponding to the report triggering operation, and obtaining a configured report based on a reading result.

S440, when a display trigger event of the report display is monitored, reading data to be displayed from a target data source at the trigger moment of the display trigger event based on a data reading strategy.

The display triggering event may be an event triggered by a display object and used for displaying a configured report, for example, an event triggered when the display object touches a report display identifier in a report configuration system, an event triggered when the display object calls a report display interface in the report configuration system through a business system, and the like, where the display object may be a user with report display permission in a business department in which a report display requirement exists in a business system, or may be a user with report display permission in the report configuration system.

The triggering time is a time when the display triggering event is triggered, and since the target data source may be continuously updated, in order to ensure timeliness of the configured report displayed to the display object, the target data source at the triggering time may be acquired, and the data to be displayed is read from the target data source based on the data reading policy obtained in the configuration manner.

And S450, generating a report to be displayed based on the read data to be displayed, and displaying the report to be displayed.

And generating a report to be displayed based on the read data to be displayed, and displaying the report to be displayed. In practical application, optionally, the report to be displayed can be displayed based on the report display policy obtained in the configuration mode, and the corresponding report to be displayed can also be displayed on the same report configuration interface based on the report comparison policy. Optionally, when the report to be displayed is displayed, the object right of the display object corresponding to the display trigger event can be acquired, and whether an interface to be called corresponding to the display object exists or not is judged according to the object right; and if so, acquiring a service system in communication connection with the interface to be called, and sending the report to be displayed to the service system based on the interface to be called so that the service system displays the received report to be displayed. The reason for the setting is that some display objects have the requirement of directly displaying the report to be displayed on the business system where the display objects are located, so that the display objects do not need to log in the report configuration system, and the report to be displayed can be browsed only in the business system where the display objects frequently log in, and therefore the operation convenience is improved. That is, the report configuration system may provide an interface to be called, so as to provide query service for the business system through the calling interface.

According to the technical scheme of the embodiment of the invention, the data to be displayed is read from the target data source at the trigger moment of the display trigger event displayed by the report form through the data reading strategy, and the report form to be displayed generated based on the read data to be displayed is displayed, so that the effect of displaying the report form to be displayed meeting the display requirement is achieved.

In order to better understand the specific implementation process of the above steps, the following describes an exemplary structure of the report configuring system for executing the report configuring method according to this embodiment with reference to a specific example. For example, as shown in fig. 7a, the report configuration system may support services derived from data storage devices, such as service data derived from a remote file server, a relational database, a search device, and the like, access the service data through data acquisition information provided when the service system accesses the report configuration system, perform secondary incremental processing on the accessed service data according to service requirements, and place the processed data in an ES cluster according to different dimensions. In addition, the report configuration system may also provide different data source interfaces (DataProvider, i.e. interfaces to be called, such as the data provider in fig. 7 a) for the rest of service systems to call through the unified interface adaptation. The report configuration system can also perform data set configuration according to the target data source selected by the configuration object, and read corresponding target data from the target data source according to the ES aggregation function SQL according to the indexes and dimensions selected by the configuration object. Particularly, the report configuration system can support multi-tenant, multi-user and multi-role, and the tenant can manage users and roles under the tenant, so that the effects of data isolation and function isolation are achieved. The report configuration system realizes complete configurability of report graphical display, developers only need to pay attention to business logic and data extraction processing broad lists, and then configured reports can be generated dynamically by dragging and dragging indexes and dimensions of users with configuration permission in received tenants on a report configuration page, and the reports to be compared can be integrated on a panel to be authorized uniformly to users with corresponding permission for query.

As shown in fig. 7b, the report configuration system may include the following functions: and (3) access management: when the tenant applies for adding into the report configuration system, the report configuration system checks the tenant and checks the service data; and (3) user roles: setting of roles (namely permissions) of users in the tenants by the tenants; data source management: the report configures a candidate data source where the required candidate data is located; and (3) processing task management: processing each service data off-line or on-line, which may include a currently processed task and a historically processed task; and (3) report configuration management: configuring various indexes and dimensions; panel management: the set of the reports to be compared shows the comparison between at least two reports to be compared; data set management: and aggregating the service data to generate data sets with different dimensions and under different indexes.

EXAMPLE five

Fig. 8 is a block diagram of a report configuring apparatus according to a fifth embodiment of the present invention, where the apparatus is configured to execute a report configuring method according to any of the embodiments. The device and the report configuration method of each embodiment belong to the same inventive concept, and details which are not described in detail in the embodiment of the report configuration device can refer to the embodiment of the report configuration method. Referring to fig. 8, the apparatus may specifically include: a data source identification display module 510, a report identification display module 520, and a report configuration module 530.

The data source identifier display module 510 is configured to, when a configuration trigger event of report configuration is monitored, obtain a configuration object corresponding to the configuration trigger event, and display data source identifiers of candidate data sources associated with the configuration object;

a report identifier display module 520, configured to 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;

the report configuration module 530 is configured to receive a report triggering operation on the report identifier, perform data reading in the target data source according to a data reading policy corresponding to the report triggering operation, and obtain a configured report based on a reading result.

Optionally, on the basis of the above apparatus, the apparatus may further include:

the data acquisition information acquisition module is used for acquiring data storage equipment corresponding to the candidate data source and data acquisition information of the configuration object aiming at the data storage equipment;

the incremental data acquisition module is used for acquiring incremental data from the data storage equipment at regular time based on a preset time interval by taking the data acquisition information as a data acquisition basis, and/or acquiring incremental data corresponding to a message change event from a preset message queue;

and the data source updating module is used for storing the incremental data into the candidate data source so as to update the candidate data source.

On this basis, optionally, the data source updating module may specifically include:

the aggregation dimension acquisition module is used for respectively acquiring the attribute information of each incremental data and the preset aggregation dimension; the data first aggregation module is used for determining data to be aggregated which meet aggregation dimensionality from the incremental data according to the attribute information, and aggregating the data to be aggregated to obtain a first aggregation result; and the data storage module is used for storing the first aggregation result to a storage position corresponding to the aggregation dimension in the candidate data source.

Optionally, the report configuration module may further include:

the data re-aggregation module is used for acquiring a data aggregation strategy associated with the configuration object after the candidate data source corresponding to the data source triggering operation is taken as the target data source, and aggregating the data to be aggregated in the target data source based on the data aggregation strategy to obtain a second aggregation result; updating the target data source based on the second aggregation result.

Optionally, the report identifier includes an index identifier and a dimension identifier, and the report configuration module 530 specifically includes:

the operation receiving unit is used for receiving index triggering operation on the index identifier and dimension triggering operation on the dimension identifier; the reading result updating unit is used for reading data in the target data source according to a data reading strategy corresponding to the index triggering operation and the dimension triggering operation;

and/or the report mark comprises a report display mark, and the report configuration module can further comprise:

the first report display module is used for receiving display triggering operation of the report display identifier after the configured report is obtained based on the reading result, and displaying the configured report by using a report display strategy corresponding to the display triggering operation;

and/or the report identifier comprises a report comparison identifier, and the report configuration module may further comprise:

and the second report display module is used for receiving comparison triggering operation of the report comparison identifier after the configured report is obtained based on the reading result, determining the report to be compared in each configured report according to the report comparison strategy corresponding to the comparison triggering operation, and displaying each report to be compared on the same report configuration interface.

Optionally, the report configuration module may further include:

the data reading module is used for reading data to be displayed from a target data source at the triggering moment of the display triggering event based on a data reading strategy when the display triggering event of the report display is monitored;

and the third report display module is used for generating a report to be displayed based on the read data to be displayed and displaying the report to be displayed.

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

the interface judging unit is used for acquiring the object authority of the display object corresponding to the display trigger event and judging whether an interface to be called corresponding to the display object exists or not according to the object authority;

and the third report display unit is used for acquiring the service system associated with the interface to be called if the report is received, and sending the report to be displayed to the service system based on the interface to be called so that the service system displays the received report to be displayed.

In the report configuration apparatus provided in the fifth embodiment of the present invention, the data source identifier display module may obtain the configuration object corresponding to the monitored configuration trigger event of the report configuration, and may display the data source identifier of each candidate data source associated with the configuration object, so that the configuration object may determine the candidate data source that may be selected by itself from the displayed data source identifiers; the report identifier display module receives data source triggering operation of the data source identifier, takes a candidate data source corresponding to the data source triggering operation as a target data source, and displays a report identifier associated with the target data source so that the configuration object can determine which report attributes the configured report which can be configured based on the selected target data source has from the displayed report identifier; and the report configuration module receives report triggering operation of the report identification, reads data in the target data source by using a data reading strategy corresponding to the report triggering operation, and obtains a configured report corresponding to the configuration of the configuration object based on a reading result. The device can configure the configured report meeting the business requirements of the configuration object according to the received trigger operation acting on the corresponding identifier, and simplifies the report configuration process in a configuration mode, so that the effect of automatically, quickly and conveniently configuring the configured report matched with the configuration object is achieved.

The report configuration device provided by the embodiment of the invention can execute the report configuration method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the execution method.

It should be noted that, in the embodiment of the report configuration apparatus, the units and modules included in the embodiment are only divided according to functional logic, but are not limited to the above division, as long as the corresponding functions can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present invention.

EXAMPLE six

Fig. 9 is a schematic structural diagram of a report configuring system according to a sixth embodiment of the present invention, and as shown in fig. 9, the report configuring system includes a memory 610, a processor 620, an input device 630, and an output device 640. The number of the processors 620 in the report configuration system can be one or more, and one processor 620 is taken as an example in fig. 9; the memory 610, the processor 620, the input device 630 and the output device 640 in the report configuration system may be connected through a bus or other means, and fig. 9 is exemplified by being connected through the bus 650.

The memory 610 is used as a computer-readable storage medium for storing software programs, computer-executable programs, and modules, such as program instructions/modules corresponding to the report configuring method in the embodiment of the present invention (for example, the data source identifier display module 510, the report identifier display module 520, and the report configuring module 530 in the report configuring apparatus). The processor 620 executes various functional applications and data processing of the report configuration system by running software programs, instructions and modules stored in the memory 610, so as to implement the report configuration method described above.

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, an application program required for at least one function; the storage data area may store data created from use of the report configuration system, and the like. Further, the memory 610 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device. In some examples, memory 610 may further include memory located remotely from processor 620, which may be connected to devices through a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.

The input device 630 may be used to receive input numeric or character information and generate key signal inputs related to user settings and function controls of the device. The output device 640 may include a display device such as a display screen.

EXAMPLE seven

The seventh embodiment of the present invention provides a storage medium containing computer-executable instructions, where the computer-executable instructions are used for executing a report configuration method when executed by a computer processor, and the method includes:

Of course, the storage medium containing the computer-executable instructions provided in the embodiments of the present invention is not limited to the above-described method operations, and may also perform related operations in the report configuration method provided in any embodiment of the present invention.

From the above description of the embodiments, it is obvious for those skilled in the art that the present invention can be implemented by software and necessary general hardware, and certainly, can also be implemented by hardware, but the former is a better embodiment in many cases. With this understanding, the technical solutions of the present invention may be embodied in the form of a software product, which can be stored in a computer-readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, and includes instructions for enabling a computer device (which may be a personal computer, a server, or a network device) to execute the methods according to the embodiments of the present invention.

It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit 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 is characterized by comprising the following steps:

when a configuration trigger event of report configuration is monitored, acquiring a configuration object corresponding to the configuration trigger event, and displaying data source identifications of candidate data sources associated with the configuration object;

receiving a data source triggering operation for the data source identification, taking the candidate data source corresponding to the data source triggering operation as a target data source, and displaying a report identification associated with the target data source;

2. The method of claim 1, wherein each of the candidate data sources is updated by:

acquiring data storage equipment corresponding to the candidate data source and data acquisition information of the configuration object aiming at the data storage equipment;

taking the data acquisition information as a data acquisition basis, acquiring incremental data from the data storage device at regular time based on a preset time interval, and/or acquiring the incremental data corresponding to a message change event from a preset message queue;

storing the incremental data into the candidate data source to update the candidate data source.

3. The method of claim 2, wherein storing the delta data into the candidate data source comprises:

respectively acquiring attribute information of each incremental data and a preset aggregation dimension;

determining to-be-aggregated data meeting the aggregation dimensionality from the incremental data according to the attribute information, and aggregating the to-be-aggregated data to obtain a first aggregation result;

and storing the first aggregation result to a storage position corresponding to the aggregation dimension in the candidate data source.

4. The method according to claim 1, further comprising, after the taking the candidate data source corresponding to the data source trigger operation as a target data source:

acquiring a 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 to obtain a second aggregation result;

updating the target data source based on the second aggregation result.

5. The method according to claim 1, wherein the report identifier includes an index identifier and a dimension identifier, and the receiving a report trigger operation on the report identifier to perform data reading in the target data source according to a data reading policy corresponding to the report trigger operation includes:

receiving an index triggering operation on the index identifier and a dimension triggering operation on the dimension identifier, and reading data in the target data source by using a data reading strategy corresponding to the index triggering operation and the dimension triggering operation;

and/or the report mark comprises a report display mark, and after the configured report is obtained based on the reading result, the method further comprises the following steps:

receiving a display triggering operation on the report display identifier, and displaying the configured report by using a report display strategy corresponding to the display triggering operation;

and/or the report mark comprises a report comparison mark, and after the configured report is obtained based on the reading result, the method further comprises the following steps:

and receiving comparison triggering operation of the report comparison identifier, determining the report to be compared in each configured report by using a report comparison strategy corresponding to the comparison triggering operation, and displaying each report to be compared on the same report configuration interface.

6. The method of claim 1, further comprising:

when a display trigger event of report display is monitored, reading data to be displayed from the target data source at the trigger moment of the display trigger event based on the data reading strategy;

and generating a report to be displayed based on the read data to be displayed, and displaying the report to be displayed.

7. The method according to claim 6, wherein the displaying the report to be displayed comprises:

acquiring the object authority of a display object corresponding to the display trigger event, and judging whether an interface to be called corresponding to the display object exists according to the object authority;

if so, acquiring a service system associated with the interface to be called, and sending the report to be displayed to the service system based on the interface to be called so that the service system displays the received report to be displayed.

8. A report configuring apparatus, comprising:

the data source identification display module is used for acquiring a configuration object corresponding to a configuration trigger event when the configuration trigger event of report configuration is monitored, and displaying the data source identification of each candidate data source related to the configuration object;

the report identifier display module is used for receiving data source triggering operation of the data source identifier, taking the candidate data source corresponding to the data source triggering operation as a target data source and displaying the report identifier associated with the target data source;

9. A report configuration system, comprising:

one or more processors;

a memory for storing one or more programs;

when executed by the one or more processors, cause the one or more processors to implement the report configuration method of any of claims 1-7.

10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the report configuring method according to any one of claims 1-7.