Method, device, equipment and product for configuring multiple access formulas by one cell

Abstract

The invention discloses a method, a device, equipment and a product for configuring multiple access formulas in one cell, and relates to the technical field of report compiling. Comprising the following steps: in response to an allocation operation that a superior management user allocates a plurality of first access formulas to a plurality of first users in the same cell of a target report, inserting a plurality of access formula records in a formula designation table; writing access formula information of a plurality of first users into a cache to update the cache, so that the first users find out a first cell list recorded in the access formula information corresponding to the users from the cache based on the identification information of the first users and the identification information of the target report, and querying an access formula corresponding to each cell in the first cell list from the formula designation table so as to obtain an access result of each cell in the first cell list according to the access formula. According to the method, multi-access formula setting in the same cell of the same report can be realized, and the method can be widely applied to report compiling of different industry companies in the same group.

Description

Technical Field

[0001] This invention belongs to the field of report preparation technology, specifically relating to a method, apparatus, device, and product for configuring multiple data retrieval formulas in a single cell. Background Technology

[0002] In the process of compiling group reports, in order to adapt to different industry units, the same cell in the same report often needs to have multiple data retrieval formulas, which are then distributed to users in each subordinate unit for data retrieval and application.

[0003] Existing technology uses industry-specific data retrieval formulas configured on representatives of different industry units within the same report to form a data source. This addresses the differences in data retrieval formulas for some report cells caused by the characteristics of different industries (while the formulas for other cells remain the same). The data source then publishes the retrieval formulas to the corresponding industry units to meet the reporting data retrieval needs of different industry companies within a group. However, because the data retrieval formulas for a large number of report cells within the same report are consistent across industries, there is significant formula duplication between data sources within the same report. This results in low formula reuse rates, high maintenance workload, and low compilation efficiency, severely restricting the rapid deployment and flexible expansion capabilities of group reports.

[0004] Therefore, how to provide an effective solution to facilitate the preparation of financial statements for companies in different industries within a group has become a pressing problem that needs to be solved in the existing technology. Summary of the Invention

[0005] The purpose of this invention is to provide a method, apparatus, device, and product for configuring multiple data retrieval formulas in a single cell, in order to solve the aforementioned problems existing in the prior art.

[0006] To achieve the above objectives, the present invention adopts the following technical solution: In a first aspect, the present invention provides a method for configuring multiple data retrieval formulas in a single cell, including: In response to the allocation operation of the superior management user to assign multiple first data retrieval formulas to multiple corresponding first users in the same cell of the target report, multiple data retrieval formula records corresponding to the multiple first data retrieval formulas are inserted into the formula specification table. Each data retrieval formula record includes the identification information of the corresponding first data retrieval formula, the identification information of the target report, and the identification information of the corresponding first user. Write the data retrieval formula information of the multiple first users into the cache to update the cache, so that any first user can retrieve the list of first cells recorded in the data retrieval formula information corresponding to any first user from the cache based on the identification information of any first user and the identification information of the target report, and retrieve the data retrieval formula corresponding to each cell in the first cell list from the formula specification table, so as to obtain the data retrieval result of each cell in the first cell list according to the data retrieval formula; The data retrieval formula information for the first user includes the identification information of the first user, the identification information of the target report, and the position information of the cell where the data retrieval formula is inserted.

[0007] In one possible design, the method further includes: In response to the second user's request for data retrieval from the target report, the list of cells recorded in the data retrieval formula information corresponding to the second user is retrieved from the cache based on the identification information of the second user and the identification information of the target report; Based on the identification information of the second user and the identification information of the target report, the second data retrieval formula corresponding to each cell in the cell list is queried from the formula specification table, wherein the formula specification table records the user identification information and report identification information corresponding to each data retrieval formula; After retrieving the second data retrieval formula corresponding to any cell in the cell list, the second data retrieval formula corresponding to that cell is parsed and executed to obtain the data retrieval result of that cell.

[0008] In one possible design, before inserting multiple data retrieval formula records corresponding one-to-one with the multiple first data retrieval formulas in the formula specification table in response to an assignment operation by a superior management user to multiple corresponding first users in the same cell of a target report, the method further includes: In response to the upper-level management user's operation of setting multiple data retrieval formulas for a specified cell on the target report, the multiple data retrieval formula records entered by the upper-level management user are written into the data retrieval formula table. The data retrieval formula records include the identification information of the third data retrieval formula, the identification information of the target report, the label of the third data retrieval formula, the version number of the third data retrieval formula, and the activation status of the third data retrieval formula. Create a composite index on the data retrieval formula table that includes the identification information of the target report and the activation status of the third data retrieval formula; Create a composite index on the formula-specified table containing the identification information of the standard report and the user identification of the assigned user; Write all data retrieval formula information of the specified cell to the cache. All data retrieval formula information of the specified cell includes the identifier information of the third data retrieval formula, the content of the third data retrieval formula, the label of the third data retrieval formula, and the update time of the third data retrieval formula. The index of all data retrieval formula information of the specified cell is the cell name of the specified cell and the identifier information of the target report.

[0009] In one possible design, before writing the multiple data retrieval formula records entered by the superior management user into the data retrieval formula table, the method further includes: Verify whether the identification information of the target report already exists and was created by the aforementioned superior management user; Verify that the coordinate format of the third data retrieval formula is correct; Verify whether the specified cell has a data retrieval formula that is the same as the third data retrieval formula; Verify that the syntax and logic of the third data retrieval formula are correct.

[0010] In one possible design, before inserting multiple data retrieval formula records corresponding one-to-one with the multiple first data retrieval formulas in the formula specification table in response to an assignment operation by a superior management user to multiple corresponding first users in the same cell of a target report, the method further includes: Verify the legitimacy of the permissions and assignment operations of the superior management user.

[0011] In one possible design, before inserting multiple data retrieval formula records corresponding one-to-one with the multiple first data retrieval formulas in the formula specification table in response to an assignment operation by a superior management user to multiple corresponding first users in the same cell of a target report, the method further includes: The formula specifies a table to check if any other data retrieval formulas have already been assigned to the first user in the cell where the first data retrieval formula is to be assigned to the first user. If another data retrieval formula has already been assigned to the first user in the cell where the first data retrieval formula is to be assigned, then the existing other data retrieval formula will be overwritten, the priority of the first data retrieval formula will be determined based on the set priority order, or a message will be sent to the superior administrator indicating a conflict.

[0012] In one possible design, the data retrieval formula record may also include the effective date of the first data retrieval formula, the expiration date of the first data retrieval formula, and the priority of the first data retrieval formula.

[0013] Secondly, the present invention provides an apparatus for configuring multiple data retrieval formulas in a single cell, comprising: The insertion unit is used to respond to the allocation operation of the superior management user in the same cell of the target report to assign multiple first data retrieval formulas to multiple corresponding first users, and to insert multiple data retrieval formula records corresponding to the multiple first data retrieval formulas in the formula specification table. Each data retrieval formula record includes the identification information of the corresponding first data retrieval formula, the identification information of the target report, and the identification information of the corresponding first user. The writing unit is used to write the data retrieval formula information of the multiple first users into the cache to update the cache, so that any first user can retrieve the first cell list recorded in the data retrieval formula information corresponding to any first user from the cache based on the identification information of any first user and the identification information of the target report, and retrieve the data retrieval formula corresponding to each cell in the first cell list from the formula specification table, so as to obtain the data retrieval result of each cell in the first cell list according to the data retrieval formula; The data retrieval formula information for the first user includes the identification information of the first user, the identification information of the target report, and the position information of the cell where the data retrieval formula is inserted.

[0014] Thirdly, the present invention provides an electronic device comprising a memory, a processor, and a transceiver connected in sequence and communication, wherein the memory is used to store a computer program, the transceiver is used to send and receive messages, and the processor is used to read the computer program and execute a method for configuring multiple data retrieval formulas in a cell as described in the first aspect or any possible design of the first aspect.

[0015] Fourthly, the present invention provides a computer-readable storage medium storing instructions that, when executed on a computer, perform the method of configuring multiple data retrieval formulas in a cell as described in the first aspect or any possible design of the first aspect.

[0016] Fifthly, the present invention provides a computer program product containing instructions that, when the instructions are executed on a computer, cause the computer to perform a method for configuring multiple data retrieval formulas in a cell as described in the first aspect or any possible design of the first aspect.

[0017] Beneficial effects: This invention responds to an allocation operation by a higher-level management user assigning multiple first data retrieval formulas to multiple corresponding first users in the same cell of a target report. It inserts multiple data retrieval formula records, each corresponding to a first data retrieval formula, into a formula specification table. Each data retrieval formula record includes the identifier information of the corresponding first data retrieval formula, the identifier information of the target report, and the identifier information of the corresponding first user. The invention also updates the cache by writing the data retrieval formula information of the multiple first users, allowing any first user to retrieve the list of first cells recorded in the corresponding data retrieval formula information from the cache based on the identifier information of any first user and the identifier information of the target report. Furthermore, it retrieves the data retrieval formula corresponding to each cell in the first cell list from the formula specification table, thereby obtaining the data retrieval result for each cell in the first cell list based on the data retrieval formula. The data retrieval formula information of each first user includes the identifier information of the first user, the identifier information of the target report, and the position information of the cell where the data retrieval formula is inserted. By inserting data retrieval formula records containing data retrieval formula identifiers, report identifiers, and user identifiers into the formula specification table, and simultaneously writing user-specific data retrieval formula information containing user identifiers, report identifiers, and data retrieval formula cell location information into the cache, users can find the cell assigned to them based on their user and report identifiers, locate the corresponding data retrieval formula, and then retrieve data using that formula. This allows higher-level administrators to set different data retrieval formulas for different users in the same report's cells, and different users can also find their corresponding data retrieval formulas to retrieve data. This enables multiple data retrieval formula settings in the same cell of the same report, enhancing report reusability, unifying formula data sources, and reducing report preparation workload. It can be widely used for report preparation in different industries within the same group, facilitating practical application and promotion. Attached Figure Description

[0018] Figure 1 A flowchart illustrating a method for configuring multiple data retrieval formulas in a single cell, as provided in this application embodiment; Figure 2 A block diagram illustrating a device for configuring multiple data retrieval formulas in a cell according to an embodiment of this application; Figure 3 This is a block diagram of an electronic device provided in an embodiment of this application. Detailed Implementation

[0019] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the present invention will be briefly introduced below in conjunction with the accompanying drawings and descriptions of the embodiments or the prior art. Obviously, the following description of the structure of the accompanying drawings is only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort. It should be noted that the description of these embodiments is for the purpose of helping to understand the present invention, but does not constitute a limitation of the present invention.

[0020] It should be understood that although the terms first, second, etc., may be used herein to describe various units, these units should not be limited by these terms. These terms are only used to distinguish one unit from another. For example, a first unit may be referred to as a second unit, and similarly, a second unit may be referred to as a first unit, without departing from the scope of the exemplary embodiments of the invention.

[0021] It should be understood that the term "and / or" that may appear in this document is merely a description of the relationship between related objects, indicating that three relationships can exist. For example, A and / or B can mean: A exists alone, B exists alone, and A and B exist simultaneously. The term " / and" that may appear in this document describes another relationship between related objects, indicating that two relationships can exist. For example, A / and B can mean: A exists alone, and A and B exist alone. In addition, the character " / " that may appear in this document generally indicates that the related objects before and after it are in an "or" relationship.

[0022] It should be understood that specific details are provided in the following description to facilitate a complete understanding of the exemplary embodiments. However, those skilled in the art will understand that the exemplary embodiments can be implemented without these specific details. For example, the system may be shown in block diagrams to avoid obscuring the example with unnecessary details. In other instances, well-known processes, structures, and techniques may be shown without unnecessary details to avoid obscuring the exemplary embodiments.

[0023] To facilitate the preparation of reports for companies in different industries within a group, this application provides a method, apparatus, device, and product for configuring multiple data retrieval formulas in a single cell. This method, apparatus, device, and product can realize the setting of multiple data retrieval formulas in the same cell of the same report, and can be widely used for the preparation of reports for companies in different industries within the same group.

[0024] The method for configuring multiple data retrieval formulas in a single cell, as provided in this application embodiment, can be applied to a server or a user terminal of a group-level management user terminal. It is understood that the executing entity does not constitute a limitation on the embodiments of this application.

[0025] The following will provide a detailed description of the method for configuring multiple data retrieval formulas in a single cell, as provided in the embodiments of this application.

[0026] like Figure 1 The diagram shown is a flowchart of a method for configuring multiple data retrieval formulas in a cell, provided by the first aspect of the embodiments of this application. This method for configuring multiple data retrieval formulas in a cell may include, but is not limited to, the following steps S101-S102.

[0027] Step S101. In response to the allocation operation of the superior management user in the same cell of the target report to assign multiple first data retrieval formulas to multiple corresponding first users, insert multiple data retrieval formula records corresponding to the multiple first data retrieval formulas in the formula specification table.

[0028] When a higher-level administrator needs to set different first data retrieval formulas for multiple first users in the same cell of a target report, they can initiate an allocation operation to assign multiple first data retrieval formulas to multiple corresponding first users in the same cell of the target report. At this time, multiple data retrieval formula records corresponding one-to-one with the multiple first data retrieval formulas can be inserted into the formula specification table. Each data retrieval formula record includes the identification information of the corresponding first data retrieval formula, the identification information of the target report, and the identification information of the corresponding first user. The formula specification table records the identification information of the data retrieval formula, the identification information of the report where the data retrieval formula is located, the user identification information of the user corresponding to the data retrieval formula, and the identification information of the table corresponding to the data retrieval formula, etc.

[0029] In one or more embodiments, the inserted data retrieval formula record may also include the effective date of the first data retrieval formula, the expiration date of the first data retrieval formula, the priority of the first data retrieval formula, the status of the first data retrieval formula (effective), and information such as the operator (e.g., user information of the superior management user) and the operation time (corresponding to the allocation operation).

[0030] In one or more embodiments, before inserting multiple data retrieval formula records corresponding to the multiple first data retrieval formulas into the formula specification table in response to the allocation operation of the superior management user in the same cell of the target report to a multiple first users, the permissions of the superior management user and the legality of the allocation operation may also be verified.

[0031] Verifying the permissions of the superior management user can involve verifying whether the superior management user has the authority to initiate the data retrieval formula assignment operation (usually the report creator or administrator has this authority). Verifying the legality of the assignment operation by the superior management user can involve verifying whether the target report's identification information is correct, verifying whether the first user's identification information exists and is a valid user, and verifying whether the first data retrieval formula is duplicated (the same first data retrieval formula already exists in the same cell of the same unit).

[0032] In one or more embodiments, before inserting multiple data retrieval formula records corresponding to the multiple first data retrieval formulas into the formula specification table in response to the allocation operation of the superior management user to allocate multiple first data retrieval formulas to multiple corresponding first users in the same cell of the target report, the formula specification table can be queried to see if other data retrieval formulas have already been allocated to the first users in the cell to which the first data retrieval formula is to be allocated. If other data retrieval formulas have already been allocated to the first users in the cell to which the first data retrieval formula is to be allocated, the existing other data retrieval formulas can be overwritten, or the priority of the first data retrieval formula and the existing other data retrieval formulas can be determined based on a set priority order, or the superior management user can be prompted that there is a conflict.

[0033] Step S102. Write multiple first user's data retrieval formula information into the cache to update the cache, so that any first user can retrieve the first cell list recorded in the data retrieval formula information corresponding to any first user from the cache based on the identification information of any first user and the identification information of the target report, and retrieve the data retrieval formula corresponding to each cell in the first cell list from the formula specified table, so as to obtain the data retrieval result of each cell in the first cell list according to the data retrieval formula.

[0034] The data retrieval formula information for the first user includes the identification information of the first user, the identification information of the target report, and the position information of the cell where the data retrieval formula is inserted.

[0035] In one or more embodiments, the expiration time (e.g., 24 hours) for data written to the cache can also be set automatically.

[0036] Writing the first user's data retrieval formula information into the cache to update the cache can also record relevant information about the formula allocation operation in the audit table, including the operator (superior management user), operation time, operation content, and the status of the target report before and after the operation.

[0037] This invention responds to an allocation operation by a higher-level management user assigning multiple first data retrieval formulas to multiple corresponding first users in the same cell of a target report. It inserts multiple data retrieval formula records, each corresponding to a first data retrieval formula, into a formula specification table. Each data retrieval formula record includes the identifier information of the corresponding first data retrieval formula, the identifier information of the target report, and the identifier information of the corresponding first user. The invention also updates the cache by writing the data retrieval formula information of the multiple first users, allowing any first user to retrieve the list of first cells recorded in the corresponding data retrieval formula information from the cache based on the identifier information of any first user and the identifier information of the target report. Furthermore, it retrieves the data retrieval formula corresponding to each cell in the first cell list from the formula specification table, thereby obtaining the data retrieval result for each cell in the first cell list based on the data retrieval formula. The data retrieval formula information of each first user includes the identifier information of the first user, the identifier information of the target report, and the position information of the cell where the data retrieval formula is inserted. By inserting data retrieval formula records containing data retrieval formula identifiers, report identifiers, and user identifiers into the formula specification table, and simultaneously writing user-specific data retrieval formula information containing user identifiers, report identifiers, and data retrieval formula cell location information into the cache, users can find the cell assigned to them based on their user and report identifiers, locate the corresponding data retrieval formula, and then retrieve data using that formula. This allows higher-level administrators to set different data retrieval formulas for different users in the same report's cells, and different users can also find their corresponding data retrieval formulas to retrieve data. This enables multiple data retrieval formula settings in the same cell of the same report, enhancing report reusability, unifying formula data sources, and reducing report preparation workload. It can be widely used for report preparation in different industries within the same group, facilitating practical application and promotion.

[0038] This application embodiment also provides a possible design for users to retrieve data through the data retrieval formula corresponding to the cell in the target report, which may include, but is not limited to, the following steps S201-S203.

[0039] Step S201. In response to the second user's request for data retrieval from the target report, retrieve the list of cells recorded in the data retrieval formula information corresponding to the second user from the cache based on the identification information of the second user and the identification information of the target report.

[0040] The second user's request for data retrieval from the target report includes the identification information of the target report, the identification information of the second user, and some other parameters.

[0041] After receiving a data retrieval request from a second user for a target report, the system can retrieve data retrieval formula information (i.e., the data retrieval formula information corresponding to the second user) from the cache based on the identification information of the second user and the identification information of the target report. All cells recorded in all the retrieved data retrieval formula information constitute a cell list.

[0042] Step S202. Based on the identification information of the second user and the identification information of the target report, query the second data retrieval formula corresponding to each cell in the cell list from the formula specification table.

[0043] The formula specification table records the user identification information and report identification information corresponding to each data retrieval formula.

[0044] In one or more embodiments, when querying the second data retrieval formula corresponding to each cell in the cell list from the formula specification table, the query conditions may also include the data retrieval formula being in effect and the current date being within the effective date of the data retrieval formula.

[0045] If multiple secondary formulas are found for a given cell, the secondary formula with the highest priority can be selected as the secondary formula for that cell.

[0046] Step S203. After finding the second data retrieval formula corresponding to any cell in the cell list, parse and execute the second data retrieval formula corresponding to the cell to obtain the data retrieval result of the cell.

[0047] In one or more embodiments, if the second data retrieval formula corresponding to a certain cell is empty, that is, the cell does not have a corresponding second data retrieval formula, a general formula or a default formula can be selected as the second data retrieval formula corresponding to the cell. If there is neither a general formula nor a default formula, an error can be returned.

[0048] Therefore, through the aforementioned possible design one, users can find the cell to which the data retrieval formula is assigned based on user identification information and report identification information, and then retrieve the data according to the corresponding data retrieval formula. This allows different users to use their corresponding data retrieval formula to retrieve data, realizing the retrieval of data by multiple data retrieval formulas for different users in the same cell under the same report.

[0049] This application embodiment also provides a possible design two for setting multi-value formulas on cells of a report, which may include, but is not limited to, the following steps S301-S304.

[0050] Step S301. In response to the upper-level management user's operation of setting multiple data retrieval formulas for specified cells on the target report, write the multiple data retrieval formula records entered by the upper-level management user into the data retrieval formula table.

[0051] The data retrieval formula record may include, but is not limited to, the identification information of the third data retrieval formula, the identification information of the target report, the label of the third data retrieval formula, the version number of the third data retrieval formula, and the activation status of the third data retrieval formula.

[0052] In one or more instances, before writing multiple data retrieval formula records entered by the superior management user into the data retrieval formula table, it is also possible to verify whether the identification information of the target report already exists and belongs to the superior management user, verify whether the coordinate format of the third data retrieval formula is correct, verify whether the specified cell has a data retrieval formula that is the same as the third data retrieval formula (if so, version management can be performed), and verify whether the syntax and logic of the third data retrieval formula are correct (such as SQL injection detection, function validity detection, etc.).

[0053] Step S302. Create a composite index on the data retrieval formula table that includes the identification information of the target report and the activation status of the third data retrieval formula.

[0054] Step S303. Create a composite index on the formula-specified table that combines the identification information of the standard report with the user identification of the assigned user.

[0055] Step S304. Write all the data retrieval formula information of the specified cell into the cache. The data retrieval formula information of the specified cell includes the identifier information of the third data retrieval formula, the content of the third data retrieval formula, the label of the third data retrieval formula, and the update time of the third data retrieval formula.

[0056] The index for all data retrieval formulas in a specified cell is the cell name of the specified cell and the identifier of the target report.

[0057] Please see Figure 2 The second aspect of this application provides an apparatus for configuring multiple data retrieval formulas in a single cell. The apparatus includes: The insertion unit is used to respond to the allocation operation of the superior management user in the same cell of the target report to assign multiple first data retrieval formulas to multiple corresponding first users, and to insert multiple data retrieval formula records corresponding to the multiple first data retrieval formulas in the formula specification table. Each data retrieval formula record includes the identification information of the corresponding first data retrieval formula, the identification information of the target report, and the identification information of the corresponding first user. The writing unit is used to write the data retrieval formula information of the multiple first users into the cache to update the cache, so that any first user can retrieve the first cell list recorded in the data retrieval formula information corresponding to any first user from the cache based on the identification information of any first user and the identification information of the target report, and retrieve the data retrieval formula corresponding to each cell in the first cell list from the formula specification table, so as to obtain the data retrieval result of each cell in the first cell list according to the data retrieval formula; The data retrieval formula information for the first user includes the identification information of the first user, the identification information of the target report, and the position information of the cell where the data retrieval formula is inserted.

[0058] The working process, working details and technical effects of the device for configuring multiple data retrieval formulas in a single cell provided in the second aspect of this embodiment can be found in the first aspect of the embodiment, and will not be repeated here.

[0059] Please see Figure 3 The third aspect of this application provides an electronic device, including a memory, a processor, and a transceiver that are sequentially and communicatively connected, wherein the memory is used to store a computer program, the transceiver is used to send and receive messages, and the processor is used to read the computer program and execute the method of configuring multiple data retrieval formulas in a cell as described in the first aspect of the application.

[0060] Specifically, the memory may include, but is not limited to, random access memory (RAM), read-only memory (ROM), flash memory, first-in-first-out (FIFO) memory, and / or last-in-first-out (FILO) memory, etc.; the processor may not be limited to microprocessors of the STM32F105 series, ARM (Advanced RISC Machines), x86 architecture processors, or processors with integrated NPU (neural-network processing units); the transceiver may be, but is not limited to, WiFi (Wireless Fidelity) wireless transceivers, Bluetooth wireless transceivers, General Packet Radio Service (GPRS) wireless transceivers, ZigBee (a low-power LAN protocol based on the IEEE 802.15.4 standard), 3G transceivers, 4G transceivers, and / or 5G transceivers, etc.

[0061] This fourth aspect of the embodiment provides a computer-readable storage medium storing instructions containing the method for configuring multiple data retrieval formulas in a cell as described in the first aspect of the embodiment. Specifically, the computer-readable storage medium stores instructions that, when executed on a computer, perform the method for configuring multiple data retrieval formulas in a cell as described in the first aspect. The computer-readable storage medium refers to a data storage medium, which may include, but is not limited to, floppy disks, optical disks, hard disks, flash memory, USB flash drives, and / or Memory Sticks. The computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable devices.

[0062] The fifth aspect of this embodiment provides a computer program product containing instructions that, when executed on a computer, cause the computer to perform a method for configuring multiple data retrieval formulas in a cell as described in the first aspect of this embodiment, wherein the computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable device.

[0063] Finally, it should be noted that the above description is merely a preferred embodiment of the present invention and is not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the scope of protection of the present invention.

Claims

1. A method for configuring a plurality of retrieval formulas in a single cell, comprising: The method comprises: in response to the allocation operation of the superior management user allocating a plurality of first data extraction formulas to a plurality of first users one by one in the same cell of the target report, inserting a plurality of data extraction formula records corresponding to the plurality of first data extraction formulas one by one in the formula specification table, each of the data extraction formula records comprising identification information of the corresponding first data extraction formula, identification information of the target report, and identification information of the corresponding first user; writing the data extraction formula information of the plurality of first users in the cache to update the cache, so that any first user can find the first cell list recorded in the corresponding data extraction formula information of the first user based on the identification information of any first user and the identification information of the target report from the cache, and query the data extraction formula corresponding to each cell in the first cell list from the formula specification table to obtain the data extraction result of each cell in the first cell list according to the data extraction formula; wherein the data extraction formula information of the first user comprises identification information of the first user, identification information of the target report, and position information of the cell where the data extraction formula is inserted.

2. The method for configuring a plurality of retrieval formulas for a single cell according to claim 1, wherein, The method further comprises: in response to the report data extraction request of the second user to the target report, finding the cell list recorded in the corresponding data extraction formula information of the second user from the cache based on the identification information of the second user and the identification information of the target report; based on the identification information of the second user and the identification information of the target report, querying the second data extraction formula corresponding to each cell in the cell list from the formula specification table, wherein the formula specification table records the user identification information and report identification information corresponding to each data extraction formula; after querying the second data extraction formula corresponding to any cell in the cell list, parsing and executing the second data extraction formula corresponding to the any cell to obtain the data extraction result of the any cell.

3. The method for configuring multiple formulas for retrieving data from a single cell according to claim 1, wherein, Before inserting a plurality of data extraction formula records corresponding to the plurality of first data extraction formulas one by one in the formula specification table in response to the allocation operation of the superior management user allocating a plurality of first data extraction formulas to a plurality of first users one by one in the same cell of the target report, the method further comprises: in response to the multi-data extraction formula setting operation of the superior management user on the specified cell of the target report, writing a plurality of data extraction formula records input by the superior management user into the data extraction formula table, the data extraction formula records comprising identification information of the third data extraction formula, identification information of the target report, a label of the third data extraction formula, a version number of the third data extraction formula, and an enabled state of the third data extraction formula; establishing a composite index of the identification information of the target report and the enabled state of the third data extraction formula on the data extraction formula table; establishing a composite index of the identification information of the target report and the user identification of the allocation user on the formula specification table; The method further comprises:

4. The method of claim 3, wherein, Before writing the plurality of formula records input by the superior management user into the formula table, the method further comprises: verifying whether the identification information of the target report exists and belongs to the superior management user; verifying whether the coordinate format of the third formula is correct; verifying whether the specified cell is set with the same formula as the third formula; verifying whether the syntax and logic of the third formula are correct.

5. The method for configuring multiple formulas for retrieving data from a single cell according to claim 1, wherein, In response to the assignment operation of the superior management user assigning a plurality of first formulas to a plurality of first users one by one in the same cell of the target report, before inserting a plurality of formula records corresponding to the plurality of first formulas one by one into the formula assignment table, the method further comprises: verifying the authority of the superior management user and the legality of the assignment operation.

6. The method for configuring multiple retrieval formulas for a single cell according to claim 1, wherein, In response to the assignment operation of the superior management user assigning a plurality of first formulas to a plurality of first users one by one in the same cell of the target report, before inserting a plurality of formula records corresponding to the plurality of first formulas one by one into the formula assignment table, the method further comprises: querying, through the formula assignment table, whether there is another formula assigned to the first user in the cell to which the first formula is to be assigned to the first user; if there is another formula assigned to the first user in the cell to which the first formula is to be assigned to the first user, covering the existing another formula, determining the priority of the first formula and the existing another formula based on the set priority order or prompting the superior management user of the conflict.

7. The method for configuring multiple retrieval formulas for a single cell according to claim 1, wherein, The formula record further comprises the effective date of the first formula, the invalid date of the first formula, and the priority of the first formula.

8. An apparatus for configuring a plurality of retrieval formulas in one cell, comprising: The method comprises: inserting unit, for inserting a plurality of formula records corresponding to a plurality of first formulas one by one into the formula assignment table in response to the assignment operation of the superior management user assigning the plurality of first formulas to a plurality of first users one by one in the same cell of the target report, each of the formula records comprising identification information of the corresponding first formula, identification information of the target report, and identification information of the corresponding first user; writing unit, for writing the formula information of the plurality of first users in the cache to update the cache, so that any first user can find the first cell list recorded in the corresponding formula information of the first user from the cache based on the identification information of any first user and the identification information of the target report, and query the formula corresponding to each cell in the first cell list from the formula assignment table to obtain the formula result of each cell in the first cell list according to the formula; The first user's taking formula information includes the first user's identification information, the target report's identification information and the position information of the cell in which the taking formula is inserted.

9. An electronic device, comprising: The application comprises a memory, a processor and a transceiver connected in sequence, wherein the memory is used to store a computer program, the transceiver is used to transceive messages, and the processor is used to read the computer program and execute the method for configuring multiple taking formulas in one cell according to any one of claims 1-7.

10. A computer program product comprising computer programs or instructions, characterized in that, The computer program or the instruction realizes the method for configuring multiple taking formulas in one cell according to any one of claims 1-7 when executed by a computer.

Images