Data processing method, apparatus, device, medium, and product

Abstract

The application provides a data processing method, device, equipment, medium and product, and relates to the technical field of data processing. The method comprises the following steps: determining an original calculation formula for a target cell, wherein the original calculation formula indicates an operation relationship of a plurality of calculation factor cells to the target cell, and the target cell and the plurality of calculation factor cells are cells in a table. A summary value of a set of hidden cells for the target cell is determined based on the original calculation formula and a set of display cells, wherein the set of display cells are cells displayed on a user interface, and the set of hidden cells are cells not displayed on the user interface. A target calculation formula for the target cell is determined based on the set of display cells and the summary value, wherein the target calculation formula is used to indicate an operation relationship of the set of display cells and the summary value to the target cell. The target calculation formula is displayed on the user interface. The efficiency of processing multi-dimensional data is visualized and improved.

Description

Technical Field

[0001] The embodiments of this application primarily relate to the field of data processing. More specifically, the embodiments of this application relate to data processing methods, apparatus, devices, media, and products. Background Technology

[0002] With the advancement of computer technology, data processing technology, especially in the context of multidimensional data processing, has developed rapidly. Multidimensional data processing is now increasingly being applied across various fields to handle complex information, and it is gradually becoming an important means of information processing in the data processing field.

[0003] With the development of multidimensional data processing technology, the demand for such technology is increasing and becoming more frequent. Furthermore, the rapid changes in these demands mean that multidimensional data processing technologies are needed in various scenarios. For example, in scenarios with large data throughput, such as budget preparation and transaction accounting, multidimensional data processing technologies are required to visualize the data processing process so that users can observe data changes in real time. Related technologies typically require aggregation calculations based on multidimensional hierarchical structures, often using manually configured calculation formulas to achieve data linkage. However, manually configuring formulas is extremely labor-intensive, and the same calculation formulas cannot be replicated and used for different scenarios, leading to huge resource consumption. Moreover, when displaying formulas on the front end, it is difficult to quickly present the correspondence between formulas and cells, resulting in low data processing efficiency. Summary of the Invention

[0004] The embodiments of this application provide a data processing scheme.

[0005] According to a first aspect of this application, a data processing method is provided. The method includes determining an original calculation formula for a target cell, the original calculation formula indicating the operational relationship of the target cell calculated based on multiple calculation factor cells, wherein the target cell and the multiple calculation factor cells are cells in a table. The method also includes determining a summary value of a set of hidden cells for the target cell based on the original calculation formula and a set of displayed cells, wherein the set of displayed cells are cells among the multiple calculation factor cells that are displayed on a user interface, and the set of hidden cells are cells among the multiple calculation factor cells that are not displayed on the user interface. The method further includes determining a target calculation formula for the target cell based on the set of displayed cells and the summary value, the target calculation formula indicating the operational relationship of the target cell calculated based on the set of displayed cells and the summary value. The method also includes displaying the target calculation formula on a user interface.

[0006] In this way, in data processing tasks involving multidimensional hierarchical data, multiple calculation factor cells and the original calculation formula for the target cell can be used to quickly calculate the change in the value of the target cell based on the change in the cell values ​​of a set of display cells in the target table. The target calculation formula and summary value are then displayed on the user interface, which improves data processing efficiency, visualizes the data processing process, and enhances the user experience.

[0007] In some embodiments, the method further includes: in response to an adjustment of the value of a cell in a set of displayed cells, determining an incremental value for the cell's value; and updating the value of a target cell based on the incremental value using a target calculation formula. In this way, after a cell's value is adjusted, the difference between the initial value and the adjusted value can be determined first, and then the value of the target cell can be quickly updated based on the target calculation formula and the difference, improving the efficiency of multidimensional data processing.

[0008] In some embodiments, the method includes displaying the target cell on a user interface. This allows the target cell to be displayed on the front end, providing a more intuitive view of the correspondence between the target calculation formula and the target cell.

[0009] In some embodiments, determining the summary value of a set of hidden cells for a target cell includes: determining a set of identifiers for a set of displayed cells; adjusting the original calculation formula based on the set of identifiers; and determining the summary value formed by the values ​​of the set of hidden cells based on the initial value of the target cell and the adjusted original calculation formula. In this way, the values ​​of a set of hidden cells from multiple calculation factor cells are merged to determine the summary value for the target cell. Furthermore, the summary value is independent of the set of displayed cells in the table, avoiding any impact on the results during subsequent calculations and saving computational resources consumed by subsequent multidimensional data processing tasks.

[0010] In some embodiments, determining the target calculation formula for a target cell includes combining a summary value with a set of identifiers for a set of display cells. This method combines the summary value and the set of identifiers for a set of display cells to form a target calculation formula specifically for calculating the value of the target cell. Furthermore, the summary value in the target calculation formula does not need to be recalculated, saving computational resources and improving the efficiency of multidimensional data processing.

[0011] In some embodiments, the method further includes: displaying the updated value on a user interface in response to the value of the target cell being updated. This allows the updated value to be displayed on the front end, and due to improved data processing efficiency, the updated value can be displayed more quickly.

[0012] In some embodiments, the table includes multiple tables, and a first table among the multiple tables includes a target cell. A set of displayed cells and a set of hidden cells are determined for the first table. The summary value for the target cell is a first summary value, the target calculation formula is a first target calculation formula, and the first summary value remains unchanged in the first table. In this way, each of the multiple tables has a corresponding summary value, and the summary value remains unchanged in the corresponding table, which can improve the data processing efficiency of each table.

[0013] In some embodiments, where the target cell is a first cell, a set of displayed cells is a first group of displayed cells, and a set of hidden cells is a first group of hidden cells, the method further includes: in response to switching from a first table to a second table among multiple tables in a user interface, determining a second summary value for a second cell in the second table, wherein the first cell and the second cell have the same original calculation formula, multiple calculation factor cells are divided into a second group of displayed cells and a second group of hidden cells relative to the second table, and the second summary value is the summary value of the second group of hidden cells; determining a second target calculation formula for the second cell based on the second summary value and the second group of displayed cells for the second cell; and displaying the second target calculation formula on the user interface. In this way, a first table and a second table can be displayed in the user interface, and the first table and the second table have the same original calculation formula. When switching tables, the same original calculation formula can be used for data processing, improving the efficiency of multidimensional data processing.

[0014] In some embodiments, determining the original calculation formula for the target cell includes: determining a target dimension combination object in a multidimensional model used to store business data that corresponds to the target cell; and determining the original calculation formula related to the target dimension combination object based on the metadata of the multidimensional model. This method improves the efficiency of multidimensional data processing by determining the target dimension combination object based on the multidimensional model and further determining the original calculation formula.

[0015] In some embodiments, determining the original calculation formula related to the target dimension combination object based on the metadata of the multidimensional model includes: determining multiple dimension combination objects corresponding to the target dimension combination object based on the calculation paths for the dimension combination objects included in the metadata, wherein the dimension combination objects in the multiple dimension combination objects correspond to the calculation factor cells in the multiple calculation factor cells; and determining the original calculation formula for the target cell based on the multiple dimension combination objects and the operators for each dimension combination object in the multiple dimension combination objects in the metadata. This method improves the efficiency of multidimensional data processing by determining the calculation paths and operators for each dimension combination object and combining them to form the original calculation formula.

[0016] According to a second aspect of this application, a data processing apparatus is provided. The apparatus includes: an original calculation formula determining unit configured to determine an original calculation formula for a target cell, the original calculation formula indicating the operational relationship of the target cell calculated based on multiple calculation factor cells, the target cell and the multiple calculation factor cells being cells in a table; a summary value determining unit configured to determine a summary value of a set of hidden cells for the target cell based on the original calculation formula and a set of displayed cells, the set of displayed cells being cells displayed on a user interface among the multiple calculation factor cells, and the set of hidden cells being cells not displayed on the user interface among the multiple calculation factor cells; a target calculation formula determining unit configured to determine a target calculation formula for the target cell based on the set of displayed cells and the summary value, the target calculation formula indicating the operational relationship of the target cell calculated based on the set of displayed cells and the summary value; and a display unit configured to display the target calculation formula on a user interface.

[0017] In some embodiments, the apparatus further includes: an incremental value determination unit configured to determine an incremental value for the value of a cell in response to an adjustment of the value of a cell in a set of displayed cells; and a value update unit configured to update the value of a target cell based on the incremental value using a target calculation formula.

[0018] In some embodiments, the apparatus further includes a display unit configured to display a target cell on a user interface.

[0019] In some embodiments, the summary value determination unit includes: an identifier determination unit configured to determine a set of identifiers for a set of displayed cells; a formula adjustment unit configured to adjust an original calculation formula based on the set of identifiers; and a summary value determination unit configured to determine a summary value formed by the values ​​of a set of hidden cells based on the initial value of the target cell and the adjusted original calculation formula.

[0020] In some embodiments, the target calculation formula determination unit includes a combination unit configured to determine the target calculation formula by combining a summary value and a set of identifiers of a set of display cells.

[0021] In some embodiments, the apparatus further includes a display unit configured to display an updated value on a user interface in response to an update of the value of the target cell.

[0022] In some embodiments, the table includes multiple tables, a first table of the multiple tables includes a target cell, a set of displayed cells and a set of hidden cells are determined for the first table, a summary value for the target cell is a first summary value, a target calculation formula is a first target calculation formula, and the first summary value remains unchanged in the first table.

[0023] In some embodiments, wherein the target cell is a first cell, a set of displayed cells is a first set of displayed cells, and a set of hidden cells is a first set of hidden cells, the apparatus further includes: a second summary value determining unit configured to determine a second summary value for a second cell in the second table in response to switching to a second table different from the first table in the user interface, wherein the first cell and the second cell have the same original calculation formula; a second target calculation formula determining unit configured to determine a second target calculation formula for the second cell based on the second summary value and the second set of displayed cells for the second cell; and a display unit configured to display the second target calculation formula on the user interface.

[0024] In some embodiments, the original calculation formula determination unit includes: a target dimension combination object determination unit configured to determine a target dimension combination object corresponding to a target cell in a multidimensional model used to store business data; and a first formula determination unit configured to determine an original calculation formula related to the target dimension combination object based on the metadata of the multidimensional model.

[0025] In some embodiments, the first formula determining unit includes: a multiple dimension combination object determining unit, configured to determine multiple dimension combination objects corresponding to a target dimension combination object based on the calculation path for the dimension combination object included in the metadata, wherein the dimension combination objects in the multiple dimension combination objects correspond to the calculation factor cells in the multiple calculation factor cells; and a second formula determining unit, configured to determine the original calculation formula for the target cell based on the multiple dimension combination objects and the operator for each dimension combination object in the multiple dimension combination objects in the metadata.

[0026] According to a third aspect of this application, an electronic device is also provided, comprising: at least one computing unit; and at least one memory coupled to the at least one computing unit and storing instructions for execution by the at least one computing unit, the instructions, when executed by the at least one computing unit, causing the device to perform the method according to the first aspect of this application.

[0027] According to a fourth aspect of this application, a computer-readable storage medium is also provided, on which a computer program is stored, which, when executed by a processor, implements the method described according to a first aspect of this application.

[0028] According to a fifth aspect of this application, a computer program product is also provided, including computer-executable instructions, wherein the computer-executable instructions, when executed by a processor, implement the method described according to a first aspect of this application.

[0029] Understandably, the apparatus of the second aspect, the electronic device of the third aspect, the computer storage medium of the fourth aspect, or the computer program product of the fifth aspect provided above are used to perform the methods provided in the first and second aspects. Therefore, the explanations or descriptions regarding the first aspect also apply to the second, third, fourth, and fifth aspects. Furthermore, the beneficial effects achievable by the second, third, fourth, and fifth aspects can be referred to the beneficial effects in the corresponding methods, and will not be repeated here. Attached Figure Description

[0030] The above and other features, advantages, and aspects of the embodiments of this application will become more apparent from the accompanying drawings and the following detailed description. In the drawings, the same or similar reference numerals denote the same or similar elements, wherein:

[0031] Figure 1 A schematic diagram illustrates an example environment in which several embodiments of this application can be implemented;

[0032] Figure 2 An example architecture diagram for data processing according to some embodiments of this application is shown;

[0033] Figure 3 A schematic flowchart illustrating an example of a data processing method according to some embodiments of this application is shown;

[0034] Figure 4 A schematic diagram illustrating an example of determining an original calculation formula for data processing according to some embodiments of this application is shown;

[0035] Figure 5 A schematic diagram of a flowchart for data processing according to some embodiments of this application is shown;

[0036] Figure 6 A schematic diagram illustrating an example of tabular data for data processing according to some embodiments of this application is shown;

[0037] Figure 7 Block diagrams of apparatuses according to some embodiments of this application are shown; and

[0038] Figure 8A block diagram of a computing device capable of implementing several embodiments of the present application is shown. Detailed Implementation

[0039] Embodiments of this application will now be described in more detail with reference to the accompanying drawings. While some embodiments of this application are shown in the drawings, it should be understood that this application can be implemented in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided to provide a more thorough and complete understanding of this application. It should be understood that the drawings and embodiments of this application are for illustrative purposes only and are not intended to limit the scope of protection of this application.

[0040] In the description of embodiments of this application, the term "comprising" and similar terms should be understood as open-ended inclusion, i.e., "including but not limited to". The term "based on" should be understood as "at least partially based on". The term "one embodiment" or "the embodiment" should be understood as "at least one embodiment". The terms "first", "second", etc., may refer to different or the same objects. Other explicit and implicit definitions may also be included below.

[0041] As mentioned above, when using multidimensional data processing technology to handle related data processing tasks, it is generally necessary to perform aggregation calculations based on a multidimensional hierarchical structure, and manual configuration of calculation formulas is usually used to achieve data linkage. Therefore, in the current traditional approach to handling related data processing tasks using multidimensional data processing technology, the calculation formulas for multidimensional data processing are first configured based on the multidimensional hierarchical structure, then the data that needs to reference the calculation formulas is loaded into memory to prepare for the calculation task, then the calculation formulas are assembled, the calculation is executed, and the calculation results are displayed. However, in this traditional approach, the workload of manually configuring formulas is huge, and due to the large amount of data, errors are prone to occur when configuring formulas. Furthermore, the number of supported calculation formulas is limited, making it impossible to guarantee the accuracy and efficiency of the multidimensional data processing results. Moreover, due to the high degree of customization in the processing task scenarios, the same calculation formulas cannot be replicated and used in different task scenarios, resulting in high implementation costs and huge resource consumption.

[0042] To address at least some of the aforementioned problems and other potential issues, in the embodiments of this application, an original calculation formula for the target cell is first determined. This original calculation formula indicates the operational relationship between the target cell and multiple calculation factor cells, which are cells in a table. Next, using the determined original calculation formula and a set of displayed cells, a summary value for a set of hidden cells is determined for the target cell. The set of displayed cells consists of the cells shown on the user interface among the multiple calculation factor cells, and the set of hidden cells consists of the cells not shown on the user interface among the multiple calculation factor cells. Then, using the set of displayed cells and the determined summary value, a target calculation formula for the target cell is further determined. This target calculation formula indicates the operational relationship between the target cell and the set of displayed cells and the summary value. Finally, after determining the target calculation formula, it is displayed on the user interface. In this way, in data processing tasks involving multidimensional hierarchical data, multiple calculation factor cells and the original calculation formula for the target cell can be used to quickly calculate the change in the value of the target cell based on the change in the cell values ​​of a set of display cells in the target table. The target calculation formula and summary value are then displayed on the user interface, which improves data processing efficiency, visualizes the data processing process, and enhances the user experience.

[0043] Figure 1 A schematic diagram of an example environment 100 in which various embodiments of this application can be implemented is shown. For example... Figure 1 As shown, example environment 100 includes computing device 102. In some embodiments, computing device 102 may be a device that can be used to perform data processing tasks. In some embodiments, computing device 102 may be an edge computing device. In some embodiments, computing device 102 may include a display device for displaying data processing processes and data processing results. In some embodiments, computing device 102 may include a data processing acceleration device such as a graphics processing unit (GPU). In some embodiments, computing device 102 includes, but is not limited to, in-vehicle computing devices, personal computers, servers, handheld or laptop devices, mobile devices, multiprocessor systems, consumer electronics, minicomputers, mainframe computers, and distributed computing environments including any of the above systems or devices.

[0044] like Figure 1As shown, the computing device 102 can be used to process multidimensional data processing tasks, such as processing calculations in multidimensional data tables. The computing device 102 can also store table information, such as the table name and detailed data information within the table. The computing device 102 can also be used to calculate values ​​in the table, such as calculating the value of a cell in the table. In some embodiments, the computing device 102 can also display the calculated results.

[0045] Target cell 108 is a cell in table 106. Before performing data processing on target cell 108, it is necessary to obtain a multidimensional model related to target cell 108. This multidimensional model stores business data related to target cell 108 and also stores business data related to multiple calculation factor cells 112 in table 106. The multidimensional model has a hierarchical structure. Based on the multidimensional model, multiple dimension combination objects related to the multiple calculation factor cells 112 in table 106 can be identified. These multiple dimension combination objects together constitute the multidimensional model related to target cell 108. The cells in the multiple calculation factor cells 112 correspond to the dimension combination objects in the multiple dimension combination objects. In one example, the multidimensional model is a data cube model.

[0046] It should be noted that dimension combination objects are obtained by combining multiple dimensions of data, where dimension combination refers to any combination of multiple dimensions of data. In one example, the data has three dimensions: time, location, and category. Therefore, there are eight possible dimension combination objects, such as [], [time], [location], [category], [time, location], [time, category], [location, category], and [time, location, category]. Dimension combination objects can also be aggregated according to certain aggregation rules to form a multidimensional model. These aggregation rules can be set according to user needs, and this application does not impose any restrictions on them.

[0047] Furthermore, in the multidimensional model, there is a correspondence between the target cell 108 and the multiple calculated factor cells 112 in Table 106 and the dimension combination objects. For example, the target cell 108 and the multiple calculated factor cells 112 correspond to the target dimension combination object and the multiple dimension combination object, respectively. The dimension combination objects in the multidimensional model can form a tree structure, thus creating parent nodes and child nodes. In one example, the target dimension combination object corresponding to the target cell 108 is the parent node, and the multiple dimension combination objects corresponding to a set of displayed cells 114 and a set of hidden cells 116 are two sets of child nodes corresponding to the parent node. Changes in the data in the two sets of child nodes can cause changes in the data of the parent node through dimension roll-up. Additionally, the multidimensional model can include multiple parent nodes and multiple sets of child nodes corresponding to multiple parent nodes.

[0048] like Figure 1 As shown, in the process of multidimensional data processing, the original calculation formula 110 for target cell 108 is first determined. The original calculation formula 110 indicates the operational relationship for calculating target cell 108 based on multiple calculation factor cells 112, where target cell 108 and multiple calculation factor cells 112 are cells in table 106. The original calculation formula 110 is associated with the multiple calculation factor cells 112; for example, it indicates the original calculation formula 110 for obtaining target cell 108 based on the multiple calculation factor cells 112. It should be noted that the original calculation formula 110 is obtained through preprocessing, for example, by processing the dimension combination object associated with the multiple calculation factor cells 112 to determine the corresponding original calculation formula before processing the data in target cell 108. Additionally, table 106 includes multiple tables, and in one example, the target cells in multiple tables have the same original calculation formula. Subsequently, the summary value 118 of a set of hidden cells 116 for target cell 108 can be determined based on a set of displayed cells 114 and the original calculation formula 110. In this system, a set of display cells 114 are the cells shown on the user interface 104 among multiple calculation factor cells 112, and the summary value 118 is the sum of the values ​​of a set of hidden cells 116 that are not shown on the user interface 104 among the multiple calculation factor cells 112. The calculation of the value of the target cell 108 in table 106 is unrelated to the summary value 118; once determined, the summary value 118 remains unchanged in table 106 and does not change with the changes in the values ​​of the set of display cells 114. Next, based on the summary value 118 and the set of display cells 114, a new target calculation formula 120 is determined for the target cell 108. The summary value 118 in the target calculation formula 120 is not processed when calculating the value of the target cell 108. Finally, once the target calculation formula 120 is determined, it is displayed on the user interface 104.

[0049] In this way, in data processing tasks involving multidimensional hierarchical data, multiple calculation factor cells and the original calculation formula for the target cell can be used to quickly calculate the change in the value of the target cell based on the change in the cell values ​​of a set of display cells in the target table. The target calculation formula and summary value are then displayed on the user interface, which improves data processing efficiency, visualizes the data processing process, and enhances the user experience.

[0050] The above combination Figure 1 A schematic diagram illustrating an example environment 100 in which embodiments of this application can be implemented is described. The following is in conjunction with... Figure 2 The present application describes an example architecture schematic diagram for data processing according to some embodiments thereof. Figure 1 The computing device 102 is an example of an architecture used for data processing. For example, the computing device 102 can be used as client 202 in example 200.

[0051] As shown in Example 200, the following description uses the processing of tabular data from multiple tables as an example. Client 202 includes several functional modules, such as model definition 204, data input 206, and data query 208. The example architecture also includes a database 214, where model metadata is stored. Database 214 also stores dimensional metadata 218 and aggregation rules 220 for the model metadata. The example architecture also includes a multidimensional computing engine 216, which is primarily used to perform computational tasks on multidimensional data. The example architecture also includes hardware 228, where memory 230 and disk 232 can be used to cache data generated during the computational tasks performed by the multidimensional computing engine 216. Additionally, client 202 can also be used to display table 106, target cell 108, a set of display cells 114, and target calculation formula 120, thereby visually displaying the data processing content and process, improving the user experience during data processing.

[0052] During multidimensional data processing in client 202, a multidimensional model for multiple tables needs to be determined first. This is first defined at 204, for example, by defining the model's structure. In one example, the model's structure is defined as a multidimensional hierarchy to handle multidimensional data processing tasks. After the model definition is complete, when data needs to be processed, data input operations are performed at 206, such as modifying, adding, and deleting data.

[0053] When switching to table 106 at client 202, a data query task is first executed at 208. This query identifies the ordinary data 210 currently in table 106, which is the most intuitive data displayed to the user. Then, the corresponding dimension metadata 218 for table 106 is determined in database 214. Combined with aggregation rules 220 for dimension metadata 218, a formula 212 is determined to perform multidimensional data processing. Formula 212 can then be used to calculate the value of the target cell 108 in table 106.

[0054] After the values ​​of cells in a set of display cells 114 in Table 106 are adjusted, the multidimensional calculation engine 216 first determines, based on the calculation path operator 222, that the adjusted cell values ​​will ultimately be aggregated in the target cell 108. Then, it uses the incremental value calculation operator 224 to calculate the difference between the adjusted value and the initial value of the cell. The incremental value can be positive or negative. Subsequently, the multidimensional calculation engine 216 updates the operator at 226 based on the calculation path operator 222 and the incremental value calculation operator 224, and caches the updated operator in memory 230. Furthermore, the updated operator can be transmitted and stored on disk 232 via the data link between memory 230 and disk 232, thereby freeing up memory cache space. It should be noted that formula 212 is a logical expression used to describe the calculation rules in the multidimensional model, such as aggregation rule 220, while the calculation path operator 222 and the incremental value calculation operator 224 are the basic units used to perform calculations, such as aggregation, slicing, and drill-down operators. The operator breaks down the logic in formula 212 into specific calculation steps to perform the relevant mathematical operations. Among them, the operation logic of the calculation path operator 222 and the incremental value calculation operator 224 can be modified by the user, so the operator can be updated at 226.

[0055] In this way, in data processing tasks involving multidimensional hierarchical data, multiple calculation factor cells and the original calculation formula for the target cell can be used to quickly calculate the change in the value of the target cell based on the change in the cell values ​​of a set of display cells in the target table. The target calculation formula and summary value are then displayed on the user interface, which improves data processing efficiency, visualizes the data processing process, and enhances the user experience.

[0056] The above combination Figure 2 Example architecture diagrams for data processing according to some embodiments of this application are described below. Figure 3 A schematic flowchart illustrating examples of data processing methods according to some embodiments of this application. Example 300 can be derived from... Figure 1 It can be executed at computing device 102 or any other suitable computing device.

[0057] At box 302, the original calculation formula 110 for target cell 108 is first determined. This original calculation formula 110 indicates the operational relationship used to calculate target cell 108 based on multiple calculation factor cells 112, where target cell 108 and the multiple calculation factor cells 112 are cells in table 106. In one example, table 106 is a single table, in which case target cell 108 and the multiple calculation factor cells 112 are different cells within the same table. In another example, table 106 comprises multiple tables, in which case target cell 108 is a cell within one of the multiple tables, and the multiple calculation factor cells 112 can be multiple different cells located within the multiple tables.

[0058] In some embodiments, before data processing is performed on the target cell 108 in table 106, the relationship between multiple calculation factor cells 112 and the target cell is determined. For example, the calculation relationship that can be obtained from the multiple calculation factor cells 112 is determined.

[0059] In some embodiments, before performing data processing tasks, a multidimensional model related to the target cell 108 is first obtained. This multidimensional model stores business data related to the target cell 108 and also stores business data related to multiple calculation factor cells 112 in table 106. The multidimensional model also includes metadata, which includes the calculation path and operators for each dimension combination object in the multiple dimension combination objects. In one example, the structure of the multidimensional model is a multidimensional hierarchical structure, such as a data cube model. In some embodiments, the target dimension combination object corresponding to the target cell 108 and the multiple dimension combination objects corresponding to the target dimension combination object can also be determined based on the multidimensional model.

[0060] In some embodiments, the original calculation formula 110 is obtained through preprocessing. First, a target dimension combination object for the target cell 108 is determined based on the multidimensional model. Then, multiple dimension combination objects corresponding to the multiple calculation factor cells 112 in table 106 in the multidimensional model are determined based on the target dimension combination object. The original calculation formula 110 is then determined based on the determined multiple dimension combination objects. In one example, when the amount of metadata in the multidimensional model is large, the server corresponding to client 202 is used to determine the original calculation formula 110. In this way, a large amount of calculation is avoided to determine the original calculation formula 110 every time a multidimensional data processing task is performed, reducing the consumption of computing resources and improving the efficiency of data processing.

[0061] In some embodiments, after determining multiple dimension combination objects corresponding to multiple calculation factor cells 112 based on the multidimensional model, the determined multiple dimension combination objects are further traversed to determine multiple calculation paths and multiple operators for the multiple dimension combination objects. The determined calculation paths indicate the target cell 108 where the multiple calculation factor cells 112 corresponding to the multiple dimension combination objects are finally aggregated and summarized. The determined operators can be addition or subtraction symbols, used to indicate adding or subtracting the values ​​corresponding to the cells during data processing. Additionally, the operators can be other than addition or subtraction symbols, and this application does not impose any limitations on them. In this way, a set of dimension combination objects 120 for the target cell 108 in the multidimensional model can be quickly located and calculated rapidly, improving the efficiency of multidimensional data processing.

[0062] In some embodiments, the multidimensional model for target cell 108 also includes a correspondence between dimension combination objects and tables and cells. Additionally, the dimension combination objects in the multidimensional model have object identifiers, each table in table 106 includes a table identifier, each cell in the multiple calculated factor cells 112 includes a cell identifier, and the multidimensional model also includes a correspondence between multiple object identifiers, multiple table identifiers, and multiple cell identifiers for multiple dimension combination objects. For example, the object identifier indicates which cell in which table the object corresponds to. In this way, by utilizing the correspondence between dimension combination objects and tables and cells, data traversal can be performed quickly, improving the efficiency of multidimensional data processing.

[0063] At box 304, based on the original calculation formula 110 and a set of displayed cells 114, the summary value 118 of a set of hidden cells 116 for the target cell 108 is determined. The set of displayed cells 114 consists of cells from the multiple calculated factor cells 112 that are displayed on the user interface 104. Displaying the displayed cells from the set of displayed cells 112 on the user interface 104 also displays the values ​​within those displayed cells. The set of hidden cells 116 consists of cells from the multiple calculated factor cells 112 that are not displayed on the user interface 104 or are not in an active editing state. Additionally, the hidden cells and their values ​​are not displayed on the user interface 104.

[0064] In some embodiments, Table 106 includes multiple tables, and the summary values ​​for multiple target cells with the same original calculation formula in the multiple tables may differ across the multiple tables. In one example, the summary value for a set of hidden cells in Table A of the multiple tables may be 5000, and the summary value for another set of hidden cells in Table B of the multiple tables may be 10000. In another example, the summary values ​​for two different sets of hidden cells in Table A and Table B of the multiple tables may both be 8000.

[0065] In some embodiments, in determining the summary value 118 for target cell 108, a set of identifiers for display cells 114 is first determined, and then the original calculation formula 110 is adjusted based on the set of identifiers. Additionally, the set of identifiers for display cells 114 may be a set of cell references for display cells 114 in table 106. In one example, the row and column of a cell in the table can be represented by a cell reference; for example, if a cell is in column F and row 4, then the cell reference can be "F4".

[0066] In some embodiments, a set of displayed cells 114 in the original calculation formula 110 is replaced with a set of cell references of a set of displayed cells 114, thereby generating an adjusted original calculation formula 110. After replacing the set of displayed cells 114 in the original calculation formula 110 with a set of cell references, the cells corresponding to the other calculated factor cells in the adjusted original calculation formula 110, excluding the replaced set of displayed cells 114, are a set of hidden cells 116, which are not visible in table 106. Subsequently, the summary value 118 formed by the value of each cell in the set of hidden cells 116 can be further determined based on the initial value of the original calculation formula 110 and the adjusted original calculation formula 110. In this way, a set of cell references in table 106 that can be used to replace a set of displayed cells can be quickly located, improving the efficiency of multidimensional data processing.

[0067] In some embodiments, the summary value 118 may be obtained by summing. In other embodiments, the summary value 118 may be obtained by any other feasible calculation method. It should be noted that this application does not limit the calculation method of the summary value 118.

[0068] At box 306, a target calculation formula 120 for target cell 108 is determined based on a set of displayed cells 114 and a summary value 118. The target calculation formula 120 indicates the operational relationship used to calculate the target cell 108 based on the set of displayed cells 114 and the summary value 118. In some embodiments, the cells in the set of displayed cells 114 may or may not have specific values. For example, the value in a cell in the set of displayed cells 114 may be 100 or empty; when a cell is empty, it is considered to have a value of 0. In some embodiments, after determining the summary value 118, the set of displayed cells 114 can be further utilized, for example, by combining a set of cell references from the set of displayed cells 114 with the summary value 118, to obtain the target calculation formula 120 for target cell 108. The target calculation formula 120 consists of a summary value 118 and a set of cell references for a set of displayed cells 114. The set of hidden cells 116 corresponding to the summary value 118 are not displayed in table 106. Therefore, adjusting the value of the set of displayed cells 114 in table 106 will not affect the summary value 118. Thus, the summary value 118 remains unchanged in table 106. This method avoids repeatedly calculating the summary value when using the target calculation formula 120, reducing computational resource consumption and improving the efficiency of multidimensional data processing.

[0069] At box 308, after the target calculation formula 120 is determined, it is displayed in the user interface 104. In one example, the target calculation formula 120 can be displayed on a display device included in the computing device 102. In another example, the target cell 108 and the value in the target cell 108 can also be displayed on the display device included in the computing device 102. Additionally, the value in the target cell 108 can be updated in real time according to changes in the values ​​of cells in a set of display cells 114, and the updated value is displayed in the user interface 104. In this way, the data processing process is visualized, improving the user's experience in processing data.

[0070] In some embodiments, after determining that the value of a cell in a set of display cells 114 has been adjusted, the value of the target cell 108 is updated using the target calculation formula 120. In some embodiments, when the value of a cell is adjusted, the summary value 118 in table 106 does not change. Therefore, the target calculation formula 120 only needs to process the calculation tasks related to a set of display cells 114, which greatly improves the calculation efficiency.

[0071] In some embodiments, after the values ​​of cells in a set of display cells 114 are adjusted, the incremental value for the adjusted cell can be determined first, and then the value of target cell 108 can be updated using the incremental value and target calculation formula 120. Additionally, after the value of target cell 108 is updated, the dimension combination object corresponding to the cell with the incremental value is updated, thereby updating the original calculation formula 110 for target cell 108 and the initial value for the original calculation formula 110. In other embodiments, after the values ​​of cells in a set of display cells 114 are adjusted, the value of target cell 108 can also be updated directly using the adjusted value and target calculation formula 120. For example, when the value of a cell is adjusted from 100 to 200, the value of target cell 108 can be updated directly using the adjusted value 200. In this way, the calculation time is accelerated by directly calculating in the target calculation formula 120 using the incremental value or adjusted value before and after the adjustment.

[0072] Additionally, Table 106 includes multiple tables. For ease of description, target cell 108 can be referred to as the first target cell, and the summary value 118 for the first target cell can be referred to as the first summary value. In the first table among the multiple tables, a set of displayed cells 114 and a set of hidden cells 116 are determined based on the first table. The set of displayed cells 114 can be referred to as the first set of displayed cells, and the set of hidden cells 116 can be referred to as the first set of hidden cells. The target calculation formula 120 for the first target cell can be referred to as the first target calculation formula. The multiple tables also include a second table, a third table, and so on. Similarly, the summary value in the second target cell of the second table is the second summary value, and the summary value in the third target cell of the third table is the third summary value. It should be noted that multiple target cells in multiple tables can have the same original calculation formula 110 to display the same data result. In this way, the efficiency of multidimensional data processing in multiple tables can be improved by utilizing the same calculation method.

[0073] In some embodiments, when switching from the first table to the second table in the user interface 104, a second summary value of the second cell in the second table is also determined. The plurality of calculated factor cells 112 are correspondingly divided into a second group of displayed cells and a second group of hidden cells in the second table. Additionally, the first cell and the second cell have the same original calculation formula 110. A second target calculation formula for the second cell can then be determined based on the second summary value and the second group of displayed cells, and finally, the determined second target calculation formula is displayed on the user interface 104.

[0074] In some embodiments, after the value of target cell 108 is updated, the updated value is displayed on user interface 104. Additionally, when displaying the first table of multiple tables on the display device of computing device 102, a second table, a third table, and so on can also be displayed simultaneously. In one example, more than one table can be displayed on the display device simultaneously. In another example, only one table is displayed on the display device at a time. For example, tabs corresponding to multiple tables can be displayed simultaneously on the display device and can be switched at any time according to the user's needs; for example, the user can switch from the current table to another table they want to display by operating the tab corresponding to any cell. This increases the utilization of display space and improves the efficiency of processing multiple tables simultaneously.

[0075] In this way, in data processing tasks involving multidimensional hierarchical data, multiple calculation factor cells and the original calculation formula for the target cell can be used to quickly calculate the change in the value of the target cell based on the change in the cell values ​​of a set of display cells in the target table. The target calculation formula and summary value are then displayed on the user interface, which improves data processing efficiency, visualizes the data processing process, and enhances the user experience.

[0076] The above combination Figure 3 A schematic flowchart illustrating examples of data processing methods according to some embodiments of this application is described below. Figure 4 A schematic diagram illustrating an example of determining an original calculation formula for data processing according to some embodiments of this application.

[0077] like Figure 4 As shown in Example 400, taking the processing of data in target table 402 within a multidimensional table as an example, in determining the original calculation formula 404 for target table 402, it is necessary to first determine the multidimensional model corresponding to target table 402. During the determination of the multidimensional model, the dimensions of the model need to be defined at 406. In one example, when processing multidimensional data processing tasks such as transaction accounting, it is necessary to define multiple dimension combination objects such as budget, department, and project in the multidimensional model, and use relevant summary rules configuration 408 to combine these dimension combination objects to form metadata including multiple dimension combination objects, thus constituting a complete multidimensional model including metadata.

[0078] In some embodiments, the constructed multidimensional model includes multiple dimension combination objects. For ease of description, these dimension combination objects are referred to as nodes below. The multiple nodes in the multidimensional model include parent nodes and child nodes. A parent node can have multiple corresponding child nodes, and the number of child nodes corresponding to a parent node does not exceed a threshold. In one example, the budget in the table is the parent node, which includes 100 child nodes. These 100 child nodes can constitute the original calculation formula 404 for the budget. For example, the values ​​of the 100 child nodes can be summed to obtain the original calculation formula 404 for the budget. Additionally, the threshold for the number of child nodes can be set by the user based on the performance of the computing device 102 and other factors. For example, the threshold for the number of child nodes can be set to 2000. It should be noted that this application does not impose a limit on the threshold for the number of child nodes.

[0079] The above combination Figure 4 A schematic diagram illustrating examples of determining original calculation formulas for data processing according to some embodiments of this application is described below. Figure 5 This illustration depicts a flowchart for data processing according to some embodiments of this application. Example 500 can be derived from... Figure 1 It can be executed at computing device 102 or any other suitable computing device.

[0080] like Figure 5As shown, in example flow 500, combined with the previous example 400, we take processing data in a multidimensional table as an example. First, the multidimensional data processing task begins at 502. Before executing the calculation task for the multidimensional data processing task, at 504, we need to construct the formula metadata of a parent level based on the multidimensional model metadata driver. This determines the original calculation formula for the target cell, which is obtained by combining multiple dimension combination objects from multiple tables corresponding to the target cell. In one example, the dimension combination object also includes operators and values ​​for the dimension combination object, and the dimension combination object is represented by cuboid. Different dimension combination objects are distinguished by adding suffix numbers. Thus, we can determine the original calculation formula: operator cuboid1 + operator cuboid2 + ..., where the operators can include addition or subtraction operators. The "+" in the original calculation formula indicates summing the multiple dimension combination objects from multiple tables corresponding to the target cell. Subsequently, after the original calculation formula is determined, we need to further determine the initial value of the original calculation formula, represented by "value". For example, we sum the multiple values ​​corresponding to multiple dimension combination objects to obtain the initial value "value". For ease of understanding, a dimension combination object can also be called a calculated factor cell. The dimension combination objects in multiple dimension combination objects correspond one-to-one with the cells in multiple calculated factor cells. The original calculation formula is composed of multiple calculated factor cells corresponding to multiple dimension combination objects, and the initial value is a summary of multiple values ​​corresponding to multiple calculated factor cells.

[0081] In some embodiments, after the original calculation formula and its initial value (value) are determined, the factors in the formula are replaced at point 506 with cell references within the table. Specifically, a set of cell references corresponding to a set of display cells in the target table is first determined, and then the set of dimension combination objects corresponding to that set of display cells in the original calculation formula is replaced with these cell references. Subsequently, the residual factor is calculated at point 508, which is the summative value for the target cell. In one example, the cell reference can be represented by the row and column of the cell. For example, if the set of display cells corresponding to the target cell is in column F3 and column F4, then the modified original calculation formula = operator cuboid1 + operator cuboid2 + ... + operator F3 value + operator F4 value + ... Therefore, the residual factor can be further calculated as: residual factor = initial value - ∑ initial values ​​of all referenceable cells, i.e., summative value = initial value - ∑ operator F3 value + operator F4 value. The summative value (residual factor) can be calculated using addition, subtraction, multiplication, division, or any other calculation method that yields this value; this application does not limit this method.

[0082] In some embodiments, after determining the summary value for the target cell, the formula for the parent node can be redefined at 510, which means determining the target calculation formula for the target cell. For example, the formula for the parent node could be: Residual Factor + ∑ All Referenced Cells. In one example, the formula for the parent node could be: Residual Factor + ∑ All Referenced Cells = (Initial Value - ∑ Operator F3 Value + Operator F4 Value) + (Operator &F3 + Operator &F4), where the values ​​of Operator &F3 and Operator &F4 can be changed according to user needs. Since the summary value in the target calculation formula remains unchanged in the target table, the target calculation formula can directly calculate its value using the difference between the changed cell value and the cell's initial value. Finally, the entire process ends at 512. This method greatly improves the efficiency of computational tasks in multidimensional data processing, significantly saves time, and reduces the consumption of computing resources.

[0083] The above combination Figure 5 A schematic diagram of a flowchart for data processing according to some embodiments of this application is described below. Figure 6 This illustration depicts examples of tabular data for data processing according to some embodiments of this application. Example 600 can be provided by... Figure 1 It can be executed at computing device 102 or any other suitable computing device.

[0084] like Figure 6 As shown in Example 600, Table C4 602 and Table C5 608 can be seen. In one example, Table 602 and Table 608 can be displayed on the display device of computing device 102 respectively and occupy the entire display space of the display device. In another example, Table 602 and Table 608 can be displayed on the display device of computing device 102 simultaneously. In yet another example, the display device also includes a table tab for switching the display of tables, and the display of Table 602 or Table 608 can be switched by operating the table tab.

[0085] The target cells in Tables 602 and 608 are the annual totals for the 2025 budget of the outsourced items. Table 602 displays a set of six cells for the annual totals: January, February, March, April, May, and June. Table 608 displays a set of six cells for the annual totals: July, August, September, October, November, and December. If a cell has no value, it means that the value of that cell is 0.

[0086] In Tables 604 and 608, the initial value of the target cell, the annual total cell, is 1700. This initial value is pre-processed based on the original calculation formula for the annual total cell. The sum of the values ​​of the 12 cells from January to December in both tables is 1700. The value in box 604 is 1000. This 1000 is obtained by subtracting the values ​​of the four cells corresponding to January to April in Table 602 from the initial value of 1700 in the target cell corresponding to the annual total. Box 606 displays six cell references corresponding to the six cells from January to June: "D4+E4+F4+G4+H4+I4". Therefore, by combining the summary value in box 604 and the set of cell references in box 606, the target calculation formula for the target cell corresponding to the annual total can be obtained. For distinction, the target calculation formula for the target cell of the annual total in Table 602 is the first target calculation formula, and the summary value is the first summary value. Similarly, in Table 608, the value in box 610 is 700. This 700 is obtained by subtracting the value of the cell corresponding to July in Table 602 from the initial value of 1700 for the target cell corresponding to the annual total. Box 612 displays six cell references corresponding to the six cells from July to December: "J4+K4+L4+M4+N4+O4". Therefore, by combining the second summary value in box 608 and the set of cell references displayed in box 612, we can obtain the second target calculation formula for the target cell corresponding to the annual total. It should be noted that the original calculation formulas for the target cells of the annual total in Tables 602 and 608 are the same, both obtained by combining the dimension combination objects corresponding to the cells from January to December, and the initial value is the same, 1700.

[0087] The first target calculation formula (composed of the first summary value in box 604 and the cell references in box 606), the annual total cell, and a set of display cells for January to June in Table 602 can all be displayed on the display device of computing device 102. Similarly, the second target calculation formula (composed of the second summary value in box 610 and the cell references in box 612), the annual total cell, and a set of display cells for July to December in Table 608 can also be displayed on the display device of computing device 102. Furthermore, changes in values ​​can be displayed quickly and in real time while the user is processing the data.

[0088] In some embodiments, after the value of any cell in the six cells from January to June in Table 602 is adjusted, the value of the target cell corresponding to the annual total can be quickly calculated. In one example, when the value of the cell corresponding to May in Table 602 is adjusted to 100, the value of the target cell for the annual total becomes 1000 + "D4 value + E4 value + F4 value + G4 value + H4 value + I4 value" = 1000 + (100 + 200 + 300 + 100 + 100 + 0) = 1800 according to the first target calculation formula. Additionally, the value of the target cell corresponding to the annual total in Table 608 will also be updated to 1800, and the summary value in box 610 in Table 608 will also be updated to 1800 - 1000 = 800. It is understandable that when the values ​​of the cells corresponding to the six cells from July to December in Table 608 are adjusted, the value of the target cell for the annual total in Table 602 and the summary value in box 604 of Table 602 will also be updated accordingly. It should be noted that the table data in Example 600 is merely an example and is not intended to limit this disclosure. This method flexibly utilizes changes in the values ​​of referenceable cells within the target table to quickly perform calculations in multidimensional data processing, greatly improving the efficiency of multidimensional data processing.

[0089] Figure 7 A block diagram of a data processing apparatus 700 according to an embodiment of this application is further shown. The apparatus 700 is applied to a device where the computing device 102 is located, and may include multiple modules for performing tasks such as... Figure 2 The corresponding steps in process 200 discussed herein. For example... Figure 7 As shown, the apparatus 700 includes: an original calculation formula determination unit 702, configured to determine an original calculation formula for a target cell, the original calculation formula indicating the operation relationship of the target cell calculated based on multiple calculation factor cells, the target cell and the multiple calculation factor cells being cells in a table; a summary value determination unit 704, configured to determine a summary value of a set of hidden cells for the target cell based on the original calculation formula and a set of displayed cells, the set of displayed cells being cells displayed on the user interface among the multiple calculation factor cells, and the set of hidden cells being cells not displayed on the user interface among the multiple calculation factor cells; a target calculation formula determination unit 706, configured to determine a target calculation formula for the target cell based on a set of displayed cells and a summary value, the target calculation formula indicating the operation relationship of the target cell calculated based on a set of displayed cells and a summary value; and a display unit 708, configured to display the target calculation formula on the user interface.

[0090] In some embodiments, the apparatus further includes: an incremental value determination unit configured to determine an incremental value for the value of a cell in response to an adjustment of the value of a cell in a set of displayed cells; and a value update unit configured to update the value of a target cell based on the incremental value using a target calculation formula.

[0091] In some embodiments, the apparatus further includes a display unit configured to display a target cell on a user interface.

[0092] In some embodiments, the summary value determination unit 704 includes: an identifier determination unit configured to determine a set of identifiers for a set of displayed cells; a formula adjustment unit configured to adjust an original calculation formula based on the set of identifiers; and a summary value determination unit configured to determine a summary value formed by the values ​​of a set of hidden cells based on the initial value of the target cell and the adjusted original calculation formula.

[0093] In some embodiments, the target calculation formula determination unit 706 includes a combination unit configured to determine the target calculation formula by combining a summary value and a set of identifiers of a set of display cells.

[0094] In some embodiments, the apparatus further includes a display unit configured to display an updated value on a user interface in response to an update of the value of the target cell.

[0095] In some embodiments, the table includes multiple tables, a first table of the multiple tables includes a target cell, a set of displayed cells and a set of hidden cells are determined for the first table, a summary value for the target cell is a first summary value, a target calculation formula is a first target calculation formula, and the first summary value remains unchanged in the first table.

[0096] In some embodiments, wherein the target cell is a first cell, a set of displayed cells is a first set of displayed cells, and a set of hidden cells is a first set of hidden cells, the apparatus further includes: a second summary value determining unit configured to determine a second summary value for a second cell in the second table in response to switching to a second table different from the first table in the user interface, wherein the first cell and the second cell have the same original calculation formula; a second target calculation formula determining unit configured to determine a second target calculation formula for the second cell based on the second summary value and the second set of displayed cells for the second cell; and a display unit configured to display the second target calculation formula on the user interface.

[0097] In some embodiments, the original calculation formula determination unit 702 includes: a target dimension combination object determination unit, configured to determine a target dimension combination object corresponding to a target cell in a multidimensional model used to store business data; and a first formula determination unit, configured to determine an original calculation formula related to the target dimension combination object based on the metadata of the multidimensional model.

[0098] In some embodiments, the first formula determining unit includes: a multiple dimension combination object determining unit, configured to determine multiple dimension combination objects corresponding to a target dimension combination object based on the calculation path for the dimension combination object included in the metadata, wherein the dimension combination objects in the multiple dimension combination objects correspond to the calculation factor cells in the multiple calculation factor cells; and a second formula determining unit, configured to determine the original calculation formula for the target cell based on the multiple dimension combination objects and the operator for each dimension combination object in the multiple dimension combination objects in the metadata.

[0099] Figure 8 A schematic block diagram of an example device 800 that can be used to implement embodiments of the present application is shown. For example, according to embodiments of the present application... Figure 1 The computing device 102 in the example device 800 can be implemented by the example device 800. As shown, the device 800 includes a central processing unit (CPU) 801, which can perform various appropriate actions and processes according to computer program instructions stored in read-only memory (ROM) 802 or loaded from storage unit 808 into random access memory (RAM) 803. The RAM 803 can also store various programs and data required for the operation of the device 800. The CPU 801, ROM 802, and RAM 803 are interconnected via bus 804. An input / output (I / O) interface 805 is also connected to bus 804.

[0100] Multiple components in device 800 are connected to I / O interface 805, including: input unit 806, such as keyboard, mouse, etc.; output unit 807, such as various types of monitors, speakers, etc.; storage unit 808, such as disk, optical disk, etc.; and communication unit 809, such as network card, modem, wireless transceiver, etc. Communication unit 809 allows device 800 to exchange information / data with other devices through computer networks such as the Internet and / or various telecommunications networks.

[0101] The various processes and handling described above, such as method 300, can be executed by processing unit 801. For example, in some embodiments, method 300 can be implemented as a computer software program tangibly contained in a machine-readable medium, such as storage unit 808. In some embodiments, part or all of the computer program can be loaded and / or installed on device 800 via ROM 802 and / or communication unit 809. When the computer program is loaded into RAM 803 and executed by CPU 801, one or more actions of method 300 described above can be performed.

[0102] This application may be a method, apparatus, system, chip, and / or computer program product. A chip may include a processing unit and a communication interface, the processing unit being capable of processing program instructions received from the communication interface. A computer program product may include a computer-readable storage medium on which computer-readable program instructions for performing various aspects of this application are stored.

[0103] Computer-readable storage media can be tangible devices capable of holding and storing instructions for use by an instruction execution device. Computer-readable storage media can be, for example—but not limited to—electrical storage devices, magnetic storage devices, optical storage devices, electromagnetic storage devices, semiconductor storage devices, or any suitable combination thereof. More specific examples (a non-exhaustive list) of computer-readable storage media include: portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), static random access memory (SRAM), portable compact disc read-only memory (CD-ROM), digital multifunction disc (DVD), memory sticks, floppy disks, mechanical encoding devices, such as punch cards or recessed protrusions storing instructions thereon, and any suitable combination thereof. The computer-readable storage media used herein are not to be construed as transient signals themselves, such as radio waves or other freely propagating electromagnetic waves, electromagnetic waves propagating through waveguides or other transmission media (e.g., light pulses through fiber optic cables), or electrical signals transmitted through wires.

[0104] The computer-readable program instructions described herein can be downloaded from computer-readable storage media to various computing / processing devices, or downloaded via a network, such as the Internet, local area network, wide area network, and / or wireless network, to an external computer or external storage device. The network may include copper transmission cables, fiber optic transmission, wireless transmission, routers, firewalls, switches, gateway computers, and / or edge servers. A network adapter card or network interface in each computing / processing device receives the computer-readable program instructions from the network and forwards them to the computer-readable storage media in the respective computing / processing device.

[0105] The computer program instructions used to perform the operations of this application may be assembly instructions, instruction set architecture (ISA) instructions, machine instructions, machine-dependent instructions, microcode, firmware instructions, state setting data, or source code or object code written in any combination of one or more programming languages, including object-oriented programming languages ​​such as Smalltalk, C++, etc., and conventional procedural programming languages ​​such as the "C" language or similar programming languages. The computer-readable program instructions may be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving a remote computer, the remote computer may be connected to the user's computer via any type of network—including a local area network (LAN) or a wide area network (WAN)—or may be connected to an external computer (e.g., via the Internet using an Internet service provider). In some embodiments, electronic circuits, such as programmable logic circuits, field-programmable gate arrays (FPGAs), or programmable logic arrays (PLAs), are personalized by utilizing state information from the computer-readable program instructions. These electronic circuits can execute the computer-readable program instructions to implement various aspects of this application.

[0106] Various aspects of this application are described herein with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of this application. It should be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer-readable program instructions.

[0107] These computer-readable program instructions can be provided to a processing unit of a general-purpose computer, a special-purpose computer, or other programmable data processing apparatus to produce a machine such that, when executed by the processing unit of the computer or other programmable data processing apparatus, they create means for implementing the functions / actions specified in one or more blocks of the flowchart and / or block diagram. These computer-readable program instructions can also be stored in a computer-readable storage medium that causes a computer, programmable data processing apparatus, and / or other device to operate in a particular manner. Thus, the computer-readable medium storing the instructions comprises an article of manufacture that includes instructions for implementing aspects of the functions / actions specified in one or more blocks of the flowchart and / or block diagram.

[0108] Computer-readable program instructions may also be loaded onto a computer, other programmable data processing apparatus, or other device to cause a series of operational steps to be performed on the computer, other programmable data processing apparatus, or other device to produce a computer-implemented process, thereby causing the instructions executed on the computer, other programmable data processing apparatus, or other device to perform the functions / actions specified in one or more boxes of a flowchart and / or block diagram.

[0109] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of this application. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of an instruction containing one or more executable instructions for implementing a specified logical function. In some alternative implementations, the functions marked in the blocks may occur in a different order than those marked in the drawings. For example, two consecutive blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, can be implemented using a dedicated hardware-based system that performs the specified function or action, or using a combination of dedicated hardware and computer instructions.

[0110] The various embodiments of this application have been described above. These descriptions are exemplary and not exhaustive, nor are they limited to the disclosed embodiments. Many modifications and variations will be apparent to those skilled in the art without departing from the scope and spirit of the described embodiments. The terminology used herein is chosen to best explain the principles, practical applications, or improvements to technology in the market, or to enable others skilled in the art to understand the embodiments disclosed herein.

Claims

1. A data processing method, characterized in that, include: Determine the original calculation formula for the target cell, the original calculation formula being used to indicate the operational relationship of the target cell calculated based on multiple calculation factor cells, the target cell and the multiple calculation factor cells being cells in a table; Based on the original calculation formula and a set of displayed cells, a summary value of a set of hidden cells for the target cell is determined. The set of displayed cells are the cells among the plurality of calculation factor cells that are displayed on the user interface, and the set of hidden cells are the cells among the plurality of calculation factor cells that are not displayed on the user interface. Based on the set of displayed cells and the summary value, a target calculation formula is determined for the target cell. The target calculation formula is used to indicate the operation relationship calculated based on the set of displayed cells and the summary value to obtain the target cell. as well as The target calculation formula is displayed on the user interface.

2. The method according to claim 1, characterized in that, The method further includes: In response to an adjustment to the value of a cell in the set of displayed cells, an incremental value is determined for the value of that cell; and Based on the incremental value, the value of the target cell is updated using the target calculation formula.

3. The method according to claim 1 or 2, characterized in that, The method includes: The target cell is displayed on the user interface.

4. The method according to claim 1, characterized in that, Determining the summary value of a set of hidden cells for the target cell includes: Determine a set of identifiers for the set of displayed cells; Based on the aforementioned set of identifiers, the original calculation formula is adjusted; and Based on the initial value of the target cell and the adjusted original calculation formula, the summary value formed by the values ​​of the set of hidden cells is determined.

5. The method according to claim 1, characterized in that, Determining the target calculation formula for the target cell includes: The target calculation formula is determined by combining the summary value and a set of identifiers of the set of display cells.

6. The method according to claim 5, characterized in that, Also includes: In response to the value of the target cell being updated, the updated value is displayed on the user interface.

7. The method according to claim 5, characterized in that, The table includes multiple tables, the first table of the multiple tables includes the target cell, the set of displayed cells and the set of hidden cells are determined for the first table, the summary value for the target cell is a first summary value, the target calculation formula is a first target calculation formula, and the first summary value remains unchanged in the first table.

8. The method according to claim 7, characterized in that, The target cell is the first cell, the group of displayed cells is the first group of displayed cells, the group of hidden cells is the first group of hidden cells, and the method further includes: In response to switching from the first table to the second table among the plurality of tables in the user interface, a second summary value is determined for the second cell in the second table, wherein the first cell and the second cell have the same original calculation formula, and the plurality of calculation factor cells are divided into a second group of displayed cells and a second group of hidden cells relative to the second table, and the second summary value is the summary value of the second group of hidden cells; Based on the second summary value and the second group of displayed cells for the second cell, determine the second target calculation formula for the second cell; and The formula for calculating the second target is displayed on the user interface.

9. The method according to claim 1, characterized in that, Determining the original calculation formula for the target cell includes: Determine the target dimension combination object corresponding to the target cell in the multidimensional model used to store business data; and Based on the metadata of the multidimensional model, the original calculation formula related to the target dimension combination object is determined.

10. The method according to claim 9, characterized in that, Based on the metadata of the multidimensional model, the original calculation formula related to the target dimension combination object is determined as follows: Based on the computation path for the dimension combination object included in the metadata, multiple dimension combination objects corresponding to the target dimension combination object are determined, wherein the dimension combination objects in the multiple dimension combination objects correspond to the computation factor cells in the multiple computation factor cells; and Based on the multiple dimension combination objects and the operators in the metadata for each of the multiple dimension combination objects, the original calculation formula for the target cell is determined.

11. An apparatus for data processing, characterized in that, include: The original calculation formula determination unit is configured to determine the original calculation formula for the target cell, wherein the original calculation formula is used to indicate the operation relationship of the target cell calculated based on multiple calculation factor cells, and the target cell and the multiple calculation factor cells are cells in a table; The summary value determination unit is configured to determine the summary value of a set of hidden cells for the target cell based on the original calculation formula and a set of displayed cells, wherein the set of displayed cells are the cells displayed on the user interface among the plurality of calculation factor cells, and the set of hidden cells are the cells not displayed on the user interface among the plurality of calculation factor cells; The target calculation formula determination unit is configured to determine a target calculation formula for the target cell based on the set of display cells and the summary value. The target calculation formula is used to indicate the operation relationship for calculating the target cell based on the set of display cells and the summary value. as well as The display unit is configured to display the target calculation formula on the user interface.

12. The apparatus according to claim 11, characterized in that, Also includes: An incremental value determination unit is configured to determine an incremental value for the value of a cell in the set of displayed cells in response to an adjustment of the value of the cell. as well as The value update unit is configured to update the value of the target cell based on the incremental value using the target calculation formula.

13. The apparatus according to claim 11 or 12, characterized in that, Also includes: The display unit is configured to display the target cell on the user interface.

14. The apparatus according to claim 11, characterized in that, The summary value determination unit includes: The identifier determination unit is configured to determine a set of identifiers for the set of display cells; The formula adjustment unit is configured to adjust the original calculation formula based on the set of identifiers; and The summary value determination unit is configured to determine the summary value formed by the values ​​of the set of hidden cells based on the initial value of the target cell and the adjusted original calculation formula.

15. The apparatus according to claim 11, characterized in that, The target calculation formula determination unit includes: The combination unit is configured to determine the target calculation formula by combining the summary value and a set of identifiers of the set of display cells.

16. The apparatus according to claim 15, characterized in that, Also includes: The display unit is configured to display the updated value on the user interface in response to the value of the target cell being updated.

17. The apparatus according to claim 15, characterized in that, The table is one of multiple tables, the summary value for the target cell is a first summary value, the target calculation formula is a first target calculation formula, and the first summary value remains unchanged in the table.

18. The apparatus according to claim 17, characterized in that, The table is a first table, the target cell is a first cell, the group of display cells is a first group of display cells, and it also includes: The second summary value determination unit is configured to determine a second summary value for a second cell in the second table in response to switching to a second table in the user interface that is different from the first table, wherein the first cell and the second cell have the same original calculation formula; The second target calculation formula determination unit is configured to determine a second target calculation formula for the second cell based on the second summary value and a second set of display cells for the second cell; and The display unit is configured to display the second target calculation formula on the user interface.

19. The apparatus according to claim 11, characterized in that, The unit for determining the original calculation formula includes: The target dimension combination object determination unit is configured to determine the target dimension combination object corresponding to the target cell in a multidimensional model used to store business data; and The first formula determination unit is configured to determine the original calculation formula related to the target dimension combination object based on the metadata of the multidimensional model.

20. The apparatus according to claim 19, characterized in that, The first formula determination unit includes: A multi-dimensional combination object determination unit is configured to determine multiple dimension combination objects corresponding to the target dimension combination object based on the calculation path for the dimension combination object included in the metadata, wherein the dimension combination objects in the multiple dimension combination objects correspond to the calculation factor cells in the multiple calculation factor cells; and The second formula determination unit is configured to determine the original calculation formula for the target cell based on the multiple dimension combination objects and the operators in the metadata for each of the multiple dimension combination objects.

21. An electronic device, comprising: At least one processor; as well as A storage device for storing at least one program, which, when executed by the at least one processor, causes the at least one processor to implement the method according to any one of claims 1-10.

22. A computer-readable storage medium having a computer program stored thereon, the program being executed by a processor to implement the method according to any one of claims 1-10.

23. A computer program product comprising computer-executable instructions, wherein the computer-executable instructions, when executed by a processor, implement the method according to any one of claims 1-10.

Images