CN117291519A - Budget data processing method and system based on multidimensional index - Google Patents
Budget data processing method and system based on multidimensional index Download PDFInfo
- Publication number
- CN117291519A CN117291519A CN202311069242.1A CN202311069242A CN117291519A CN 117291519 A CN117291519 A CN 117291519A CN 202311069242 A CN202311069242 A CN 202311069242A CN 117291519 A CN117291519 A CN 117291519A
- Authority
- CN
- China
- Prior art keywords
- data
- budget
- accounting
- processing
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 12
- 238000012545 processing Methods 0.000 claims abstract description 78
- 238000000034 method Methods 0.000 claims abstract description 31
- 238000012549 training Methods 0.000 claims abstract description 25
- 238000003032 molecular docking Methods 0.000 claims abstract description 3
- 238000007726 management method Methods 0.000 claims description 37
- 238000013439 planning Methods 0.000 claims description 16
- 230000003993 interaction Effects 0.000 claims description 9
- 238000004458 analytical method Methods 0.000 claims description 8
- 238000004364 calculation method Methods 0.000 claims description 8
- 238000003860 storage Methods 0.000 claims description 7
- 238000012986 modification Methods 0.000 claims description 6
- 230000004048 modification Effects 0.000 claims description 6
- 238000005096 rolling process Methods 0.000 claims description 6
- 238000012795 verification Methods 0.000 claims description 6
- 238000013528 artificial neural network Methods 0.000 claims description 3
- 238000000354 decomposition reaction Methods 0.000 claims description 3
- 238000005259 measurement Methods 0.000 claims description 3
- 230000008520 organization Effects 0.000 description 8
- 230000008569 process Effects 0.000 description 6
- 238000013499 data model Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 4
- 238000004140 cleaning Methods 0.000 description 3
- 238000010276 construction Methods 0.000 description 3
- 238000013523 data management Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 238000007405 data analysis Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 230000010354 integration Effects 0.000 description 2
- 210000001503 joint Anatomy 0.000 description 2
- 238000004886 process control Methods 0.000 description 2
- 230000009466 transformation Effects 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000005056 compaction Methods 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 230000004069 differentiation Effects 0.000 description 1
- 230000002708 enhancing effect Effects 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000001125 extrusion Methods 0.000 description 1
- 238000013101 initial test Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 238000012384 transportation and delivery Methods 0.000 description 1
- 238000012800 visualization Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06313—Resource planning in a project environment
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0637—Strategic management or analysis, e.g. setting a goal or target of an organisation; Planning actions based on goals; Analysis or evaluation of effectiveness of goals
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Strategic Management (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Operations Research (AREA)
- Educational Administration (AREA)
- Marketing (AREA)
- General Engineering & Computer Science (AREA)
- Development Economics (AREA)
- Game Theory and Decision Science (AREA)
- Life Sciences & Earth Sciences (AREA)
- Biodiversity & Conservation Biology (AREA)
- Software Systems (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The embodiment of the invention provides a budget data processing method and system based on multidimensional indexes, and belongs to the technical field of data processing. The method comprises the following steps: acquiring user budget processing requirements, and downloading system data matched with the user budget processing requirements based on a pre-constructed database; docking accounting data of an accounting database, and accounting the downloaded system data based on the accounting data to obtain corrected system data; training the corrected system data based on a preset data processing model to obtain processed data; and displaying the processed data based on user specified criteria, and storing the processed data into the pre-constructed database. The scheme of the invention realizes the comprehensive and efficient budget processing requirement of the enterprise level.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a budget data processing method based on multidimensional indexes and a budget data processing system based on the multidimensional indexes.
Background
Under the background of the era trend of digital transformation and upgrading, large enterprises push the enterprises to intelligently transform, develop comprehensive budget construction, improve the overall budget management capacity of the enterprises, exert the capacity of target management and process control, and improve the planning and budget management work efficiency, which is a future trend. In enterprise management, in addition to the necessary personnel management and work management, financial related budget management is also a significant concern.
In the existing budget management scheme, each functional department usually performs independent budget processing and then integrates the budget processing into the whole enterprise background, and the method has the problems that when the dimension of the multidimensional model is increased or deleted, a large amount of data cleaning work is required to be performed, the dimension is required to be supplemented, each time the organization structure is changed, the whole processing system is required to be dynamically corrected, and the like. Aiming at the problems of poor comprehensiveness and great implementation difficulty of the existing enterprise budget processing scheme, a new budget data processing scheme needs to be created.
Disclosure of Invention
The embodiment of the invention aims to provide a budget data processing method and system based on multidimensional indexes, which at least solve the problems of poor comprehensiveness and high implementation difficulty of the existing enterprise budget processing scheme.
To achieve the above object, a first aspect of the present invention provides a budget data processing method based on a multidimensional index, the method comprising: acquiring user budget processing requirements, and downloading system data matched with the user budget processing requirements based on a pre-constructed database; docking accounting data of an accounting database, and accounting the downloaded system data based on the accounting data to obtain corrected system data; training the corrected system data based on a preset data processing model to obtain processed data; and displaying the processed data based on user specified criteria, and storing the processed data into the pre-constructed database.
Optionally, the pre-built database is built based on a schema of a multi-dimensional model data table, wherein the multi-dimensional model data table comprises: data time, data form, data source, data description, and data specific values.
Optionally, the pre-constructed database is a NoSQL database.
Optionally, the user budget processing requirement includes: medium-long term rolling planning, target measurement and calculation, annual budget planning and decomposition, monthly rolling, budget adjustment, budget control, budget assessment and budget analysis.
Optionally, the pre-constructed database and the management inventory of the corresponding enterprise are stored in a data interaction node; databases among different business departments in the management libraries of the corresponding enterprises are connected through corresponding preset interaction nodes, and when a user has budget processing requirements, the interaction nodes of the databases among the business departments are opened.
Optionally, the interfacing with the accounting data of the accounting database and accounting the downloaded system data based on the data to obtain corrected system data includes: taking the database of each business department as an accounting database, and taking the data extracted by the corresponding business department as accounting data; and respectively carrying out accounting on the downloaded system data based on the accounting data, judging whether the downloaded system data have differences, and correcting the data with the differences based on the corresponding accounting data to obtain corrected system data.
Optionally, after obtaining the corrected system data, the method further includes: opening an editing function, collecting an editing instruction of a user, and carrying out corresponding editing modification on the corrected system data based on the editing instruction.
Optionally, the method further comprises: constructing a data processing model, comprising: collecting historical processing data under each budget processing requirement, and taking the historical processing data as a training sample; splitting the training sample into training data and verification data; in the pre-constructed neural network, performing data processing model pre-training based on the training data to obtain an initial model; and verifying and correcting the initial model based on the verification data to obtain a corrected model serving as a data processing model.
A second aspect of the present invention provides a budget data processing system based on a multi-dimensional index, said system comprising: the acquisition unit is used for acquiring the budget processing requirements of the user, and downloading system data matched with the budget processing requirements of the user based on a pre-constructed database; the processing unit is used for interfacing accounting data of the accounting database, and accounting the downloaded system data based on the accounting data to obtain corrected system data; the training unit is used for training the corrected system data based on a preset data processing model to obtain processed data; and the output unit is used for displaying the processed data based on a user specified standard and storing the processed data into the pre-constructed database.
In another aspect, the present invention provides a computer readable storage medium having instructions stored thereon, which when executed on a computer, cause the computer to perform the above-described method for processing budget data based on multidimensional metrics.
Through the technical scheme, the budget processing scheme of the multifunctional, multi-department and multi-organization structure based on the budget standard index system is constructed based on the multi-dimensional budget data model to cover the budget full life cycle management, the flexible organization structure and the instant analysis are supported, the data acquisition is carried out through pre-constructing a comprehensive database, the data accounting is carried out based on each accounting data, the data accuracy is ensured, the budget processing meeting the user differentiation requirements is carried out based on the accurate data, and the enterprise-level comprehensive and efficient budget processing requirements are realized.
Additional features and advantages of embodiments of the invention will be set forth in the detailed description which follows.
Drawings
The accompanying drawings are included to provide a further understanding of embodiments of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain, without limitation, the embodiments of the invention. In the drawings:
FIG. 1 is a flow chart of steps of a method for processing budget data based on a multidimensional index in accordance with an embodiment of the present invention;
FIG. 2 is a system architecture diagram of a multidimensional index based budget data processing system in accordance with one embodiment of the present invention.
Detailed Description
The following describes specific embodiments of the present invention in detail with reference to the drawings. It should be understood that the detailed description and specific examples, while indicating and illustrating the invention, are not intended to limit the invention.
Under the background of the era trend of digital transformation and upgrading, large enterprises push the enterprises to intelligently transform, develop comprehensive budget construction, improve the overall budget management capacity of the enterprises, exert the capacity of target management and process control, and improve the planning and budget management work efficiency, which is a future trend. In enterprise management, in addition to the necessary personnel management and work management, financial related budget management is also a significant concern.
In the current budget management scheme, each functional department usually performs a separate budget process and then integrates the budget process into the whole enterprise background, but this approach has the following problems:
1) The budget process is not comprehensive, there may be a correlation between the data of each functional department, and the budget process cannot be completely and independently implemented, if each department performs the budget process alone, the problem of incomplete data process must exist.
2) The data dimension of each functional department can be different, the department can also be determined by the functional characteristics, and when the dimension of the multidimensional model is added or deleted in the subsequent data integration, a large amount of data cleaning work is needed, and the dimension needs to be supplemented.
3) Without implementing budget standard index system management, it is necessary to specify a standard index system in order to efficiently manage an enterprise budget, but the existing budget processing method is completely true in this respect.
4) It is difficult to support flexible organization architecture, and when the complexity of the organization architecture becomes high and there is a certain variation performance, the existing budget processing scheme is difficult to adapt to the variation, and each time the organization structure is changed, the whole processing system needs to be dynamically modified along with the dynamic modification.
Aiming at the problems of poor comprehensiveness and high implementation difficulty of the existing enterprise budget processing scheme, the scheme of the invention provides a budget data processing method based on multidimensional indexes.
FIG. 1 is a method flow diagram of a budget data processing method based on multidimensional metrics, as provided by one embodiment of the present invention. As shown in fig. 1, an embodiment of the present invention provides a budget data processing method based on a multidimensional index, the method including:
step S10: and acquiring user budget processing requirements, and downloading system data matched with the user budget processing requirements based on a pre-constructed database.
Specifically, the user budget processing requirement includes: medium-long term rolling planning, target measurement and calculation, annual budget planning and decomposition, monthly rolling, budget adjustment, budget control, budget assessment and budget analysis.
In the embodiment of the invention, the medium-long term planning is a planning scheme for further enhancing the strategic management of the company and the overall planning capability of medium-long term resources, perfecting the budget management and control system, effectively improving the medium-long term guiding and supervising capability of the budget management on the development of the enterprise, and particularly showing the whole enterprise in a certain future time. The objective calculation is to accept the enterprise planning, and the annual objective is ensured to be consistent with the enterprise objective by carrying out numerical determination on the enterprise objective, so that the development requirement of the enterprise is met, and the objective is realized. Annual budget planning is carried out by a step-by-step summarizing method based on target measuring and calculating data, and next annual budget data is planned according to historical operation data analysis. Support the cooperative linkage of the foreground and the background: the foreground timely reflects the measuring and calculating result, and the background supports multiple versions of data. The vertical summarization of the organization hierarchy is supported, summarized data can be modified, and manual filling and reverse differential extrusion can be performed. And two sets of system applications of a set of budget model are supported, and users can switch and fill between a unified version and a secondary self-use version of the group. Budget adjustment is to adjust annual budget timely according to the investment and operation progress. According to a preset budget planning principle, budget control is integrated with an integrated centralized management and control system FM, so that budget control data is ensured to be issued and issued in time, enterprise operation targets are ensured to be realized, and meanwhile, group budget management and control requirements are met. Budget analysis is carried out to track and analyze budget execution conditions, and deviation is found, the cause of the problem is insight and deviation is corrected in time through execution analysis. By deeply associating with the enterprise financial merge reporting system, timely extraction of data is realized, analysis models of different value views are established according to business categories and management requirements, dynamic pre-compaction comparison data are formed, and changeable management requirements of users of all levels are met. The budget assessment is assessment on each level of unit budget execution results, reflects the operation performance of the whole enterprise, and provides basis for planning the next-period budget.
For users, there are different financial processing requirements, namely, the above-mentioned various requirements, and these different requirements are different corresponding to the data to be processed, and the following corresponding processing results are different. The user self-defines the current budget processing requirement based on the self-requirement, and the system automatically determines a corresponding budget processing scheme based on the user requirement so as to facilitate targeted data extraction.
Preferably, the pre-built database is built based on a schema of a multi-dimensional model data table, wherein the multi-dimensional model data table comprises: data time, data form, data source, data description, and data specific values.
Preferably, the pre-constructed database is a NoSQL database.
In the embodiment of the invention, the budget system builds a multidimensional data model based on a budget standard index system, and the data is stored in a multidimensional model data table. The model of annual budgeting data comprises budget indexes, organizations, versions, years, periods, days, areas, scenes, plates, income sources, auxiliary classifications, assets, increase and decrease changes, projects, resources, job types, passenger classification, auxiliary descriptions, functional ranges and index values, and the formed multidimensional data is stored in a NoSQL database. When the dimension of the budget model is increased, the dimension information is added to the data without cleaning the data and the data, and only the form and the rule which refer to the dimension are modified.
Step S20: and checking the check data of the check database, and performing check on the downloaded system data based on the data to obtain corrected system data.
Specifically, the pre-constructed database and the management inventory of the corresponding enterprise are stored in a data interaction node; the databases among different business departments in the management libraries of the corresponding enterprises are connected through corresponding preset interaction nodes, and when a user has budget processing requirements, the interaction nodes of the databases among the business departments are opened.
In the embodiment of the invention, the budget management system is integrated with the related financial and business system, the financial combined report actual accounting data is accessed, the engineering plan data is accessed, the business actual data such as production operation collaborative scheduling, electric power marketing and the like is accessed, the matching relation between the budget and the accounting subjects and the matching relation between the business system and the budget management system organization architecture are solved, the business financial data access is completed, and the comprehensive budget planning is supported; and simultaneously, budget data is provided for the service system, and data support is provided for service optimization trial calculation. In order to make the data more comprehensive, different departments and organization structures need to be subjected to differentiated data acquisition, so that the currently constructed data system needs to be in butt joint with an original enterprise management system, and all departments of an enterprise need to be connected in series so as to be convenient for data updating and accounting. In real time, the data stored in the construction database is not communicated with the reserved data of each department in real time, and the mode is used for protecting key data of each department and avoiding important data leakage caused by too thorough data opening. However, this scheme may have a possibility that the data stored in the build database may be different from the current department data, and based on this, accounting needs to be performed on the data stored in the pre-build system to ensure that the extracted data is satisfactory.
Specifically, the interfacing the accounting data of the accounting database, and performing accounting on the downloaded system data based on the data to obtain corrected system data, including: taking the database of each business department as an accounting database, and taking the data extracted by the corresponding business department as accounting data; and respectively carrying out accounting on the downloaded system data based on the accounting data, judging whether the downloaded system data has a difference, and correcting the data with the difference based on the corresponding accounting data to obtain corrected system data.
Preferably, after obtaining the corrected system data, the method further comprises: opening an editing function, collecting an editing instruction of a user, and carrying out corresponding editing modification on the corrected system data based on the editing instruction.
In the embodiment of the invention, the budget model form supports manual data filling, data integration and data calculation. If the next year of the budget model form is manually recorded by a user, the actual number of the current year and the last year of the budget model form automatically acquire the actual number of the financial combined report, and part of cell data is automatically calculated according to logic. For the part of data, manual filling is needed, and in order to avoid error of accounting data, the scheme of the invention is opened with a manual editing function, and related personnel can edit the data based on own requirements and experience. The system collects editing instructions of users, and writes and modifies corresponding data based on the editing instructions.
Step S30: training the modified system data based on a preset data processing model to obtain processed data.
Specifically, the scheme of the invention is to use a report engine, a calculation engine and a formula grammar system based on a budget management system, and the front end can quickly respond to the change of the budget business requirement, quickly implement budget report and calculation logic, and quickly configure user permission and online delivery. Based on this, it is first necessary to construct a data processing model, including: collecting historical processing data under each budget processing requirement, and taking the historical processing data as a training sample; splitting the training sample into training data and verification data; in the pre-constructed neural network, performing data processing model pre-training based on the training data to obtain an initial model; and verifying and correcting the initial model based on the verification data to obtain a corrected model serving as a data processing model.
Step S40: and displaying the processed data based on user specified criteria, and storing the processed data into the pre-constructed database.
Specifically, based on a multidimensional budget data model, the back end supports multi-version budget data management such as initial testing version, quick editing version, reporting version, formal version, decomposing version and the like. Based on a standard index system and a multidimensional data model, the budget management system supports an impromptu analysis function, so that each industry user selects different subjects and different dimensions in an autonomous dragging mode, the budget data is inquired and analyzed, and the scene, refinement and visualization level of the data analysis are improved. The user can carry out data differentiated display based on own requirements so as to ensure that the user can extract own interest information more quickly, and the method has good practical significance for data efficient processing and user use experience.
Preferably, the scheme of the invention supports model distributed parallel computing, the system performance supports flexible expansion, computing nodes are added during the period of using the system such as annual budget establishment and the like to improve the system performance, and the computing nodes are reduced after the peak so as to save resources.
FIG. 2 is a system architecture diagram of a multidimensional index based budget data processing system in accordance with one embodiment of the present invention. As shown in FIG. 2, an embodiment of the present invention provides a budget data processing system based on multidimensional metrics, the system comprising: the acquisition unit is used for acquiring the budget processing requirements of the user, and downloading system data matched with the budget processing requirements of the user based on a pre-constructed database; the processing unit is used for butting accounting data of the accounting database, and accounting the downloaded system data based on the data to obtain corrected system data; the training unit is used for training the modified system data based on a preset data processing model to obtain processed data; and the output unit is used for displaying the processed data based on a user specified standard and storing the processed data into the pre-constructed database.
Preferably, the budget data processing system based on the multidimensional index is in butt joint with the data management platform, the data management platform accesses a synchronous database of the budget management system, reads budget index data, displays budget data assets and provides data service to the outside.
The embodiment of the invention also provides a computer readable storage medium, wherein the computer readable storage medium stores instructions, and when the computer readable storage medium runs on a computer, the computer is caused to execute the budget data processing method based on the multidimensional index.
Those skilled in the art will appreciate that all or part of the steps in a method for implementing the above embodiments may be implemented by a program stored in a storage medium, where the program includes several instructions for causing a single-chip microcomputer, chip or processor (processor) to perform all or part of the steps in a method according to the embodiments of the invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The alternative embodiments of the present invention have been described in detail above with reference to the accompanying drawings, but the embodiments of the present invention are not limited to the specific details of the above embodiments, and various simple modifications may be made to the technical solutions of the embodiments of the present invention within the scope of the technical concept of the embodiments of the present invention, and all the simple modifications belong to the protection scope of the embodiments of the present invention. In addition, the specific features described in the above embodiments may be combined in any suitable manner without contradiction. In order to avoid unnecessary repetition, the various possible combinations of embodiments of the invention are not described in detail.
In addition, any combination of the various embodiments of the present invention may be made, so long as it does not deviate from the idea of the embodiments of the present invention, and it should also be regarded as what is disclosed in the embodiments of the present invention.
Claims (10)
1. A method for budget data processing based on a multidimensional index, the method comprising:
acquiring user budget processing requirements, and downloading system data matched with the user budget processing requirements based on a pre-constructed database;
docking accounting data of an accounting database, and accounting the downloaded system data based on the accounting data to obtain corrected system data;
training the corrected system data based on a preset data processing model to obtain processed data;
and displaying the processed data based on user specified criteria, and storing the processed data into the pre-constructed database.
2. The method of claim 1, wherein the pre-built database is built based on a schema of a multi-dimensional model data table, wherein,
the multidimensional model data table comprises:
data time, data form, data source, data description, and data specific values.
3. The method of claim 1, wherein the pre-built database is a NoSQL database.
4. The method of claim 1, wherein the user budget processing requirement comprises:
medium-long term rolling planning, target measurement and calculation, annual budget planning and decomposition, monthly rolling, budget adjustment, budget control, budget assessment and budget analysis.
5. The method of claim 1, wherein the pre-built database is stored with a management inventory of a corresponding enterprise at a data interaction node;
databases among different business departments in the management libraries of the corresponding enterprises are connected through corresponding preset interaction nodes, and when a user has budget processing requirements, the interaction nodes of the databases among the business departments are opened.
6. The method of claim 5, wherein interfacing the accounting data of the accounting database and accounting the downloaded system data based on the data to obtain corrected system data, comprises:
taking the database of each business department as an accounting database, and taking the data extracted by the corresponding business department as accounting data;
and respectively carrying out accounting on the downloaded system data based on the accounting data, judging whether the downloaded system data have differences, and correcting the data with the differences based on the corresponding accounting data to obtain corrected system data.
7. The method of claim 1, wherein after obtaining the corrected system data, the method further comprises:
opening an editing function, collecting an editing instruction of a user, and carrying out corresponding editing modification on the corrected system data based on the editing instruction.
8. The method according to claim 1, wherein the method further comprises:
constructing a data processing model, comprising:
collecting historical processing data under each budget processing requirement, and taking the historical processing data as a training sample;
splitting the training sample into training data and verification data;
in the pre-constructed neural network, performing data processing model pre-training based on the training data to obtain an initial model;
and verifying and correcting the initial model based on the verification data to obtain a corrected model serving as a data processing model.
9. A budget data processing system based on a multidimensional index, said system comprising:
the acquisition unit is used for acquiring the budget processing requirements of the user, and downloading system data matched with the budget processing requirements of the user based on a pre-constructed database;
the processing unit is used for interfacing accounting data of the accounting database, and accounting the downloaded system data based on the accounting data to obtain corrected system data;
the training unit is used for training the corrected system data based on a preset data processing model to obtain processed data;
and the output unit is used for displaying the processed data based on a user specified standard and storing the processed data into the pre-constructed database.
10. A computer readable storage medium having instructions stored thereon, which when run on a computer causes the computer to perform the multidimensional index based budget data processing method according to any of the claims 1-8.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202311069242.1A CN117291519A (en) | 2023-08-23 | 2023-08-23 | Budget data processing method and system based on multidimensional index |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202311069242.1A CN117291519A (en) | 2023-08-23 | 2023-08-23 | Budget data processing method and system based on multidimensional index |
Publications (1)
Publication Number | Publication Date |
---|---|
CN117291519A true CN117291519A (en) | 2023-12-26 |
Family
ID=89247075
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202311069242.1A Pending CN117291519A (en) | 2023-08-23 | 2023-08-23 | Budget data processing method and system based on multidimensional index |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN117291519A (en) |
-
2023
- 2023-08-23 CN CN202311069242.1A patent/CN117291519A/en active Pending
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102117306B (en) | Method and system for monitoring ETL (extract-transform-load) data processing process | |
CN113807747A (en) | Enterprise budget management maturity evaluation system | |
CN106503222A (en) | Batch based on Excel imports the method and device of management data base | |
CN113408890A (en) | Artificial intelligence-based method and system for generating evaluation report after industrial investment project | |
CN112395370B (en) | Data processing method, device, equipment and storage medium | |
CN109299445A (en) | It obtains the method, apparatus of file template, calculate equipment and storage medium | |
CN112651218A (en) | Automatic generation method and management method of bidding document, medium and computer | |
JP2008544407A (en) | Technical methods and tools for capability-based multiple family of systems planning | |
CN115470195A (en) | Index data automatic calculation method and device fusing dimension models | |
CN115577883A (en) | Carbon asset management method and system, electronic device and storage medium | |
CN113610595A (en) | Method and system for informatization management of price reporting and reviewing | |
Lewis et al. | Microsimulation techniques for tax and transfer analysis | |
CN114118669A (en) | Project management method based on Monte Carlo | |
CN109299926A (en) | A kind of external finance software data integration method | |
CN117827792A (en) | Data asset management method and system | |
CN117291519A (en) | Budget data processing method and system based on multidimensional index | |
Shuxiang | Application of Hadoop cloud platform based on soft computing in financial accounting budget control | |
CN103714066B (en) | Database analysis device based on template | |
CN111127186A (en) | Application method of customer credit rating evaluation system based on big data technology | |
CN114638431A (en) | Infomworks model-based typical plot year runoff total amount control rate quick-check method | |
Canfora et al. | Applying a framework for the improvement of software process maturity | |
CN113298120B (en) | Fusion model-based user risk prediction method, system and computer equipment | |
Nulhusna et al. | Strategy to Improve Data Quality Management: A Case Study of Master Data at Government Organization in Indonesia | |
Niska | Multi-model Database Migration | |
CN110060100A (en) | The prediction technique and system of market competition intensity, electronic equipment, storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination |