Report data acquisition method, report configuration method, device and computer equipment

Abstract

The present specification relates to the field of computer technology, and in particular to a report data retrieval method, report configuration method, device and computer equipment. The report data retrieval method includes: receiving a data retrieval request, the data retrieval request includes a report identifier, and the report identifier is used to identify the report; obtaining data retrieval information of an indicator cell in the report, the data retrieval information is obtained by configuring a business model, the data retrieval information is used to indicate business data, and the business model is used to indicate calculation logic; using the calculation logic indicated by the business model, the business data indicated by the data retrieval information is calculated; and the calculated indicator data is fed back so that the indicator data is filled into the indicator cell. The embodiments of the present specification can simplify the report configuration process and improve the accuracy and efficiency of report data retrieval.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a report acquisition method, a report configuration method, a device and a computer device. Background Art

[0002] With the evolution of enterprise informatization and business systems, enterprises are increasingly relying on data to make decisions. Reports, as a carrier of data, have been widely used. Report data extraction refers to extracting the required business data from the data source to fill in the cells.

[0003] In the related art, technicians configure data extraction formulas for reports according to business requirements. In the process of extracting data from reports, according to the configured data extraction formulas, required business data is extracted from the data source to be filled into cells.

[0004] In the above-mentioned related technologies, technicians need to master the skills of writing data extraction formulas, and then write data extraction formulas according to business needs, which has high learning and implementation costs. In addition, the report configuration process is relatively complicated and prone to errors. Summary of the invention

[0005] The embodiments of the present specification provide a report data acquisition method, a report configuration method, an apparatus, and a computer device, which are used to simplify the report configuration process and improve the accuracy and efficiency of report data acquisition.

[0006] The embodiment of this specification provides a report configuration method, including:

[0007] Displaying a report to be configured, wherein the report includes a cell to be configured;

[0008] In response to a configuration operation on a cell, a configuration interface is displayed, wherein the configuration interface includes one or more business models, and the business model is used to indicate a calculation logic of business data;

[0009] Acquire the target business model selected in the configuration interface;

[0010] Displaying parameters of the target business model on the configuration interface;

[0011] Obtaining parameter values ​​entered in the configuration interface;

[0012] According to the parameter value, the cell data acquisition information is determined, and the data acquisition information is used to indicate the business data.

[0013] The embodiment of this specification also provides a report data acquisition method, including:

[0014] receiving a data retrieval request, wherein the data retrieval request includes a report identifier, and the report identifier is used to identify a report;

[0015] Acquire data acquisition information of an indicator cell in the report, wherein the data acquisition information is obtained by configuring a business model, the data acquisition information is used to indicate business data, and the business model is used to indicate calculation logic;

[0016] Using the calculation logic indicated by the business model, the business data indicated by the data acquisition information is calculated;

[0017] Feedback the calculated indicator data so that the indicator data can be filled into the indicator cell.

[0018] The embodiment of this specification also provides a report configuration device, including:

[0019] A first display unit, used to display a report to be configured, wherein the report includes a cell to be configured;

[0020] A second display unit, configured to display a configuration interface in response to a configuration operation on a cell, wherein the configuration interface includes one or more business models;

[0021] A first acquisition unit, configured to acquire a target business model selected on the configuration interface;

[0022] A third display unit, configured to display parameters of the target business model on the configuration interface;

[0023] A second acquisition unit, used to acquire a parameter value input in the configuration interface;

[0024] Determine the cell, which is used to determine the cell data information based on the parameter value.

[0025] The embodiment of this specification also provides a report data acquisition device, including:

[0026] A receiving unit, configured to receive a data acquisition request, wherein the data acquisition request includes a report identifier, and the report identifier is used to identify a report;

[0027] An acquisition unit, used for acquiring data acquisition information of an indicator cell in the report, wherein the data acquisition information is obtained by configuring a business model, the data acquisition information is used to indicate business data, and the business model is used to indicate calculation logic;

[0028] A calculation unit, used to calculate the business data indicated by the data acquisition information using the calculation logic indicated by the business model;

[0029] The feedback unit is used to feed back the calculated indicator data so as to fill the indicator data into the indicator cell.

[0030] The embodiments of the present specification also provide a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the above-mentioned report acquisition method and / or the above-mentioned report configuration method when executing the computer program.

[0031] The embodiments of the present specification also provide a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the above-mentioned report acquisition method and / or the above-mentioned report configuration method are implemented.

[0032] The embodiments of this specification also provide a computer program product, which includes a computer program. When the computer program is executed by a processor, the above-mentioned report acquisition method and / or the above-mentioned report configuration method are implemented.

[0033] The technical solution of the embodiment of this specification can receive a data acquisition request, the data acquisition request includes a report identifier, and the report identifier is used to identify the report; the data acquisition information of the indicator cell in the report can be obtained, the data acquisition information is obtained by configuring the business model, the data acquisition information is used to indicate the business data, and the business model is used to indicate the calculation logic; the business data indicated by the data acquisition information can be calculated using the calculation logic indicated by the business model; the calculated indicator data can be fed back so that the indicator data is filled into the indicator cell. Thus, the data acquisition information of this specification can be obtained by configuring the business model, thereby avoiding the technical personnel from writing complex data acquisition formulas according to business needs, and can simplify the configuration process of the report. In addition, the business model is pre-set and encapsulates the calculation logic of the business data. The data acquisition information is used to indicate the business data involved in the calculation. Thus, after receiving the data acquisition request, the specific business data can be accurately located through the data acquisition information, and the located business data can be calculated through the calculation logic indicated by the business model corresponding to the data acquisition information, thereby obtaining the indicator data. This improves the calculation efficiency of the indicator data and reduces the occurrence of errors. BRIEF DESCRIPTION OF THE DRAWINGS

[0034] In order to more clearly illustrate the embodiments of this specification or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. The drawings described below are only some embodiments recorded in this specification. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0035] Figure 1 This is a flow chart of a report data acquisition method in an embodiment of this specification;

[0036] Figure 2This is a schematic diagram of the report data acquisition process in the embodiment of this specification;

[0037] Figure 3 This is a flowchart of a report configuration method in an embodiment of this specification;

[0038] Figure 4 A schematic diagram of a configuration interface in an embodiment of this specification;

[0039] Figure 5 This is a structural diagram of a report acquisition device in an embodiment of this specification;

[0040] Figure 6 This is a schematic diagram of the structure of the report configuration device in the embodiment of this specification. DETAILED DESCRIPTION

[0041] The technical solutions in the embodiments of this specification will be clearly and completely described below in conjunction with the drawings in the embodiments of this specification. Obviously, the described embodiments are only part of the embodiments of this specification, rather than all of the embodiments. The specific embodiments described herein are only used to explain the present disclosure, rather than to limit the present disclosure. Based on the described embodiments of the present disclosure, all other embodiments obtained by those of ordinary skill in the art are within the scope of protection of the present disclosure. In addition, relational terms such as "first" and "second" are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations.

[0042] For example, a business requirement is "to extract the current year, current month, and the ending balance in the base currency of accounts greater than or equal to 1001 and less than 1003". The technicians use their own formula writing skills to write the formula ZW(YE,"1001:1003") according to the business requirement. For another example, a business requirement is "to obtain the current year, current accounting period, account 1122, and the ending balance in the base currency of the "department" auxiliary code exactly equal to 010 from the current unit". The technicians use their own formula writing skills to write the formula ZFZ(YE,1122,"<department>@=010") according to the business requirement.

[0043] Since technical personnel need to master the skills of writing data extraction formulas and then write data extraction formulas according to business needs, the learning cost and implementation cost are relatively high. In addition, errors are prone to occur during the process of formula writing. In addition, it is difficult for business personnel to understand the meaning of the data extraction formulas written by technical personnel from a business perspective. In this way, if an error occurs in the process of extracting business data using the data extraction formula, it is difficult for business personnel to identify the cause of the error.

[0044] The embodiment of this specification provides a report processing system. The report processing system may include a terminal device, a business server and a database server. The terminal device may be a user-oriented device, including but not limited to a smart phone, a desktop computer, a laptop computer, etc. The business server may be a backend device, specifically a server, or a distributed server cluster including multiple servers. The database server may be a backend device, specifically a server, or a server cluster including multiple servers.

[0045] In some embodiments, the terminal device can configure the data acquisition information for the cells in the report in a visual manner. The terminal device can configure the data acquisition information for the cells based on one or more preset business models. Specifically, the terminal device can display the report to be configured, and the report includes the cells to be configured; in response to the configuration operation for the cell, the configuration interface can be displayed, and the configuration interface includes multiple business models; the target business model selected in the configuration interface can be obtained; the parameters of the target business model can be displayed in the configuration interface; the parameter value entered in the configuration interface can be obtained; and the data acquisition information of the cell can be determined based on the parameter value. The terminal device can send the data acquisition information and the report identifier to the business server. The business server can receive the data acquisition information and the report identifier; the data acquisition information can be stored in the configuration information set corresponding to the report identifier.

[0046] After configuring the data acquisition information for the cells in the report in a visual manner, the terminal device can use the report as the report to be acquired, and can display the report to be acquired; and can send a data acquisition request for the report to the business server. The business server can receive the data acquisition request, and the data acquisition request includes a report identifier, and the report identifier is used to identify the report; the data acquisition information of the indicator cell in the report can be obtained, and the data acquisition information is obtained by configuring the business model, and the data acquisition information is used to indicate the business data, and the business model is used to indicate the calculation logic; the business data indicated by the data acquisition information can be calculated using the calculation logic indicated by the business model; and the calculated indicator data can be fed back to the terminal device. The terminal device can receive the indicator data; and the indicator data can be filled into the indicator cell.

[0047] One or more source data tables are stored in the database server. Each source data table includes one or more fields. Each source data table stores one or more business data. The above-mentioned data acquisition information can indicate the business data in the source data table. The business data includes but is not limited to financial data, sales data, consumption data, transaction data, etc.

[0048] See also Figure 1 and Figure 2The embodiment of this specification provides a method for obtaining data from a report. The method for obtaining data from a report can be applied to a business server. The method for obtaining data from a report can include the following steps.

[0049] Step 11: Receive a data retrieval request, wherein the data retrieval request includes a report identifier, and the report identifier is used to identify the report.

[0050] In some embodiments, the terminal device may send a data retrieval request to the business server. The business server may receive the data retrieval request. The data retrieval request may include one or more report identifiers, and the report identifier is used to identify the report. For example, the report identifier may include the name and number of the report. Of course, the data retrieval request may also include other information. For example, the data retrieval request may also include a screening condition. The screening condition is used to filter business data. For example, the screening condition may include a time screening condition, and the time screening condition may include a time interval.

[0051] In some embodiments, the terminal device may display a report interface. The report interface includes one or more reports to be retrieved. The report interface includes a data retrieval control. The business personnel may operate the data retrieval control, such as clicking the data retrieval control. After detecting the operation on the data retrieval control, the terminal device may display a report range selection interface. The business personnel may enter one or more report identifiers in the report range selection interface. For example, the report range selection interface includes one or more report identifiers to be selected. The user may select a report identifier in the report range selection interface. The terminal device may receive the report identifier entered by the business personnel; and may send a data retrieval request to the business server. The data retrieval request includes one or more report identifiers.

[0052] Step 12: Obtain data acquisition information of the indicator cell in the report, wherein the data acquisition information is obtained by configuring the business model, the data acquisition information is used to indicate business data, and the business model is used to indicate calculation logic.

[0053] In some embodiments, a report may include one or more cells. A report may include one or more indicator cells. An indicator cell is a cell configured with data fetching information. The business server may fetch data from a source data table of a database server using the data fetching information of the indicator cell to obtain business data; by calculating the business data, the indicator data may be obtained. The indicator data may be filled into the indicator cell of the report. In this way, the indicator data may be displayed in the indicator cell. The indicator data may be numerical data. For example, the indicator data may be a balance at the end of a period, a transaction amount, or a transaction volume, etc. Of course, other types of cells may also be included in the report. For example, the report may also include an information description cell. Descriptive information is displayed in the information description cell. The information description cell includes a table description cell and an indicator description cell. The table description cell displays description information of the report. The indicator description cell displays description information of the indicator data.

[0054]

[0055] For example, in Table 1, the project cell, the end-of-period amount cell, the beginning-of-year amount cell, and the quarter-on-quarter cell are sample description cells. The monetary fund cell, the bill receivable cell, and the debt investment cell are indicator description cells. A1, A2, A3, B1, B2, and B3 are indicator cells. The indicator cells correspond to the data acquisition information.

[0056] In some embodiments, the business model can be preset. The number of business models can be one or more. A business model can have one or more parameters and can be associated with one or more source data tables. By configuring each business model, one or more data acquisition information of the business model can be obtained. Configuring a business model can be understood as assigning values ​​to the parameters of the business model to obtain parameter values ​​(referred to as parameter values). One data acquisition information of a business model may include the values ​​of one or more parameters of the business model. Optionally, one data acquisition information of a business model may include the values ​​of all parameters of the business model. In different data acquisition information of the business model, the values ​​of one or more parameters may be different.

[0057] The parameters of the business model may include fields in the source data table. Multiple parameters of the business model may correspond to fields in one source data table, or may correspond to fields in multiple different source data tables. Assigning values ​​to the parameters of the business model can be understood as determining the row information under the field corresponding to the parameter. Therefore, the parameter value of the business model may include the row information under the field, and the data acquisition information of the business model may indicate the business data corresponding to the field and the row information in the source data table associated with the business model. Therefore, the business data corresponding to the field and the row information in the source data table can be obtained based on the data acquisition information. The row information may include a row identifier. The row information under the field may indicate the specific business data of the field in the row corresponding to the row identifier.

[0058] Of course, the data acquisition information may also include other content, such as a model identifier of the business model corresponding to the data acquisition information. The model identifier is used to identify the business model. The model identifier may include the name and number of the business model.

[0059] Different data acquisition information of the same business model can indicate different business data under the same field in the same source data table. Data acquisition information of different business models can indicate business data in different source data tables. Alternatively, data acquisition information of different business models can also indicate business data under different fields in the same source data table.

[0060] The business model can be encapsulated with calculation logic. The calculation logic can be the calculation logic of business data. The calculation logic includes but is not limited to addition, subtraction, multiplication, division, averaging and any combination thereof. As mentioned above, the parameters of the business model include the fields in the source data table, so the calculation logic encapsulated by the business model can be applied to the calculation of all business data under the parameters (i.e., fields) in the source data table associated with the business model. The business data indicated by the data acquisition information includes specific business data under the field (business data corresponding to both the field and row information). Therefore, using the calculation logic indicated by the business model, the business data indicated by the data acquisition information of the business model can be calculated to obtain the indicator data corresponding to the data acquisition information. The data acquisition information can be understood as the data acquisition rules. The data acquisition information can indicate the business data to be calculated and the calculation logic.

[0061] The above fields can refer to columns in a data table. Each column in a data table can be called a field. In a data table, specific business data can be located by field and row information.

[0062] The parameters of the business model may include fields in the source data table. According to the business model, the fields of the source data table may be located to achieve coarse positioning of the business data. The data acquisition information may include parameter values ​​of the business model, and the parameter values ​​of the business model may include row information under the field. Thus, the data acquisition information may include row information under the field. According to the data acquisition information, the row under the field may be located, thereby achieving more fine-grained positioning based on the coarse positioning of the business model.

[0063] The parameters of different business models may be different. Thus, different business models may be suitable for extracting different types of business data. Different business models may be suitable for calculating different types of indicator data.

[0064] For example, business models may include account balances, auxiliary balances, reclassified balances, auxiliary balance reclassification, cash flow balances, offset balances, aging balances, auxiliary aging balances, basic data, vouchers, offsetting entries, etc. Among them, the account balance business model is used to extract the beginning of the year, beginning of the period, debit, credit, balance and other amounts of each account. It is applicable to the calculation of the indicator data "monetary funds" in the balance sheet, the indicator data "total comprehensive income" in the statement of changes in owners' equity, and the indicator data "operating income" in the income statement. The auxiliary balance business model is used to extract the beginning of the year, beginning of the period, amount, balance and other amounts of each account and the corresponding auxiliary item value. It is applicable to the calculation of the indicator data "rented fixed assets" and "financial lease fixed assets" in the enterprise's main asset status table, and the indicator data "pension insurance" and "medical insurance" in the employee salary status table. The reclassified balance business model is used to extract the total debit balance, total credit balance and other amounts of each account after reclassification according to a certain auxiliary dimension. Applicable to calculating the indicator data "accounts receivable" and "advances received" in the balance sheet, and the indicator data "bad debt provision for other receivables" in the other accounts receivable and payable situation table. The cash flow balance business model is used to extract the current period number, current period cumulative number and other amounts of each cash flow balance. Applicable to calculating the indicator data "sales of goods", "cash received from providing services" and "cash received from investment income" in the cash flow statement.

[0065] In some embodiments, the business server may provide a configuration information set. The configuration information set may include one or more subsets. Each subset may correspond to a report identifier, including the data acquisition information of each indicator cell in the report corresponding to the report identifier. The business server may parse the data acquisition request to obtain one or more report identifiers; for each report identifier, a corresponding subset may be selected in the configuration information set according to the report identifier, and the data acquisition information in the subset may be obtained. In this way, the business server may obtain the data acquisition information of each indicator cell in one or more reports.

[0066] Step 13: Use the calculation logic indicated by the business model to calculate the business data indicated by the data acquisition information.

[0067] In some embodiments, for each data acquisition information obtained, the business server can load the business data indicated by the data acquisition information; the calculation logic indicated by the business model corresponding to the data acquisition information can be used to calculate the loaded business data to obtain the indicator data corresponding to the data acquisition information, thereby obtaining the indicator data of the indicator cell corresponding to the data acquisition information.

[0068] Optionally, the business server can load business data in the source data table for each data retrieval information. For example, the business server can send the data retrieval information to the database server. The database server can receive the data retrieval information; can determine the corresponding source data table based on the data retrieval information; can select business data from the determined source data table based on the data retrieval information; and can send business data to the business server. The business server can receive business data. Specifically, for example, the data retrieval information includes a model identifier. The database server can obtain the source data table associated with the business model corresponding to the model identifier.

[0069] In some embodiments, the business server may further divide the acquired data acquisition information according to the granularity of the business model to obtain several first task sets. The several may be one or more. Each first task set may correspond to a business model, including data acquisition information obtained by configuring the business model. Each first task set may include one or more data acquisition information, and the one or more data acquisition information may correspond to the same business model. Thus, for each first task set, the business server may calculate the business data indicated by each data acquisition information in the first task set using the calculation logic indicated by the business model of the first task set, and obtain the index data corresponding to each data acquisition information. For example, the business server may load the business data indicated by each data acquisition information; may calculate the loaded business data using the calculation logic indicated by the business model of the first task set, and obtain the index data corresponding to the data acquisition information, thereby obtaining the index data of the index cell corresponding to the data acquisition information. Specifically, for example, the business server may send the data acquisition information to the database server. The database server may receive the data acquisition information; may determine the corresponding source data table according to the data acquisition information; may select business data from the determined source data table according to the data acquisition information; and may send business data to the business server.

[0070] Therefore, by dividing the acquired data acquisition information according to the business model granularity, each data acquisition information in each first task set can correspond to the same business model. It is convenient to use the same calculation logic to calculate the business data indicated by each data acquisition information in the first task set, thereby improving the calculation efficiency of the indicator data.

[0071] Optionally, multiple first task sets can also be calculated in parallel. The business server can create the same number of threads according to the number of first task sets; multiple first task sets can be assigned to multiple threads. Each thread corresponds to a first task set. Thus, each thread can use the calculation logic indicated by the first task set to calculate the business data indicated by each data acquisition information in the first task set to obtain the indicator data of each data acquisition information. Since one thread can only execute the calculation logic of one business model, the overall calculation efficiency of the above-mentioned first task sets is improved.

[0072] Optionally, the business server can create the same number of hotspot tables according to the number of first task sets. Each hotspot table can correspond to a first task set. The business server can load the corresponding business data to the hotspot table corresponding to the first task set according to the business model corresponding to each first task set. Thus, the hotspot table can contain the business data indicated by each data acquisition information in the first task set. For each first task set, the business server can use the calculation logic indicated by the business model of the first task set to calculate the business data indicated by each data acquisition information in the hotspot table of the first task set, and obtain the index data of each data acquisition information. In this way, the business data is loaded into the hotspot table at one time according to the business model, so that the business data can be obtained and calculated in the local hotspot table according to the data acquisition information, without the need to interact with the database server for each data acquisition information separately. The number of interactions with the database server is reduced, and the calculation efficiency of the index data is improved.

[0073] As mentioned above, the business server can have one or more parameters and can be associated with one or more source data tables. The parameters of the business model can include fields in the source data table. Therefore, the business data corresponding to the business model can include all business data under all parameters in the source data table corresponding to the business model. For each business model of the first task set, the business server can send the parameter identifier (i.e., field identifier) ​​of each parameter of the business model and the table identifier of the associated source data table to the database server. The database server can receive the parameter identifier and the table identifier; can determine the corresponding source data table according to the table identifier; can select the business data under the parameter identifier in the source data table corresponding to the table identifier; and can send the business data to the business server. The business server can receive the business data; can create a hotspot table corresponding to the first task set; and can store the business data in the hotspot table corresponding to the first task set. Thereby, the business data is loaded according to the business model.

[0074] For each data acquisition information in each first task set, the business server can select business data from the hot spot table corresponding to the first task set based on the data acquisition information; the selected business data can be calculated using the calculation logic indicated by the business model of the first task set to obtain indicator data corresponding to the data acquisition information.

[0075] Optionally, after receiving the parameter identifier and the table identifier, the database server can determine the corresponding source data table according to the table identifier; select the business data under the parameter identifier from the source data table corresponding to the table identifier; determine the data volume of the selected business data; and send the business data to the business server when the data volume of the selected business data is less than or equal to the set threshold. The business server can receive the business data; create a hotspot table corresponding to the first task set; and store the business data in the hotspot table corresponding to the first task set. When the data volume of the selected business data is greater than the set threshold, the database server can filter out part of the business data from the selected business data; and send the filtered business data to the business server. The data volume of the filtered business data is less than or equal to the set threshold. The business server can receive the business data; create a hotspot table corresponding to the first task set; and store the business data in the hotspot table corresponding to the first task set. In this way, the amount of business data in the local hotspot table can be avoided to affect the performance of the business server. Among them, the database server can randomly filter the business data, or filter out the business data with the most recent update time.

[0076] For each data acquisition information in each first task set, the business server can preferentially select business data from the hotspot table corresponding to the first task set according to the data acquisition information; if the selection is successful, the selected business data can be calculated using the calculation logic indicated by the business model of the first task set to obtain the indicator data corresponding to the data acquisition information. If the selection fails, the business server can send the data acquisition information to the database server. The database server can receive the data acquisition information; can determine the corresponding source data table according to the data acquisition information; can select business data from the determined source data table according to the data acquisition information; and can send business data to the business server. The business server can calculate the received business data using the calculation logic indicated by the business model of the first task set to obtain the indicator data corresponding to the data acquisition information.

[0077] As an example, the business server can create the same number of threads according to the number of first task sets; multiple first task sets can be assigned to multiple threads. Each thread can correspond to a first task set. Each thread can create a hotspot table; according to the business model corresponding to the first task set, the corresponding business data can be loaded into the hotspot table corresponding to the first task set; for each data acquisition information in the first task set, business data can be selected from the hotspot table corresponding to the first task set according to the data acquisition information; the selected business data can be calculated using the calculation logic indicated by the business model of the first task set to obtain the indicator data corresponding to the data acquisition information. In this way, multi-threaded parallel computing is realized.

[0078] In some implementations of this embodiment, the business server can directly divide the acquired data acquisition information according to the granularity of the business model to obtain a plurality of first task sets. In this way, each data acquisition information in each first task set can correspond to an indicator cell in a report or to indicator cells in multiple different reports.

[0079] In other embodiments of the present embodiment, the business server may further divide the acquired data acquisition information according to the report granularity to obtain multiple second task sets. Each second task set may correspond to a report, including the data acquisition information of each indicator cell in the report. The business server may divide the data acquisition information in each second task set according to the business model granularity to obtain several first task sets. Thus, each data acquisition information in each first task set may correspond to an indicator cell in a report, and correspond to the same business model. This may further improve the calculation efficiency of the indicator data.

[0080] Optionally, the business server is a distributed server cluster including multiple servers. The distributed server cluster includes a scheduling node and multiple business nodes. The scheduling node can receive a data acquisition request; can obtain data acquisition information of an indicator cell in a report; can divide the acquired data acquisition information according to the report granularity to obtain multiple second task sets. The scheduling node can assign multiple second task sets to multiple business nodes. Each business node can obtain a second task set. Each business node can divide the data acquisition information in the second task set according to the business model granularity to obtain multiple first task sets; can create multiple threads; can assign multiple first task sets to multiple threads. Each thread can correspond to a first task set. Each thread can create a hotspot table; can load corresponding business data to the hotspot table corresponding to the first task set according to the business model corresponding to the first task set; for each data acquisition information in the first task set, can select business data from the hotspot table corresponding to the first task set according to the data acquisition information; can use the calculation logic indicated by the business model of the first task set to calculate the selected business data to obtain the indicator data corresponding to the data acquisition information. Each business node can send the calculated indicator data to the scheduling node. The scheduling node can feed back the indicator data to the terminal device, thereby using the distributed cluster to implement multi-threaded parallel computing, thereby improving the computing efficiency of the indicator data.

[0081] Optionally, for each data acquisition information in the first task set, the thread can preferentially select business data from the hotspot table corresponding to the first task set according to the data acquisition information; if the selection is successful, the selected business data can be calculated using the calculation logic indicated by the business model of the first task set to obtain the indicator data corresponding to the data acquisition information. If the selection fails, the thread can send the data acquisition information to the database server. The database server can receive the data acquisition information; determine the corresponding source data table based on the data acquisition information; select business data from the determined source data table based on the data acquisition information; and send business data to the thread. The thread can calculate the received business data using the calculation logic indicated by the business model of the first task set to obtain the indicator data corresponding to the data acquisition information.

[0082] Step 14: Feedback the calculated indicator data so that the indicator data can be filled into the indicator cell.

[0083] In some embodiments, the business server may feedback the indicator data after calculating each indicator data of the data acquisition information, so as to fill the indicator data into the corresponding indicator cell. For example, the business server may feedback the indicator data to the terminal device. The terminal device may receive the indicator data; and may fill the indicator data into the corresponding indicator cell.

[0084] In some embodiments, after calculating the indicator data of all the data acquisition information, the business server can aggregate the indicator data of all the data acquisition information to obtain an indicator data set; the indicator data set can be fed back so that the indicator data in the indicator data set can be filled into the indicator cells in the report. This can reduce the time interval when each indicator cell is filled with indicator data, thereby improving the user experience. Specifically, the business server can feed back the indicator data set to the terminal device. The indicator data set includes one or more indicator data, and each indicator data corresponds to an indicator cell. The terminal device can receive the indicator data set; the indicator data in the indicator data set can be filled into the indicator cells in the report.

[0085] The data acquisition request may include one or more report identifiers. Therefore, all the above-mentioned data acquisition information may specifically include the data acquisition information of the indicator cells in the report corresponding to the one or more report identifiers.

[0086] The technical solution of the embodiment of this specification can receive a data acquisition request, the data acquisition request includes a report identifier, and the report identifier is used to identify the report; the data acquisition information of the indicator cell in the report can be obtained, the data acquisition information is obtained by configuring the business model, the data acquisition information is used to indicate the business data, and the business model is used to indicate the calculation logic; the business data indicated by the data acquisition information can be calculated using the calculation logic indicated by the business model; the calculated indicator data can be fed back so that the indicator data is filled into the indicator cell. Thus, the data acquisition information of this specification can be obtained by configuring the business model, thereby avoiding the technical personnel from writing complex data acquisition formulas according to business needs, and can simplify the configuration process of the report. In addition, the business model is pre-set and encapsulates the calculation logic of the indicator data. The data acquisition information can indicate the business data involved in the calculation. Thus, after receiving the data acquisition request, the business data can be accurately located by the data acquisition information, and the located business data can be calculated by the calculation logic indicated by the business model corresponding to the data acquisition information, thereby obtaining the indicator data. This improves the calculation efficiency of the indicator data and reduces the occurrence of errors.

[0087] See also Figure 3 The embodiment of this specification provides a report configuration method. The report configuration method can be used to configure data acquisition information for cells in a report. The cells configured with data acquisition information can be called indicator cells.

[0088] The report configuration method may include the following steps.

[0089] Step 31: Displaying a report to be configured, wherein the report includes cells to be configured.

[0090] Step 32: In response to the configuration operation on the cell, display the configuration interface.

[0091] Step 33: Acquire the target business model selected in the configuration interface.

[0092] Step 34: Displaying parameters of the target business model on the configuration interface.

[0093] Step 35: Obtain parameter values ​​entered in the configuration interface.

[0094] Step 36: Determine the cell data access information based on the parameter value.

[0095] In some embodiments, a terminal device may display a report to be configured. The report may include one or more cells to be configured. A user may perform configuration operations on one or more cells in the report, for example, may click on one or more cells in the report. In response to the configuration operation on the cells, the terminal device may display a configuration interface. The configuration interface includes one or more preset business models. For example, the configuration interface may include a business model option. The business model option may be a drop-down box. The user may select a business model through the drop-down box. For another example, the configuration interface may include an input box. The user may enter a business model in the input box. The terminal device may obtain a business model selected by the user in the configuration interface as a target business model; and may display one or more parameters of the target business model in the configuration interface. The user may enter the values ​​of the one or more parameters in the configuration interface. The terminal device may receive the parameter values ​​input by the user; and may determine the data acquisition information according to the parameter values ​​input by the user. The data acquisition information may include the parameter values ​​of the target business model input by the user. Of course, the data acquisition information may also include other content, such as a model identifier of the target business model. The model identifier of the target business model may include the name and number of the target business model.

[0096] In some embodiments, the report may include a fixed report and a floating report. The style of the fixed report is fixed, and the number of rows and columns cannot be changed dynamically. The style of the floating report is not fixed, and the number of rows and / or columns can be changed dynamically. The cell to be configured may be a cell in a fixed report, or a cell in a newly added row or column in a floating report.

[0097] In some embodiments, for each parameter of the target business model in the configuration interface, the user can enter a value of the parameter in the configuration interface. Thus, the terminal device can determine the data information according to a value of each parameter of the target business model. Figure 4, which shows a configuration interface. The user enters a value of each parameter of the target business model in the configuration interface. Of course, the user can also enter multiple sets of values ​​and operators of the multiple values ​​in the configuration interface. Each set of values ​​can include a value of each parameter of the target business model. The operator can include Boolean operations, etc. The terminal device can operate on the multiple sets of values ​​according to the operator to obtain the operation result as the data acquisition information.

[0098] In some embodiments, through steps 31-36, data acquisition information can be configured for multiple cells of a report. The terminal device can use the cell configured with data acquisition information as an indicator cell; the data acquisition information of each indicator cell in the report can be sent to the business server. The business server can receive the data acquisition information; the data acquisition information can be stored in a configuration information set. Optionally, the configuration information set can include one or more subsets. Each subset can correspond to a report identifier. The terminal device can send the report identifier of the report and the data acquisition information of each indicator cell in the report to the business server. The business server can select a corresponding subset in the configuration information set based on the received report identifier; the received data acquisition information can be stored in the selected subset. This facilitates the business server to subsequently obtain the data acquisition information of the report in the configuration information set.

[0099] Optionally, the terminal device may convert the data acquisition information of each indicator cell in the report into a format that can be recognized by the business server to obtain converted data (such as JSON structure data); and may send the converted data to the business server. The business server may parse the converted data to obtain the data acquisition information of each indicator cell in the report.

[0100] The technical solution of the embodiment of this specification can display a report to be configured, the report includes a cell to be configured; in response to a configuration operation for a cell, a configuration interface is displayed, the configuration interface includes multiple business models; the target business model selected in the configuration interface can be obtained; the parameters of the target business model can be displayed in the configuration interface; the parameter value entered in the configuration interface can be obtained; the cell data acquisition information can be determined according to the parameter value. Thus, the data acquisition information can be configured for the cells in the report through a visual configuration interface. This makes the configuration process more intuitive and more readable. In addition, the user does not need to be proficient in the writing skills of the data acquisition formula, but can configure the data acquisition information through a preset business model, thereby simplifying the configuration process and reducing the learning cost. In addition, the meaning of the data acquisition information is also convenient for users to understand.

[0101] See also Figure 5The embodiment of this specification also provides a report data acquisition device. The report data acquisition device can be applied to a business server. The report data acquisition device can include the following units.

[0102] A receiving unit 51 is used to receive a data acquisition request, wherein the data acquisition request includes a report identifier, and the report identifier is used to identify a report;

[0103] An acquisition unit 52, used for acquiring data acquisition information of an indicator cell in the report, wherein the data acquisition information is obtained by configuring a business model, the data acquisition information is used to indicate business data, and the business model is used to indicate calculation logic;

[0104] A calculation unit 53, used to calculate the business data indicated by the data acquisition information using the calculation logic indicated by the business model;

[0105] The feedback unit 54 is used to feed back the calculated indicator data so as to fill the indicator data into the indicator cell.

[0106] See also Figure 6 The embodiment of this specification also provides a report configuration device. The report configuration device can be applied to a terminal device. The report configuration device can include the following units.

[0107] A first display unit 61, used to display a report to be configured, wherein the report includes cells to be configured;

[0108] A second display unit 62, configured to display a configuration interface in response to a configuration operation on a cell, wherein the configuration interface includes one or more business models;

[0109] A first acquisition unit 63, configured to acquire a target business model selected in the configuration interface;

[0110] A third display unit 64, configured to display parameters of the target business model on the configuration interface;

[0111] A second acquisition unit 65, used to acquire a parameter value input in the configuration interface;

[0112] The determination unit 66 is used to determine the data acquisition information of the cell according to the parameter value.

[0113] The embodiments of the present specification also provide a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the above-mentioned report acquisition method and / or the above-mentioned report configuration method when executing the computer program.

[0114] The embodiments of the present specification also provide a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the above-mentioned report acquisition method and / or the above-mentioned report configuration method are implemented.

[0115] The embodiments of this specification also provide a computer program product, which includes a computer program. When the computer program is executed by a processor, the above-mentioned report acquisition method and / or the above-mentioned report configuration method are implemented.

[0116] Those skilled in the art will appreciate that this specification may be provided as a method, system, or computer program product. Therefore, this specification may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, this specification may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0117] This specification is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products of the embodiments of this specification. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. The computer can be a personal computer, a laptop computer, a cellular phone, a camera phone, a smart phone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.

[0118] The various functional units in the embodiments of this specification may be integrated into one processing unit, or each functional unit may exist physically separately, or two or more functional units may be integrated into one processing unit.

[0119] Those skilled in the art will understand that the description of each embodiment in this specification has its own emphasis. For parts not described in detail in a certain embodiment, reference can be made to the relevant description of other embodiments. In addition, it is understood that after reading this specification, those skilled in the art can think of any combination of some or all of the embodiments listed in this specification without creative work, and these combinations are also within the scope of disclosure and protection of this specification.

[0120] Although the present specification is described by way of examples, it is known to those skilled in the art that the above examples are only used to help understand the core idea of ​​the present specification. It is understood by those skilled in the art that there are many variations and changes in the present specification. It is hoped that the appended claims include these variations and changes without departing from the spirit of the present specification.

Claims

1. A report configuration method, characterized in that: include: Displaying a report to be configured, wherein the report includes a cell to be configured; In response to a configuration operation on a cell, displaying a configuration interface, the configuration interface including one or more business models, the business model being used to indicate a calculation logic of business data; Acquire the target business model selected in the configuration interface; Displaying parameters of the target business model on the configuration interface; Obtaining parameter values ​​entered in the configuration interface; According to the parameter value, the cell data acquisition information is determined, and the data acquisition information is used to indicate the business data.

2. A report data acquisition method, characterized in that: include: receiving a data retrieval request, wherein the data retrieval request includes a report identifier, and the report identifier is used to identify a report; Acquire data acquisition information of an indicator cell in the report, wherein the data acquisition information is obtained by configuring a business model, the data acquisition information is used to indicate business data, and the business model is used to indicate calculation logic; Using the calculation logic indicated by the business model, the business data indicated by the data acquisition information is calculated; Feedback the calculated indicator data so that the indicator data can be filled into the indicator cell.

3. The method according to claim 2, characterized in that The data acquisition information includes parameter values ​​of the business model; The business model is associated with a field of a source data table, and the parameter value includes row information under the field.

4. The method according to claim 2 or 3, characterized in that: The calculating the business data indicated by the parameter value by using the calculation logic indicated by the business model includes: The acquired data acquisition information is divided according to the business model granularity to obtain a plurality of first task sets; wherein each first task set corresponds to a business model, including the data acquisition information configured by the business model; For each piece of data acquisition information in the first task set, the business data indicated by the data acquisition information is calculated using the calculation logic indicated by the business model corresponding to the first task set to obtain the indicator data corresponding to the data acquisition information.

5. The method according to claim 4, characterized in that The method further comprises: According to the business model corresponding to the first task set, loading the associated business data into the hotspot table corresponding to the first task set; The calculating of the business data indicated by the data acquisition information includes: Selecting business data from the hotspot table according to the data acquisition information; Calculate the selected business data.

6. The method according to claim 4, characterized in that The data retrieval request includes multiple report identifiers; The division of the acquired data acquisition information according to the business model granularity includes: The acquired data acquisition information is divided according to the report granularity to obtain a plurality of second task sets; wherein each second task set corresponds to a report, including the data acquisition information of each indicator cell in the report; The data acquisition information in the second task set is divided according to the business model granularity to obtain a plurality of first task sets.

7. The method according to claim 2, characterized in that The indicator data obtained by the feedback calculation includes: After calculating the indicator data of all the data acquisition information, the indicator data of all the data acquisition information are aggregated; The feedback is aggregated to obtain an indicator data set so that the indicator data in the indicator data set can be filled into the indicator cells.

8. A report configuration device, characterized in that: include: A first display unit, used to display a report to be configured, wherein the report includes a cell to be configured; A second display unit, configured to display a configuration interface in response to a configuration operation on a cell, wherein the configuration interface includes one or more business models, and the business model is used to indicate a calculation logic of business data; A first acquisition unit, configured to acquire a target business model selected on the configuration interface; A third display unit, configured to display parameters of the target business model on the configuration interface; A second acquisition unit, used to acquire a parameter value input in the configuration interface; The determination unit is used to determine the data acquisition information of the cell according to the parameter value, and the data acquisition information is used to indicate the business data.

9. A report data acquisition device, characterized in that: include: A receiving unit, configured to receive a data acquisition request, wherein the data acquisition request includes a report identifier, and the report identifier is used to identify a report; An acquisition unit, used for acquiring data acquisition information of an indicator cell in the report, wherein the data acquisition information is obtained by configuring a business model, the data acquisition information is used to indicate business data, and the business model is used to indicate calculation logic; A calculation unit, used to calculate the business data indicated by the data acquisition information using the calculation logic indicated by the business model; The feedback unit is used to feed back the calculated indicator data so as to fill the indicator data into the indicator cell.

10. A computer device, characterized in that: include: A memory, a processor and a computer program stored in the memory, wherein the processor executes the computer program to implement the steps of any one of the methods of claims 1 to 7.

Images