Business data table generation method and device

Abstract

The invention provides a business data table generation method and device, and relates to the technical field of data processing. The management department to which each business mechanism belongs is determined, the management information is generated based on the business mechanisms and the management departments, and the management information table is established based on the management information; obtaining business data corresponding to the business mechanism, and establishing a first business data table based on the business data; newly adding a management department content box after each piece of business data in the first business data table; for any business data, obtaining a target business mechanism corresponding to the business data, determining a target management department corresponding to the target business mechanism from the management information table, and filling the target management department into a management department content box corresponding to the business data; and after monitoring that the management department content box corresponding to each piece of business data in the first business data table is filled, obtaining a generated second business data table. According to the invention, the cost and risk of system reconstruction are reduced.

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to a method and device for generating a business data table. Background Art

[0002] In modern business organization management, the aggregation and analysis of business data is an important means of decision support. The traditional method of business data aggregation usually adopts a layered reporting method, that is, the data of each business organization is aggregated to the superior organization step by step, and finally a total business data table is formed. However, this aggregation method has some limitations, and the generated business data table cannot be screened and analyzed based on the management department.

[0003] In order to add the dimension of management department to business data, it is necessary to improve the system of each business organization. This is not only time-consuming and labor-intensive, but also requires a lot of development and testing work, which increases the operating costs of the enterprise. Summary of the invention

[0004] The present disclosure provides a method and device for generating a business data table, so as to at least solve the problem in the related art that in order to add the dimension of management department in business data, it is necessary to improve the system of each business organization, which is not only time-consuming and labor-intensive, but also requires a lot of development and testing work, thereby increasing the operating cost of the enterprise.

[0005] The first aspect of the present application proposes a method for generating a business data table, including: determining the management department to which each business organization belongs, generating management information based on the business organization and the management department, and establishing a management information table based on the management information; obtaining business data corresponding to the business organization, and establishing a first business data table based on the business data, wherein each data in the first business data table and the management information table includes a target business organization corresponding to the data; adding a management department content box after each business data in the first business data table; for any business data, obtaining the target business organization corresponding to the business data, and determining the target management department corresponding to the target business organization from the management information table, and filling the target management department into the management department content box corresponding to the business data; after monitoring that the management department content box corresponding to each business data in the first business data table has been filled, obtaining the generated second business data table.

[0006] According to one embodiment of the present application, determining the management department to which each business organization belongs includes: determining the hierarchical relationship between the business organizations, and determining the associated business organization corresponding to each business organization based on the hierarchical relationship; for any business organization, determining the management department to which the business organization belongs based on the business organization and the associated business organizations corresponding to the business organization.

[0007] According to one embodiment of the present application, the hierarchical relationship between the business organizations is determined, and the associated business organizations corresponding to each business organization are determined based on the hierarchical relationship, including: obtaining multiple business areas corresponding to the business system and a tree-like hierarchical diagram corresponding to each business area, wherein the nodes in the tree-like hierarchical diagram represent business organizations included in the business system, and the tree-like hierarchical diagram is used to represent the hierarchical relationship between the nodes; for any business organization, determining the branch corresponding to the business organization in the tree-like hierarchical diagram, and based on the branch, determining the associated business organizations corresponding to the business organization in order from bottom to top starting from the business organization at the next higher level of the business organization.

[0008] According to one embodiment of the present application, the root node of the tree hierarchy diagram is a first-level business organization within the business area corresponding to the tree hierarchy diagram, and the management department to which the business organization belongs is determined based on the business organization and the associated business organizations corresponding to the business organization, including: obtaining a first mapping relationship between a candidate first-level management department and a first candidate business organization, wherein the first candidate business organization belongs to a business system, each first candidate business organization corresponds to a unique candidate first-level management department, and the first candidate business organization is a first-level business organization in the business system; for any business organization, determining the highest-level business organization from the business organization and the associated business organizations corresponding to the business organization; querying the first mapping relationship based on the highest-level business organization, and using the candidate first-level management department obtained by the query as the first-level management department to which the business organization belongs.

[0009] According to an embodiment of the present application, determining the management department to which a business organization belongs based on the business organization and the associated business organizations corresponding to the business organization includes: obtaining a first mapping relationship between a candidate first-level management department and a first candidate business organization, wherein the first candidate business organization belongs to a business system, and each first candidate business organization corresponds to a unique candidate first-level management department; for any business organization, generating a business organization matching sequence based on the business organization and the associated business organizations corresponding to the business organization; matching the business organization matching sequence with the first mapping relationship in sequence; and taking the first matched candidate first-level management department as the first-level management department to which the business organization belongs.

[0010] According to one embodiment of the present application, a business institution matching sequence is generated based on business institutions and associated business institutions corresponding to the business institutions, including: generating an associated business institution sequence according to the acquisition order of the associated business institutions corresponding to the business institutions; adding the business institution before the first sequence element of the associated business institution sequence, and acquiring the business institution matching sequence generated after the addition.

[0011] According to one embodiment of the present application, the method for generating a business data table also includes: obtaining a second mapping relationship between a candidate secondary management department and a second candidate business organization, wherein the second candidate business organization belongs to a business system, and each second candidate business organization corresponds to a unique candidate secondary management department; for any business organization, matching a business organization matching sequence corresponding to the business organization with the second mapping relationship in sequence; and using the first matched candidate secondary management department as the secondary management department to which the business organization belongs.

[0012] According to one embodiment of the present application, the method for generating a business data table also includes: for any business organization, in response to matching the business organization matching sequence corresponding to the business organization with the second mapping relationship in sequence, if the matching result is empty, then determining that the secondary management department corresponding to the business organization is a null value.

[0013] According to one embodiment of the present application, after obtaining the generated second business data table, it also includes: in response to monitoring the user's management department filtering instruction, obtaining the management department to be filtered carried by the filtering instruction; filtering the business data of the second business data table based on the management department to be filtered, and generating a management department business data table based on the filtered business data.

[0014] The second aspect of the present application proposes a device for generating a business data table, including: a determination module, used to determine the management department to which each business organization belongs, and generate management information based on the business organization and the management department, and establish a management information table based on the management information; an establishment module, used to obtain business data corresponding to the business organization, and establish a first business data table based on the business data, wherein each data in the first business data table and the management information table includes a target business organization corresponding to the data; a new addition module, used to add a management department content box after each business data in the first business data table; a filling module, used to obtain the target business organization corresponding to any business data, and determine the target management department corresponding to the target business organization from the management information table, and fill the target management department into the management department content box corresponding to the business data; a generation module, used to obtain the generated second business data table after monitoring that the management department content boxes corresponding to each business data in the first business data table have been filled.

[0015] According to one embodiment of the present application, the determination module is also used to: determine the hierarchical relationship between the business organizations, and determine the associated business organizations corresponding to each business organization based on the hierarchical relationship; for any business organization, determine the management department to which the business organization belongs based on the business organization and the associated business organizations corresponding to the business organization.

[0016] According to one embodiment of the present application, the determination module is also used to: obtain multiple business areas corresponding to the business system and a tree-like hierarchical diagram corresponding to each business area, wherein the nodes in the tree-like hierarchical diagram represent business organizations included in the business system, and the tree-like hierarchical diagram is used to represent the hierarchical relationship between the nodes; for any business organization, determine the branch corresponding to the business organization in the tree-like hierarchical diagram, and based on the branch, determine the associated business organizations corresponding to the business organization in sequence from bottom to top, starting from the business organization at the next higher level of the business organization.

[0017] According to one embodiment of the present application, the root node of the tree hierarchy diagram is a first-level business organization within the business area corresponding to the tree hierarchy diagram, and the determination module is also used to: obtain a first mapping relationship between a candidate first-level management department and a first candidate business organization, the first candidate business organization is a first-level business organization in the business system, wherein the first candidate business organization belongs to the business system, each first candidate business organization corresponds to a unique candidate first-level management department, and the first candidate business organization is a first-level business organization in the business system; for any business organization, determine the highest-level business organization from the business organization and the associated business organizations corresponding to the business organization; query the first mapping relationship based on the highest-level business organization, and use the candidate first-level management department obtained by the query as the first-level management department to which the business organization belongs.

[0018] According to one embodiment of the present application, the determination module is also used to: obtain a first mapping relationship between a candidate first-level management department and a first candidate business organization, wherein the first candidate business organization belongs to a business system, and each first candidate business organization corresponds to a unique candidate first-level management department; for any business organization, generate a business organization matching sequence based on the business organization and the associated business organizations corresponding to the business organization; match the business organization matching sequence with the first mapping relationship in sequence; and use the first matched candidate first-level management department as the first-level management department to which the business organization belongs.

[0019] According to one embodiment of the present application, the determination module is further used to: generate a sequence of associated business institutions according to the acquisition order of the associated business institutions corresponding to the business institutions; add the business institution before the first sequence element of the associated business institution sequence, and obtain the business institution matching sequence generated after the addition.

[0020] According to one embodiment of the present application, the determination module is also used to: obtain a second mapping relationship between a candidate secondary management department and a second candidate business organization, wherein the second candidate business organization belongs to a business system, and each second candidate business organization corresponds to a unique candidate secondary management department; for any business organization, the business organization matching sequence corresponding to the business organization is matched sequentially with the second mapping relationship; and the first matched candidate secondary management department is used as the secondary management department to which the business organization belongs.

[0021] According to one embodiment of the present application, the determination module is further used to: for any business organization, in response to matching the business organization matching sequence corresponding to the business organization with the second mapping relationship in sequence, and the matching result is empty, determine that the secondary management department corresponding to the business organization is a null value.

[0022] According to one embodiment of the present application, the generation module is also used to: in response to monitoring the user's management department filtering instruction, obtain the management department to be filtered carried by the filtering instruction; filter the business data of the second business data table based on the management department to be filtered, and generate the management department business data table based on the filtered business data.

[0023] The third aspect embodiment of the present application proposes an electronic device, comprising: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor to implement the method for generating a business data table as described in the first aspect embodiment of the present application.

[0024] The fourth aspect embodiment of the present application proposes a non-transitory computer-readable storage medium storing computer instructions, wherein the computer instructions are used to implement the method for generating a business data table as described in the first aspect embodiment of the present application.

[0025] The fifth aspect embodiment of the present application proposes a computer program product, including a computer program, which, when executed by a processor, implements the method for generating a business data table as described in the first aspect embodiment of the present application.

[0026] The technical solution provided by the embodiments of the present disclosure brings at least the following beneficial effects: the present application realizes efficient integration of data and reduces the operating costs of the enterprise; there is no need to improve the system of each business organization, reducing the cost and risk of system transformation; by obtaining management department information from the management information table, the accuracy and consistency of the data are ensured; the matching and filling of business data and management department information are automatically processed, which improves the efficiency of data processing and reduces manual intervention; the generated second business data table contains the management department dimension, which can be screened and analyzed based on the management department, thereby improving the flexibility and depth of data analysis.

[0027] It is to be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present disclosure. BRIEF DESCRIPTION OF THE DRAWINGS

[0028] The above and / or additional aspects and advantages of the present application will become apparent and easily understood from the following description of the embodiments in conjunction with the accompanying drawings, in which:

[0029] Figure 1 It is a schematic diagram of an exemplary implementation of a method for generating a business data table shown in an embodiment of the present application.

[0030] Figure 2 It is a schematic diagram of an exemplary implementation of a method for generating a business data table shown in an embodiment of the present application.

[0031] Figure 3 It is a schematic diagram of a tree-like hierarchical diagram corresponding to a business area A shown in an embodiment of the present application.

[0032] Figure 4 It is a schematic diagram of an exemplary implementation of a method for generating a business data table shown in an embodiment of the present application.

[0033] Figure 5 It is a schematic diagram of an exemplary implementation of a method for generating a business data table shown in an embodiment of the present application.

[0034] Figure 6 It is a schematic diagram of a device for generating a business data table shown in an embodiment of the present application.

[0035] Figure 7 It is a schematic diagram of an electronic device shown in one embodiment of the present application. DETAILED DESCRIPTION

[0036] Embodiments of the present application are described in detail below, and examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are intended to be used to explain the present application, and should not be construed as limiting the present application.

[0037] It should be noted that the acquisition, transmission, storage, use, and processing of data in the technical solution of this application are in compliance with the relevant provisions of national laws and regulations.

[0038] It should be noted that in the embodiments of the present application, certain software, components, models and other existing solutions in the industry may be mentioned, and they should be regarded as exemplary. Their purpose is only to illustrate the feasibility of implementing the technical solution of the present application, but it does not mean that the applicant has or will necessarily use the solution.

[0039] Figure 1 is a schematic diagram of an exemplary implementation of a method for generating a business data table shown in the present application, such as Figure 1 As shown, the method for generating the business data table includes the following steps:

[0040] S101, determining the management department to which each business organization belongs, generating management information based on the business organization and the management department, and establishing a management information table based on the management information.

[0041] Determine the management department to which each business organization belongs, record the relationship between each business organization and its management department, generate management information, and store the management information in a management information table. Each record in the management information table includes a business organization and a corresponding management department.

[0042] There may be one or more management departments.

[0043] Taking the case of counting only the first-level management departments, assuming that there are business organizations 1, 2, and 3, which belong to the first-level management departments A, B, and C respectively, the management information table records are as follows:

[0044] Business organization 1-first-level management department A;

[0045] Business organization 2-first-level management department B;

[0046] Business organization 3-first level management department C.

[0047] Take the example of two management departments, namely the first-level management department and the second-level management department. Assuming that there are business units 1, 2, and 3, which belong to the first-level management departments A, B, and C respectively, and the second-level management departments A1, B1, and C1 respectively, the management information table records are as follows:

[0048] Business organization 1-first-level management department A-second-level management department A1;

[0049] Business organization 2-first-level management department B-second-level management department B1;

[0050] Business organization 3-first-level management department C-second-level management department C1.

[0051] S102, obtaining business data corresponding to the business organization, and establishing a first business data table based on the business data, wherein each data item in the first business data table and the management information table includes a target business organization corresponding to the data item.

[0052] The existing business data is obtained from the database of each business organization, and the obtained business data is stored in a first business data table, wherein each record in the first business data table includes business data and a target business organization corresponding to the business data.

[0053] Assume that the first business data table corresponding to business organizations 1, 2, and 3 is as follows:

[0054] Business organization 1 - January 1, 2024 - business value 100;

[0055] Business organization 2 - January 2, 2024 - Business value 200;

[0056] Business Organization 3 - January 3, 2024 - Business value 300.

[0057] S103, adding a management department content box after each business data in the first business data table.

[0058] It is not difficult to understand that the first business data table does not have a management department filtering dimension, that is, the user cannot directly filter data from the first business data table based on the management department. The purpose of this application is to add a management department dimension to the first business data table. Therefore, in this step, it is necessary to add a management department content box after each business data in the first business data table. At this time, the management department content box has not been filled with content.

[0059] Exemplarily, if only the first-level management departments are counted, a column of content boxes corresponding to the first-level management departments is added to the first business data table.

[0060] For example, if there are two management departments in total, namely, the first-level management department and the second-level management department, a column of content boxes corresponding to the first-level management department and a column of content boxes corresponding to the second-level management department are added to the first business data table.

[0061] S104, for any piece of business data, obtaining a target business organization corresponding to the business data, determining a target management department corresponding to the target business organization from the management information table, and filling the target management department into a management department content box corresponding to the business data.

[0062] For example, taking the statistics of two management departments, namely the first-level management department and the second-level management department, as an example, after filling the management department with the business data corresponding to the business organization 1, the filled business data corresponding to the business organization 1 is as follows:

[0063] Business organization 1-January 1, 2024-Business value 100-First-level management department A-Second-level management department A1.

[0064] S105, after monitoring that the management department content box corresponding to each piece of business data in the first business data table is filled, obtaining the generated second business data table.

[0065] Check whether the management department content box of each record in the first business data table has been filled, and save the first business data table filled with management department information as the second business data table for subsequent analysis.

[0066] Exemplarily, the second business data table is as follows:

[0067] Business organization 1-January 1, 2024-Business value 100-First-level management department A-Second-level management department A1;

[0068] Business organization 2-January 2, 2024-Business value 200-First-level management department B-Second-level management department B1;

[0069] Business organization 3-January 3, 2024-Business value 300 First-level management department C-Second-level management department C1.

[0070] The embodiment of the present application proposes a method for generating a business data table, by determining the management department to which each business organization belongs, generating management information based on the business organization and the management department, and establishing a management information table based on the management information; obtaining business data corresponding to the business organization, and establishing a first business data table based on the business data, wherein each data in the first business data table and the management information table includes a target business organization corresponding to the data; adding a management department content box after each business data in the first business data table; for any business data, obtaining the target business organization corresponding to the business data, and determining the target management department corresponding to the target business organization from the management information table, and filling the target management department into the management department content box corresponding to the business data; after monitoring that the management department content box corresponding to each business data in the first business data table has been filled, obtaining the generated second business data table. This application achieves efficient data integration and reduces the company's operating costs. It does not require improvements to the systems of each business organization, reducing the cost and risk of system transformation. It ensures data accuracy and consistency by obtaining management department information from the management information table. It automates the matching and filling of business data and management department information, improves data processing efficiency, and reduces manual intervention. The generated second business data table contains the management department dimension, which can be screened and analyzed based on the management department, improving the flexibility and depth of data analysis.

[0071] Furthermore, after obtaining the generated second business data table, if the user's management department screening instruction is monitored, the management department to be screened carried by the screening instruction is obtained; and the business data of the second business data table is screened based on the management department to be screened, and the management department business data table is generated based on the screened business data. Exemplarily, if the management department screening instruction indicates that the business data corresponding to the first-level management department A is screened out, the business data corresponding to the first-level management department A is screened out from the second business data table, and the business data table corresponding to the first-level management department A is generated based on the screened business data. In this way, by screening the second business data table, the business data related to a specific management department can be quickly obtained, and the management department business data table generated after screening provides direct and relevant data support for decision makers, reduces the search and analysis time, and makes the decision-making process more efficient and timely.

[0072] Figure 2 is a schematic diagram of an exemplary implementation of a method for generating a business data table shown in the present application, such as Figure 2 As shown, the method for generating the business data table includes the following steps:

[0073] S201, determining the hierarchical relationship between the business organizations, and determining the associated business organization corresponding to each business organization according to the hierarchical relationship.

[0074] As a feasible method, when determining the hierarchical relationship between business organizations, multiple business areas corresponding to the business system and a tree-like hierarchical diagram corresponding to each business area can be obtained, wherein the nodes in the tree-like hierarchical diagram represent the business organizations included in the business system, and the tree-like hierarchical diagram is used to represent the hierarchical relationship between the nodes. Figure 3 is a schematic diagram of a tree-like hierarchical diagram corresponding to a service area A shown in the present application, such as Figure 3 As shown, business area A includes multiple business organizations, and the hierarchical relationship between the business organizations is as follows: Figure 3 As shown, the node level corresponds to the business organization level, and the higher the node level, the higher the business organization level.

[0075] For any business organization, determine the branch corresponding to the business organization in the tree hierarchy diagram, and based on the branch, determine the associated business organizations corresponding to the business organization in order from bottom to top starting from the business organization above the business organization. Figure 3 For example, the associated business organizations of business organization 1112 are business organization 111, business organization 11, and business organization 1 in the order of acquisition.

[0076] As another achievable manner, the associated business institutions corresponding to each business institution may be recorded in advance in the form of a data table, and then the associated business institutions corresponding to each business institution may be obtained based on a query on the data table.

[0077] S202, for any business organization, determine the management department to which the business organization belongs based on the business organization and its corresponding associated business organizations, generate management information based on the business organization and the management department, and establish a management information table based on the management information.

[0078] The root node of the tree hierarchy diagram is the first-level business organization in the business area corresponding to the tree hierarchy diagram. If you need to obtain the first-level management department of each business organization, you can first obtain the first mapping relationship between the candidate first-level management department and the first candidate business organization. The first candidate business organization belongs to the business system. Each first candidate business organization corresponds to a unique candidate first-level management department. The first candidate business organization can be set as a first-level business organization in the business system. For example, the first-level business organization (i.e. Figure 3 The candidate first-level administrative department corresponding to the business organization 1) in the business area is administrative department A, the candidate first-level administrative department corresponding to the first-level business organization in business area B is administrative department B, and so on. The first-level business organizations correspond to the candidate first-level administrative departments.

[0079] For any business organization, determine the highest-level business organization from among the business organizations and their corresponding associated business organizations (that is, the highest-level business organization is the first-level business organization in the business area where the business organization is located); query the first mapping relationship based on the highest-level business organization, and use the candidate first-level management department obtained from the query as the first-level management department to which the business organization belongs.

[0080] It should be noted that if the business organization is a first-level business organization itself, it can also be regarded that although the business organization has no associated business organizations, the business organization itself is the highest-level business organization among the business organization and the associated business organizations corresponding to the business organization. That is, it is necessary to query the first mapping relationship based on the first-level business organization itself, and use the candidate first-level management department obtained by the query as the first-level management department to which the business organization belongs.

[0081] After determining the primary management department corresponding to each business organization, management information is generated based on the business organization and the primary management department, and a management information table is established based on the management information.

[0082] S203, obtaining business data corresponding to the business organization, and establishing a first business data table based on the business data, wherein each piece of data in the first business data table and the management information table includes a target business organization corresponding to the piece of data.

[0083] S204, adding a management department content box after each business data in the first business data table.

[0084] S205, for any piece of business data, obtaining a target business organization corresponding to the business data, determining a target management department corresponding to the target business organization from the management information table, and filling the target management department into a management department content box corresponding to the business data.

[0085] S206: After monitoring that the management department content box corresponding to each piece of business data in the first business data table is filled, obtain the generated second business data table.

[0086] Regarding the specific implementation of steps S203 to S206, reference may be made to the specific introduction of the relevant parts in the above embodiments, which will not be elaborated here.

[0087] The present application automatically generates a management information table based on a tree-like hierarchical diagram and a preset first mapping relationship, thereby ensuring the accuracy and consistency of the relationship between a business organization and its management department and reducing errors caused by human factors; by adding a content box of the management department to the first business data table and automatically filling in the corresponding management department information, the business data can directly reflect the management department to which it belongs, making it easier for the management to screen, aggregate and analyze data according to the department, thereby enhancing the utilization value of the business data.

[0088] Combination Figure 3 It is not difficult to understand that in life, not all first-level business organizations correspond to first-level management departments. It is also common for a second-level business organization or a lower-level business organization to be directly managed by a first-level management department. Therefore, in this application, in addition to the above embodiments, Figure 4 is a schematic diagram of an exemplary implementation of a method for generating a business data table shown in the present application, such as Figure 4 As shown, the method for generating the business data table includes the following steps:

[0089] S401, determining the hierarchical relationship between the business organizations, and determining the associated business organization corresponding to each business organization according to the hierarchical relationship.

[0090] Regarding the specific implementation of step S401, reference may be made to the specific introduction of step S201 in the above embodiment, which will not be repeated here.

[0091] S402, obtaining a first mapping relationship between a candidate primary management department and a first candidate business organization, wherein the first candidate business organization belongs to a business system, and each first candidate business organization corresponds to a unique candidate primary management department.

[0092] S403: For any business organization, generate a business organization matching sequence based on the business organization and its corresponding associated business organizations.

[0093] Generate an associated business institution sequence according to the acquisition order of the associated business institutions corresponding to the business institutions; add the business institution before the first sequence element of the associated business institution sequence, and obtain the business institution matching sequence generated after the addition.

[0094] by Figure 3 Taking the business organization 1112 in the example, the business organization matching sequence corresponding to the business organization 1112 is: [business organization 1112, business organization 111, business organization 11, business organization 1].

[0095] by Figure 3 Taking business organization 1 in as an example, the business organization matching sequence corresponding to business organization 1 is: [business organization 1].

[0096] S404: Match the business organization matching sequence with the first mapping relationship in order.

[0097] S405: The first matched candidate primary management department is used as the primary management department to which the business organization belongs, management information is generated based on the business organization and the primary management department, and a management information table is established based on the management information.

[0098] Taking the business organization matching sequence of [business organization 1112, business organization 111, business organization 11, business organization 1] as an example, first match business organization 1112 with the first mapping relationship to see whether the match is successful. If the match is not successful, then match business organization 111 with the first mapping relationship, and so on, until the first matched candidate first-level management department is used as the first-level management department to which the business organization belongs, and generate management information based on the business organization and the first-level management department, and establish a management information table based on the management information.

[0099] S406, obtaining business data corresponding to the business organization, and establishing a first business data table based on the business data, wherein each piece of data in the first business data table and the management information table includes a target business organization corresponding to the piece of data.

[0100] S407, adding a management department content box after each business data in the first business data table.

[0101] S408, for any piece of business data, obtain the target business organization corresponding to the business data, determine the target management department corresponding to the target business organization from the management information table, and fill the target management department into the management department content box corresponding to the business data.

[0102] S409: After monitoring that the management department content box corresponding to each piece of business data in the first business data table is filled, obtain the generated second business data table.

[0103] Regarding the specific implementation of steps S406 to S409, reference may be made to the specific introduction of the relevant parts in the above embodiments, which will not be elaborated here.

[0104] The present application automatically generates a management information table based on a tree-like hierarchical diagram and a preset first mapping relationship, taking into account the situation in real life that non-first-level business institutions are directly managed by a first-level management department, ensuring the accuracy and consistency of the relationship between the business institution and its management department, and reducing errors caused by human factors; by adding a content box of the management department to the first business data table and automatically filling in the corresponding management department information, the business data can directly reflect the management department to which it belongs, making it convenient for the management to screen, summarize and analyze the data according to the department, thereby enhancing the utilization value of the business data.

[0105] Figure 5 is a schematic diagram of an exemplary implementation of a method for generating a business data table shown in the present application, such as Figure 5 As shown, the method for generating the business data table includes the following steps:

[0106] S501, determining the hierarchical relationship between the business organizations, and determining the associated business organization corresponding to each business organization according to the hierarchical relationship.

[0107] S502 : Acquire a first mapping relationship between a candidate primary management department and a first candidate business organization, wherein the first candidate business organization belongs to a business system, and each first candidate business organization corresponds to a unique candidate primary management department.

[0108] S503: For any business organization, generate a business organization matching sequence based on the business organization and its corresponding associated business organizations.

[0109] S504: Match the business organization matching sequence with the first mapping relationship in order.

[0110] S505: The first matched candidate primary management department is used as the primary management department to which the business organization belongs.

[0111] Regarding the specific implementation of steps S501 to S505, reference may be made to the specific introduction of the relevant parts in the above embodiments, which will not be elaborated here.

[0112] S506, obtaining a second mapping relationship between the candidate secondary management department and the second candidate business organization, wherein the second candidate business organization belongs to the business system, and each second candidate business organization corresponds to a unique candidate secondary management department.

[0113] S507, for any business organization, matching the business organization matching sequence corresponding to the business organization with the second mapping relationship in order; if a candidate secondary management department is matched, the first matched candidate secondary management department is used as the secondary management department to which the business organization belongs.

[0114] S508, for any business organization, in response to matching the business organization matching sequence corresponding to the business organization with the second mapping relationship in sequence, and the matching result is null, determining that the secondary management department corresponding to the business organization is a null value.

[0115] It should be noted that if the business organization matching sequence corresponding to the business organization is matched with the second mapping relationship in sequence, and the matching result is empty, when filling in the subsequent filling, the secondary management department corresponding to the business organization will be filled with an empty value or a preset value to represent that the content box is empty.

[0116] S509, generating management information based on the business organization and the primary management department and the secondary management department, and establishing a management information table based on the management information.

[0117] S510, obtaining business data corresponding to the business organization, and establishing a first business data table based on the business data, wherein each data item in the first business data table and the management information table includes a target business organization corresponding to the data item.

[0118] S511, adding a management department content box after each business data in the first business data table.

[0119] S512, for any piece of business data, obtain the target business organization corresponding to the business data, determine the target management department corresponding to the target business organization from the management information table, and fill the target management department into the management department content box corresponding to the business data.

[0120] S513, after monitoring that the management department content box corresponding to each piece of business data in the first business data table is filled, obtaining the generated second business data table.

[0121] Regarding the specific implementation of steps S510 to S513, reference may be made to the specific introduction of the relevant parts in the above embodiments, which will not be elaborated here.

[0122] This application takes into account the situation in real life that non-first-level business organizations are directly managed by a first-level management department, and also takes into account the situation that management departments may have multiple levels. A management information table is automatically generated based on a tree hierarchy diagram and a preset first mapping relationship and a second mapping relationship, thereby ensuring the accuracy and consistency of the relationship between the business organization and its management department and reducing errors caused by human factors. By adding a content box of the management department to the first business data table and automatically filling in the corresponding management department information, the business data can directly reflect the management department to which it belongs, which facilitates the management level to screen, summarize and analyze the data according to the department, thereby improving the utilization value of the business data.

[0123] Figure 6 is a schematic diagram of a device for generating a business data table shown in the present application, such as Figure 6 As shown, the device 600 for generating the business data table includes a determination module 601, a creation module 602, a new addition module 603, a filling module 604 and a generation module 605, wherein:

[0124] The determination module 601 is used to determine the management department to which each business organization belongs, generate management information based on the business organization and the management department, and establish a management information table based on the management information.

[0125] Establishing module 602 is used to obtain business data corresponding to the business organization and establish a first business data table based on the business data, wherein each data in the first business data table and the management information table includes a target business organization corresponding to the data.

[0126] The new adding module 603 is used to add a management department content box after each business data in the first business data table.

[0127] The filling module 604 is used to obtain the target business organization corresponding to any piece of business data, determine the target management department corresponding to the target business organization from the management information table, and fill the target management department into the management department content box corresponding to the business data.

[0128] The generating module 605 is used to obtain a generated second business data table after monitoring that the management department content box corresponding to each business data in the first business data table is filled.

[0129] This device realizes efficient data integration and reduces the operating costs of the enterprise. It does not need to improve the system of each business organization, reducing the cost and risk of system transformation. It ensures the accuracy and consistency of data by obtaining management department information from the management information table. It automates the matching and filling of business data and management department information, improves the efficiency of data processing, and reduces manual intervention. The generated second business data table contains the management department dimension, which can be screened and analyzed based on the management department, improving the flexibility and depth of data analysis.

[0130] Furthermore, the determination module 601 is also used to: determine the hierarchical relationship between the business organizations, and determine the associated business organizations corresponding to each business organization according to the hierarchical relationship; for any business organization, determine the management department to which the business organization belongs based on the business organization and the associated business organizations corresponding to the business organization.

[0131] Furthermore, the determination module 601 is also used to: obtain multiple business areas corresponding to the business system and a tree-like hierarchical diagram corresponding to each business area, wherein the nodes in the tree-like hierarchical diagram represent business organizations included in the business system, and the tree-like hierarchical diagram is used to represent the hierarchical relationship between the nodes; for any business organization, determine the branch corresponding to the business organization in the tree-like hierarchical diagram, and based on the branch, determine the associated business organizations corresponding to the business organization in order from the bottom to the top, starting from the business organization at the next level above the business organization.

[0132] Furthermore, the root node of the tree hierarchy diagram is a first-level business organization within the business area corresponding to the tree hierarchy diagram, and the determination module 601 is further used to: obtain a first mapping relationship between a candidate first-level management department and a first candidate business organization, wherein the first candidate business organization belongs to a business system, each first candidate business organization corresponds to a unique candidate first-level management department, and the first candidate business organization is a first-level business organization in the business system; for any business organization, determine the highest-level business organization from the business organization and the associated business organizations corresponding to the business organization; query the first mapping relationship based on the highest-level business organization, and use the candidate first-level management department obtained by the query as the first-level management department to which the business organization belongs.

[0133] Furthermore, the determination module 601 is also used to: obtain a first mapping relationship between a candidate first-level management department and a first candidate business organization, wherein the first candidate business organization belongs to a business system, and each first candidate business organization corresponds to a unique candidate first-level management department; for any business organization, generate a business organization matching sequence based on the business organization and the associated business organizations corresponding to the business organization; match the business organization matching sequence with the first mapping relationship in sequence; and use the first matched candidate first-level management department as the first-level management department to which the business organization belongs.

[0134] Furthermore, the determination module 601 is further used to: generate an associated business institution sequence according to the acquisition order of the associated business institutions corresponding to the business institutions; add the business institution before the first sequence element of the associated business institution sequence, and obtain the business institution matching sequence generated after the addition.

[0135] Furthermore, the determination module 601 is also used to: obtain a second mapping relationship between the candidate secondary management department and the second candidate business organization, wherein the second candidate business organization belongs to the business system, and each second candidate business organization corresponds to a unique candidate secondary management department; for any business organization, the business organization matching sequence corresponding to the business organization is matched in sequence with the second mapping relationship; and the first matched candidate secondary management department is used as the secondary management department to which the business organization belongs.

[0136] Furthermore, the determination module 601 is further configured to: for any business organization, in response to matching the business organization matching sequence corresponding to the business organization with the second mapping relationship in sequence and the matching result is null, determine that the secondary management department corresponding to the business organization is null.

[0137] Furthermore, the generation module 601 is also used to: in response to monitoring the user's management department screening instruction, obtain the management department to be screened carried by the screening instruction; screen the business data of the second business data table based on the management department to be screened, and generate the management department business data table based on the screened business data.

[0138] In order to implement the above embodiment, the present application embodiment also proposes an electronic device 700, such as Figure 7 As shown, the electronic device 700 includes: a processor 701 and a memory 702 communicatively connected to the processor, the memory 702 stores instructions executable by at least one processor, and the instructions are executed by at least one processor 701 to implement the method for generating a business data table as shown in the above embodiment.

[0139] In order to implement the above embodiment, the embodiment of the present application also proposes a non-transitory computer-readable storage medium storing computer instructions, wherein the computer instructions are used to enable the computer to implement the method for generating a business data table as shown in the above embodiment.

[0140] In order to implement the above embodiment, the embodiment of the present application also proposes a computer program product, including a computer program, which implements the method for generating a business data table as shown in the above embodiment when executed by a processor.

[0141] In the description of the present application, it should be understood that the terms "center", "longitudinal", "lateral", "length", "width", "thickness", "up", "down", "front", "back", "left", "right", "vertical", "horizontal", "top", "bottom", "inside", "outside", "clockwise", "counterclockwise", "axial", "radial", "circumferential" and the like indicate orientations or positional relationships based on the orientations or positional relationships shown in the accompanying drawings, and are only for the convenience of describing the present application and simplifying the description, and do not indicate or imply that the referred device or element must have a specific orientation, be constructed and operated in a specific orientation, and therefore should not be understood as a limitation on the present application.

[0142] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of the features. In the description of this application, the meaning of "plurality" is two or more, unless otherwise clearly and specifically defined.

[0143] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "example", "specific example", or "some examples" etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present application. In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner. In addition, those skilled in the art may combine and combine the different embodiments or examples described in this specification and the features of the different embodiments or examples, without contradiction.

[0144] It should be noted that in the embodiments of the present application, certain software, components, models and other existing solutions in the industry may be mentioned, and they should be regarded as exemplary. Their purpose is only to illustrate the feasibility of implementing the technical solution of the present application, but it does not mean that the applicant has or will necessarily use the solution.

[0145] Although the embodiments of the present application have been shown and described above, it can be understood that the above embodiments are exemplary and cannot be understood as limitations on the present application. Ordinary technicians in this field can change, modify, replace and modify the above embodiments within the scope of the present application.

Claims

1. A method for generating a business data table, characterized in that: include: Determine the management department to which each business organization belongs, generate management information based on the business organization and the management department, and establish a management information table based on the management information; Acquire business data corresponding to the business organization, and establish a first business data table based on the business data, wherein each piece of data in the first business data table and the management information table includes a target business organization corresponding to the piece of data; Adding a management department content box after each piece of business data in the first business data table; For any piece of the business data, obtain the target business organization corresponding to the business data, determine the target management department corresponding to the target business organization from the management information table, and fill the target management department into the management department content box corresponding to the business data; After monitoring that the management department content box corresponding to each piece of business data in the first business data table is filled, the generated second business data table is obtained.

2. The method according to claim 1, characterized in that: The management department to which each business organization belongs shall include: Determine the hierarchical relationship between the business organizations, and determine the associated business organization corresponding to each business organization according to the hierarchical relationship; For any of the business organizations, the management department to which the business organization belongs is determined based on the business organization and the associated business organizations corresponding to the business organization.

3. The method according to claim 2, characterized in that The step of determining the hierarchical relationship between the business organizations, and determining the associated business organization corresponding to each business organization according to the hierarchical relationship, includes: Acquire multiple business areas corresponding to the business system and a tree-like hierarchical diagram corresponding to each of the business areas, wherein the nodes in the tree-like hierarchical diagram represent business organizations included in the business system, and the tree-like hierarchical diagram is used to represent the hierarchical relationship between the nodes; For any of the business organizations, determine the branch corresponding to the business organization in the tree hierarchy diagram, and based on the branch, determine the associated business organizations corresponding to the business organization in order from bottom to top starting from the business organization at the next higher level.

4. The method according to claim 3, characterized in that: The root node of the tree hierarchy diagram is a first-level business organization in the business area corresponding to the tree hierarchy diagram, and the determining of the management department to which the business organization belongs based on the business organization and the associated business organization corresponding to the business organization includes: Acquire a first mapping relationship between a candidate first-level management department and a first candidate business organization, wherein the first candidate business organization belongs to the business system, each of the first candidate business organizations corresponds to a unique candidate first-level management department, and the first candidate business organization is a first-level business organization in the business system; For any of the business organizations, determining the highest-level business organization from the business organization and the associated business organizations corresponding to the business organization; The first mapping relationship is queried based on the highest-level business organization, and the candidate first-level management department obtained by the query is used as the first-level management department to which the business organization belongs.

5. The method according to claim 3, characterized in that: The determining of the management department to which the business organization belongs based on the business organization and the associated business organization corresponding to the business organization includes: Acquire a first mapping relationship between a candidate primary management department and a first candidate business organization, wherein the first candidate business organization belongs to the business system, and each of the first candidate business organizations corresponds to a unique candidate primary management department; For any of the business institutions, generating a business institution matching sequence based on the business institution and the associated business institutions corresponding to the business institution; Matching the business organization matching sequence with the first mapping relationship in sequence; The first matched candidate first-level management department is used as the first-level management department to which the business organization belongs.

6. The method according to claim 5, characterized in that The generating of a business institution matching sequence based on the business institution and the associated business institution corresponding to the business institution includes: Generate a sequence of associated business institutions according to the acquisition order of the associated business institutions corresponding to the business institutions; The business organization is added before the first sequence element of the associated business organization sequence, and a business organization matching sequence generated after the addition is obtained.

7. The method according to claim 6, characterized in that The method further comprises: Acquire a second mapping relationship between a candidate secondary management department and a second candidate business organization, wherein the second candidate business organization belongs to the business system, and each second candidate business organization corresponds to a unique candidate secondary management department; For any of the business organizations, matching the business organization matching sequence corresponding to the business organization with the second mapping relationship in order; The first matched candidate secondary management department is used as the secondary management department to which the business organization belongs.

8. The method according to claim 7, characterized in that The method further comprises: For any of the business organizations, in response to matching the business organization matching sequence corresponding to the business organization with the second mapping relationship in sequence and the matching result is null, it is determined that the secondary management department corresponding to the business organization is a null value.

9. The method according to any one of claims 1 to 8, characterized in that After the second business data table is obtained, the method further includes: In response to monitoring a management department screening instruction of a user, obtaining the management department to be screened carried by the screening instruction; The second business data table is screened for business data based on the management department to be screened, and a management department business data table is generated based on the screened business data.

10. A device for generating a business data table, characterized in that: include: A determination module, used to determine the management department to which each business organization belongs, generate management information based on the business organization and the management department, and establish a management information table based on the management information; An establishment module, used for acquiring business data corresponding to the business organization, and establishing a first business data table based on the business data, wherein each piece of data in the first business data table and the management information table includes a target business organization corresponding to the piece of data; A new adding module, used for adding a management department content box after each business data in the first business data table; A filling module is used to obtain, for any piece of the business data, a target business organization corresponding to the business data, determine a target management department corresponding to the target business organization from the management information table, and fill the target management department into a management department content box corresponding to the business data; The generating module is used to obtain the generated second business data table after monitoring that the management department content box corresponding to each business data in the first business data table is filled.

11. The device according to claim 10, characterized in that The determining module is further used for: Determine the hierarchical relationship between the business organizations, and determine the associated business organization corresponding to each business organization according to the hierarchical relationship; For any of the business organizations, the management department to which the business organization belongs is determined based on the business organization and the associated business organizations corresponding to the business organization.

12. The device according to claim 11, characterized in that The determining module is further used for: Acquire multiple business areas corresponding to the business system and a tree-like hierarchical diagram corresponding to each of the business areas, wherein the nodes in the tree-like hierarchical diagram represent business organizations included in the business system, and the tree-like hierarchical diagram is used to represent the hierarchical relationship between the nodes; For any of the business organizations, determine the branch corresponding to the business organization in the tree hierarchy diagram, and based on the branch, determine the associated business organizations corresponding to the business organization in order from bottom to top starting from the business organization at the next higher level.

13. The device according to claim 12, characterized in that The root node of the tree-like hierarchical diagram is a first-level business organization in the business area corresponding to the tree-like hierarchical diagram, and the determination module is further used to: Acquire a first mapping relationship between a candidate first-level management department and a first candidate business organization, wherein the first candidate business organization belongs to the business system, each of the first candidate business organizations corresponds to a unique candidate first-level management department, and the first candidate business organization is a first-level business organization in the business system; For any of the business organizations, determining the highest-level business organization from the business organization and the associated business organizations corresponding to the business organization; The first mapping relationship is queried based on the highest-level business organization, and the candidate first-level management department obtained by the query is used as the first-level management department to which the business organization belongs.

14. The device according to claim 12, characterized in that The determining module is further used for: Acquire a first mapping relationship between a candidate primary management department and a first candidate business organization, wherein the first candidate business organization belongs to the business system, and each of the first candidate business organizations corresponds to a unique candidate primary management department; For any of the business institutions, generating a business institution matching sequence based on the business institution and the associated business institutions corresponding to the business institution; Matching the business organization matching sequence with the first mapping relationship in sequence; The first matched candidate first-level management department is used as the first-level management department to which the business organization belongs.

15. The device according to claim 14, characterized in that The determining module is further used for: Generate a sequence of associated business institutions according to the acquisition order of the associated business institutions corresponding to the business institutions; The business organization is added before the first sequence element of the associated business organization sequence, and a business organization matching sequence generated after the addition is obtained.

16. The device according to claim 15, characterized in that The determining module is further used for: Acquire a second mapping relationship between a candidate secondary management department and a second candidate business organization, wherein the second candidate business organization belongs to the business system, and each second candidate business organization corresponds to a unique candidate secondary management department; For any of the business organizations, matching the business organization matching sequence corresponding to the business organization with the second mapping relationship in order; The first matched candidate secondary management department is used as the secondary management department to which the business organization belongs.

17. The device according to claim 16, characterized in that The determining module is further used for: For any of the business organizations, in response to matching the business organization matching sequence corresponding to the business organization with the second mapping relationship in sequence and the matching result is null, it is determined that the secondary management department corresponding to the business organization is a null value.

18. The device according to any one of claims 10 to 17, characterized in that The generating module is further used for: In response to monitoring a management department screening instruction of a user, obtaining the management department to be screened carried by the screening instruction; The second business data table is screened for business data based on the management department to be screened, and a management department business data table is generated based on the screened business data.

19. An electronic device comprising: at least one processor; as well as, a memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the method according to any one of claims 1 to 9.

20. A non-transitory computer-readable storage medium storing computer instructions, wherein: The computer instructions are used to cause the computer to execute the method according to any one of claims 1-9.

21. A computer program product comprising a computer program, which, when executed by a processor, implements the steps of the method according to any one of claims 1 to 9.

Images