Report processing method and device, equipment, storage medium and program product

Abstract

The invention discloses a report processing method and device, equipment, a storage medium and a program product, and relates to the technical field of electrical digital data processing.The report processing method comprises the steps that in response to a report processing instruction triggered by a user, configuration information of a report processing task is extracted from the report processing instruction, and based on the configuration information, a target cube model is determined, and based on the target cube model, processing a source data table obtained from a target database to obtain a target report. When a report processing task needing to adjust the dimensionality or the logic relation of the report appears, the corresponding target cube model is determined through the dimensionality configuration and the measurement configuration, the corresponding target report is generated based on the target cube model, report processing can be carried out only through configuration of the report processing task, and therefore the report processing efficiency is improved, and the report processing efficiency is improved. The report processing method and the report processing device can improve report processing completion efficiency while saving resources.

Description

Technical Field

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

[0002] Data report processing is the process of generating new reports based on existing datasets. Currently, this process primarily involves processing and aggregating data across various dimensions within a dataset, using stored procedures. Current report processing methods require developers familiar with database tables and field logic to repeatedly modify and develop stored procedures when adjusting report dimensions or logical relationships. This wastes significant resources and reduces report processing efficiency. Summary of the Invention

[0003] The main purpose of this application is to provide a report processing method, device, equipment, storage medium and program product, aiming to solve the technical problems that the current report processing method wastes a lot of resources and reduces completion efficiency.

[0004] To achieve the above objectives, this application proposes a report processing method, which includes:

[0005] In response to a report processing instruction triggered by a user, extracting configuration information of the report processing task from the report processing instruction;

[0006] Determine a target cube model based on the dimension configuration and the metric configuration in the configuration information;

[0007] Based on the target cube model, the source data table obtained from the target database is processed to obtain a target report.

[0008] In one embodiment, the dimension configuration includes dimension field configuration, the metric configuration includes metric field configuration and operation function configuration, and the step of determining the target cube model based on the dimension configuration and metric configuration in the configuration information includes:

[0009] Based on the dimension field configuration, determining a target dimension field from the dimension fields of the source data table;

[0010] Based on the metric field configuration and the operation function configuration, determining a target metric field from the metric fields of the source data table and a target operation function corresponding to the target metric field;

[0011] The target cube model is determined based on the target dimension field, the target metric field and the target operation function.

[0012] In one embodiment, the configuration information includes source data period configuration and report format configuration. The step of processing the source data table obtained from the target database based on the target cube model to obtain the target report includes:

[0013] Based on the source data period configuration, the data within the source data period in the source data table is stored in the target cube model to obtain a target data set;

[0014] Based on the target data set and the report format configuration, the target report in a corresponding format is generated.

[0015] In one embodiment, the configuration information further includes a generation and expiration time configuration, wherein the generation and expiration time configuration includes an effective time point, an expiration time point, and a generation cycle. Before the step of processing the source data table obtained from the target database based on the target cube model to obtain the target report, the step further includes:

[0016] Get the current time point;

[0017] Every generation cycle, determining whether the current time point is after the validation time point and before the expiration time point;

[0018] If so, the source data table obtained from the target database is processed based on the target cube model to obtain a target report.

[0019] In one embodiment, the configuration information further includes sending configuration and email configuration, the email configuration includes an email receiving address, the sending configuration includes a sending cycle and a sending time point corresponding to the sending cycle, and after the step of processing the source data table obtained from the target database based on the target cube model to obtain the target report, the step further includes:

[0020] Get the current time point;

[0021] Determining whether the current time point is the sending time point in the sending cycle;

[0022] If so, the target report is sent to the email receiving address, wherein the email receiving address is one or more email addresses.

[0023] In one embodiment, before the step of extracting configuration information of the report processing task from the report processing instruction in response to the user-triggered report processing instruction, the method further includes:

[0024] In response to a user's selection operation, determining a source data table in a target database;

[0025] Read the source data table and obtain the source data table fields;

[0026] Determining, based on the field type of the source data table field, the dimension field and the metric field in the source data table field;

[0027] The dimension fields and the metric fields are visually displayed to facilitate the user to configure the dimension fields and the metric fields.

[0028] In addition, to achieve the above-mentioned purpose, the present application also proposes a report processing device, which includes:

[0029] A configuration acquisition module, configured to extract configuration information of a report processing task from a report processing instruction triggered by a user;

[0030] A model determination module, configured to determine a target cube model based on the dimension configuration and metric configuration in the configuration information;

[0031] The report processing module is used to process the source data table obtained from the target database based on the target cube model to obtain the target report.

[0032] In addition, to achieve the above-mentioned purpose, the present application also proposes a report processing device, which includes: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program is configured to implement the steps of the report processing method described above.

[0033] In addition, to achieve the above-mentioned purpose, the present application also proposes a storage medium, which is a computer-readable storage medium and stores a computer program. When the computer program is executed by a processor, the steps of the report processing method described above are implemented.

[0034] In addition, to achieve the above-mentioned purpose, the present application also provides a computer program product, which includes a computer program. When the computer program is executed by a processor, it implements the steps of the report processing method described above.

[0035] One or more technical solutions proposed in this application have at least the following technical effects:

[0036] In response to a report processing instruction triggered by a user, configuration information of the report processing task is extracted from the report processing instruction, wherein the configuration information includes dimension configuration and metric configuration. Based on the configuration information, the target cube model is determined. Based on the target cube model, the source data table obtained from the target database is processed to obtain the target report.

[0037] In the present application, the target report is generated based on the target cube model, and the target cube model is determined based on the dimension configuration and metric configuration in the configuration information. When a report processing task that requires adjustment of the dimensions or logical relationships of the report occurs, it is only necessary to perform the corresponding dimension configuration and metric configuration, determine the corresponding target cube model, and then generate the corresponding target report based on the target cube model. Therefore, the present application does not require developers who are familiar with the library tables and field logic to repeatedly modify and develop stored procedures. Report processing can be performed by only configuring the report processing task, thereby saving resources while improving the completion efficiency of report processing. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the present application.

[0039] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, for ordinary technicians in this field, other drawings can be obtained based on these drawings without any creative work.

[0040] Figure 1 A flow chart of Example 1 of the report processing method for this application;

[0041] Figure 2 A flow chart of Example 2 of the report processing method for this application is provided;

[0042] Figure 3 A schematic diagram of a scenario provided for Example 2 of the report processing method of this application;

[0043] Figure 4 A flow chart of Example 3 of the report processing method for this application is provided;

[0044] Figure 5 This is a schematic diagram of the module structure of the report processing device according to an embodiment of the present application;

[0045] Figure 6 This is a schematic diagram of the device structure of the hardware operating environment involved in the report processing method in the embodiment of the present application.

[0046] The purpose, features and advantages of this application will be further explained in conjunction with the embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION

[0047] It should be understood that the specific embodiments described herein are merely used to explain the technical solutions of the present application and are not intended to limit the present application.

[0048] In order to better understand the technical solution of the present application, a detailed description will be given below in conjunction with the accompanying drawings and specific implementation methods.

[0049] It should be noted that the execution subject of this embodiment may be a computing service device with data processing, network communication, and program execution capabilities, such as a tablet computer, personal computer, mobile phone, etc., or an electronic device or report processing device capable of performing the aforementioned functions. This embodiment and the following embodiments will be described below using a report processing device as an example.

[0050] The data processing area of ​​big data systems includes data report processing, which is the process of generating new reports based on existing data sets. Current report processing methods mainly process and aggregate the data of each dimension of the data set through stored procedures.

[0051] When adjustments to report dimensions or logical relationships are needed, current report processing methods require modification and redevelopment of stored procedures. This development process requires developers to have a solid foundation in SQL (Structured Query Language) and a high level of familiarity with database tables and field logic. This creates a development barrier for new report processing and significantly reduces processing efficiency. If this repetitive development process involves intermediate tables, these tables must be adjusted or new ones developed to support report processing, resulting in a significant amount of duplicate development work and a waste of resources.

[0052] Based on this, the embodiment of the present application provides a report processing method, referring to Figure 1 , Figure 1 This is a flow chart of the first embodiment of the report processing method of this application.

[0053] In this embodiment, the report processing method includes steps S10 to S30:

[0054] Step S10, in response to a report processing instruction triggered by a user, extracting configuration information of the report processing task from the report processing instruction;

[0055] It should be noted that the report processing instruction is a confirmation instruction when the user completes the configuration of the report processing task. The user's configuration operation of the report processing task is performed in the front-end graphical interface.

[0056] It's understandable that report processing is the process of generating new reports based on existing datasets. Different requirements necessitate different reports. Therefore, it's necessary to first extract the configuration information for the report processing task and then use this extracted task configuration information to determine the report the user needs to generate.

[0057] Step S20: determining a target cube model based on the dimension configuration and metric configuration in the configuration information;

[0058] It's important to note that the Cube model is a multidimensional data structure in which data is organized into multiple dimensions. Each dimension can have multiple levels, each corresponding to a subdivision of that dimension. By precalculating and storing multidimensional data, the Cube model provides fast data query and analysis capabilities, enabling complex business intelligence analysis and report generation.

[0059] It's understandable that data report processing involves adjusting dimensions and logical relationships. Dimension configuration determines the dimension fields used to describe data in new tables, while metric configuration determines the fields to be counted and aggregated, along with their calculation logic. Therefore, by configuring the dimension and metric configurations in the information, you can meet the requirements for adjusting dimensions and logical relationships during data report processing.

[0060] Since the data in actual business scenarios is usually highly complex, often involving the association, nesting, and aggregation of multiple tables, traditional report processing methods require professional technicians to spend a lot of time repeatedly developing stored procedures.

[0061] The Cube model abstracts these complex data relationships into a multidimensional structure, simplifying data organization. This allows report processing to focus solely on dimensions and metrics, eliminating the need to worry about the storage details of the underlying data. Therefore, this embodiment determines the target Cube model based on the dimension and metric configurations in the configuration information. This configuration can be used to meet adjustments to dimensions and logical relationships. By determining the target Cube model, adjustments can be made without developing stored procedures, reducing resource consumption during report processing and improving completion efficiency.

[0062] Step S30: Based on the target cube model, the source data table obtained from the target database is processed to obtain a target report.

[0063] It should be noted that the target database is the database that the user chooses to connect to when processing a report, and the source data table is the basic data table in the target database used for report processing.

[0064] It's understandable that the target cube model is based on the dimension and metric configurations. That is, the dimensions and metrics in the target cube model are consistent with those required for the target report generated by the user. Therefore, processing the source data table based on the target cube model allows you to leverage the common data structure provided by the cube model to reorganize the source data according to the dimension and metric configurations to generate the target report, without the need for redeveloping stored procedures. This reduces resource consumption and improves completion efficiency.

[0065] In multidimensional analysis, users often need to frequently query aggregate results for different dimensional combinations. Dynamically calculating these results from the source data table each time would be very inefficient. This embodiment, based on the cube model, pre-calculates and stores aggregate results, significantly improving query performance.

[0066] In a feasible implementation, the configuration information includes source data cycle configuration and report format configuration. The specific implementation of processing the source data table obtained from the target database based on the target cube model to obtain the target report may also be:

[0067] Based on the source data period configuration, the data in the source data period in the source data table is stored in the target cube model to obtain a target data set, and based on the target data set and the report format configuration, the target report in the corresponding format is generated.

[0068] It should be noted that the source data period is the starting period of the data in the source data table. The source data period field is selected as needed. The available periods include day, week, month, and year. The starting period can be set to the last date, last week, last month, last quarter, or last year. You can also flexibly set the period start range as needed by using a custom period. The report format is the format of the generated target report. The available formats are Excel, CSV, and PDF.

[0069] It is understandable that source data tables in a database typically contain a large amount of data. Directly processing all of this data would consume significant computing resources. Furthermore, different business scenarios require different data cycles within the source data tables to be processed. Therefore, this embodiment uses source data cycle configuration to limit the data scope to be processed, loading and processing only data within a specific time period. This improves processing efficiency while meeting report generation requirements.

[0070] Since source data tables are typically structured tables containing numerous fields and records that may be scattered across multiple tables, processing the source data tables directly can result in poor query performance, impacting report processing efficiency. Therefore, it's necessary to store the data in the source data tables in the target cube model, forming a multidimensional dataset with corresponding dimensions and measures. Pre-calculation can then be used to store the data to be calculated in the cube model, thereby improving report processing efficiency.

[0071] Furthermore, this embodiment can generate reports in different formats as needed through report format configuration, such as generating reports in Excel format for further processing and analysis of data, generating reports in CSV format for batch import and export of data, and generating reports in PDF format for archiving or formal reporting, thereby meeting different needs and improving the practicality of report processing.

[0072] In summary, this embodiment responds to a report processing instruction triggered by a user, extracts configuration information of the report processing task from the report processing instruction, wherein the configuration information includes dimension configuration and metric configuration. Based on the configuration information, the target cube model is determined. Based on the target cube model, the source data table obtained from the target database is processed to obtain the target report.

[0073] In this embodiment, the target report is generated based on the target cube model, and the target cube model is determined based on the dimension configuration and metric configuration in the configuration information. When a report processing task that requires adjustment of the dimensions or logical relationships of the report occurs, it is only necessary to perform the corresponding dimension configuration and metric configuration, determine the corresponding target cube model, and then generate the corresponding target report based on the target cube model. Therefore, this application does not require developers who are familiar with library tables and field logic to repeatedly modify and develop stored procedures. Report processing can be performed by only configuring the report processing task, thereby saving resources while improving the completion efficiency of report processing.

[0074] Based on the first embodiment of the present application, in the second embodiment of the present application, the same or similar contents as those in the above embodiment 1 can be referred to the above introduction and will not be described in detail later. Figure 2 In step S20, the dimension configuration includes dimension field configuration, the metric configuration includes metric field configuration and operation function configuration, and the report processing method further includes steps S21 to S23:

[0075] Step S21, based on the dimension field configuration, determining a target dimension field from the dimension fields of the source data table;

[0076] It should be noted that dimension field configuration is to check the required dimension fields from the multiple dimension fields displayed on the front-end interface. The dimension fields checked by default are all grouping item fields. Among them, dimension field values ​​can be filtered during dimension field configuration.

[0077] It is understandable that the dimension fields in the source data table may differ from the dimension fields required for the target report generated by the user. Therefore, based on the dimension field configuration, it is necessary to determine the target dimension fields required by the target report from the dimension fields in the source data table, so that the dimension fields of the generated target report meet the requirements.

[0078] In this embodiment, in addition to selecting dimension fields, you can also aggregate dimension fields. For example, if the source data table contains a time dimension field called "Month," you can aggregate "Month" to create a new dimension field. The name of the new dimension field generated through aggregation can be set; if not, the name is the default.

[0079] Step S22: determining a target metric field and a target operation function corresponding to the target metric field from the metric fields of the source data table based on the metric field configuration and the operation function configuration;

[0080] It should be noted that the metric field configuration is to select the required metric field from the multiple metric fields displayed on the front-end interface and select the corresponding operation function as needed. For metric fields that do not have a function operation selected, the default is to sum the field values ​​in the metric field of the target report.

[0081] It's understandable that the metric fields in the source data table may differ from the metric fields in the target report you need to generate, and the calculation method for the field values ​​of each metric field in the target report may also differ depending on the requirements. Therefore, in order to ensure that the metric fields and corresponding field value calculation methods of the target report meet the requirements, it is necessary to determine the target metric field from the metric fields in the source data table and determine the target operation function corresponding to the target metric field.

[0082] In this embodiment, calculating the target metric field using the corresponding target operation function may generate a new metric field, which will also be determined as the metric field of the target report. For example, for the metric field "Call Duration," setting the target operation function to average will generate a new target metric field. The specific name of the new target metric field can be set; otherwise, a default value will be used.

[0083] Step S23: Determine the target cube model based on the target dimension field, the target metric field and the target operation function.

[0084] It's understandable that the target dimension fields, target metric fields, and target operation functions are related to report processing requirements. By determining the target cube model using these fields, the fields in the target cube model are guaranteed to meet the requirements, thus avoiding interference from irrelevant dimension and metric fields and reducing computational overhead. Furthermore, by determining the target operation function corresponding to the target metric field, pre-calculation can be used to calculate field values ​​in advance, allowing results to be directly extracted from the cube model without requiring dynamic calculation each time, significantly improving query performance.

[0085] In a feasible implementation manner, before the step of extracting the configuration information of the report processing task from the report processing instruction in response to the report processing instruction triggered by the user, the step further includes:

[0086] In response to the user's selection operation, the source data table in the target database is determined, the source data table is read, the source data table fields are obtained, and based on the field types of the source data table fields, the dimension fields and metric fields in the source data table fields are determined, and the dimension fields and the metric fields are visually displayed for the user to configure the dimension fields and the metric fields.

[0087] It should be noted that the user's selection operation is an operation in which the user selects one or more source data tables to be processed in the visual interface and performs confirmation.

[0088] It's understandable that a source data table is a structured data table that includes data fields and their corresponding values. The source data table fields define the structure and content of the data. Understanding the field information allows us to further distinguish between dimension fields and metric fields. Therefore, we first need to read the source data table and obtain its fields.

[0089] Furthermore, since report processing in this embodiment is the process of generating a new report based on the source data table data, the dimension fields and metric fields in the target report are determined based on the source data table fields. Therefore, by first determining the dimension fields and metric fields in the source data table fields and then visually displaying them, the user's configuration requirements for the dimensions and metrics in the target report can be met. This allows users to generate corresponding reports without having to have a development foundation, thereby improving the efficiency of report processing.

[0090] This example performs a corresponding search based on the Hbase database. The number of underlying search and query basic data items is 2 billion. The deployment environment is shown in the following table:

[0091]

[0092] The execution effect is as follows Figure 3 As shown in the figure, among 2 billion basic data, when three, five, and eight field filtering conditions are set and the displayed fields are 10, 30, 50, and all fields, the longest response time is 4.4 seconds, 0.3 seconds, and 0.2 seconds, respectively.

[0093] This embodiment does not require a full table scan when querying an HBase table, thereby reducing query time and improving query efficiency. Furthermore, query conditions can be set to meet the needs of multi-condition queries, thereby improving the intelligence and flexibility of queries. Furthermore, indexes with higher query frequencies are stored on high-configuration machines, while indexes with lower query frequencies are stored on low-configuration machines. This hot and cold data dumping method effectively improves index query efficiency and resource utilization.

[0094] In summary, this embodiment determines the target dimension field from the dimension field of the source data table based on the dimension field configuration, determines the target metric field from the metric field of the source data table based on the metric field configuration and the operation function configuration, and the target operation function corresponding to the target metric field, and determines the target cube model based on the target dimension field, the target metric field and the target operation function.

[0095] By specifying the target dimension and metric fields, you can load and process only the necessary dimension and metric fields, reducing data processing and optimizing storage and query performance. By specifying the calculation method for the target metric fields, you can ensure accurate calculations while pre-calculating and storing the results of different metric fields using the target cube model, avoiding real-time calculations and reducing resource consumption.

[0096] Based on the first and second embodiments of the present application, in the third embodiment of the present application, the same or similar contents as those in the first and second embodiments can be referred to above and will not be described in detail. Figure 4 Before step S30, the configuration information further includes a generation and expiration time configuration, and the generation and expiration time configuration includes an effective time point, an expiration time point, and a generation cycle. The report processing method further includes steps S031 to S033:

[0097] Step S031, obtaining the current time point;

[0098] It is understandable that after the user completes the configuration of the report processing task, the report processing task needs to be performed at a specific time point based on the user's specific configuration. Therefore, in order to ensure the accuracy of the time for performing the report processing task, it is necessary to first obtain the current time point.

[0099] Step S032: every generation cycle, determining whether the current time point is after the validation time point and before the expiration time point;

[0100] It should be noted that the generation cycle is the time interval between repeated report processing tasks, that is, the time required to perform the report processing task again after the current time point. The effective time point is the time when the set report processing task begins to take effect, and the expiration time point is the time when the set report processing task begins to expire. The report processing task will only be performed when the current time point is after the effective time point and before the expiration time point.

[0101] Understandably, data often changes dynamically, requiring regular report processing to analyze the changing data. However, for the same business, the target report's dimensions, metrics, and other data typically remain constant. Therefore, by setting a generation cycle, report processing tasks can be performed once per generation cycle, eliminating the need to reconfigure the report processing task each time, improving the convenience of report processing.

[0102] However, depending on actual business needs, report processing may only be required during fixed time periods. Therefore, this embodiment uses the creation and expiration time configuration to allow report processing tasks to be performed only between the creation and expiration time points. This not only meets report processing needs, but also prevents some report processing tasks from occupying large amounts of resources, thereby reducing resource consumption.

[0103] Step S033: If yes, then based on the target cube model, the source data table obtained from the target database is processed to obtain a target report.

[0104] It is understandable that after the set generation cycle, the current time is after the effective time point and before the expiration time point. Therefore, it can be determined that report processing is required. Based on the target cube model, the source data table obtained from the target database is processed to obtain the target report, thereby improving the efficiency and accuracy of the report generation process.

[0105] In a feasible implementation, the configuration information further includes sending configuration and email configuration, the email configuration includes an email receiving address, the sending configuration includes a sending cycle and a sending time point corresponding to the sending cycle, and the specific real-time method after the step of processing the source data table obtained from the target database based on the target cube model to obtain the target report can also be:

[0106] Obtain the current time point, determine whether the current time point is the sending time point in the sending cycle, and if so, send the target report to the email receiving address, wherein the email receiving address is one or more email addresses.

[0107] It should be noted that the email configuration also includes the configuration of the email distribution subject and the configuration of the email body content. The sending cycle includes immediate sending, daily sending, weekly sending, monthly sending, quarterly sending and custom period sending.

[0108] Depending on the selected sending cycle, you need to set the corresponding trigger time. For example, if you send on a daily basis, the trigger time you need to set is the hour, minute, and second of the sending time. If you send on a weekly basis, the trigger time you need to set is the date from Monday to Sunday and the hour, minute, and second of the sending time.

[0109] It is understandable that after a report is generated, it needs to be sent to the appropriate personnel for further processing and analysis. Different business needs will generate different target reports at different generation cycles, and different target reports need to be sent to different personnel. Therefore, you can set the sending cycle to meet the distribution needs of target reports with different generation cycles, eliminating the need to manually send target reports and improving the efficiency and accuracy of report distribution. On the basis of periodic report distribution, you can further improve the effectiveness of report distribution by setting the email distribution subject, email distribution body, and setting one or more email addresses.

[0110] In summary, this embodiment obtains the current time point, and every generation cycle, determines whether the current time point is after the effective time point and before the expiration time point. If so, the source data table obtained from the target database is processed based on the target cube model to obtain the target report.

[0111] When the same business requires regular report processing, a report processing task can be executed once during each generation cycle by setting a generation cycle, eliminating the need to reconfigure the report processing task each time, thereby improving the convenience of report processing. Furthermore, this embodiment configures the generation and expiration time, so that report processing tasks can be executed only between the effective and expiration time points. While meeting the requirements, it also prevents some useless report processing tasks from occupying a large amount of resources, thereby reducing resource consumption.

[0112] It should be noted that the above examples are only used to understand this application and do not constitute a limitation on the report processing method of this application. More simple transformations based on this technical concept are all within the scope of protection of this application.

[0113] This application also provides a report processing device, please refer to Figure 5 , the report processing device includes:

[0114] A configuration acquisition module, configured to extract configuration information of a report processing task from a report processing instruction triggered by a user;

[0115] A model determination module, configured to determine a target cube model based on the dimension configuration and metric configuration in the configuration information;

[0116] The report processing module is used to process the source data table obtained from the target database based on the target cube model to obtain the target report.

[0117] In one embodiment, the model determination module includes:

[0118] A dimension configuration submodule, configured to determine a target dimension field from the dimension fields of the source data table based on the dimension field configuration;

[0119] A metric configuration submodule, configured to determine a target metric field and a target operation function corresponding to the target metric field from the metric fields of the source data table based on the metric field configuration and the operation function configuration;

[0120] The model determination submodule is used to determine the target cube model based on the target dimension field, the target metric field and the target operation function.

[0121] In one embodiment, the report processing module includes:

[0122] A data set generation submodule is used to store the data within the source data period in the source data table in the target cube model based on the source data period configuration to obtain a target data set;

[0123] The report generation submodule is used to generate the target report in a corresponding format based on the target data set and the report format configuration.

[0124] In one embodiment, the report processing device includes:

[0125] The first time acquisition module is used to obtain the current time point;

[0126] a generation failure judgment module, configured to judge, at each generation cycle, whether the current time point is after the validation time point and before the failure time point;

[0127] The execution module is used to process the source data table obtained from the target database based on the target cube model to obtain a target report.

[0128] In one embodiment, the report processing device includes:

[0129] The second time acquisition module is used to obtain the current time point;

[0130] A sending time judgment module, used to judge whether the current time point is the sending time point in the sending cycle;

[0131] The scheduled email trigger module is used to send the target report to the email receiving address if yes, wherein the email receiving address is one or more email addresses.

[0132] In one embodiment, the report processing device includes:

[0133] A source table acquisition module, configured to determine a source data table in a target database in response to a user's selection operation;

[0134] A source table reading module is used to read the source data table and obtain the source data table fields;

[0135] A field determination module, configured to determine dimension fields and metric fields in the source data table fields based on the field types of the source data table fields;

[0136] The field display module is used to visually display the dimension fields and the metric fields so that users can configure the dimension fields and the metric fields.

[0137] The report processing device provided in this application, utilizing the report processing method of the aforementioned embodiment, can address the technical issues of current report processing methods, which waste significant resources and reduce completion efficiency. Compared to the prior art, the report processing device provided in this application achieves the same beneficial effects as the report processing method of the aforementioned embodiment. Other technical features of the report processing device are the same as those disclosed in the aforementioned embodiment and are not further elaborated here.

[0138] The present application provides a report processing device, which includes: at least one processor; and 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 execute the report processing method in the above-mentioned embodiment one.

[0139] Reference below Figure 6, which shows a schematic diagram of the structure of a report processing device suitable for implementing the embodiments of the present application. The report processing device in the embodiments of the present application may include, but is not limited to, mobile terminals such as mobile phones, tablet computers, laptop computers, digital broadcast receivers, PDAs (Personal Digital Assistants), PMPs (Portable Media Players), in-vehicle terminals (such as in-vehicle navigation terminals), and fixed terminals such as digital TVs and desktop computers. Figure 6 The report processing 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 application.

[0140] like Figure 6 As shown, the report processing device may include a processing device 1001 (e.g., a central processing unit, a graphics processing unit, etc.), which can perform various appropriate actions and processes based on programs stored in a read-only memory (ROM) 1002 or programs loaded from a storage device 1003 into a random access memory (RAM) 1004. RAM 1004 also stores various programs and data required for the operation of the report processing device. Processing device 1001, ROM 1002, and RAM 1004 are interconnected via a bus 1005. An input / output (I / O) interface 1006 is also connected to the bus. Typically, the following systems may be connected to I / O interface 1006: input devices 1007 including, for example, a touchscreen, touchpad, keyboard, mouse, image sensor, microphone, accelerometer, gyroscope, etc.; output devices 1008 including, for example, a liquid crystal display (LCD), speaker, vibrator, etc.; storage device 1003 including, for example, a magnetic tape, hard disk, etc.; and communication devices 1009. Communication device 1009 can allow the report processing device to communicate with other devices wirelessly or wired to exchange data. Although the figure shows a report processing device with various systems, it should be understood that it is not required to implement or have all of the systems shown. More or fewer systems may be implemented or provided instead.

[0141] In particular, according to the embodiments disclosed in the present application, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, the embodiments disclosed in the present application include a computer program product comprising a computer program carried on a computer-readable medium, the computer program comprising program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network via a communication device, or installed from a storage device 1003, or installed from a ROM 1002. When the computer program is executed by the processing device 1001, the above-mentioned functions defined in the method of the embodiment disclosed in the present application are executed.

[0142] The report processing device provided in this application, utilizing the report processing method of the aforementioned embodiment, can address the technical issues of current report processing methods, which waste significant resources and reduce completion efficiency. Compared to the prior art, the report processing device provided in this application achieves the same beneficial effects as the report processing method of the aforementioned embodiment. Other technical features of the report processing device are the same as those disclosed in the aforementioned embodiment and are not further elaborated here.

[0143] It should be understood that the various parts disclosed in this application can be implemented using hardware, software, firmware, or a combination thereof. In the description of the above embodiments, specific features, structures, materials, or characteristics can be combined in any one or more embodiments or examples in a suitable manner.

[0144] The above description is merely a specific embodiment of the present application, but the scope of protection of the present application is not limited thereto. Any changes or substitutions that can be easily conceived by a person skilled in the art within the technical scope disclosed in this application should be included in the scope of protection of this application. Therefore, the scope of protection of this application should be based on the scope of protection of the claims.

[0145] The present application provides a computer-readable storage medium having computer-readable program instructions (ie, computer program) stored thereon, and the computer-readable program instructions are used to execute the report processing method in the above embodiment.

[0146] The computer-readable storage medium provided in this application may be, for example, a USB flash drive, but is not limited to electrical, magnetic, optical, electromagnetic, infrared, or semiconductor systems, systems or devices, or any combination thereof. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof. In this embodiment, the computer-readable storage medium may be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, system or device. The program code contained on the computer-readable storage medium may be transmitted using any appropriate medium, including but not limited to: wires, optical cables, RF (Radio Frequency), etc., or any suitable combination thereof.

[0147] The computer-readable storage medium may be included in the report processing device; or it may exist independently without being assembled into the report processing device.

[0148] The computer-readable storage medium carries one or more programs. When the one or more programs are executed by the report processing device, the report processing device is enabled to execute the report processing method.

[0149] Computer program code for performing the operations of the present application may be written in one or more programming languages, or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, C++, and conventional procedural programming languages ​​such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a stand-alone software package, partially on the user's computer and partially on a remote computer, or entirely on the remote computer or server. In cases involving a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., through the Internet using an Internet service provider).

[0150] The flow charts and block diagrams in the accompanying drawings illustrate the possible architecture, functions and operations of the systems, methods and computer program products according to the various embodiments of the present application. In this regard, each box in the flow chart or block diagram can represent a module, program segment or a part of code, and the module, program segment or a part of code contains one or more executable instructions for realizing the prescribed logical functions. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order than that marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram and / or flow chart, and the combination of the boxes in the block diagram and / or flow chart can be implemented by a dedicated hardware-based system that performs the prescribed function or operation, or can be implemented by a combination of dedicated hardware and computer instructions.

[0151] The modules described in the embodiments of the present application may be implemented in software or hardware, wherein the name of a module does not necessarily limit the unit itself.

[0152] The computer-readable storage medium provided in this application is a computer-readable storage medium storing computer-readable program instructions (i.e., a computer program) for executing the aforementioned report processing method. This computer-readable storage medium can address the technical issues of current report processing methods, which waste significant resources and reduce completion efficiency. Compared to the prior art, the beneficial effects of the computer-readable storage medium provided in this application are similar to those of the report processing method provided in the aforementioned embodiments and are not further elaborated here.

[0153] The present application also provides a computer program product, comprising a computer program, which implements the steps of the above-mentioned report processing method when executed by a processor.

[0154] The computer program product provided in this application can address the technical issues of current report processing methods, which waste significant resources and reduce completion efficiency. Compared to the prior art, the beneficial effects of the computer program product provided in this application are the same as those of the report processing methods provided in the aforementioned embodiments, and are not further elaborated here.

[0155] The above description is only part of the embodiments of the present application and does not limit the patent scope of the present application. All equivalent structural transformations made by using the contents of the present application specification and drawings under the technical concept of the present application, or direct / indirect application in other related technical fields are included in the patent protection scope of the present application.

Claims

1. A report processing method, characterized in that: The method includes: In response to a report processing instruction triggered by a user, extracting configuration information of the report processing task from the report processing instruction; Determine the target cube model based on the dimension configuration and metric configuration in the configuration information; Based on the target cube model, the source data table obtained from the target database is processed to obtain a target report.

2. The method according to claim 1, wherein The dimension configuration includes dimension field configuration, the metric configuration includes metric field configuration and operation function configuration, and the step of determining the target cube model based on the dimension configuration and metric configuration in the configuration information includes: Based on the dimension field configuration, determining a target dimension field from the dimension fields of the source data table; Based on the metric field configuration and the operation function configuration, determining a target metric field from the metric fields of the source data table and a target operation function corresponding to the target metric field; The target cube model is determined based on the target dimension field, the target metric field and the target operation function.

3. The method according to claim 1, wherein The configuration information includes source data cycle configuration and report format configuration. The step of processing the source data table obtained from the target database based on the target cube model to obtain the target report includes: Based on the source data period configuration, the data within the source data period in the source data table is stored in the target cube model to obtain a target data set; Based on the target data set and the report format configuration, the target report in a corresponding format is generated.

4. The method according to claim 1, wherein The configuration information also includes generation and expiration time configuration, which includes an effective time point, an expiration time point, and a generation cycle. Before the step of processing the source data table obtained from the target database based on the target cube model to obtain the target report, the step further includes: Get the current time point; Every generation cycle, determining whether the current time point is after the validation time point and before the expiration time point; If so, the source data table obtained from the target database is processed based on the target cube model to obtain a target report.

5. The method according to claim 1, wherein The configuration information also includes sending configuration and email configuration. The email configuration includes an email receiving address. The sending configuration includes a sending cycle and a sending time point corresponding to the sending cycle. After the step of processing the source data table obtained from the target database based on the target cube model to obtain the target report, the step further includes: Get the current time point; Determining whether the current time point is the sending time point in the sending cycle; If so, the target report is sent to the email receiving address, wherein the email receiving address is one or more email addresses.

6. The method according to claim 1, wherein Before the step of extracting configuration information of the report processing task from the report processing instruction in response to the report processing instruction triggered by the user, the method further includes: In response to a user's selection operation, determining a source data table in a target database; Read the source data table and obtain the source data table fields; Determining, based on the field type of the source data table field, the dimension field and the metric field in the source data table field; The dimension fields and the metric fields are visually displayed to facilitate the user to configure the dimension fields and the metric fields.

7. A report processing device, characterized in that: The device comprises: A configuration acquisition module, configured to extract configuration information of a report processing task from a report processing instruction triggered by a user; A model determination module, configured to determine a target cube model based on the dimension configuration and metric configuration in the configuration information; The report processing module is used to process the source data table obtained from the target database based on the target cube model to obtain the target report.

8. A report processing device, characterized in that: The device includes: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program is configured to implement the steps of the report processing method according to any one of claims 1 to 6.

9. A storage medium, characterized in that: The storage medium is a computer-readable storage medium, and a computer program is stored on the storage medium. When the computer program is executed by a processor, the steps of the report processing method according to any one of claims 1 to 6 are implemented.

10. A computer program product, characterized in that The computer program product includes a computer program, and when the computer program is executed by a processor, the steps of the report processing method according to any one of claims 1 to 6 are implemented.

Images