CN-121981768-A - Cost tracing method and device, electronic equipment and storage medium

CN121981768ACN 121981768 ACN121981768 ACN 121981768ACN-121981768-A

Abstract

The present disclosure provides a cost tracing method, a device, an electronic device and a storage medium, wherein the method includes obtaining multi-source data required by cost tracing; the method comprises the steps of marking production scenes and cleaning the data of multi-source data to obtain cleaned data, constructing a site cost list according to the cleaned data, auditing the data quality of the site cost list to obtain an auditing standard-reaching site cost list, constructing tracing models adapting to different production scenes and cost types based on the auditing standard-reaching site cost list, setting corresponding tracing paths for the tracing models, and extracting and generating corresponding tracing data from the auditing standard-reaching site cost list according to the corresponding production scenes, cost types and tracing models and the corresponding tracing paths according to the cost to be traced. According to the embodiment of the disclosure, the depth, flexibility and service fitting degree of cost tracing can be remarkably enhanced.

Inventors

HUANG SHUYI
WU HONGCHAO
MA CHEN
LIU HONGYU
DENG MIN
CAI RUIWEN
Mai Zhiyi
CHEN YUCHEN
CHEN ZHENHUA
SU HAN

Assignees

中国联合网络通信集团有限公司

Dates

Publication Date: 20260505
Application Date: 20260122

Claims (10)

1. A cost tracing method, the method comprising: Acquiring multi-source data required by cost tracing; marking production scenes and cleaning the multi-source data to obtain cleaned data; Constructing a site cost list according to the cleaned data, and auditing the data quality of the site cost list to obtain an auditing standard site cost list; Constructing traceability models adapting to different production scenes and cost types based on the site cost list reaching the inspection standards, and setting corresponding traceability paths for the traceability models; And aiming at the cost to be traced, extracting and generating corresponding tracing data from the site cost list reaching the inspection standards according to the corresponding tracing path according to the corresponding production scene, the cost type and the tracing model.
2. The method according to claim 1, wherein the acquiring the multi-source data required for cost tracing specifically includes: A plurality of business systems are butted through a unified data center, and corresponding multi-source data are collected; the acquired multi-source data is pushed and stored to a traceability system database at regular time based on an extraction, conversion and loading ETL tool; And acquiring multi-source data required by cost tracing from the tracing system database.
3. The method according to claim 1, wherein the performing production scene marking and data cleaning on the multi-source data to obtain cleaned data specifically comprises: Marking the multi-source data based on a predefined data caliber corresponding to each production scene, wherein the production scene comprises a thinned peripheral site scene and a thinned office site scene; aiming at the marked data, cleaning the data at three layers of regular account period, regular site association and cost allocation/collection to obtain cleaned data; The accounting period regulation is used for converting various time information in the multi-source data into a standard financial accounting period to realize time sequence alignment of the multi-source data, the site association regulation is used for unifying heterogeneous identifications representing the same site in a plurality of service systems of the multi-source data source into a unique site ID, the multi-source data are associated and aligned based on the site ID, and the cost allocation/collection is used for allocating or merging the cost to the single site according to a preset rule aiming at the cost data shared by a plurality of sites.
4. A method according to claim 3, wherein the multi-source system comprises a contract system, an energy consumption system, a finance system, an iron tower system, a network resource system and a cost management platform, and the method comprises the steps of constructing a site cost list according to the cleaned data: Extracting key fields from the cleaned data, and integrating according to site dimensions to form a site cost list; The key fields comprise account periods, production scene labels, site basic information from the network resource system and cost related information from the contract system, the energy consumption system, the financial system, the iron tower system and the cost management platform.
5. The method according to claim 1, wherein the step of auditing the data quality of the site cost list to obtain an audited and up-to-standard site cost list specifically comprises: The method comprises the steps of conducting site scale auditing and cost amount auditing on the site cost list, wherein the site scale auditing is used for verifying consistency of the site statistical quantity in the site cost list and the actual site construction quantity, and the cost data auditing is used for verifying whether deviation rate of sum of various costs in the site cost list and corresponding sum in financial system financial report is smaller than or equal to a preset threshold value on the premise that the site scale is accurate; if the auditing is not passed, triggering a problem closed-loop flow, and pushing the data source end to rectify and modify until the auditing is passed, so as to obtain an auditing standard-reaching site cost list.
6. The method according to claim 1, wherein the setting a corresponding tracing path for the tracing model specifically includes: determining a corresponding required tracing level according to the monitoring granularity of the tracing model; defining a logic chain from a high-level summary dimension to specific site cost data based on the tracing hierarchy, and taking the logic chain as a tracing path corresponding to the tracing model; The traceability model comprises a total cost overview model, a single-station cost monitoring model, a station electricity consumption monitoring model and a station electricity price monitoring model.
7. The method according to claim 1, wherein the method further comprises: configuring a scheduling rule based on a production scene, a cost type and a traceability model, wherein the scheduling rule comprises a judging condition for judging cost abnormality; Responding to the traceability data to meet the scheduling rule, and generating a corresponding scheduling work order; pushing the scheduling work orders to corresponding processing persons to drive abnormality checking and processing, and receiving processing receipts to form a management closed loop.
8. A cost tracing apparatus, the apparatus comprising: the multi-source data acquisition module is used for acquiring multi-source data required by cost tracing; the standardized processing module is connected with the multi-source data acquisition module and is used for marking production scenes and cleaning data of the multi-source data to obtain cleaned data; The list construction and auditing module is connected with the standardized processing module and is used for constructing a site cost list according to the cleaned data, and auditing the data quality of the site cost list to obtain an auditing standard site cost list; the model and path setting module is connected with the list construction and auditing module and is used for constructing traceability models adapting to different production scenes and cost types based on the site cost list reaching the audit standard and setting corresponding traceability paths for the traceability models; and the cost tracing module is connected with the model and path setting module and is used for extracting and generating corresponding tracing data from the site cost list which is up to standard according to the corresponding production scene, the cost type and the tracing model and the corresponding tracing path.
9. An electronic device, the electronic device comprising: at least one processor, and A memory communicatively coupled to the at least one processor, wherein, The memory stores one or more computer programs executable by the at least one processor to enable the at least one processor to perform the cost tracing method of any one of claims 1-7.
10. A computer readable storage medium, on which a computer program is stored, which, when being executed by a processor, implements the cost tracing method according to any one of claims 1-7.

Description

Cost tracing method and device, electronic equipment and storage medium Technical Field The disclosure relates to the technical field of network operation, and in particular relates to a cost tracing method, a cost tracing device, electronic equipment and a storage medium. Background In the global context of digitized wave mats, network operation has become a key element of enterprise core competitiveness, and cost management is more relevant to the lifeline of enterprise sustainable development. Along with exponential expansion of the network scale of operators, the production scene is continuously complicated, and the accurate accounting and effective tracing of the network operation cost become core propositions of enterprise cost reduction and efficiency enhancement and resource allocation optimization. However, the current network operation cost tracing method has the following problems, resulting in poor tracing effect: (1) In the whole process of generating and using the network cost, the data redundancy and the repetition phenomenon are obvious, and the standardability of the cost tracing information is insufficient, so that the data format and the statistic caliber are inconsistent, part of information needs to be manually supplemented, the data processing burden is increased, the efficiency and the accuracy of the cost tracing are more directly influenced, and a credible cost data base is difficult to form; (2) The traceability is weak and stiff, the existing method can only provide static and macroscopic cost summary data, specialized traceability logic is not built by combining specific production scenes and cost types, detailed cost data cannot be obtained by drilling downwards, meanwhile, a configurable traceability path is lacking, penetration analysis from different management dimensions is difficult to support flexibly, and the requirement of fine traceability cannot be met. Disclosure of Invention The disclosure provides a cost tracing method, a cost tracing device, electronic equipment and a storage medium, which are used for solving the problems of low data quality, weak tracing capability and rigidification of the existing cost tracing method. In a first aspect, the present disclosure provides a cost tracing method, the method comprising: Acquiring multi-source data required by cost tracing; marking production scenes and cleaning the multi-source data to obtain cleaned data; Constructing a site cost list according to the cleaned data, and auditing the data quality of the site cost list to obtain an auditing standard site cost list; Constructing traceability models adapting to different production scenes and cost types based on the site cost list reaching the inspection standards, and setting corresponding traceability paths for the traceability models; And aiming at the cost to be traced, extracting and generating corresponding tracing data from the site cost list reaching the inspection standards according to the corresponding tracing path according to the corresponding production scene, the cost type and the tracing model. Further, the acquiring the multi-source data required by the cost tracing specifically includes: A plurality of business systems are butted through a unified data center, and corresponding multi-source data are collected; the acquired multi-source data is pushed and stored to a traceability system database at regular time based on an extraction, conversion and loading ETL tool; And acquiring multi-source data required by cost tracing from the tracing system database. Further, the marking of the production scene and the cleaning of the data are performed on the multi-source data to obtain cleaned data, which specifically comprises: Marking the multi-source data based on a predefined data caliber corresponding to each production scene, wherein the production scene comprises a thinned peripheral site scene and a thinned office site scene; aiming at the marked data, cleaning the data at three layers of regular account period, regular site association and cost allocation/collection to obtain cleaned data; The accounting period regulation is used for converting various time information in the multi-source data into a standard financial accounting period to realize time sequence alignment of the multi-source data, the site association regulation is used for unifying heterogeneous identifications representing the same site in a plurality of service systems of the multi-source data source into a unique site ID, the multi-source data are associated and aligned based on the site ID, and the cost allocation/collection is used for allocating or merging the cost to the single site according to a preset rule aiming at the cost data shared by a plurality of sites. Further, the multi-source system comprises a contract system, an energy consumption system, a financial system, an iron tower system, a network resource system and a cost management platform, and the method comprises the