Report-based data processing method, device, equipment and medium

Abstract

Embodiments of the present application provide a report-based data processing method, device and equipment and medium. The method comprises: obtaining a report to be filled with data; determining a target index structure in a preset index model corresponding to the report to be filled with data according to the report to be filled with data; wherein the preset index model comprises a plurality of index structures, and the target index structure indicates the logic of obtaining a target index parameter; obtaining the target index parameter from a data source corresponding to the preset index model according to the logic of obtaining the target index parameter indicated by the target index structure, filling the report to be filled with data, and obtaining a filled report. The method can improve the efficiency of report production.

Description

Technical Field

[0001] This application relates to the field of big data technology, and in particular to a data processing method, apparatus, device and medium based on reports. Background Technology

[0002] Visualized reports are an indispensable information technology tool for all types of enterprises in their production, operation, investment, and management processes. The ability to generate various types of visualized reports in a timely and accurate manner according to business needs has become a core requirement.

[0003] Currently, report creation requires designers to have database knowledge, which makes report creation more difficult and consequently reduces the efficiency of report creation. Summary of the Invention

[0004] This application provides a data processing method, apparatus, device, and medium based on reports to improve the efficiency of report production.

[0005] In a first aspect, embodiments of this application provide a data processing method based on reports, including:

[0006] Retrieve the report containing the data to be populated;

[0007] Based on the report containing the data to be filled, determine the target indicator structure in the preset indicator model corresponding to the report containing the data to be filled; wherein, the preset indicator model includes multiple indicator structures, and the target indicator structure indicates the data retrieval logic of the target indicator parameters;

[0008] According to the data retrieval logic of the target indicator parameters indicated by the target indicator structure, data is retrieved from the data source corresponding to the preset indicator model, and the report containing the data to be filled is used to obtain the filled report.

[0009] In one possible implementation, based on the report containing the data to be populated, determining the target indicator structure in a preset indicator model corresponding to the report containing the data to be populated includes:

[0010] For each cell in the report containing the data to be filled, the target indicator structure in the preset indicator model corresponding to the cell to be filled is determined from the preset indicator model.

[0011] The step of retrieving data from the data source corresponding to the preset indicator model according to the data retrieval logic of the target indicator parameters indicated by the target indicator structure, and filling the report of the data to be filled to obtain the filled report includes:

[0012] According to the data retrieval logic of the target indicator parameters indicated by the target indicator structure, data is retrieved from the data source corresponding to the preset indicator model and used to fill the cells to be filled; until all cells to be filled are filled, the filled report is obtained.

[0013] In one possible implementation, the target indicator structure indicates multiple dimensions and multiple measures of the target indicator parameters; for each cell to be filled in the report of the data to be filled, the target indicator structure in the preset indicator model corresponding to the cell to be filled is determined from the preset indicator model, including:

[0014] Determine the row and column names of the cell;

[0015] In the indicator structure included in the preset indicator model, the target indicator parameters that match the row name and column name of the cell are determined to obtain the initial target indicator structure.

[0016] Based on the initial target indicator structure, the target dimension information and target metric information of the target indicator parameters that match the row name and column name of the cell are determined to obtain the target indicator structure.

[0017] In one possible implementation, for each cell in the report containing the data to be filled, determining the target indicator structure in the preset indicator model corresponding to the cell to be filled, from the preset indicator model, includes:

[0018] Receive a trigger command from the user in the cell to be filled; wherein the trigger command includes a target indicator structure selected by the user, the target indicator structure includes target indicator parameters, and target dimension information and target measurement information of the target indicator parameters.

[0019] In one possible implementation, the method further includes:

[0020] Obtain an initial indicator model and at least one indicator parameter required for the business; wherein the indicator parameter is used to describe the business situation; the initial indicator model has a data source;

[0021] For each indicator parameter, data retrieval logic, dimension information, and measurement information are added to the indicator parameter to obtain the indicator structure of the indicator parameter;

[0022] The indicator structure is added to the initial indicator model to obtain the preset indicator model.

[0023] In one possible implementation, for each indicator parameter, data retrieval logic, dimension information, and measurement information are added to the indicator parameter to obtain the indicator structure of the indicator parameter, including:

[0024] For each indicator parameter, if the data retrieval logic of the indicator parameter is determined to be consistent with the data retrieval logic of the indicator parameter in the existing indicator structure in the indicator model, then the dimension information and measurement information of the indicator parameter in the existing indicator structure are adjusted according to the dimension information and measurement information of the indicator parameter.

[0025] If it is determined that the data retrieval logic of the indicator parameter overlaps with the data retrieval logic of the indicator parameter in the existing indicator structure in the indicator model, then the usage frequency of the indicator parameter is determined; based on the usage frequency, the data retrieval logic, dimension information, and measurement information of the indicator parameter are added to the indicator parameter to obtain the indicator structure of the indicator parameter; or, based on the usage frequency, the dimension information and measurement information of the indicator parameter are subjected to dimension transformation processing, and the processed dimension information and measurement information of the indicator parameter are added to the existing indicator structure.

[0026] If it is determined that the data retrieval logic of the indicator parameter is completely inconsistent with the data retrieval logic of the indicator parameter in the existing indicator structure in the indicator model, then the data retrieval logic, dimension information and measurement information of the indicator parameter are added to the indicator parameter to obtain the indicator structure of the indicator parameter.

[0027] In one possible implementation, the at least one indicator parameter includes a first indicator parameter, a second indicator parameter, and a third indicator parameter; wherein, the first indicator parameter represents an indivisible indicator parameter; the second indicator parameter represents an indicator parameter obtained by summing multiple first indicator parameters; and the third indicator parameter represents an indicator parameter obtained by multiplying or dividing the first indicator parameter and / or the second indicator parameter.

[0028] For each indicator parameter, data retrieval logic, dimension information, and measurement information are added to the indicator parameter to obtain the indicator structure of the indicator parameter, including:

[0029] For each first indicator parameter, add the data retrieval logic, dimension information and measurement information of the first indicator parameter to obtain the first indicator structure of the first indicator parameter;

[0030] For each second indicator parameter, based on the first indicator structure, the data retrieval logic, dimension information, and measurement information of the second indicator parameter are added to the second indicator parameter to obtain the second indicator structure of the second indicator parameter.

[0031] For each third indicator parameter, based on the first indicator structure and / or the second indicator structure, the data retrieval logic, dimension information, and measurement information of the third indicator parameter are added to the third indicator parameter to obtain the third indicator structure of the third indicator parameter.

[0032] Secondly, embodiments of this application provide a report-based data processing apparatus, including:

[0033] The retrieval module is used to retrieve reports containing data to be populated.

[0034] The determination module is used to determine the target indicator structure in a preset indicator model corresponding to the report containing the data to be filled, based on the report containing the data to be filled; wherein the preset indicator model includes multiple indicator structures, and the target indicator structure indicates the data retrieval logic of the target indicator parameters.

[0035] The filling module is used to retrieve data from the data source corresponding to the preset indicator model according to the data retrieval logic of the target indicator parameters indicated by the target indicator structure, and fill the report of the data to be filled to obtain the filled report.

[0036] Thirdly, embodiments of this application provide an electronic device, including: a memory and a processor;

[0037] The memory stores computer-executed instructions;

[0038] The processor executes computer execution instructions stored in the memory, causing the processor to perform the first aspect and / or various possible implementations of the first aspect as described above.

[0039] Fourthly, embodiments of this application provide a computer-readable storage medium storing computer-executable instructions, which, when executed by a processor, are used to implement the first aspect and / or various possible implementations of the first aspect.

[0040] Fifthly, embodiments of this application provide a computer program product, including a computer program that, when executed by a processor, implements the first aspect and / or various possible implementations of the first aspect.

[0041] The data processing method, apparatus, device, and medium based on reports provided in this application, for reports with data to be populated, utilize the data retrieval logic indicated by the indicator structure in a preset indicator model to retrieve data from the data source corresponding to the indicator model to populate the report, thus completing the report creation. In this way, report creators do not need to possess database knowledge; they only need to determine the indicator structure in the preset indicator model to populate the report with the data to be populated, reducing the difficulty of report creation and improving its efficiency. Simultaneously, the indicator structure in the preset indicator model can be reused, eliminating the need to code the data retrieval logic for each report creation. Attached Figure Description

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

[0043] Figure 1 A schematic diagram of a report provided in this application;

[0044] Figure 2 Flowchart of the report-based data processing method provided in this application Figure 1 ;

[0045] Figure 3 Flowchart of the report-based data processing method provided in this application Figure 2 ;

[0046] Figure 4 Flowchart of the report-based data processing method provided in this application Figure 3 ;

[0047] Figure 5 A schematic diagram of the structure of the report-based data processing device provided in this application;

[0048] Figure 6 A schematic diagram of the structure of the electronic device provided in this application.

[0049] The accompanying drawings illustrate specific embodiments of this application, which will be described in more detail below. These drawings and descriptions are not intended to limit the scope of the concept in any way, but rather to illustrate the concept of this application to those skilled in the art through reference to particular embodiments. Detailed Implementation

[0050] Exemplary embodiments will now be described in detail, examples of which are illustrated in the accompanying drawings. When the following description relates to the drawings, unless otherwise indicated, the same numbers in different drawings denote the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with some aspects of this application as detailed in the appended claims.

[0051] First, let me explain the terms used in this application:

[0052] Reports: These are data that are dynamically displayed using formats such as tables and charts.

[0053] Indicator model: refers to the collection and structure of various indicators used to measure, evaluate or monitor a specific area or activity.

[0054] Figure 1 This is a schematic diagram of a report provided in this application. (In conjunction with...) Figure 1 As shown in the report, in existing technologies, when designers create reports, for each cell, they need to combine the row and column names of that cell and use database languages ​​to retrieve data from the database to populate the cell. This method requires report designers to have at least a basic understanding of databases, which makes report creation more difficult and consequently less efficient.

[0055] The data processing method based on reports provided in this application uses a preset indicator model and the indicator structure within the model to indicate data retrieval logic. This allows for data retrieval and report population based on the indicator structure within the model, eliminating the need for database knowledge, thus reducing the difficulty and efficiency of report creation. It should be noted that the embodiments in this application only use financial statements as an example for illustration and do not limit the content of the reports.

[0056] refer to Figure 1 As shown, Figure 1 Items such as cash, bank deposits, other monetary funds, and internal deposits in the report can be used as indicators; currency and financial institutions can be used as dimensions; and deposit term, ending balance, and total can be considered as measures. Furthermore, by determining the indicator structure corresponding to each cell, the data retrieval logic indicated by that indicator structure can be used to retrieve data from the data source to populate that cell, completing the report creation process, reducing the difficulty of report creation, and improving report creation efficiency.

[0057] The subject of this application may be an electronic device with processing capabilities, such as a computer, laptop, server, etc., and this application does not limit it.

[0058] The technical solution of this application and how the technical solution of this application solves the above-mentioned technical problems are described in detail below with specific embodiments. These specific embodiments can be combined with each other, and the same or similar concepts or processes may not be described again in some embodiments. The embodiments of this application will be described below with reference to the accompanying drawings.

[0059] Figure 2 Flowchart of the report-based data processing method provided in this application Figure 1 ,like Figure 2 As shown, this embodiment first explains how to construct the indicator model, which includes:

[0060] S201. Obtain the initial indicator model and at least one indicator parameter required for the business.

[0061] For example, the above-mentioned indicator parameters are used to describe business conditions, and may be, for example, the aforementioned Figure 1 The parameters in the table shown, such as cash, bank deposits, other monetary funds, and internal deposits, are not limited in this application; their specific content is related to the business setup.

[0062] The aforementioned initial indicator model refers to an indicator model with pre-configured data sources, meaning that the initial indicator model has a data source. For example, the initial indicator model may have information such as model ID, model name, and data source identifier. The data source identifier can be information that uniquely identifies the data source, such as the data source ID, name, or address. This application does not limit this information. Furthermore, this application does not limit the form of the data source. For example, it can be in the form of a view, where the business data corresponding to the initial indicator model is aggregated into a single view; or it can be in the form of discrete data tables, depending on the model settings.

[0063] In one example, the electronic device can receive an initial indicator model configured by the user through a front-end display interface, or it can extract the initial indicator model from a database.

[0064] In one example, the electronic device may receive at least one indicator parameter required for the business input by the user through the front-end display interface, or it may extract at least one indicator parameter required for the business from the database; or it may communicate with other electronic devices to obtain at least one indicator parameter required for the business; or it may receive at least one indicator parameter required for the business imported by an external device, such as a USB flash drive.

[0065] In another example, an electronic device can use a large language model to extract at least one indicator parameter of the business data from each detailed table. For example, the indicator parameter can be extracted from the name of the detailed table. It should be noted that this application does not limit the type of large language model.

[0066] S202. For each indicator parameter, add data retrieval logic, dimension information, and measurement information to obtain the indicator structure of the indicator parameter.

[0067] For example, the aforementioned dimensional information is used to describe the classification and attributes of business data, and may include dimension names, dimension IDs, etc., to enable fine-grained division of the aforementioned indicator parameters, such as... Figure 1 The table shown includes information such as financial institutions and currencies. The aforementioned measurement information describes the measurement standards for business data and may include measurement names, measurement IDs, etc., for example... Figure 1 The deposit term in the table shown can be measured in different ways, such as 3 months, half a year, or one year. This measurement information can be used to describe business data under different measurement standards.

[0068] The data retrieval logic described above indicates the location of the indicator parameter in the data source. This logic can indicate not only the overall location of the indicator parameter in the data source, but also its location within each dimension and each metric. For example, consider the indicator parameter as... Figure 1 Taking "bank deposits" as an example, this data retrieval logic can indicate the position of the overall detailed table corresponding to the "bank deposits" indicator parameter in the data source. It can also indicate the position of the "bank deposits" indicator parameter in the data source under the "financial institution" dimension, and the position of the "bank deposits" indicator parameter in the data source under the "deposit term 1" metric.

[0069] The above indicator structure represents detailed information about the indicator parameters. This structure includes the parameter information, all dimensions of the indicator parameter, all measures of the indicator parameter, and the data retrieval logic. The parameter information includes the parameter name, parameter ID, etc. For each indicator structure, by selecting the dimension and measure information of the indicator parameter, the value of that indicator parameter under the set data retrieval logic can be determined.

[0070] In one example, an electronic device can receive configuration information from a user through a front-end display interface to obtain the indicator structure for each indicator parameter. In other words, the user can configure the dimension information, measurement information, and data retrieval logic for each indicator parameter through the front-end display interface.

[0071] In another example, for each indicator parameter, the electronic device can process the detailed table of the indicator parameter using a large language model, extract the dimension information and measurement information of the detailed table, and determine the data retrieval logic of the indicator parameter based on the position of the detailed table in the view, thereby obtaining the indicator structure of the indicator parameter.

[0072] When adding data retrieval logic, dimension information, and measurement information to each indicator parameter, deduplication can be performed to ensure that the indicator structure is not duplicated. In some possible implementations, for each indicator parameter, if it is determined that the data retrieval logic of the indicator parameter is consistent with the data retrieval logic of the indicator parameters in the existing indicator structure of the indicator model, then the dimension information and measurement information of the indicator parameter in the existing indicator structure are adjusted according to the dimension information and measurement information of the indicator parameter. For example, if the data retrieval logic of the indicator parameter to be added is consistent with the data retrieval logic of the existing indicator parameters, to avoid duplicate or contradictory indicators, the dimension information and measurement information of the indicator parameter to be added can be converted into the dimension information and measurement information of the existing indicator parameters and configured into the existing indicator structure. For example, if the indicator parameter to be added is "Bank A", this indicator parameter can be converted into a dimension value of the "Financial Institution" dimension in the existing indicator structure, for example, referring to... Figure 1 Since there are already three dimension values ​​"Bank 1, Bank 2 and Bank 3" under the "Financial Institutions" dimension, we can take the parameter "Bank A" as a dimension value of the "Financial Institutions" dimension.

[0073] If it is determined that the data retrieval logic of the indicator parameter overlaps with the data retrieval logic of the indicator parameter in the existing indicator structure in the indicator model, then the usage frequency of the indicator parameter is determined. Based on the usage frequency, the data retrieval logic, dimension information, and measurement information of the indicator parameter are added to the indicator parameter to obtain the indicator structure of the indicator parameter; or, based on the usage frequency, the dimension information and measurement information of the indicator parameter are subjected to dimension transformation processing, and the processed dimension information and measurement information of the indicator parameter are added to the existing indicator structure.

[0074] For example, if the data retrieval logic of the indicator parameter overlaps with the data retrieval logic of the indicator parameter in the existing indicator structure in the indicator model, the electronic device can determine the usage frequency of the indicator parameter. For example, it can count the data call data of the indicator parameter in the database to obtain the usage frequency of the indicator parameter. If it is determined that the usage frequency is greater than or equal to a preset threshold, the indicator parameter can be used as a new indicator structure, that is, the data retrieval logic, dimension information and measurement information of the indicator parameter are added to the indicator parameter to obtain the indicator structure of the indicator parameter. If it is determined that the usage frequency is less than the preset threshold, the indicator parameter is added to the existing indicator structure instead of being used as a new indicator structure. That is, the dimension information and measurement information of the indicator parameter are subjected to dimension transformation processing, and the processed dimension information and measurement information of the indicator parameter are added to the existing indicator structure.

[0075] If it is determined that the data retrieval logic of the indicator parameter is completely inconsistent with the data retrieval logic of the indicator parameter in the existing indicator structure in the indicator model, then the data retrieval logic, dimension information and measurement information of the indicator parameter are added to the indicator parameter to obtain the indicator structure of the indicator parameter.

[0076] Optionally, when configuring each indicator parameter, after receiving the data retrieval logic input by the user, the electronic device performs a deduplication judgment between the data retrieval logic of the indicator parameter and the data retrieval logic in the existing indicator structure. If they are consistent or overlap, the overlapping part can be output to the front-end display interface for the user to select. The device also receives the dimension conversion information selected by the user and converts the dimension information and measurement information of the indicator parameter into the existing indicator structure.

[0077] In some possible implementations, the aforementioned indicator parameters may include multiple types. For example, at least one indicator parameter may include a first indicator parameter, a second indicator parameter, and a third indicator parameter. The first indicator parameter represents an indivisible indicator parameter, i.e., an atomic indicator parameter, or data that can be directly extracted from the data source without computation. The second indicator parameter represents an indicator parameter obtained by aggregating multiple first indicator parameters, i.e., a parameter obtained after performing addition and subtraction operations on the first indicator parameters. The third indicator parameter represents an indicator parameter obtained by multiplying and / or dividing the first indicator parameter and / or the second indicator parameter.

[0078] In this implementation, electronic devices can perform different processing for different types of indicator parameters.

[0079] For example, the first indicator parameter can be processed first. That is, for each first indicator parameter, the data retrieval logic, dimension information and measurement information of the first indicator parameter are added to the first indicator parameter to obtain the first indicator structure of the first indicator parameter.

[0080] The second indicator parameters are then processed. Specifically, for each second indicator parameter, based on the first indicator structure, its data retrieval logic, dimension information, and measurement information are added to it, resulting in the second indicator structure. It should be understood that the second indicator parameter is obtained by adding or subtracting from the first indicator parameter. Therefore, the data retrieval logic, dimension information, and measurement information of the second indicator parameter can be obtained based on the first indicator structure. For example, the second indicator parameter could be... Figure 1 The "internal deposits" parameter in the table shown is the sum of three first-level parameters (cash, bank deposits, and other monetary funds). Therefore, the second-level parameter's dimensionality and measurement information can be derived from the dimensionality and measurement information of these three first-level parameters. For example, the data retrieval logic, dimensionality, and measurement information of the second-level parameter can be obtained by the electronic device receiving the user's configuration information, or the electronic device can input the first-level indicator structure and the calculation logic between the second-level and first-level parameters into a large language model, and output the data retrieval logic, dimensionality, and measurement information of the second-level parameter.

[0081] For each third indicator parameter, based on the first indicator structure and / or the second indicator structure, the data retrieval logic, dimension information, and measurement information of the third indicator parameter are added to it to obtain the third indicator structure of the third indicator parameter. This step is similar in principle to the steps of the second indicator structure described above, and will not be repeated here.

[0082] S203. Add the indicator structure to the initial indicator model to obtain the preset indicator model.

[0083] For example, a mapping is established between each indicator structure and the initial indicator model to obtain the preset indicator model. For instance, the ID or name of each indicator structure is added to the indicator list in the initial indicator model to obtain the preset indicator model.

[0084] The report-based data processing method provided in this application adds data retrieval logic, dimension information, and measurement information to the indicator parameters of business data to obtain an indicator structure. This indicator structure is then added to an initial indicator model configured with a data source to obtain a preset indicator model. In this way, electronic devices can establish an indicator model with logical consistency and comprehensive information, facilitating subsequent report creation.

[0085] It should be noted that the electronic device that performs the indicator model construction in the above embodiments may be the same as or different from the electronic device that performs report filling in the following embodiments, and this application does not limit it here.

[0086] Figure 3Flowchart of the report-based data processing method provided in this application Figure 2 ,like Figure 3 As shown, in this embodiment... Figure 2 Based on the examples, a report-based data processing method is described, which includes:

[0087] S301. Obtain the report containing the data to be filled.

[0088] For example, the report containing the data to be populated represents a report to be created. This report includes preset row and column names, as shown in the reference. Figure 1 The table shown.

[0089] In one example, an electronic device can receive a form with data to be filled by the user, a form with data to be filled sent by other electronic devices, or a form with data to be filled imported by an external device, such as a USB flash drive.

[0090] It should be noted that this application does not limit the content or size of the table to be filled with data.

[0091] S302. Based on the report containing the data to be filled, determine the target indicator structure in the preset indicator model corresponding to the report containing the data to be filled.

[0092] For example, the above-mentioned preset indicator model includes multiple indicator structures. The target indicator structure indicates the data acquisition logic of the target indicator parameters. The target indicator structure can also indicate the target dimension information and target measurement information of the target indicator parameters.

[0093] In one example, for each cell in the report containing the data to be populated, the electronic device can receive the target indicator structure corresponding to each cell input by the user. For instance, the electronic device can display multiple indicator structures with preset indicator models through a front-end display interface, and then receive the target indicator structure selected by the user as instructed by the user's trigger command. In other words, the user can select the target dimension information and target metric information of the target indicator parameters in the indicator structure corresponding to each cell, thereby obtaining the target indicator structure.

[0094] Specifically, the electronic device can receive a trigger command from the user in the cell to be filled; the trigger command includes the target indicator structure selected by the user, the target indicator structure includes target indicator parameters, and the target dimension information and target measurement information of the target indicator parameters.

[0095] In another example, for each cell in the report containing the data to be filled, the electronic device can match the cell's column name and row name with the indicator parameters of the indicator structure in the preset indicator model, as well as the dimension information and measurement information of the indicator parameters, to obtain the target indicator structure.

[0096] S303. Based on the data retrieval logic of the target indicator parameters indicated by the target indicator structure, retrieve data from the data source corresponding to the preset indicator model, fill the report with the data to be filled, and obtain the filled report.

[0097] For example, the above-mentioned preset indicator model is configured with a data source. Therefore, the electronic device can retrieve data from the data source according to the data retrieval logic of the target indicator parameters indicated by the target indicator structure, fill the report, obtain the filled report, and complete the report production.

[0098] The report-based data processing method provided in this application, for a report with data to be populated, utilizes the data retrieval logic indicated by the indicator structure in a preset indicator model to retrieve data from the data source corresponding to the indicator model and populate the report. In this way, report creators do not need database knowledge; they only need to determine the indicator structure in the preset indicator model to populate the report with the data to be populated, reducing the difficulty of report creation and improving its efficiency. Furthermore, the indicator structure in the preset indicator model can be reused, eliminating the need to code the data retrieval logic for each report creation.

[0099] Figure 4 Flowchart of the report-based data processing method provided in this application Figure 3 ,like Figure 4 As shown, in this embodiment... Figure 3 Based on the examples, a detailed description of the report-based data processing method is provided, which includes:

[0100] S401, Retrieve the report containing the data to be filled.

[0101] It should be noted that this step is similar to the aforementioned step S301, and will not be repeated here.

[0102] S402. For each cell in the report containing the data to be filled, determine the target indicator structure in the preset indicator model corresponding to the cell to be filled from the preset indicator model.

[0103] For example, the cells to be filled mentioned above represent cells that need to be filled with data. For instance, an electronic device can determine whether there is data in each cell, and if it is determined that there is no data, then it is designated as a cell to be filled.

[0104] In some possible implementations, the electronic device can first determine the row and column names of the cell; in the indicator structure included in the preset indicator model, determine the target indicator parameters that match the row and column names of the cell to obtain the initial target indicator structure; and based on the initial target indicator structure, determine the target dimension information and target measurement information of the target indicator parameters that match the row and column names of the cell to obtain the target indicator structure.

[0105] For example, electronic devices can calculate the semantic similarity between the row and column names of a cell and the indicator parameters of each indicator structure in the indicator model. The indicator parameter with the highest semantic similarity is taken as the target indicator parameter. Then, from the indicator structure corresponding to the target indicator parameter, the dimension information and measurement information with the highest similarity to the row and column names of the cell are determined to obtain the target indicator structure.

[0106] Alternatively, the electronic device can use the preset indicator model as an external knowledge base for the large language model, input the report of the data to be filled into the large language model, and the large language model can match each cell in the report of the data to be filled with the indicator structure in the preset indicator model to obtain the target indicator structure corresponding to the cell.

[0107] S403. Based on the data retrieval logic of the target indicator parameters indicated by the target indicator structure, retrieve data from the data source corresponding to the preset indicator model and fill the cells to be filled; until all cells to be filled are filled, the filled report is obtained.

[0108] It should be noted that this step is similar to the aforementioned step S303, and will not be repeated here.

[0109] The report-based data processing method provided in this application allows an electronic device to automatically determine the target indicator structure in a preset indicator model that matches each cell to be filled. Then, it can automatically retrieve data from the data source using the data retrieval logic indicated by the target indicator structure to fill the cell, continuing this process until all cells are filled, thus completing the report generation. This method enables automated report generation for reports containing data to be filled, improving report generation efficiency.

[0110] Figure 5 A schematic diagram of the structure of the report-based data processing device provided in this application is shown below. Figure 5 As shown, the report-based data processing device 500 provided in this embodiment includes:

[0111] Module 501 is used to obtain the report containing the data to be populated.

[0112] The determining module 502 is used to determine the target indicator structure in a preset indicator model corresponding to the report of the data to be filled, based on the report of the data to be filled; wherein, the preset indicator model includes multiple indicator structures, and the target indicator structure indicates the data retrieval logic of the target indicator parameters.

[0113] The filling module 503 is used to retrieve data from the data source corresponding to the preset indicator model according to the data retrieval logic of the target indicator parameters indicated by the target indicator structure, fill the report of the data to be filled, and obtain the filled report.

[0114] In one possible implementation, module 502 is specifically used for:

[0115] For each cell in the report containing the data to be filled, the target indicator structure in the preset indicator model corresponding to the cell to be filled is determined from the preset indicator model.

[0116] Fill module 503 is specifically used for:

[0117] According to the data retrieval logic of the target indicator parameters indicated by the target indicator structure, data is retrieved from the data source corresponding to the preset indicator model and used to fill the cells to be filled; until all cells to be filled are filled, the filled report is obtained.

[0118] In one possible implementation, module 502 is specifically used for:

[0119] Determine the row and column names of the cell;

[0120] In the indicator structure included in the preset indicator model, the target indicator parameters that match the row name and column name of the cell are determined to obtain the initial target indicator structure.

[0121] Based on the initial target indicator structure, the target dimension information and target metric information of the target indicator parameters that match the row name and column name of the cell are determined to obtain the target indicator structure.

[0122] In one possible implementation, module 502 is specifically used for:

[0123] Receive a trigger command from the user in the cell to be filled; wherein the trigger command includes a target indicator structure selected by the user, the target indicator structure includes target indicator parameters, and target dimension information and target measurement information of the target indicator parameters.

[0124] In one possible implementation, the device further includes a building module for:

[0125] Obtain an initial indicator model and at least one indicator parameter required for the business; wherein the indicator parameter is used to describe the business situation; the initial indicator model has a data source;

[0126] For each indicator parameter, data retrieval logic, dimension information, and measurement information are added to the indicator parameter to obtain the indicator structure of the indicator parameter;

[0127] The indicator structure is added to the initial indicator model to obtain the preset indicator model.

[0128] In one possible implementation, the building module is specifically used for:

[0129] For each indicator parameter, if the data retrieval logic of the indicator parameter is determined to be consistent with the data retrieval logic of the indicator parameter in the existing indicator structure in the indicator model, then the dimension information and measurement information of the indicator parameter in the existing indicator structure are adjusted according to the dimension information and measurement information of the indicator parameter.

[0130] If it is determined that the data retrieval logic of the indicator parameter overlaps with the data retrieval logic of the indicator parameter in the existing indicator structure in the indicator model, then the usage frequency of the indicator parameter is determined; based on the usage frequency, the data retrieval logic, dimension information, and measurement information of the indicator parameter are added to the indicator parameter to obtain the indicator structure of the indicator parameter; or, based on the usage frequency, the dimension information and measurement information of the indicator parameter are subjected to dimension transformation processing, and the processed dimension information and measurement information of the indicator parameter are added to the existing indicator structure.

[0131] If it is determined that the data retrieval logic of the indicator parameter is completely inconsistent with the data retrieval logic of the indicator parameter in the existing indicator structure in the indicator model, then the data retrieval logic, dimension information and measurement information of the indicator parameter are added to the indicator parameter to obtain the indicator structure of the indicator parameter.

[0132] In one possible implementation, the at least one indicator parameter includes a first indicator parameter, a second indicator parameter, and a third indicator parameter; wherein, the first indicator parameter represents an indivisible indicator parameter; the second indicator parameter represents an indicator parameter obtained by summing multiple first indicator parameters; and the third indicator parameter represents an indicator parameter obtained by multiplying or dividing the first indicator parameter and / or the second indicator parameter.

[0133] Build modules, specifically used for:

[0134] For each first indicator parameter, add the data retrieval logic, dimension information and measurement information of the first indicator parameter to obtain the first indicator structure of the first indicator parameter;

[0135] For each second indicator parameter, based on the first indicator structure, the data retrieval logic, dimension information, and measurement information of the second indicator parameter are added to the second indicator parameter to obtain the second indicator structure of the second indicator parameter.

[0136] For each third indicator parameter, based on the first indicator structure and / or the second indicator structure, the data retrieval logic, dimension information, and measurement information of the third indicator parameter are added to the third indicator parameter to obtain the third indicator structure of the third indicator parameter.

[0137] The report-based data processing device provided in this embodiment can execute the methods provided in the above method embodiments. Its implementation principle and technical effect are similar, and will not be described in detail here.

[0138] Figure 6 A schematic diagram of the structure of the electronic device provided in this application. Figure 6 As shown, the electronic device 600 provided in this embodiment includes at least one processor 601 and a memory 602. Optionally, the device 600 further includes a communication component 603. The processor 601, memory 602, and communication component 603 are connected via a bus 604.

[0139] In a specific implementation, at least one processor 601 executes computer execution instructions stored in memory 602, causing at least one processor 601 to perform the above-described method.

[0140] The specific implementation process of processor 601 can be found in the above method embodiments, and its implementation principle and technical effect are similar. It will not be repeated here.

[0141] In the above embodiments, it should be understood that the processor can be a Central Processing Unit (CPU), or other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), etc. The general-purpose processor can be a microprocessor or any conventional processor. The steps of the method disclosed in this invention can be directly implemented by a hardware processor, or implemented by a combination of hardware and software modules within the processor.

[0142] The memory may include random access memory (RAM) and may also include non-volatile memory (NVM), such as at least one disk storage device.

[0143] The bus can be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, or an Extended Industry Standard Architecture (EISA) bus, etc. Buses can be categorized as address buses, data buses, control buses, etc. For ease of illustration, the buses shown in the accompanying drawings are not limited to a single bus or a single type of bus.

[0144] This application also provides a computer program product, including a computer program that, when executed by a processor, implements the above-described method.

[0145] This application also provides a computer-readable storage medium storing computer-executable instructions, which, when executed by a processor, implement the above-described method.

[0146] The aforementioned readable storage medium can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic storage, flash memory, magnetic disk, or optical disk. The readable storage medium can be any available medium accessible to a general-purpose or special-purpose computer.

[0147] An exemplary readable storage medium is coupled to a processor, enabling the processor to read information from and write information to the readable storage medium. Of course, the readable storage medium can also be a component of the processor. The processor and the readable storage medium can reside in an Application Specific Integrated Circuit (ASIC). Alternatively, the processor and the readable storage medium can exist as discrete components in the device.

[0148] The division of units is merely a logical functional division; in actual implementation, there may be other division methods. For example, multiple units or components may be combined or integrated into another system, or some features may be ignored or not executed. Furthermore, the coupling or direct coupling or communication connection shown or discussed may be indirect coupling or communication connection through some interfaces, devices, or units, and may be electrical, mechanical, or other forms.

[0149] The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the units can be selected to achieve the purpose of this embodiment according to actual needs.

[0150] In addition, the functional units in the various embodiments of the present invention can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit.

[0151] If a function is implemented as a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of this invention, or the part that contributes to the prior art, or a part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods of the various embodiments of this invention. The aforementioned storage medium includes various media capable of storing program code, such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.

[0152] Those skilled in the art will understand that all or part of the steps of the above-described method embodiments can be implemented by hardware related to program instructions. The aforementioned program can be stored in a computer-readable storage medium. When executed, the program performs the steps of the above-described method embodiments; and the aforementioned storage medium includes various media capable of storing program code, such as ROM, RAM, magnetic disks, or optical disks.

[0153] Finally, it should be noted that other embodiments of the invention will readily occur to those skilled in the art upon consideration of the specification and practice of the invention disclosed herein. This invention is intended to cover any variations, uses, or adaptations of the invention that follow the general principles of the invention and include common knowledge or customary techniques in the art not disclosed herein, and is not limited to the precise structures described above and shown in the accompanying drawings, and various modifications and changes can be made without departing from its scope. The scope of the invention is limited only by the appended claims.

Claims

1. A data processing method based on reports, characterized in that, include: Retrieve the report containing the data to be populated; Based on the report containing the data to be filled, determine the target indicator structure in the preset indicator model corresponding to the report containing the data to be filled; wherein, the preset indicator model includes multiple indicator structures, and the target indicator structure indicates the data retrieval logic of the target indicator parameters; According to the data retrieval logic of the target indicator parameters indicated by the target indicator structure, data is retrieved from the data source corresponding to the preset indicator model, and the report containing the data to be filled is used to obtain the filled report.

2. The method according to claim 1, characterized in that, Based on the report containing the data to be populated, determine the target indicator structure in the preset indicator model corresponding to the report containing the data to be populated, including: For each cell in the report containing the data to be filled, the target indicator structure in the preset indicator model corresponding to the cell to be filled is determined from the preset indicator model. The step of retrieving data from the data source corresponding to the preset indicator model according to the data retrieval logic of the target indicator parameters indicated by the target indicator structure, and filling the report of the data to be filled to obtain the filled report includes: According to the data retrieval logic of the target indicator parameters indicated by the target indicator structure, data is retrieved from the data source corresponding to the preset indicator model and used to fill the cells to be filled; until all cells to be filled are filled, the filled report is obtained.

3. The method according to claim 2, characterized in that, The target indicator structure indicates multiple dimensions and multiple measures of the target indicator parameters; for each cell to be filled in the report of the data to be filled, the target indicator structure in the preset indicator model corresponding to the cell to be filled is determined from the preset indicator model, including: Determine the row and column names of the cell; In the indicator structure included in the preset indicator model, target indicator parameters that match the row name and column name of the cell are determined to obtain the initial target indicator structure. Based on the initial target indicator structure, the target dimension information and target metric information of the target indicator parameters that match the row name and column name of the cell are determined to obtain the target indicator structure.

4. The method according to claim 2, characterized in that, For each cell in the report containing the data to be filled, the method involves determining the target indicator structure within the preset indicator model corresponding to that cell, from the preset indicator model, including: Receive a trigger command from the user in the cell to be filled; wherein the trigger command includes a target indicator structure selected by the user, the target indicator structure includes target indicator parameters, and target dimension information and target measurement information of the target indicator parameters.

5. The method according to any one of claims 1-4, characterized in that, The method further includes: Obtain an initial indicator model and at least one indicator parameter required for the business; wherein the indicator parameter is used to describe the business situation; the initial indicator model has a data source; For each indicator parameter, data retrieval logic, dimension information, and measurement information are added to the indicator parameter to obtain the indicator structure of the indicator parameter; The indicator structure is added to the initial indicator model to obtain the preset indicator model.

6. The method according to claim 5, characterized in that, For each indicator parameter, data retrieval logic, dimension information, and measurement information are added to the indicator parameter to obtain the indicator structure of the indicator parameter, including: For each indicator parameter, if the data retrieval logic of the indicator parameter is determined to be consistent with the data retrieval logic of the indicator parameter in the existing indicator structure in the indicator model, then the dimension information and measurement information of the indicator parameter in the existing indicator structure are adjusted according to the dimension information and measurement information of the indicator parameter. If it is determined that the data retrieval logic of the indicator parameter overlaps with the data retrieval logic of the indicator parameter in the existing indicator structure in the indicator model, then the usage frequency of the indicator parameter is determined; based on the usage frequency, the data retrieval logic, dimension information, and measurement information of the indicator parameter are added to the indicator parameter to obtain the indicator structure of the indicator parameter; or, based on the usage frequency, the dimension information and measurement information of the indicator parameter are subjected to dimension transformation processing, and the processed dimension information and measurement information of the indicator parameter are added to the existing indicator structure. If it is determined that the data retrieval logic of the indicator parameter is completely inconsistent with the data retrieval logic of the indicator parameter in the existing indicator structure in the indicator model, then the data retrieval logic, dimension information and measurement information of the indicator parameter are added to the indicator parameter to obtain the indicator structure of the indicator parameter.

7. The method according to claim 5, characterized in that, The at least one indicator parameter includes a first indicator parameter, a second indicator parameter, and a third indicator parameter; wherein, the first indicator parameter represents an indivisible indicator parameter; the second indicator parameter represents an indicator parameter obtained by summing multiple first indicator parameters; and the third indicator parameter represents an indicator parameter obtained by multiplying or dividing the first indicator parameter and / or the second indicator parameter. For each indicator parameter, data retrieval logic, dimension information, and measurement information are added to the indicator parameter to obtain the indicator structure of the indicator parameter, including: For each first indicator parameter, add the data retrieval logic, dimension information and measurement information of the first indicator parameter to obtain the first indicator structure of the first indicator parameter; For each second indicator parameter, based on the first indicator structure, the data retrieval logic, dimension information, and measurement information of the second indicator parameter are added to the second indicator parameter to obtain the second indicator structure of the second indicator parameter; For each third indicator parameter, based on the first indicator structure and / or the second indicator structure, the data retrieval logic, dimension information, and measurement information of the third indicator parameter are added to the third indicator parameter to obtain the third indicator structure of the third indicator parameter.

8. A report-based data processing device, characterized in that, include: The retrieval module is used to retrieve reports containing data to be populated. The determination module is used to determine the target indicator structure in a preset indicator model corresponding to the report containing the data to be filled, based on the report containing the data to be filled; wherein the preset indicator model includes multiple indicator structures, and the target indicator structure indicates the data retrieval logic of the target indicator parameters. The filling module is used to retrieve data from the data source corresponding to the preset indicator model according to the data retrieval logic of the target indicator parameters indicated by the target indicator structure, and fill the report of the data to be filled to obtain the filled report.

9. An electronic device, characterized in that, include: Memory, processor; The memory stores computer-executed instructions; The processor executes computer execution instructions stored in the memory, causing the processor to perform the method as described in any one of claims 1-7.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer-executable instructions, which, when executed by a processor, are used to implement the method as described in any one of claims 1-7.

Images