Cost data management method, system, computer device and storage medium

Abstract

A cost data management method, system, computer device and storage medium can be applied to cloud servers. The method includes: obtaining cost-related data of each dimension associated with the cost, and extracting existing mapping relationships from the cost-related data of each dimension; when new data appears in the obtained cost-related data of each dimension, creating a new mapping relationship corresponding to the dimension to which the new data belongs; calculating the cost corresponding to the dimension to which the new data belongs based on the new data, the existing data of the dimension to which the new data belongs, and the new mapping relationship; obtaining the preset threshold corresponding to the dimension to which the new data belongs, and enabling the new mapping relationship when the cost is greater than the corresponding preset threshold. The above method can automatically create a new mapping relationship corresponding to the new data, and determine whether to enable the new mapping relationship by combining the calculation of the cost of the corresponding dimension with the newly created mapping relationship. There is no need for communication between personnel, and no need for developers to modify scripts, so the operation is simple.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a cost data management method, system, computer device, and storage medium. Background Art

[0002] Cost management, in short, refers to a company's management of cost accounting, cost analysis, cost decision-making, and cost control. A cost management system integrates these elements, providing employees with query, modification, and review capabilities, thereby reducing waste, ensuring scientific decision-making, and truly improving corporate profitability. Cost management system data typically requires obtaining data from various sub-business systems, integrating cost-related data, and then performing operations such as splitting this data into different dimensions. This integration is then displayed based on specific needs.

[0003] When cost management rules change, traditional methods typically require communication between different product and business levels, with relevant personnel notifying developers of changes to existing cost data. The corresponding developers then manually adjust the corresponding scripts to complete the data modification operation. However, this method relies on communication between relevant personnel and is cumbersome. Summary of the Invention

[0004] Based on this, it is necessary to provide a cost data management method, system, computer equipment and storage medium that are easy to operate in order to address the above technical problems.

[0005] A cost data management method, comprising:

[0006] Acquire cost-related data of each dimension associated with the cost, and extract existing mapping relationships from the cost-related data of each dimension;

[0007] When new data appears in the acquired cost-related data of each dimension, a new mapping relationship corresponding to the dimension to which the new data belongs is created;

[0008] Calculating a cost corresponding to the dimension to which the newly added data belongs based on the newly added data, existing data of the dimension to which the newly added data belongs, and the new mapping relationship;

[0009] A preset threshold corresponding to the dimension to which the newly added data belongs is obtained, and when the cost is greater than the corresponding preset threshold, the new mapping relationship is enabled.

[0010] A cost data management system, comprising:

[0011] A data acquisition module is used to acquire cost-related data of various dimensions associated with the cost, and extract existing mapping relationships from the cost-related data of various dimensions;

[0012] A mapping relationship adjustment module is used to create a new mapping relationship corresponding to the dimension to which the newly added data belongs when new data appears in the acquired cost-related data of each dimension;

[0013] A cost calculation module, configured to calculate the cost corresponding to the dimension to which the new data belongs based on the new data, the existing data of the dimension to which the new data belongs, and the new mapping relationship;

[0014] The parameter configuration module is used to obtain the cost corresponding to the dimension to which the newly added data belongs, which is calculated by the cost calculation module, and enable the new mapping relationship when the cost is greater than the corresponding preset threshold.

[0015] A computer device includes a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the following steps are implemented:

[0016] Acquire cost-related data of each dimension associated with the cost, and extract existing mapping relationships from the cost-related data of each dimension;

[0017] When new data appears in the acquired cost-related data of each dimension, a new mapping relationship corresponding to the dimension to which the new data belongs is created;

[0018] Calculating a cost corresponding to the dimension to which the newly added data belongs based on the newly added data, existing data of the dimension to which the newly added data belongs, and the new mapping relationship;

[0019] A preset threshold corresponding to the dimension to which the newly added data belongs is obtained, and when the cost is greater than the corresponding preset threshold, the new mapping relationship is enabled.

[0020] A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the following steps:

[0021] Acquire cost-related data of each dimension associated with the cost, and extract existing mapping relationships from the cost-related data of each dimension;

[0022] When new data appears in the acquired cost-related data of each dimension, a new mapping relationship corresponding to the dimension to which the new data belongs is created;

[0023] Calculating a cost corresponding to the dimension to which the newly added data belongs based on the newly added data, existing data of the dimension to which the newly added data belongs, and the new mapping relationship;

[0024] A preset threshold corresponding to the dimension to which the newly added data belongs is obtained, and when the cost is greater than the corresponding preset threshold, the new mapping relationship is enabled.

[0025] The above-mentioned cost data management method, system, computer device and storage medium, after obtaining cost-related data of each dimension associated with the cost and extracting existing mapping relationships from the cost-related data of each dimension, if it is determined that new data appears in the obtained cost-related data of each dimension, create a new mapping relationship corresponding to the dimension to which the new data belongs; calculate the cost corresponding to the dimension to which the new data belongs based on the new data and the new mapping relationship; obtain a preset threshold corresponding to the dimension to which the new data belongs, and activate the new mapping relationship when the cost is greater than the corresponding preset threshold. The above-mentioned method, when it is determined that new cost-related data exists in the obtained data, creates a new mapping relationship corresponding to the dimension to which the new data belongs, and calculates the cost of the dimension to which the new data belongs based on the new mapping relationship and the existing data and the new data, and activates the newly created mapping relationship when the calculated cost is greater than the corresponding preset threshold; the method can automatically create a new mapping relationship corresponding to the change in the cost management rules or data, and determine the corresponding cost by combining the newly created mapping relationship and the cost-related data to determine whether to activate the new mapping relationship, without requiring communication between personnel or developers to modify scripts, and thus is simple to operate. BRIEF DESCRIPTION OF THE DRAWINGS

[0026] Figure 1 A diagram of an application environment of a cost data management method in one embodiment;

[0027] Figure 2 is a flowchart of a cost data management method in one embodiment;

[0028] Figure 3 is a flowchart of a cost data management method in another embodiment;

[0029] Figure 4 A schematic diagram of a process for creating a new mapping relationship corresponding to the dimension to which the newly added data belongs when newly added data appears in the acquired cost-related data of each dimension in another embodiment;

[0030] Figure 5 is a flowchart of a cost data management method in a specific embodiment;

[0031] Figure 6 is a structural block diagram of a cost data management system in one embodiment;

[0032] Figure 7 FIG. 1 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0033] In order to make the purpose, technical solutions and advantages of this application more clear, the following further describes this application in detail with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain this application and are not intended to limit this application.

[0034] The cost data management method provided in this application can be applied to Figure 1 In the application environment shown. The terminal 102 communicates with the server 104 through the network. In some embodiments, after the server 104 obtains the cost-related data of each dimension associated with the cost and extracts the existing mapping relationship from the cost-related data of each dimension, if it is determined that new data appears in the acquired cost-related data of each dimension, a new mapping relationship corresponding to the dimension to which the new data belongs is created; the cost corresponding to the dimension to which the new data belongs is calculated based on the new data and the new mapping relationship; the preset threshold corresponding to the dimension to which the new data belongs is obtained, and when the cost is greater than the corresponding preset threshold, the new mapping relationship is enabled. The server can obtain cost-related data from an external interface or an external database. Furthermore, if the cost calculated using the new mapping relationship does not reach the corresponding preset threshold, an alarm message needs to be generated and sent to the terminal 102 of the relevant personnel for confirmation by manual intervention. Among them, the terminal 102 can be, but is not limited to, various personal computers, laptops, smart phones, tablet computers, and portable wearable devices. The server 104 can be an independent physical server, or a server cluster or distributed system composed of multiple physical servers. It can also be a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, CDN, and big data and artificial intelligence platforms. The terminal can be a smart phone, tablet computer, laptop computer, desktop computer, smart speaker, smart watch, etc., but is not limited to these. The terminal and the server can be directly or indirectly connected via wired or wireless communication, which is not limited in this application.

[0035] In one embodiment, Figure 2 As shown, a cost data management method is provided, which is applied to Figure 1 The server in is used as an example to illustrate, including steps S210 to S240.

[0036] Step S210 : acquiring cost-related data of each dimension associated with the cost, and extracting existing mapping relationships from the cost-related data of each dimension.

[0037] Cost is the economic value, measured in monetary terms, of the resources expended in producing and selling a certain type and quantity of products. Product production requires the consumption of means of production and labor. These expenditures, measured in monetary terms in costs, manifest as material expenses, depreciation, and wages. A company's operating activities encompass not only production but also sales, so expenses incurred in sales activities should also be included in costs. Similarly, expenses incurred in managing production should also be included in costs. Consequently, expenses incurred in managing production and operating activities also constitute costs.

[0038] In this embodiment, cost-related data includes multiple dimensions. In one embodiment, the dimensions include at least one of the following: overseas region, outsourcing attributes, user settlement type, upstream and downstream settlement method, cost allocation calculation method, and overseas regional price. In this embodiment, cost refers to overseas cost. In other embodiments, the dimensions of the cost-related data associated with cost may also include other dimensions.

[0039] The mapping relationships of cost-related data include: mapping relationships formed by sub-dimensions contained in a single dimension of cost-related data, and / or mapping relationships between dimensions of cost-related data. The mapping relationships are generated by the system based on manually configured rules for establishing relationships for mapping data of different dimensions and corresponding data; the system already has mapping relationships of the dimensions established based on the existing cost-related data and corresponding rules, as well as mapping relationships between dimensions, which are recorded as existing mapping relationships in this embodiment. It can be understood that the cost-related data obtained and associated with the cost at least includes existing cost-related data, and similarly, there are existing mapping relationships. After the cost-related data is obtained, the existing mapping relationships contained therein can be extracted based on the cost-related data.

[0040] In one embodiment, cost-related data of various dimensions associated with the cost are obtained at preset time intervals, and existing mapping relationships are extracted therefrom. The preset time period can be set according to actual conditions, for example, to 1 day, 5 days, or 10 days, etc. In another embodiment, obtaining cost-related data can also be done manually. For example, when relevant personnel receive a change in cost-related data, they can directly obtain the cost-related data manually. In another embodiment, if the automatic acquisition of cost-related data fails, an alarm message is generated, and the cost-related data is manually acquired by the relevant personnel.

[0041] Step S220 : When new data appears in the acquired cost-related data of each dimension, a new mapping relationship corresponding to the dimension to which the new data belongs is created.

[0042] After acquiring the cost-related data for each dimension, the acquired cost-related data for each dimension is compared with the existing cost-related data stored in the system to determine whether the acquired cost-related data contains new data. In one embodiment, the new data may be new data in an existing dimension; in another embodiment, the new data may be data corresponding to a new sub-dimension under an existing dimension; in another embodiment, the new data may be data corresponding to a new dimension.

[0043] In one embodiment, obtaining cost-related data of various dimensions associated with cost includes obtaining existing cost-related data and new cost-related data. If the new cost-related data contains data other than the existing cost-related data, it indicates that new data has appeared.

[0044] Furthermore, in one embodiment, acquiring new cost-related data is obtaining it from an external interface or an external database. When the external interface or the external database adds new data, it indicates that new data exists.

[0045] When new data appears, a corresponding mapping relationship needs to be created; in one embodiment, if the new data is new data of an existing dimension, a new mapping relationship corresponding to the dimension to which the new data belongs is created, which may be to update the mapping relationship corresponding to the existing dimension. In another embodiment, if the new data is data corresponding to a new sub-dimension under an existing dimension, creating a new mapping relationship corresponding to the dimension to which the new data belongs includes adding the new sub-dimension, then obtaining definition data associated with the new sub-dimension, and re-establishing the mapping relationship of the dimension to which the new data belongs based on the definition data, the new data, the existing data of the existing dimension, and the existing mapping relationship. The specific process of creating the mapping relationship to which the new data belongs will be described in detail in the following embodiments and will not be repeated here.

[0046] Step S230 , calculating the cost corresponding to the dimension to which the newly added data belongs based on the newly added data, the existing data of the dimension to which the newly added data belongs, and the new mapping relationship.

[0047] After creating a new mapping relationship corresponding to the dimension to which the newly added data belongs, it is necessary to determine whether the new mapping relationship meets the requirements. Therefore, in this embodiment, the cost is calculated based on the newly added data, the existing data of the dimension, and the new mapping relationship, and combined with the preset threshold corresponding to the dimension to which the newly added data belongs, to determine whether the new mapping relationship meets the requirements.

[0048] Step S240: Obtain a preset threshold corresponding to the dimension to which the newly added data belongs, and when the cost is greater than the corresponding preset threshold, enable a new mapping relationship.

[0049] The preset threshold is manually configured and can be set and adjusted according to actual conditions. The preset threshold can be stored locally. In one embodiment, the preset threshold corresponds to a dimension, that is, each dimension corresponds to a preset threshold. In this embodiment, after obtaining the preset threshold corresponding to the dimension to which the newly added data belongs, the cost calculated in step S230 is compared with the preset threshold. If the preset threshold is reached, the new mapping relationship is considered to meet the requirements and can be enabled. Conversely, if the cost calculated in step S230 does not reach the corresponding preset threshold, the new mapping relationship is considered to be possibly not meeting the requirements.

[0050] In one embodiment, the preset threshold can be a numerical value or an interval range; in the embodiment where the preset threshold is an interval range, if the calculated cost reaches the preset threshold, it means that the cost falls within the interval range; if the preset threshold is not reached, it means that the calculated cost falls outside the interval range.

[0051] Further, if Figure 3 As shown, in one embodiment, after calculating the cost corresponding to the dimension to which the new data belongs based on the new data, the existing data of the dimension to which the new data belongs, and the new mapping relationship, step S310 is also included: when the cost is less than or equal to the corresponding preset threshold, an alarm message is issued.

[0052] In this embodiment, if the corresponding data calculated using the new mapping relationship does not reach the preset threshold of the corresponding dimension, an alarm message is generated and issued, and is confirmed by relevant personnel.

[0053] For further information, please refer to Figure 3 In one embodiment, when the cost is less than or equal to the corresponding preset threshold, after issuing an alarm message, it also includes step S320: receiving feedback information on the alarm message; step S330: if the feedback information is confirmed to be correct, enabling a new mapping relationship.

[0054] Among them, the feedback information for the alarm information is issued by relevant personnel, specifically to determine whether the new mapping relationship meets the requirements. If the feedback information is confirmed to be correct, it means that the new mapping relationship is correct and can be enabled. At this time, the mapping relationship is still enabled.

[0055] Furthermore, in one embodiment, the number of times alarm information is generated when the mapping relationship of each dimension is updated within a predetermined time period is counted, and it is determined whether the number of times the alarm information is generated falls within a preset number range. If the number of times the alarm is generated when the mapping relationship of any dimension is updated does not fall within the preset number range, the above method also includes: adjusting the preset threshold corresponding to the dimension.

[0056] Furthermore, in one embodiment, if the number of times an alarm message is generated is greater than the maximum value of a preset number range, the preset threshold value of the corresponding dimension can be appropriately lowered; if the number of times an alarm message is generated is less than the minimum value of the preset number range, the preset threshold value of the corresponding dimension can be appropriately raised. It is understood that if the number of times an alarm message is generated for all dimensions when updating the mapping relationship falls within the preset number range, the preset threshold value does not need to be adjusted. The preset threshold value and preset number range corresponding to each dimension can be set to the same or different values ​​or value ranges.

[0057] Furthermore, in another embodiment, adjusting the preset threshold corresponding to the dimension also includes: counting the number of times that alarm information is generated when the mapping relationship of each dimension is updated within a predetermined time period, and the number of times the feedback information for the alarm information is confirmed to be correct; if an alarm information is generated when any dimension updates the mapping relationship, and the number of times the feedback information for the alarm information is confirmed to be correct does not fall within the preset number range, the above method also includes: adjusting the preset threshold corresponding to the dimension.

[0058] Furthermore, in one embodiment, if an alarm message is generated, and the number of times the feedback information for the alarm message is confirmed to be correct is greater than the maximum value of the preset number range, the preset threshold of the corresponding dimension can be appropriately lowered; if an alarm message is generated, and the number of times the feedback information for the alarm message is confirmed to be correct is less than the minimum value of the preset number range, the preset threshold of the corresponding dimension can be appropriately raised. It is understandable that if all dimensions generate alarm messages when updating the mapping relationship, and the number of times the feedback information for the alarm message is confirmed to be correct falls within the preset number range, then the preset threshold does not need to be adjusted. Among them, the preset threshold and preset number range corresponding to each dimension can be set to the same or different values ​​or value ranges.

[0059] In this embodiment, an automatic adjustment mechanism is set for the preset threshold value, and the threshold value for generating alarm information is adjusted in real time, which can reduce the unreasonable number of times alarm information is generated.

[0060] Furthermore, after enabling the new mapping relationship, it also includes: detecting whether there are existing total cost calculation results for other dimensions. If so, generating an adjusted total cost calculation result based on the cost corresponding to the dimension to which the newly added data belongs and the total cost calculation result; otherwise, determining the cost corresponding to the dimension to which the newly added data belongs as the total cost calculation result.

[0061] The cost data management method described above, after obtaining cost-related data for each dimension associated with the cost and extracting existing mapping relationships from the cost-related data for each dimension, creates a new mapping relationship corresponding to the dimension to which the newly added data belongs if it is determined that new data exists in the obtained cost-related data for each dimension; calculates the cost corresponding to the dimension to which the newly added data belongs based on the new mapping relationship; obtains a preset threshold corresponding to the dimension to which the newly added data belongs, and activates the new mapping relationship when the cost exceeds the corresponding preset threshold. The method described above, upon determining that new cost-related data exists in the obtained data, creates a new mapping relationship corresponding to the dimension to which the newly added data belongs, calculates the cost of the dimension to which the newly added data belongs based on the new mapping relationship and the existing and new data, and activates the newly created mapping relationship when the calculated cost exceeds the corresponding preset threshold. The method automatically creates a new mapping relationship corresponding to changes in cost management rules or data, and determines the corresponding cost using the newly created mapping relationship and the cost-related data to determine whether to activate the new mapping relationship. This method does not require communication between personnel or script modification by developers, making it simple to operate.

[0062] In one embodiment, Figure 4 As shown, when new data appears in the acquired cost-related data of each dimension, a new mapping relationship corresponding to the dimension to which the new data belongs is created, including step S410: if the new data is new data of the first existing dimension, the new data is added to the first existing dimension to form a new mapping relationship corresponding to the first existing dimension.

[0063] The existing dimension refers to the dimension to which previously acquired data belongs. If the newly acquired data includes new data under an existing dimension, the new data is considered new data in the existing dimension. In a specific embodiment, the new data is a country in the sub-dimension corresponding to Asia in the existing overseas region dimension, which is considered new data in the existing dimension.

[0064] When the new data is new data of an existing dimension, the new data of the existing dimension is directly added to the corresponding dimension to complete the update. After the existing dimension is updated, the sub-dimensions and the relationship between them form the updated mapping relationship of the existing dimension.

[0065] Furthermore, in one embodiment, the newly added data of an existing dimension includes data in a known sub-dimension of the existing dimension and data in an unknown sub-dimension of the existing dimension. In this embodiment, for the newly added data in a known sub-dimension of an existing dimension, the newly added data is directly added to the known sub-dimension. For the newly added data in an unknown sub-dimension of an existing dimension, the newly added data is uniformly added to the special data under the existing dimension.

[0066] In another embodiment, please refer to Figure 4 When new data appears in the acquired cost-related data of each dimension, a new mapping relationship corresponding to the dimension to which the new data belongs is created, which also includes:

[0067] Step S420: If the newly added data is data corresponding to a newly added sub-dimension of the second existing dimension, a sub-dimension is created under the second existing dimension.

[0068] In a specific embodiment, if the newly added data is a sub-dimension "retweet allocation" added to an existing allocation method dimension, then the newly added data corresponds to the newly added sub-dimension of the existing dimension. In this embodiment, if the newly added data corresponds to the newly added sub-dimension of an existing dimension, a corresponding sub-dimension is first created in the existing dimension.

[0069] Step S430: Obtain definition data associated with the sub-dimension.

[0070] In one embodiment, the definition data associated with a dimension and a sub-dimension is manually defined, including the dimension's definition and rules. Furthermore, in one embodiment, the definition data associated with a dimension and a sub-dimension may be predefined and stored locally; in this embodiment, obtaining the definition data associated with a sub-dimension includes obtaining the definition data locally. In another embodiment, obtaining the definition data associated with a sub-dimension may also be defined in real time when the sub-dimension is created, that is, obtaining the definition data associated with the sub-dimension input by relevant personnel. It is understood that in other embodiments, obtaining the definition data associated with a sub-dimension may also be achieved through other means.

[0071] Step S440 : recalculate a new mapping relationship corresponding to the second existing dimension according to the newly added data, the definition data associated with the sub-dimension, and the existing data and the existing mapping relationship of the second existing dimension.

[0072] After obtaining the definition data associated with the sub-dimension, the updated mapping relationship of the existing dimension can be calculated based on the newly added data, the definition data, and the existing data and mapping relationships in the existing dimension. Calculating the mapping relationship can be achieved in any manner.

[0073] The “first” and “second” in the first existing dimension and the second existing dimension are only used to distinguish existing dimensions in different situations in the embodiments and do not represent any practical meaning.

[0074] In the above embodiments, the specific process of creating corresponding new mapping relationships is described for the newly added data in different situations. In different situations, the effect of automatically creating new mapping relationships corresponding to the dimensions to which the newly added data belongs can be achieved, eliminating the need for communication between relevant personnel, developers modifying scripts, etc., which relatively saves labor costs and is simple to operate.

[0075] In one embodiment, the cost corresponding to the dimension to which the newly added data belongs is calculated based on the newly added data, the existing data of the dimension to which the newly added data belongs, and the new mapping relationship, including: if the dimension to be calculated includes a newly added sub-dimension, the existing data and the newly added data of the dimension to be calculated are obtained, and the cost corresponding to the dimension to be calculated is calculated using a full calculation method based on the existing data, the newly added data and the new mapping relationship of the dimension to be calculated; if the dimension to be calculated does not include the newly added sub-dimension, the newly added data is obtained, and the cost corresponding to the dimension to be calculated is calculated using an incremental calculation method using the new mapping relationship and the newly added data of the dimension to be calculated.

[0076] The dimension to be calculated represents the dimension whose cost needs to be calculated.

[0077] If the newly added data includes data corresponding to the newly added sub-dimension, that is, the dimension to be calculated includes the newly added sub-dimension, it is necessary to obtain the existing data and the newly added data of the dimension to be calculated, and use the existing data, the newly added data and the new mapping relationship to perform a full calculation.

[0078] If the newly added data is only for an existing dimension, meaning the dimension to be calculated does not include any newly added sub-dimensions, only the newly added data is needed for the dimension to be calculated. Using the new mapping relationship, incremental calculation is used to calculate the cost of the dimension to be calculated. If no sub-dimensions have been added, using incremental calculation can reduce the amount of computation and time required.

[0079] Furthermore, after completing the calculation of a single dimension, if there is a previous settlement result for the total multiple dimension data, the relevant multiple dimension data will be readjusted to obtain the final settlement result. If there is no previous settlement result for the total multiple dimension data, the result of the current calculation will be the final calculation result.

[0080] This application also provides an application scenario, which applies the above-mentioned cost data management method. Figure 5 The figure shows a flow chart of the cost data management method in this embodiment. Specifically, the application of the cost data management method in this application scenario is as follows:

[0081] Obtain existing cost-related data for each dimension associated with the cost, extract existing mapping relationships from it, and obtain new cost-related data for each dimension from an external interface or external database.

[0082] Compare the existing cost-related data with the new cost-related data to see if they are the same. If so, reuse the settlement results for each dimension. If not (indicating the presence of new data), create a new mapping relationship corresponding to the dimension to which the new data belongs, and use the new mapping relationship to calculate the cost corresponding to the dimension to which the new data belongs. Determine whether the cost reaches the preset threshold corresponding to the dimension to which the new data belongs. If so, activate the new mapping relationship. If not, generate and send an alarm message, and manual intervention is required. After receiving the feedback information for the alarm message after manual intervention, confirm that it is correct, activate the new mapping relationship.

[0083] After the new mapping relationship is activated, the corresponding costs for the dimensions of the newly added data are recalculated and adjusted to generate new cost results. Specifically, after the calculation of the newly added dimension data is completed, if there is a previous settlement result for the total multiple dimension data, the relevant multiple dimension data is readjusted to obtain the final settlement result. If there is no previous settlement result for the total multiple dimension data, the result of the current calculation data is the final calculation result.

[0084] The above-mentioned cost data management method automatically adjusts the mapping relationship of the corresponding dimension according to the changed data when the cost-related data required for cost calculation changes, and combines the manually set preset threshold to determine whether the created mapping relationship meets the requirements. The newly created mapping relationship is enabled only when the requirements are met. This method can reduce the cost of manual communication and the corresponding error problems as much as possible when the cost-related data changes, and generate a mapping relationship of a single module according to the rules. In addition, the results of the relevant newly added data mapping module are adjusted in real time, and the final results are updated without manual intervention, which greatly reduces the manual workload and the time for troubleshooting errors.

[0085] It should be understood that, although the various steps in the flowcharts in the above-described embodiments are shown in sequence as indicated by the arrows, these steps are not necessarily performed in sequence in the order indicated by the arrows. Unless otherwise specified herein, there is no strict order restriction on the execution of these steps, and these steps may be performed in other orders. Moreover, at least a portion of the steps in the flowcharts in the above-described embodiments may include multiple steps or multiple stages, and these steps or stages are not necessarily performed at the same time, but may be performed at different times, and the execution order of these steps or stages is not necessarily performed in sequence, but may be performed in turn or alternately with other steps or at least a portion of the steps or stages in other steps.

[0086] In one embodiment, Figure 6As shown, a cost data management system is provided. The device can be a software module or a hardware module, or a combination of the two to form a part of a computer device. The device specifically includes: a data acquisition module 610, a mapping relationship adjustment module 620, a cost calculation module 630 and a parameter configuration module 640, wherein:

[0087] A data acquisition module 610 is used to acquire cost-related data of various dimensions associated with the cost, and extract existing mapping relationships from the cost-related data of various dimensions;

[0088] A mapping relationship adjustment module 620 is configured to create a new mapping relationship corresponding to the dimension to which the newly added data belongs when new data appears in the acquired cost-related data of each dimension;

[0089] The cost calculation module 630 is used to calculate the cost corresponding to the dimension to which the new data belongs based on the new data, the existing data of the dimension to which the new data belongs, and the new mapping relationship;

[0090] The parameter configuration module 640 is used to obtain the cost corresponding to the dimension of the newly added data calculated by the cost calculation module, and to enable a new mapping relationship when the cost is greater than a corresponding preset threshold.

[0091] The above-mentioned cost data management system includes a data acquisition module, a mapping relationship adjustment module, a cost calculation module and a parameter configuration module, wherein the data acquisition module is used to obtain cost-related data of each dimension associated with the cost, and extract existing mapping relationships from the cost-related data of each dimension; the mapping relationship adjustment module creates a new mapping relationship corresponding to the dimension to which the new data belongs when new data appears in the acquired cost-related data of each dimension; the cost calculation module calculates the cost corresponding to the new module dimension based on the new data and the new mapping relationship; the parameter configuration module enables the new mapping relationship when the cost calculated by the cost calculation module is greater than the corresponding preset threshold. In the above system, when it is determined based on the acquired data that there is new cost-related data, a new mapping relationship corresponding to the dimension to which the new data belongs is created by the mapping relationship, and the cost calculation module calculates the cost of the dimension to which the new data belongs based on the new mapping relationship and the existing data and the new data. When the calculated cost is greater than the corresponding preset threshold, the parameter configuration module enables the newly created mapping relationship; that is, when the rules and data of cost management change, a new mapping relationship corresponding to it can be automatically created, and the parameter configuration module combined with the cost calculation module uses the newly created mapping relationship and cost-related data to determine the corresponding cost, and determines whether to enable the new mapping relationship. There is no need for communication between personnel, and no need for developers to modify scripts, so the operation is simple.

[0092] In one embodiment, the mapping relationship adjustment module is further configured to: if the newly added data is newly added data of the first existing dimension, add the newly added data to the first existing dimension to form a new mapping relationship corresponding to the first existing dimension.

[0093] In one embodiment, a mapping relationship adjustment module includes: a sub-dimension creation unit, which is used to create a sub-dimension under the second existing dimension if the newly added data is data corresponding to a newly added sub-dimension of the second existing dimension; a definition data acquisition unit, which is used to acquire definition data associated with the sub-dimension; and a mapping relationship calculation unit, which is used to recalculate a new mapping relationship corresponding to the second existing dimension based on the newly added data, the definition data associated with the sub-dimension, and the existing data and existing mapping relationship of the second existing dimension.

[0094] In one embodiment, the parameter configuration module is further configured to: issue an alarm message when the cost is less than or equal to a corresponding preset threshold.

[0095] In one embodiment, the parameter configuration module is further configured to: receive feedback information on the alarm information, and if the feedback information is confirmed to be correct, enable a new mapping relationship.

[0096] In one embodiment, overseas regions, outsourcing attributes, user settlement types, upstream and downstream settlement methods, calculation methods for shared costs, and overseas regional prices.

[0097] In one embodiment, the cost calculation module is further used to: if the dimension to be calculated includes a newly added sub-dimension, obtain the existing data and newly added data of the dimension to be calculated, and calculate the cost corresponding to the dimension to be calculated using a full calculation method based on the existing data, newly added data and the new mapping relationship of the dimension to be calculated; if the dimension to be calculated does not include a newly added sub-dimension, obtain the newly added data, and use the new mapping relationship and newly added data of the dimension to be calculated to calculate the cost corresponding to the dimension to be calculated using an incremental calculation method.

[0098] In a specific embodiment, the operations of each module in the above-mentioned cost data management system specifically include the following:

[0099] The data acquisition module is mainly divided into two steps. The first step is to obtain the existing overseas cost calculation data on multiple dimensions, such as overseas regions, outsourcing attributes, user settlement types, upstream and downstream settlement methods, cost-sharing calculation methods, and overseas regional prices. At the same time, the relevant mapping is extracted for each dimension data. The second step is to obtain new overseas cost calculation data on multiple dimensions, such as overseas regions, outsourcing attributes, user settlement types, upstream and downstream settlement methods, cost-sharing calculation methods, and overseas regional prices. New dimension-related data is usually obtained from external interfaces or external databases. When new data is added to the external interface or external database, the mapping relationship adjustment module is required to modify the relevant data.

[0100] The mapping adjustment module typically maintains and modifies internal mapping data for different dimensions. When existing dimension mappings differ from newly retrieved dimension mappings, the module creates a new mapping for the dimension containing the newly added data. For example, when adding data to the overseas region dimension, the first step is to determine the country and region name corresponding to the newly added data. If a corresponding country and region name exists, the corresponding country or region is added to the dimension mapping data for the corresponding country or region according to the existing region. If the corresponding country and region name cannot be retrieved, the class is configured as special outsourced data and needs to be mapped to the outsourced data sequence according to the sequence number. In this case, a new mapping is added to the overseas region dimension. For example, if a new return data item "retweet allocation" is added to the cost allocation method, the module adds a new retweet allocation data entry to the corresponding cost allocation mapping and calculates the new mapping based on the existing data (the usage data for the allocation method is transmitted along with the retweet allocation and is calculated according to the usage rules for all other allocation methods). The relevant calculation rules for different dimensions are different. The calculation rules are usually configured manually for the first time. In addition to the configuration of the relevant rules, the threshold for manual intervention also needs to be configured. In subsequent calculations, the relevant rules are continuously and dynamically improved and adjusted, and the threshold for manual intervention of the corresponding dimension is updated in real time.

[0101] The parameter configuration module is used to configure the rules for establishing relationships between different dimensional data and the threshold for manual intervention. Usually, when cost data requires the addition of dimension-related data, it is necessary to manually configure the definition, rules, and threshold for manual intervention of the relevant dimensions. The system then automatically generates the mapping rules for the relevant dimensions. If the manually configured threshold is reached, the mapping rules for the corresponding dimensions take effect immediately, and the real-time cost corresponding dimension data is calculated according to the new dimension mapping relationship. If the manually configured threshold is not reached, manual intervention is required, and the corresponding information will be alerted to the relevant person in charge, who will then adjust the corresponding data before it takes effect.

[0102] The cost calculation module calculates overseas costs using existing or newly generated dimension mapping data. There are two calculation methods: incremental and full. When a corresponding dimension mapping data entry already exists, incremental calculation is used. While maintaining the total data, the relevant data for a single dimension is recalculated based on the new mapping relationship, minimizing the amount and time of calculations.

[0103] When this is the first time to calculate the relevant dimension mapping data, a full calculation is required. In this case, you need to first pull the full overseas cost base data of the relevant dimensions, and then split and calculate the data on the corresponding basic data according to the mapping relationship to obtain the relevant calculation data for the corresponding dimensions.

[0104] After completing the calculation of a single dimension, if there is a previous settlement result for the total of multiple dimensions, the relevant multiple dimensions will be readjusted to obtain the final settlement result. If there is no previous settlement result for the total of multiple dimensions, the result of the current calculation will be the final calculation result.

[0105] The specific definition of the cost data management system can be found in the definition of the cost data management method above and will not be repeated here. Each module in the above-mentioned cost data management system can be implemented in whole or in part through software, hardware, or a combination thereof. Each of the above-mentioned modules can be embedded in or independent of the processor of the computer device in hardware form, or can be stored in the memory of the computer device in software form, so that the processor can call and execute the corresponding operations of each of the above modules.

[0106] In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as follows: Figure 7 As shown. The computer device includes a processor, a memory and a network interface connected via a system bus. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store cost-related data of each dimension, preset thresholds, definition data of each dimension, etc. The network interface of the computer device is used to communicate with an external terminal via a network connection. When the computer program is executed by the processor, a cost data management method is implemented.

[0107] Those skilled in the art will understand that Figure 7 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than shown in the figure, or combine certain components, or have a different component arrangement.

[0108] In one embodiment, a computer device is further provided, including a memory and a processor. The memory stores a computer program, and the processor implements the steps in the above method embodiments when executing the computer program.

[0109] In one embodiment, a computer-readable storage medium is provided, storing a computer program, which implements the steps in the above-mentioned method embodiments when executed by a processor.

[0110] In one embodiment, a computer program product or computer program is provided, the computer program product or computer program including computer instructions stored in a computer-readable storage medium. A processor of a computer device reads the computer instructions from the computer-readable storage medium and executes the computer instructions, causing the computer device to perform the steps of each of the above-described method embodiments.

[0111] Those skilled in the art will appreciate that all or part of the processes in the above-mentioned embodiment methods can be implemented by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application may include at least one of non-volatile and volatile memory. Non-volatile memory may include read-only memory (ROM), magnetic tape, floppy disk, flash memory or optical memory, etc. Volatile memory may include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM).

[0112] The technical features of the above embodiments can be combined arbitrarily. In order to make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0113] The above embodiments merely represent several implementation methods of the present application. While the descriptions are relatively specific and detailed, they should not be construed as limiting the scope of the present invention. It should be noted that a person skilled in the art could make various modifications and improvements without departing from the spirit of the present application, all of which fall within the scope of protection of the present application. Therefore, the scope of protection of the present patent application shall be determined by the appended claims.

Claims

1. A cost data management method, characterized in that: The method comprises: Obtaining cost-related data for each dimension associated with the cost, and extracting existing mapping relationships from the cost-related data for each dimension; the mapping relationships for the cost-related data at least include mapping relationships formed by sub-dimensions contained in a single dimension of the cost-related data, each dimension corresponding to a preset threshold; When new data appears in the acquired cost-related data of each dimension, a new mapping relationship corresponding to the dimension to which the new data belongs is created; the new data at least includes data corresponding to a new sub-dimension under an existing dimension, or data corresponding to the new dimension; If the dimension to be calculated includes a newly added sub-dimension, the existing data and newly added data of the dimension to be calculated are obtained, and the cost corresponding to the dimension to be calculated is calculated using a full calculation method based on the existing data, newly added data of the dimension to be calculated and the new mapping relationship; If the dimension to be calculated does not include the newly added sub-dimension, obtain the newly added data, and use the new mapping relationship of the dimension to be calculated and the newly added data to calculate the cost corresponding to the dimension to be calculated in an incremental calculation manner; Obtaining a preset threshold corresponding to the dimension to which the newly added data belongs, and enabling the new mapping relationship when the cost is greater than the corresponding preset threshold; The number of times alarm information is generated when the mapping relationship of each dimension is updated within a predetermined time period is counted, and when the number of times alarm information is generated when the mapping relationship of any dimension is updated does not fall within a preset number range, the preset threshold corresponding to the dimension is adjusted.

2. The cost data management method according to claim 1, characterized in that: When new data appears in the acquired cost-related data of each dimension, creating a new mapping relationship corresponding to the dimension to which the new data belongs includes: If the newly added data is newly added data of the first existing dimension, the newly added data is added to the first existing dimension to form a new mapping relationship corresponding to the first existing dimension.

3. The cost data management method according to claim 2, characterized in that: When new data appears in the acquired cost-related data of each dimension, creating a new mapping relationship corresponding to the dimension to which the new data belongs includes: If the newly added data is data corresponding to a newly added sub-dimension of the second existing dimension, create a sub-dimension under the second existing dimension; Obtaining definition data associated with the sub-dimension; A new mapping relationship corresponding to the second existing dimension is recalculated according to the newly added data, the definition data associated with the sub-dimension, and the existing data and the existing mapping relationship of the second existing dimension.

4. The cost data management method according to claim 1, characterized in that: After calculating the cost corresponding to the dimension to which the new data belongs according to the new data, the existing data of the dimension to which the new data belongs, and the new mapping relationship, the method further includes: When the cost is less than or equal to the corresponding preset threshold, an alarm message is issued.

5. The cost data management method according to claim 4, characterized in that: After issuing an alarm message when the cost is less than or equal to a corresponding preset threshold, the method further includes: receiving feedback information regarding the warning information; If the feedback information is confirmed to be correct, the new mapping relationship is activated.

6. The cost data management method according to any one of claims 1 to 5, characterized in that: The dimensions of the cost-related data include at least one of the following: Overseas regions, outsourcing attributes, user settlement types, upstream and downstream settlement methods, cost sharing calculation methods and overseas regional prices.

7. A cost data management system, characterized in that: The system comprises: a data acquisition module configured to acquire cost-related data of various dimensions associated with the cost and extract existing mapping relationships from the cost-related data of various dimensions; the mapping relationships of the cost-related data at least comprising mapping relationships formed by sub-dimensions contained in a single dimension of the cost-related data, each dimension corresponding to a preset threshold; A mapping relationship adjustment module is configured to create a new mapping relationship corresponding to the dimension to which the newly added data belongs when new data appears in the acquired cost-related data of each dimension; the newly added data at least includes data corresponding to a newly added sub-dimension under an existing dimension, or data corresponding to a newly added dimension; A cost calculation module is configured to, if the dimension to be calculated includes a newly added sub-dimension, obtain existing data and newly added data of the dimension to be calculated, and calculate the cost corresponding to the dimension to be calculated using a full calculation method based on the existing data, newly added data, and the new mapping relationship of the dimension to be calculated; if the dimension to be calculated does not include a newly added sub-dimension, obtain the newly added data, and calculate the cost corresponding to the dimension to be calculated using an incremental calculation method using the new mapping relationship and newly added data of the dimension to be calculated; A parameter configuration module is used to obtain the cost corresponding to the dimension to which the newly added data belongs, calculated by the cost calculation module, and enable the new mapping relationship when the cost is greater than the corresponding preset threshold; count the number of times an alarm message is generated when the mapping relationship of each dimension is updated within a predetermined time period, and adjust the preset threshold corresponding to the dimension when the number of times an alarm is generated when the mapping relationship of any dimension is updated does not fall within the preset number range.

8. The cost data management system according to claim 7, characterized in that: The mapping relationship adjustment module is further configured to: if the newly added data is newly added data of the first existing dimension, add the newly added data to the first existing dimension to form a new mapping relationship corresponding to the first existing dimension.

9. The cost data management system according to claim 7, characterized in that: The mapping relationship adjustment module includes: a sub-dimension creating unit, configured to create a sub-dimension under a second existing dimension if the newly added data corresponds to a newly added sub-dimension of the second existing dimension; A definition data acquisition unit, configured to acquire definition data associated with the sub-dimension; A mapping relationship calculation unit is used to recalculate a new mapping relationship corresponding to the second existing dimension based on the newly added data, the definition data associated with the sub-dimension, and the existing data and existing mapping relationship of the second existing dimension.

10. The cost data management system according to claim 7, wherein: The parameter configuration module is further configured to issue an alarm message when the cost is less than or equal to a corresponding preset threshold.

11. The cost data management system according to claim 10, wherein: The parameter configuration module is further configured to: receive feedback information on the alarm information; and activate the new mapping relationship if the feedback information is confirmed to be correct.

12. The cost data management system according to any one of claims 8 to 11, characterized in that: The dimensions of the cost-related data include at least one of the following: overseas region, outsourcing attributes, user settlement type, upstream and downstream settlement methods, calculation method of shared costs and overseas regional prices.

13. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.

14. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Images