Report generation method and device based on business intelligence BI tool
By deploying business intelligence (BI) tools on the data service provider to acquire and process target data to generate reports, the problem of clients having to generate reports themselves is solved, enabling clients to view and edit reports synchronously, thus saving resources.
Patent Information
- Application Number
- CN202410995038.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-23
- Publication Date
- 2024-11-08
AI Technical Summary
In existing technologies, business intelligence (BI) tools are deployed on the client's side, which requires the client to spend additional manpower and resources to generate reports.
BI tools are deployed on the data service provider to acquire target data, store it in an isolated database, process the data, generate report data, and display it on the client through a visual editor.
This allows clients to edit and upload their data reports on the data service provider's end, enabling clients to view and use them synchronously, thus avoiding additional manpower and material costs and saving resources.
Smart Images

Figure CN118917285A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of big data technology, and in particular to a report generation method and device based on a business intelligence (BI) tool. Background Art
[0002] In big data applications, data visualization is an important means to ultimately present the value of data. After big data applications collect, store, and process data, and transform the data into data indicators that can guide the business, they need to use data visualization tools to display different business goals, stage results, etc. through a variety of charts.
[0003] In related technologies, when different business goals and stage results are displayed with the help of visualization tools, such as BI (Business Intelligence) tools, the visualization tools are mostly deployed on the client side. Therefore, the client side needs to spend additional manpower and material resources to use the visualization tools to generate reports. Summary of the invention
[0004] The present invention aims to solve one of the technical problems in the related art at least to a certain extent.
[0005] To this end, the first purpose of the present invention is to propose a report generation method based on a business intelligence (BI) tool, so that the BI tool is deployed on the data service side, that is, the party providing data services, rather than on the client side, so that the client's data report can be edited and put online on the data service side, and the client can view and use it simultaneously, thereby solving the technical problem in the related technology that the BI tool is deployed on the client side and the client needs to spend additional manpower and material resources to use visualization tools to generate reports.
[0006] The second objective of the present invention is to provide a report generation device based on business intelligence (BI) tools.
[0007] A third objective of the present invention is to provide an electronic device.
[0008] A fourth object of the present invention is to provide a computer-readable storage medium.
[0009] A fifth object of the present invention is to provide a computer program product.
[0010] To achieve the above-mentioned purpose, a first aspect of the present invention provides a report generation method based on a business intelligence (BI) tool, wherein the BI tool is deployed on a data service provider, and the method includes:
[0011] Acquire target data for generating a first report, and store the target data in an isolation repository;
[0012] According to preset business requirements, the target data in the isolation database is processed to obtain first report data;
[0013] In response to the visual editing operation performed on the first report data by the BI tool, the first report is generated and displayed on the target client.
[0014] Optionally, as a first possible implementation manner of the first aspect, in response to the visual editing operation performed on the first report data by the BI tool, generating and displaying the first report on the target client includes:
[0015] In response to a visual editing operation performed on the first report data by a visual editor in the BI tool, generating the first report;
[0016] The first report is synchronized to the target client through the rendering container in the BI tool, so as to display the first report on the target client.
[0017] Optionally, as a second possible implementation manner of the first aspect, the method further includes:
[0018] In response to a modification visual editing operation performed on any second report through the BI tool, the second report is regenerated and re-displayed on the target client, wherein the second report is a report that has been displayed on the target client.
[0019] Optionally, as a third possible implementation manner of the first aspect, the second report has version information, and in response to a modification visual editing operation performed on any second report by the BI tool, regenerating and re-displaying the second report on the target client includes:
[0020] In response to a modification visual editing operation performed on any first version of the second report through a visual editor in the BI tool, generating a second version of the second report;
[0021] The second version of the second report is synchronized to the target client through the rendering container in the BI tool, so as to replace the first version of the second report with the second version of the second report in the target client.
[0022] Optionally, as a fourth possible implementation manner of the first aspect, in response to the visual editing operation performed on the first report data by the BI tool, before generating and displaying the first report on the target client, further includes:
[0023] The first report data is obtained from the isolated library through the BI tool.
[0024] Optionally, as a fifth possible implementation manner of the first aspect, the obtaining the first report data from the isolated library by using the BI tool includes:
[0025] The first report data is obtained from the isolated library through a data layer in the BI tool, wherein the data layer is connected to the isolated library.
[0026] Optionally, as a sixth possible implementation of the first aspect, the BI tool includes a data layer, an interface layer, a visual editor and an application layer, wherein the visual editor includes a chart component library, a function library, an instrument production and visualization platform;
[0027] The first report has version information.
[0028] To achieve the above-mentioned purpose, a second embodiment of the present invention proposes a report generation device based on a business intelligence (BI) tool, wherein the BI tool is deployed on a data service provider, and the device comprises:
[0029] A first processing module, used for acquiring target data for generating a first report, and storing the target data in an isolation repository;
[0030] A data processing module, used for processing the target data in the isolation database according to preset business requirements to obtain first report data;
[0031] The second processing module is used to generate and display the first report on the target client in response to the visual editing operation performed on the first report data by the BI tool.
[0032] Optionally, as a first possible implementation manner of the second aspect, the second processing module is further configured to:
[0033] In response to a visual editing operation performed on the first report data by a visual editor in the BI tool, generating the first report;
[0034] The first report is synchronized to the target client through the rendering container in the BI tool, so as to display the first report on the target client.
[0035] Optionally, as a second possible implementation manner of the second aspect, the apparatus further includes:
[0036] The third processing module is used to regenerate and re-display the second report on the target client in response to a modification visual editing operation performed on any second report through the BI tool, wherein the second report is a report that has been displayed on the target client.
[0037] Optionally, as a third possible implementation manner of the second aspect, the second report has version information, and the third processing module is further used to:
[0038] In response to a modification visual editing operation performed on any first version of the second report through a visual editor in the BI tool, generating a second version of the second report;
[0039] The second version of the second report is synchronized to the target client through the rendering container in the BI tool, so as to replace the first version of the second report with the second version of the second report in the target client.
[0040] Optionally, as a fourth possible implementation manner of the second aspect, the apparatus further includes:
[0041] An acquisition module is used to acquire the first report data from the isolated library through the BI tool.
[0042] Optionally, as a fifth possible implementation manner of the second aspect, the acquisition module is further used to:
[0043] The first report data is obtained from the isolated library through a data layer in the BI tool, wherein the data layer is connected to the isolated library.
[0044] Optionally, as a sixth possible implementation of the second aspect, the BI tool includes a data layer, an interface layer, a visual editor and an application layer, wherein the visual editor includes a chart component library, a function library, an instrument production and visualization platform;
[0045] The first report has version information.
[0046] To achieve the above object, a third aspect of the present invention provides an electronic device, including:
[0047] at least one processor; and
[0048] a memory communicatively connected to the at least one processor; wherein,
[0049] The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to execute the report generation method based on the business intelligence (BI) tool of the first aspect.
[0050] In order to achieve the above objectives, the fourth aspect of the present invention proposes a computer-readable storage medium storing computer instructions, wherein the computer instructions are used to enable the computer to execute the report generation method based on business intelligence (BI) tools of the first aspect.
[0051] In order to achieve the above-mentioned purpose, a fifth aspect of the present invention proposes a computer program product, including a computer program, which, when executed by a processor, implements the report generation method based on a business intelligence (BI) tool of the first aspect.
[0052] The technical solution provided by the embodiment of the present invention has the following beneficial effects:
[0053] By acquiring the target data for generating the first report and storing the target data in the isolated library, data processing is performed on the target data in the isolated library according to preset business requirements to obtain the first report data, thereby generating and displaying the first report on the target client in response to the visual editing operation performed on the first report data through the BI tool. Therefore, by deploying the BI tool on the data service side, that is, the party providing data services, rather than on the client side, the client's data report can be edited and put online on the data service side, and the client can view and use it simultaneously, avoiding the client's consumption of additional manpower and material resources to use visualization tools to generate reports, greatly saving the client's resources.
[0054] Additional aspects and advantages of the present invention will be given in part in the following description and in part will be obvious from the following description, or will be learned through practice of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS
[0055] The above and / or additional aspects and advantages of the present invention will become apparent and easily understood from the following description of the embodiments in conjunction with the accompanying drawings, in which:
[0056] Figure 1 A flowchart of a report generation method based on a business intelligence (BI) tool provided in an embodiment of the present invention;
[0057] Figure 2 A schematic diagram of the architecture of a BI tool provided by an embodiment of the present invention;
[0058] Figure 3 A flowchart of another report generation method based on a business intelligence (BI) tool provided in an embodiment of the present invention;
[0059] Figure 4 A flowchart of another report generation method based on a business intelligence (BI) tool provided in an embodiment of the present invention;
[0060] Figure 5 A flowchart of another report generation method based on a business intelligence (BI) tool provided in an embodiment of the present invention;
[0061] Figure 6A schematic diagram of the relationship between a data provider and a client provided in an embodiment of the present invention;
[0062] Figure 7 A flowchart of a report generation method based on a business intelligence (BI) tool in a scenario provided by an embodiment of the present invention;
[0063] Figure 8 A schematic diagram of the structure of a report generation device based on a business intelligence BI tool provided in an embodiment of the present invention;
[0064] Fig. 9 A schematic diagram of the structure of another report generation device based on a business intelligence BI tool provided by an embodiment of the present invention;
[0065] Fig.10 A schematic diagram of the structure of another report generation device based on a business intelligence BI tool provided by an embodiment of the present invention;
[0066] Fig.11 A schematic diagram of the structure of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION
[0067] Embodiments of the present invention are described in detail below, examples of which are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are intended to be used to explain the present invention, and should not be construed as limiting the present invention.
[0068] In view of the technical problem in the related art that BI tools are deployed on the client side and the client side needs to spend extra manpower and material resources to generate reports using visualization tools, the embodiment of the present invention proposes a report generation method based on business intelligence BI tools.
[0069] The following describes a report generation method and device based on a business intelligence (BI) tool according to an embodiment of the present invention with reference to the accompanying drawings.
[0070] Figure 1 A flowchart of a report generation method based on a business intelligence (BI) tool provided in an embodiment of the present invention.
[0071] It should be noted that the report generation method based on the business intelligence BI tool of the embodiment of the present invention can be executed by the report generation device based on the business intelligence BI tool provided by the embodiment of the present invention. The report generation device based on the business intelligence BI tool can be an electronic device, and can also be configured in an electronic device, so as to deploy the BI tool on the data service side, that is, the party providing data services, instead of on the client side, so that the data report of the client side can be edited and put online on the data service side, and the client side can view and use it synchronously, so as to solve the technical problem in the related technology that the BI tool is deployed on the client side, and the client side needs to spend extra manpower and material resources to use the visualization tool to generate reports.
[0072] Among them, the electronic device can be any stationary or mobile computing device capable of data processing, such as mobile computing devices such as laptops, smart phones, wearable devices, or stationary computing devices such as desktop computers, or servers, or other types of computing devices, etc., which are not limited in this embodiment.
[0073] like Figure 1 As shown, the report generation method based on the business intelligence BI tool includes the following steps:
[0074] Step 101, obtaining target data for generating a first report, and storing the target data in an isolation library.
[0075] It should be noted that the BI tool of this embodiment is deployed on the data service provider, that is, the party providing data services, rather than on the client side. Optionally, the data service provider may include one or more systems, or one or more applications, which is not limited in this embodiment.
[0076] In this embodiment, the target data is data used to generate the first report. Optionally, the target data can be any data, such as business data.
[0077] In this embodiment, the isolation library is used to store target data. Optionally, the isolation library can be any database, such as MySQL database, SqlServe database, etc.
[0078] In this embodiment, the report generation device based on the business intelligence BI tool can obtain the target data through various open, legal and compliant methods. For example, the report generation device based on the business intelligence BI tool can collect the target data in real time, or it can also obtain the target data from other devices through network transmission or physical copying, or it can also obtain the data to be stored through other open, legal and compliant methods. This is not limited in this embodiment.
[0079] In a possible implementation of this embodiment, the target data is stored in the client's database, so that a report generation device based on a business intelligence (BI) tool can obtain the target data for generating a first report from the client's database and store the target data in an isolated library. This can prevent the BI tool deployed on the data service provider from directly connecting to the client's database and affecting the customer data.
[0080] Step 102: Process the target data in the isolation database according to preset business requirements to obtain first report data.
[0081] In this embodiment, the preset business demand is determined based on the business demand of the client. For example, when the client needs to calculate the number of daily active users of an application within a certain period of time, the preset business demand is to count the number of active users of the application every day during this period of time.
[0082] In this embodiment, the isolation library is used not only to store the target data but also to store the first report data obtained by processing the target data.
[0083] In this embodiment, after acquiring the target data, since the target data does not meet the business requirements at this time, it is necessary to process the target data in the isolated library according to the preset business requirements to obtain the first report data. Optionally, data processing may include data extraction, data conversion, data calculation, etc. Among them, data extraction can be understood as the integration and processing of existing data fields in the isolated library to form new fields required by the preset business requirements, which may include field splitting, field merging, etc.; data conversion mainly refers to converting data into a standardized, clear, and easy-to-analyze structure, which may include data structure conversion, row and column conversion, etc.; data calculation refers to the calculation of the data in the isolated library, which may include simple calculations, date and time data calculations, etc.
[0084] The above-mentioned field splitting means splitting a field into two or more fields in order to intercept part of the information in a field. For example, assuming that the product information field includes product model, channel and price, the product information field can be split into product model field, channel field and price field; field merging means combining several fields into a new field, or combining field values with text, numbers, etc. to form a new field; data structure conversion mainly refers to the conversion between one-dimensional data tables and two-dimensional data tables. For example, the following Table 1 is an example Table 1 of the average scores of each subject in the class, which is a one-dimensional data table, and Table 2 is an example Table 2 of the average scores of each subject in the class, which is a two-dimensional data table corresponding to Table 1:
[0085] Table 1 Example of average scores of each subject in the class Table 1
[0086] class suject Average Grade Class 1 Language 82 Class 1 math 75 Class 2 Language 81 Class 2 math 85 Class 3 Language 77 Class 3 math 80
[0087] Table 2 Example of average scores of each subject in the class Table 2
[0088] class Average score in Chinese Average score in mathematics Class 1 82 75 Class 2 81 85 Class 3 77 80
[0089] Row and column conversion mainly refers to the observation of data from different dimensions when conducting data analysis reports, such as viewing summary data from the dimension of time, or viewing summary data from the dimension of region. At this time, it is necessary to convert row and column data (also known as transposition); simple calculation refers to adding, subtracting, multiplying, dividing and other operations on data values and generating new fields, for example, calculating actual wages based on basic salary, seniority salary, position salary, social insurance, etc.; date and time data calculation mainly refers to the management and analysis of date and time data that is often involved in enterprise management. At this time, it is necessary to perform simple calculations on date and time data, for example, using the current date and entry date to calculate employee seniority.
[0090] Step 103 : In response to the visual editing operation performed on the first report data by the BI tool, a first report is generated and displayed on the target client.
[0091] In this embodiment, the BI tool is deployed on the data service provider and may include a data layer, an interface layer, a visual editor, and an application layer, wherein the visual editor includes a chart component library, a function library, an instrument production and a visualization platform, which is used to generate visual reports based on report data.
[0092] It should be noted that the data access method of the BI tool in this embodiment is different from the data access method of the visualization tool in the related art. In the related art, the BI tool is deployed on the client side. Taking Fine BI as an example, its usage scenario is internal use on the client side, and the database connection method is simpler, that is, directly connecting to the client's internal database to obtain data. The database and the BI tool are both inside the client side. In the present invention, the data service provider provides data services to the client side, and the BI tool is deployed on the data service provider for use, but it needs to connect to an external database to obtain customer data. In this case, the BI tool is required to have the ability to connect to multiple external databases and obtain data.
[0093] It should be noted that the data report online method of the BI tool in this embodiment is different from the data report online method of the visualization tool in the related art. In the related art, the BI tool is deployed on the client side. Taking Fine BI as an example, after the client obtains data internally, it can directly generate reports for use in the client's internal environment. In the present invention, the BI tool is deployed on the data service side. The data service provided by the data service side is that after the client privatizes the data platform of the data service side, the data service side develops and launches customer data reports through BI tools. In this case, the BI tool is required to have the ability to visualize configuration charts and publish in real time.
[0094] In order to clearly illustrate the architecture of the BI tool in the present invention, this embodiment provides the following Figure 2 The following is a diagram of the architecture of the BI tool.
[0095] like Figure 2 As shown in the figure, the BI tool includes a data layer, an interface layer, a visual editor, and an application layer. The data layer includes mysql, redis, and oss; the interface layer includes instrument management, instrument data, instrument configuration management, and a user center; the visual editor includes a chart component library, a function library, instrument production, and a visualization platform; and the application layer includes a rendering container and an APP. As a result, the underlying database of the BI tool can be implemented using mysql, which is cached through redis and oss; the instrument data, instrument management, and instrument configuration management generated by instrument production are placed in the interface layer, and the user center is managed at the interface layer, with different users having different permissions; and the visual editor integrates a chart component library, a function library, and a visualization production function to complete the production of reports at this layer; finally, the report is synchronized to the client through a rendering container to achieve rapid launch.
[0096] In this embodiment, the report generation device based on the business intelligence BI tool can generate a first report and display the first report on the target client in response to the visual editing operation performed on the first report data through the BI tool. Since the BI tool is deployed on the data service side, the data report of the client side can be edited and put online on the data service side, and the client side can view and use it synchronously, which solves the technical problem in the related technology that the BI tool is deployed on the client side and the client side needs to spend extra manpower and material resources to use the visualization tool to generate reports.
[0097] In this embodiment, the generated first report has version information, and optionally, the version information may correspond to a date. For example, assuming that the first report is generated on February 2, 2022, the version information of the first report may be 20220202.
[0098] It should be noted that when the version information corresponds to a date, since multiple reports may be generated on the same day, data-related information can be added to the version information. For example, suppose two reports are generated on February 2, 2022, namely Report 1 and Report 2, where Report 1 summarizes the order data of a certain product and Report 2 counts the number of daily active users of a certain application. Therefore, the version information of Report 1 can be a combination of 20220202 and the SKU (Stock Keeping Unit) information of the product, and the version information of Report 2 can be a combination of 20220202 and the application information and DAU (Daily Active User).
[0099] It should be noted that when the version information corresponds to a date, since the first report that has been generated and displayed on the target client may be modified and edited on the same day, and regenerated and displayed, in addition to adding data-related information to the version information, numbers can also be added for distinction. For example, suppose a report is generated on February 2, 2022, and displayed on the target client, and the version information of the report is 20220202yingyong1DAU, at this time, if the report is modified and edited on this day, the version information of the regenerated report can be 20220202yingyong1DAU-2.
[0100] The report generation method based on the business intelligence BI tool provided in this embodiment obtains the target data for generating the first report and stores the target data in the isolation library, so as to process the target data in the isolation library according to the preset business requirements to obtain the first report data, thereby generating and displaying the first report on the target client in response to the visual editing operation performed on the first report data by the BI tool. Therefore, by deploying the BI tool on the data service party, that is, the party providing data services, rather than on the client side, the client's data report can be edited and put online on the data service party, and the client can view and use it synchronously, avoiding the client's consumption of extra manpower and material resources to use the visualization tool to generate reports, greatly saving the client's resources.
[0101] In order to clearly explain how the present invention generates and displays a first report on a target client in response to a visual editing operation performed on first report data by a BI tool, this embodiment provides another report generation method based on a business intelligence BI tool. Figure 3 A flowchart of another report generation method based on a business intelligence (BI) tool provided in an embodiment of the present invention.
[0102] like Figure 3As shown, the report generation method based on the business intelligence BI tool may include the following steps:
[0103] Step 301, obtaining target data for generating a first report, and storing the target data in an isolation library.
[0104] Step 302: Process the target data in the isolation database according to preset business requirements to obtain first report data.
[0105] It should be noted that the execution process of steps 301-302 can refer to the execution process of steps 101-102 in the previous embodiment, and the principles are the same, which will not be repeated here.
[0106] Step 303: Generate a first report in response to a visual editing operation performed on the first report data by a visual editor in the BI tool.
[0107] In this embodiment, the BI tool is deployed on the data service provider and may include a data layer, an interface layer, a visual editor, and an application layer. The visual editor includes a chart component library, a function library, an instrument production and a visualization platform, which is used to generate a visualization report based on the report data. Figure 2 The architecture diagram of the BI tool shown in the figure, for related descriptions, please refer to the description of step 103 in the previous embodiment, which will not be repeated here.
[0108] In this embodiment, the visual editing operation performed on the first report data may be performed by a visual editor in a BI tool, so that a first report may be generated in response to the visual editing operation performed on the first report data by the visual editor in the BI tool.
[0109] Similarly, in this embodiment, the generated first report also has version information, and optionally, the version information may also correspond to a date. For related descriptions, reference may be made to the description of step 103 in the previous embodiment, which will not be repeated here.
[0110] Step 304: synchronize the first report to the target client through the rendering container in the BI tool to display the first report on the target client.
[0111] In this embodiment, the architecture of the BI tool can be seen in Figure 2 The architectural diagram of the BI tool shown, whereby the application layer in the BI tool includes a rendering container, and the BI tool can synchronize the report to the client through the rendering container. Therefore, in this embodiment, the first report can be synchronized to the target client through the rendering container in the BI tool to display the first report on the target client.
[0112] Since the BI tool of this embodiment is deployed on the data service side instead of the client side, the client's data report can be edited and put online on the data service side, and the client can view and use it simultaneously, avoiding the client's consumption of extra manpower and material resources to use visualization tools to generate reports, thereby greatly saving the client's resources.
[0113] The report generation method based on the business intelligence BI tool provided in this embodiment obtains the target data for generating the first report and stores the target data in the isolation library, so as to process the target data in the isolation library according to the preset business requirements to obtain the first report data, thereby generating the first report in response to the visual editing operation performed on the first report data by the visual editor in the BI tool, and then synchronizing the first report to the target client through the rendering container in the BI tool to display the first report on the target client. In this way, the visual editor in the BI tool can perform the visual editing operation on the first report data to generate the first report, and the generated first report can be synchronized to the target client through the rendering container in the BI tool to display the first report on the target client.
[0114] From the above analysis, it can be seen that the first report data obtained by processing the target data is stored in the isolated library. Therefore, in response to the visual editing operation performed on the first report data by the BI tool, before generating and displaying the first report on the target client, it is necessary to obtain the first report data from the isolated library by the BI tool. In order to clearly explain this process, this embodiment provides another report generation method based on the business intelligence BI tool. Figure 4 A flowchart of another report generation method based on a business intelligence (BI) tool provided in an embodiment of the present invention.
[0115] like Figure 4 As shown, the report generation method based on the business intelligence BI tool may include the following steps:
[0116] Step 401, obtaining target data for generating a first report, and storing the target data in an isolation library.
[0117] Step 402, according to preset business requirements, data processing is performed on the target data in the isolation library to obtain first report data.
[0118] It should be noted that the execution process of steps 401-402 can refer to the execution process of steps 101-102 in the above embodiment, and the principles are the same, which will not be repeated here.
[0119] Step 403: Obtain the first report data from the isolated library through the BI tool.
[0120] In this embodiment, the BI tool is deployed on the data service provider and may include a data layer, an interface layer, a visual editor, and an application layer. The visual editor includes a chart component library, a function library, an instrument production and a visualization platform, which is used to generate a visualization report based on the report data. Figure 2 The architecture diagram of the BI tool shown in the figure, related descriptions can be found in the description of step 103 in the above embodiment, which will not be repeated here.
[0121] In this embodiment, the first report data can be obtained from the isolated library through the BI tool. This requires the BI tool deployed on the data service provider to connect to the isolated library to obtain data from the isolated library. Therefore, the BI tool needs to have the ability to connect to multiple external databases and obtain data.
[0122] In a possible implementation of this embodiment, the first report data may be obtained from the isolated library through a data layer in a BI tool, wherein the data layer in the BI tool is connected to the isolated library.
[0123] Step 404 : generating a first report in response to a visual editing operation performed on the first report data by a visual editor in the BI tool.
[0124] Step 405: synchronize the first report to the target client through the rendering container in the BI tool to display the first report on the target client.
[0125] It should be noted that the execution process of steps 404-405 can refer to the execution process of steps 303-304 in the previous embodiment, and the principles are the same, which will not be repeated here.
[0126] The report generation method based on the business intelligence BI tool provided in this embodiment, after processing the target data in the isolated library according to the preset business requirements to obtain the first report data, can obtain the first report data from the isolated library through the data layer in the BI tool, thereby generating a first report in response to the visual editing operation performed on the first report data through the visual editor in the BI tool, and then synchronizing the first report to the target client through the rendering container in the BI tool to display the first report on the target client. In this way, it is possible to obtain the first report data from the isolated library through the data layer in the BI tool, perform a visual editing operation on the first report data through the visual editor in the BI tool to generate the first report, and synchronize the generated first report to the target client through the rendering container in the BI tool to display the first report on the target client.
[0127] From the above analysis, it can be seen that the first report that has been generated and displayed on the target client can also be modified and edited to regenerate and display. In order to clearly explain this process, this embodiment provides another report generation method based on a business intelligence BI tool. Figure 5 A flowchart of another report generation method based on a business intelligence (BI) tool provided in an embodiment of the present invention.
[0128] like Figure 5 As shown, the report generation method based on the business intelligence BI tool may include the following steps:
[0129] Step 501, obtaining target data for generating a first report, and storing the target data in an isolation library.
[0130] Step 502: Process the target data in the isolation database according to preset business requirements to obtain first report data.
[0131] Step 503 : In response to the visual editing operation performed on the first report data by the BI tool, a first report is generated and displayed on the target client.
[0132] It should be noted that the execution process of steps 501-503 can refer to the execution process of steps 101-103 in the above embodiment, and the principles are the same, which will not be repeated here.
[0133] Step 504 : in response to a modification visual editing operation performed on any second report through the BI tool, regenerate and re-display the second report on the target client.
[0134] In this embodiment, the second report is a report that has been displayed on the target client. It is understandable that since the first report generated and displayed on the target client in response to the visual editing operation performed on the first report data by the BI tool has version information, the second report in this embodiment also has version information.
[0135] In this embodiment, in response to a modification visual editing operation performed on any second report through the BI tool, the second report can be regenerated and re-displayed on the target client. Thus, it is possible to modify and edit the online report through the BI tool, regenerate the report and quickly synchronize it to the target client, so that the client can simultaneously perceive the modification and view the latest data report.
[0136] In a possible implementation of this embodiment, a second version of the second report can be generated in response to a modification visual editing operation performed on any first version of the second report through a visual editor in a BI tool, thereby synchronizing the second version of the second report to a target client through a rendering container in the BI tool, so that the first version of the second report is replaced by the second version of the second report in the target client, thereby displaying the latest version of the second report on the target client.
[0137] The report generation method based on the business intelligence BI tool provided in this embodiment can regenerate and re-display the second report on the target client in response to a modification visual editing operation performed on any second report by the BI tool, and can also regenerate and re-display the second report on the target client in response to a modification visual editing operation performed on any second report by the BI tool. In this way, it is possible to modify and edit the online report by the BI tool, regenerate the report and quickly synchronize it to the target client, so that the client can synchronously perceive the modification and view the latest data report.
[0138] In order to clearly illustrate the relationship between the data service provider and the client in the present invention, this embodiment provides the following Figure 6 The relationship diagram between the data provider and the client is shown in Figure 6 As shown, the data service provider can obtain the target data from the client's database and store it in an isolated library, wherein the target data is used to generate a first report, and then the target data in the isolated library can be processed according to the preset business requirements to obtain the first report data, thereby obtaining the first report data from the isolated library through the BI tool deployed on the data service provider, and generating the first report in response to the visual editing operation performed on the first report data through the BI tool, and synchronizing it to the client of the client. In addition, the data service provider can also modify and edit the report that has been launched on the client's client through the BI tool, and the client's client can perceive the modification synchronously. Therefore, by deploying the BI tool on the data service provider, that is, the party providing data services, instead of on the client side, the data report of the client side can be edited and launched on the data service provider, and the client can view and use it synchronously, avoiding the client from consuming extra manpower and material resources to use visualization tools to generate reports, greatly saving the client's resources.
[0139] Since there is an isolated library between the BI tool and the customer's database, it effectively prevents the BI tool deployed on the data service provider from directly connecting to the customer's database and affecting the customer's data.
[0140] In order to clearly illustrate the above embodiment, an example is now given for illustration.
[0141] Figure 7A flowchart of a report generation method based on a business intelligence (BI) tool in a scenario provided by an embodiment of the present invention.
[0142] like Figure 7 As shown, the report generation method based on the business intelligence BI tool may include the following steps:
[0143] Step 701: Acquire target data for generating a first report.
[0144] In this embodiment, the target data is data used to generate the first report. Optionally, the target data can be any data, such as business data.
[0145] In this embodiment, the target data is stored in a database on the client side, so that the target data for generating the first report can be obtained from the database on the client side.
[0146] pass Figure 7 It can be seen that in this embodiment, the acquired target data is stored in an isolated library, thereby preventing the BI tool deployed on the data service provider from directly connecting to the customer's database and affecting the customer's data.
[0147] Step 702: Process the target data in the isolation database according to preset business requirements to obtain first report data.
[0148] In this embodiment, the isolation library is used to store target data. Optionally, the isolation library can be any database, such as MySQL database, SqlServe database, etc.
[0149] It should be noted that the execution process of this step can refer to the execution process of step 102 in the above embodiment, and the principles are the same, so it will not be repeated here.
[0150] Step 703: Obtain first report data.
[0151] It should be noted that the BI tool of this embodiment is deployed on the data service provider, that is, the party providing data services, rather than on the client side. Optionally, the data service provider may include one or more systems, or one or more applications, which is not limited in this embodiment.
[0152] In this embodiment, the BI tool is deployed on the data service provider and may include a data layer, an interface layer, a visual editor, and an application layer. The visual editor includes a chart component library, a function library, an instrument production and a visualization platform, which is used to generate a visualization report based on the report data. Figure 2 The architecture diagram of the BI tool shown in the figure, related descriptions can be found in the description of step 103 in the above embodiment, which will not be repeated here.
[0153] In this embodiment, the data layer in the BI tool is connected to the isolated library, so that the first report data can be obtained from the isolated library through the data layer in the BI tool.
[0154] Step 704 : generating a first report in response to a visual editing operation performed on the first report data by a BI tool.
[0155] In this embodiment, the visual editing operation performed on the first report data may be performed by a visual editor in a BI tool, so that a first report may be generated in response to the visual editing operation performed on the first report data by the visual editor in the BI tool.
[0156] Similarly, in this embodiment, the generated first report also has version information, and optionally, the version information may also correspond to a date. For relevant descriptions, please refer to the description of step 103 in the above embodiment, which will not be repeated here.
[0157] Step 705: Synchronize the first report.
[0158] In this embodiment, the architecture of the BI tool can be seen in Figure 2 The architectural diagram of the BI tool shown, whereby the application layer in the BI tool includes a rendering container, and the BI tool can synchronize the report to the client through the rendering container. Therefore, in this embodiment, the first report can be synchronized to the target client through the rendering container in the BI tool to display the first report on the target client.
[0159] Since the BI tool of this embodiment is deployed on the data service side instead of the client side, the client's data report can be edited and put online on the data service side, and the client can view and use it simultaneously, avoiding the client's consumption of extra manpower and material resources to use visualization tools to generate reports, thereby greatly saving the client's resources.
[0160] Step 706: synchronously modify the second report.
[0161] In this embodiment, the second report is a report that has been displayed on the target client. It is understandable that since the first report generated and displayed on the target client in response to the visual editing operation performed on the first report data by the BI tool has version information, the second report in this embodiment also has version information.
[0162] In this embodiment, in response to a modification visual editing operation performed on any second report through the BI tool, the second report can be regenerated and re-displayed on the target client. Thus, it is possible to modify and edit the online report through the BI tool, regenerate the report and quickly synchronize it to the target client, so that the client can simultaneously perceive the modification and view the latest data report.
[0163] In a possible implementation of this embodiment, a second version of the second report can be generated in response to a modification visual editing operation performed on any first version of the second report through a visual editor in a BI tool, thereby synchronizing the second version of the second report to a target client through a rendering container in the BI tool, so that the first version of the second report is replaced by the second version of the second report in the target client, thereby displaying the latest version of the second report on the target client.
[0164] In summary, by deploying the BI tool on the data service side, that is, the party providing data services, instead of on the client side, it is possible to achieve that the client's data report can be edited and put online on the data service side, and the client can view and use it simultaneously, and the client's data report can be modified and edited on the data service side, and the client can perceive the modification and view the latest data report simultaneously, thereby solving the technical problem in related technologies that the BI tool is deployed on the client side and the client needs to spend additional manpower and material resources to use visualization tools to generate reports.
[0165] In order to implement the above embodiment, the present invention also proposes a report generation device based on a business intelligence BI tool.
[0166] Figure 8 The present invention provides a schematic diagram of a report generation device based on a business intelligence (BI) tool. It should be noted that the BI tool is deployed on a data service provider.
[0167] like Figure 8 As shown, the report generation device based on the business intelligence BI tool includes: a first processing module 81, a data processing module 82 and a second processing module 83.
[0168] The first processing module 81 is used to obtain target data for generating a first report, and store the target data in an isolation repository;
[0169] The data processing module 82 is used to process the target data in the isolation database according to the preset business requirements to obtain the first report data;
[0170] The second processing module 83 is used to generate and display the first report on the target client in response to the visual editing operation performed on the first report data through the BI tool.
[0171] Furthermore, in a possible implementation of the embodiment of the present invention, the second processing module 83 is further configured to:
[0172] In response to a visual editing operation performed on first report data by a visual editor in a BI tool, generating a first report;
[0173] The first report is synchronized to the target client through the rendering container in the BI tool to display the first report on the target client.
[0174] Further, in a possible implementation of the embodiment of the present invention, the BI tool includes a data layer, an interface layer, a visual editor and an application layer, wherein the visual editor includes a chart component library, a function library, an instrument production and a visualization platform;
[0175] The first report has version information.
[0176] It should be noted that the above explanation of the embodiment of the report generation method based on the business intelligence BI tool is also applicable to the report generation device based on the business intelligence BI tool of this embodiment, which will not be repeated here.
[0177] Based on the above embodiments, the present invention also provides a possible implementation method of a report generation device based on a business intelligence BI tool. Fig. 9 The present invention provides another structural diagram of a report generation device based on a business intelligence BI tool according to an embodiment of the present invention. Based on the previous embodiment, the report generation device based on a business intelligence BI tool further includes: a third processing module 84 .
[0178] The third processing module 84 is used to regenerate and re-display the second report on the target client in response to a modification visual editing operation performed on any second report through the BI tool, wherein the second report is a report that has been displayed on the target client.
[0179] Furthermore, in a possible implementation of the embodiment of the present invention, the second report has version information, and the third processing module 84 is further configured to:
[0180] In response to a modification visual editing operation performed on any first version of the second report through a visual editor in the BI tool, generating a second version of the second report;
[0181] The second version of the second report is synchronized to the target client through the rendering container in the BI tool, so that the first version of the second report is replaced by the second version of the second report in the target client.
[0182] Based on the above embodiments, the present invention also provides a possible implementation method of a report generation device based on a business intelligence BI tool. Fig.10 The present invention provides another structural diagram of a report generation device based on a business intelligence BI tool according to an embodiment of the present invention. Based on the previous embodiment, the report generation device based on a business intelligence BI tool further includes: an acquisition module 85 .
[0183] The acquisition module 85 is used to acquire the first report data from the isolated library through the BI tool.
[0184] Furthermore, in a possible implementation of the embodiment of the present invention, the acquisition module 85 is further configured to:
[0185] The first report data is obtained from the isolated library through the data layer in the BI tool, wherein the data layer of the BI tool is connected to the isolated library.
[0186] The report generation device based on the business intelligence BI tool provided in this embodiment obtains the target data for generating the first report and stores the target data in the isolation library, so as to process the target data in the isolation library according to the preset business requirements to obtain the first report data, thereby generating and displaying the first report on the target client in response to the visual editing operation performed on the first report data by the BI tool. Therefore, by deploying the BI tool on the data service party, that is, the party providing data services, rather than on the client side, the client's data report can be edited and put online on the data service party, and the client can view and use it synchronously, avoiding the client's consumption of extra manpower and material resources to use the visualization tool to generate reports, greatly saving the client's resources.
[0187] In order to implement the above embodiments, the present invention also proposes an electronic device, which includes: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the report generation method based on the business intelligence BI tool proposed in any of the above embodiments of the present invention.
[0188] Fig.11 This is a schematic diagram of the structure of an electronic device provided by an embodiment of the present invention. It should be noted that: Fig.11 The electronic device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.
[0189] like Fig.11As shown, the electronic device may include: a housing 11, a processor 12, a memory 13, a circuit board 14 and a power circuit 15, wherein the circuit board 14 is placed inside the space enclosed by the housing 11, and the processor 12 and the memory 13 are arranged on the circuit board 14; the power circuit 15 is used to supply power to various circuits or devices of the above-mentioned electronic device; the memory 13 is used to store executable program codes; the processor 12 runs a program corresponding to the executable program code by reading the executable program code stored in the memory 13, so as to execute the report generation method based on the business intelligence BI tool proposed in any of the above-mentioned embodiments of the present invention.
[0190] For details on the specific execution process of the above steps by the processor 12 and the steps further executed by the processor 12 by running the executable program code, please refer to the present invention. Figure 1-7 The description of the illustrated embodiment will not be repeated here.
[0191] In order to implement the above embodiments, the present invention further proposes a computer-readable storage medium storing computer instructions, wherein the computer instructions are used to enable a computer to execute the report generation method based on business intelligence (BI) tools proposed in any of the above embodiments of the present invention.
[0192] In order to implement the above embodiments, the present invention further proposes a computer program product, including a computer program, which, when executed by a processor, implements the report generation method based on a business intelligence (BI) tool proposed in any of the above embodiments of the present invention.
[0193] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "example", "specific example", or "some examples" etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner. In addition, those skilled in the art may combine and combine the different embodiments or examples described in this specification and the features of the different embodiments or examples, without contradiction.
[0194] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Therefore, the features defined as "first" and "second" may explicitly or implicitly include at least one of the features. In the description of the present invention, the meaning of "plurality" is at least two, such as two, three, etc., unless otherwise clearly and specifically defined.
[0195] Any process or method description in a flowchart or otherwise described herein may be understood to represent a module, segment or portion of code comprising one or more executable instructions for implementing the steps of a custom logical function or process, and the scope of the preferred embodiments of the present invention includes alternative implementations in which functions may not be performed in the order shown or discussed, including performing functions in a substantially simultaneous manner or in reverse order depending on the functions involved, which should be understood by technicians in the technical field to which the embodiments of the present invention belong.
[0196] The logic and / or steps represented in the flowchart or otherwise described herein, for example, can be considered as an ordered list of executable instructions for implementing logical functions, and can be embodied in any computer-readable medium for use by an instruction execution system, device or apparatus (such as a computer-based system, a system including a processor, or other system that can fetch instructions from an instruction execution system, device or apparatus and execute the instructions), or in combination with these instruction execution systems, devices or apparatuses. For the purpose of this specification, "computer-readable medium" can be any device that can contain, store, communicate, propagate or transmit a program for use by an instruction execution system, device or apparatus, or in combination with these instruction execution systems, devices or apparatuses. More specific examples of computer-readable media (a non-exhaustive list) include the following: an electrical connection with one or more wires (electronic device), a portable computer disk box (magnetic device), a random access memory (RAM), a read-only memory (ROM), an erasable and programmable read-only memory (EPROM or flash memory), a fiber optic device, and a portable compact disk read-only memory (CDROM). In addition, the computer-readable medium may even be paper or other suitable medium on which the program is printed, since the program may be obtained electronically, for example, by optically scanning the paper or other medium and then editing, interpreting or processing in other suitable ways if necessary, and then stored in a computer memory.
[0197] It should be understood that the various parts of the present invention can be implemented by hardware, software, firmware or a combination thereof. In the above-mentioned embodiments, a plurality of steps or methods can be implemented by software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented by hardware, as in another embodiment, it can be implemented by any one of the following technologies known in the art or their combination: a discrete logic circuit having a logic gate circuit for implementing a logic function for a data signal, a dedicated integrated circuit having a suitable combination of logic gate circuits, a programmable gate array (PGA), a field programmable gate array (FPGA), etc.
[0198] A person skilled in the art may understand that all or part of the steps in the method for implementing the above-mentioned embodiment may be completed by instructing related hardware through a program, and the program may be stored in a computer-readable storage medium, which, when executed, includes one or a combination of the steps of the method embodiment.
[0199] In addition, each functional unit in each embodiment of the present invention may be integrated into a processing module, or each unit may exist physically separately, or two or more units may be integrated into one module. The above-mentioned integrated module may be implemented in the form of hardware or in the form of a software functional module. If the integrated module is implemented in the form of a software functional module and sold or used as an independent product, it may also be stored in a computer-readable storage medium.
[0200] The storage medium mentioned above may be a read-only memory, a magnetic disk or an optical disk, etc. Although the embodiments of the present invention have been shown and described above, it can be understood that the above embodiments are exemplary and cannot be understood as limiting the present invention. A person of ordinary skill in the art may change, modify, replace and modify the above embodiments within the scope of the present invention.
Claims
1. A report generation method based on business intelligence (BI) tools, characterized in that: The BI tool is deployed on a data service provider, and the method includes: Acquire target data for generating a first report, and store the target data in an isolation repository; According to preset business requirements, the target data in the isolation database is processed to obtain first report data; In response to the visual editing operation performed on the first report data by the BI tool, the first report is generated and displayed on the target client.
2. The method according to claim 1, characterized in that: In response to the visual editing operation performed on the first report data by the BI tool, generating and displaying the first report on the target client includes: In response to a visual editing operation performed on the first report data by a visual editor in the BI tool, generating the first report; The first report is synchronized to the target client through the rendering container in the BI tool, so as to display the first report on the target client.
3. The method according to claim 1, characterized in that The method further comprises: In response to a modification visual editing operation performed on any second report through the BI tool, the second report is regenerated and re-displayed on the target client, wherein the second report is a report that has been displayed on the target client.
4. The method according to claim 3, characterized in that: The second report has version information, and in response to a modification visual editing operation performed on any second report by the BI tool, regenerating and re-displaying the second report on the target client includes: In response to a modification visual editing operation performed on any first version of the second report through a visual editor in the BI tool, generating a second version of the second report; The second version of the second report is synchronized to the target client through the rendering container in the BI tool, so as to replace the first version of the second report with the second version of the second report in the target client.
5. The method according to claim 1, characterized in that: In response to the visual editing operation performed on the first report data by the BI tool, before generating and displaying the first report on the target client, the method further includes: The first report data is obtained from the isolated library through the BI tool.
6. The method according to claim 5, characterized in that The obtaining the first report data from the isolated library by using the BI tool includes: The first report data is obtained from the isolated library through a data layer in the BI tool, wherein the data layer is connected to the isolated library.
7. The method according to any one of claims 1 to 6, characterized in that The BI tool includes a data layer, an interface layer, a visual editor and an application layer, wherein the visual editor includes a chart component library, a function library, an instrument production and a visualization platform; The first report has version information.
8. A report generation device based on business intelligence (BI) tools, characterized in that: The BI tool is deployed on a data service provider, and the device includes: A first processing module, used for acquiring target data for generating a first report, and storing the target data in an isolation repository; A data processing module, used for processing the target data in the isolation database according to preset business requirements to obtain first report data; The second processing module is used to generate and display the first report on the target client in response to the visual editing operation performed on the first report data by the BI tool.
9. An electronic device, characterized in that: include: at least one processor; as well as a memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the method according to any one of claims 1 to 7.
10. A computer-readable storage medium storing computer instructions, characterized in that: The computer instructions are used to cause the computer to execute the method according to any one of claims 1 to 7.
11. A computer program product, characterized in that The invention comprises a computer program which, when executed by a processor, implements the method according to any one of claims 1 to 7.
