CN111913962B - Multi-dimensional annual detail fund planning system and method - Google Patents

Multi-dimensional annual detail fund planning system and method Download PDF

Info

Publication number
CN111913962B
CN111913962B CN202010752585.8A CN202010752585A CN111913962B CN 111913962 B CN111913962 B CN 111913962B CN 202010752585 A CN202010752585 A CN 202010752585A CN 111913962 B CN111913962 B CN 111913962B
Authority
CN
China
Prior art keywords
data
dimension
approval
module
report
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.)
Active
Application number
CN202010752585.8A
Other languages
Chinese (zh)
Other versions
CN111913962A (en
Inventor
王延松
纪书鹏
吴翔
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Inspur General Software Co Ltd
Original Assignee
Inspur General Software Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Inspur General Software Co Ltd filed Critical Inspur General Software Co Ltd
Priority to CN202010752585.8A priority Critical patent/CN111913962B/en
Publication of CN111913962A publication Critical patent/CN111913962A/en
Application granted granted Critical
Publication of CN111913962B publication Critical patent/CN111913962B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/103Workflow collaboration or project management

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Strategic Management (AREA)
  • Human Resources & Organizations (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • General Physics & Mathematics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Economics (AREA)
  • Software Systems (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Marketing (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

The invention discloses a system and a method for planning and planning multi-dimensional annual detail funds, wherein the system comprises a data importing module, a data storage module, a dimension configuration module, a data processing module and an approval display module, and the method comprises the following steps: s1, acquiring a basic data table; s2, creating a report, and adding dimension data based on user operation; s3, extracting data from the basic data table by the added field corresponding to the dimension data, calculating and returning to the report; s4, generating an approval report after submitting approval. The invention reduces the workload of users, improves the programming efficiency of the self-planning table and reduces the programming difficulty.

Description

Multi-dimensional annual detail fund planning system and method
Technical Field
The invention relates to the technical field of computers, in particular to a system and a method for planning multi-dimensional annual detail fund.
Background
For large group enterprises, due to the reasons of industrial diversification, multiple and complex organization architecture levels and the like, different management departments of the group need to know annual fund planning conditions of the group from different calibers, and each level of units is required to plan according to a plurality of management dimensions. The multi-dimensional fund planning increases the complexity of planning the sample, the traditional mode is to plan a plurality of reports through splitting dimensions, the planning of the multi-report is realized, staff is required to calculate all dimensional data in a summarizing mode, each report is required to be examined and approved, the workload is doubled, and the planning efficiency is low.
Disclosure of Invention
The invention aims at overcoming the defects, and provides a system and a method for compiling multi-dimensional annual detail fund, which are used for efficiently and accurately compiling a group annual fund plan and solving the problems of complex business pain points of filling and approval of the multi-dimensional annual detail fund plan of a large group enterprise.
The technical scheme adopted by the invention is as follows:
a multi-dimensional annual detail fund planning system comprises a data importing module, a data storage module, a dimension configuration module, a data processing module and an approval display module, wherein:
the data importing module is used for importing the existing basic data table into the system;
the data storage module is used for storing the imported basic data table;
the dimension configuration module is used for adding the data dimension into the report, and when the data dimension is added, the data dimension can extract data from the imported associated basic data table; the report supports data replication and manual input in the compiling process;
the data processing module is used for extracting data corresponding to the data dimension from the relevant basic data table and then performing summarization calculation;
and the approval display module submits the configured report to an approval end for display.
As a further optimization of the system, the data storage module stores a plurality of data templates in the form, wherein the data templates are used for providing standard data input formats, and each data template is provided with a unique number.
As a further optimization of the system, the data dimension is defined through a structure field, the structure field comprises a fixed field and an extension field, the fixed field is a universal field, and the extension field is a custom field and is used for configuration and use in the process of extending the data dimension.
As a further optimization of the system, in the data processing module, each data dimension is defined with a calculation formula, and data is extracted from basic data through the calculation formula to carry out summarization calculation; the data dimension with the hierarchical relationship is calculated in the calculation process, and the data of the final data dimension is calculated in a priority mode and then is calculated upwards step by step.
As a further optimization of the system, in the data processing module, error correction is performed by establishing a comparison formula between one of the data dimensions and the associated data dimension, and if the correlation comparison formula is not satisfied between the data dimension and the associated data dimension, the system gives a warning.
As further optimization of the system, hierarchical relations exist among the associated dimensions, primary dimension data are displayed by default in the approval display module, a hierarchical expansion control is arranged at the primary dimension data, and the hierarchical expansion space opens subordinate dimension data under the dimension data.
The invention also provides a multi-dimensional annual detail fund planning method, which comprises the following steps:
s1, acquiring a basic data table;
s2, creating a report, and adding dimension data based on user operation;
s3, extracting data from the basic data table by the added field corresponding to the dimension data, calculating and returning to the report;
s4, generating an approval report after submitting approval.
As a further optimization of the method of the present invention, in step S3 of the present invention, each data dimension is defined with a calculation formula, and data is extracted from the basic data by the calculation formula to perform summary calculation; the data dimension with the hierarchical relationship is calculated in the calculation process, and the data of the final data dimension is calculated in a priority mode and then is calculated upwards step by step.
As a further optimization of the method of the present invention, in step S3 of the present invention, error correction is performed by creating a comparison formula between one of the data dimensions and the associated data dimension, and if the correlation comparison formula is not satisfied between the data dimension and the associated data dimension, the system will issue a warning.
The invention also provides a method for constructing the multi-dimensional annual detail fund planning system, which comprises the following steps:
s1, constructing a data table structure, defining fields forming dimension data, and setting report data permission; and configuring a calculation formula and/or an association comparison formula of the field;
s2, creating a data calculation process of a data dimension;
and S3, defining a folding display interface for data approval.
The invention has the following advantages: according to the invention, a multidimensional mode is adopted for programming, the dimension of programming can be flexibly configured according to service requirements, and the diversification of data statistics and payment control is realized through definition of a dimension formula; the data acquisition is convenient, and part of data processing is performed by a program instead of manual calculation; the approval data is processed and displayed in a centralized way, so that repeated approval for multiple times is avoided; the background data structure is more reasonable in design and higher in data processing performance. The method has the advantages that the method is simple to operate for planning staff, approval staff and data using staff, the working efficiency is greatly improved, and the method has good popularization and use values in large-scale group enterprises.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the description of the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
The invention is further described below with reference to the accompanying drawings:
fig. 1 is a schematic diagram of an approval interface of the system of the present embodiment.
Detailed Description
The invention will be further described with reference to the accompanying drawings and specific examples, so that those skilled in the art can better understand the invention and implement it, but the examples are not meant to limit the invention, and the technical features of the embodiments of the invention and the examples can be combined with each other without conflict.
It should be appreciated that in the description of embodiments of the invention, the words "first," "second," and the like are used merely for distinguishing between the descriptions and not for indicating or implying any relative importance or order. "plurality" in the embodiments of the present invention means two or more.
In the embodiment of the present invention, the "and/or" is merely an association relationship describing the association object, and the representation may have three relationships, for example, a and/or B may represent: a alone, B alone, and both A and B. In addition, the character "/" herein generally indicates that the front-rear associated object is an "or" relationship.
The invention provides an embodiment of a multi-dimensional annual detail fund compiling system, which comprises a data importing module, a data storage module, a dimension configuration module, a data processing module and an approval display module, wherein:
the data importing module is used for importing the existing basic data table into the system; the basic data table stores basic data for overall accounting, such as a department fund plan, a month fund plan and the like, and the basic data is summarized and calculated to obtain an annual fund plan of the whole group company;
the data storage module is used for storing the imported basic data table; the data storage module also stores data templates with various table samples, the basic data table is manufactured based on the data templates, the unified data format is convenient, each data template is provided with a unique number, and positioning and searching of data are convenient;
the dimension configuration module is used for adding required data dimensions into the report, and the data dimensions can extract data from the imported relevant basic data tables; in programming, the data table needs to be added with the type of dimension defined by the structure field, in this embodiment, the defined structure field includes a fixed field and an extension field, the fixed field defines a common field for a developer, the extension field defines a required field for the user himself, and specifically, the structure field used in this embodiment is shown in the following table:
wherein, the description of the extension field in the structure field table is as follows:
sequence number Numbering device Name of the name Data type Input mode Mapping relation Database field
1 SFQD Payment channel Text of Enumeration of Payment channel UserPreDef_1
2 SFLX Pay-and-pay type Text of Enumeration of Pay-and-pay type UserPreDef_2
3 QDX Certainty of determination Text of Enumeration of UserPreDef_3
4 WEEK Natural circumference Text of Manual input UserPreDef_4
5 ZSRMB Folding RMB Floating point number Manual input Folding RMB UserPreDef_5
6 ZSMY Dollars conversion Floating point number Manual input Dollars conversion UserPreDef_6
7 DFYH Opponent bank category Text of Help type UserPreDef_7
8 HTMC Contract name Text of Manual input UserPreDef_8
9 BZE Payment proportion Text of Manual input UserPreDef_9
10 QMYE End of period balance Floating point number Manual input UserPreDef_10
When a report is compiled, the system defaults to generate a trial-list, wherein the trial-list comprises common data dimensions, and the trial-list supports data copying and manual input in the compiling process, so that the data can be recorded and changed conveniently;
the data processing module is used for extracting data from the relevant basic data table according to the data corresponding to the data dimension and then performing summarization calculation; a calculation program is arranged between each data dimension and the associated list, corresponding data is firstly extracted from the basic data table through the calculation program, and the relevant data is filled into the report after calculation and summarization; when the enterprise initiates a payment service, whether the fund plan is sufficient is judged, each data dimension can be configured with a comparison formula of the associated data dimension, and when the data dimension and the associated data dimension do not meet the comparison formula, a warning is carried out.
The partial codes of the data processing module for data calculation are as follows:
and the approval display module submits the configured report to an approval end for display. The related dimensions have a hierarchical relationship, primary dimension data are displayed by default in the approval display module, a hierarchical expansion control is arranged at the primary dimension data, and the subordinate dimension data under the dimension data are opened by the hierarchical expansion space, so that the whole approval interface has definite hierarchy and is more ordered, and approval personnel can conveniently check the data accuracy piece by piece;
the partial codes of the data display processing of the approval interface are as follows:
the system described in this embodiment has the following features:
1. flexibly configurable orchestrated dimensions
The planning dimension is determined according to the management requirement of an enterprise, taking a certain central enterprise group as an example, and the planning dimension comprises: during the planning year, the month of construction, the unit of construction, the project of construction, the currency (RMB, dollar, harbor, pound, etc.), the pay channel (finance company, external bank, etc.), the pay type (inside the group, outside the group). Each time a dimension is configured, the detail data table structure automatically expands fields, binds a data source association table, and the data display interface filters dimension data by defining a dimension formula; when an enterprise initiates a payment service, whether the fund plan is sufficient or not is judged, and a formula of the filter plan number can be configured for each dimension.
2. Data acquisition facilitation and data processing automation
Support the data acquisition mode of many scenes: data import, data copying and direct input; the Excel table supports data import of different dimensions, so that the compiling efficiency is high; the direct input mode is free from selecting the filled expense items again, and the operation is simple and clear.
Data processing automation: the data can be processed (automatically) in a linkage way during data acquisition, so that the calculation performance is high; when the data is queried, the planning data can be queried and filtered according to multiple dimensions, and the summarized level planning number of the expense items and units can be automatically summarized and calculated and displayed.
3. Approval data centralized processing display
The approval interface may present multiple data sources; when the data is displayed according to the shrinkage of the balance items, the form is visual and concise, the plan data is integrally displayed according to the year, and the detail can be combined step by step, so that the approver can view the fund plan data from the whole and local multiple angles, and the plan data of all dimensions is intensively approved at one time.
The invention also provides a multi-dimensional annual detail fund compiling method, which comprises the following steps:
s1, acquiring a basic data table;
s2, creating a report, and adding dimension data based on user operation;
s3, extracting data from the basic data table by the added field corresponding to the dimension data, calculating and returning to the report;
a calculation program is arranged between each data dimension and the associated list, corresponding data is firstly extracted from a basic data table through the calculation program, the relevant data is filled into a report after being calculated and summarized, hierarchical summarization calculation is required to be carried out on the data dimension with hierarchical relation, such as a balance item and budget organization, the data dimension is tree data with upper and lower level relation, and after advanced final-stage data calculation, the upper-stage data are combined step by step and calculated; when the enterprise initiates a payment service, whether the fund plan is sufficient is judged, each data dimension can be configured with a comparison formula of the associated data dimension, and when the data dimension and the associated data dimension do not meet the comparison formula, a warning is carried out.
S4, generating an approval report after submitting approval.
The method for constructing the multi-dimensional annual detail fund compiling system comprises the following steps:
s1, constructing a data table structure, defining fields forming dimension data, and setting report data permission; and configuring a calculation formula and/or an association comparison formula of the field;
s2, creating a data calculation process of a data dimension;
and S3, defining a folding display interface for data approval.
The above-described embodiments are merely preferred embodiments for fully explaining the present invention, and the scope of the present invention is not limited thereto. Equivalent substitutions and modifications will occur to those skilled in the art based on the present invention, and are intended to be within the scope of the present invention. The protection scope of the invention is subject to the claims.

Claims (3)

1. A multi-dimensional annual detail fund planning system, characterized by: the device comprises a data importing module, a data storage module, a dimension configuration module, a data processing module and an approval display module, wherein:
the data importing module is used for importing the existing basic data table into the system;
the data storage module is used for storing the imported basic data table;
the data storage module stores data templates of various forms, the data templates are used for providing standard data input formats, and each data template is provided with a unique number;
the dimension configuration module is used for adding the data dimension into the report, and when the data dimension is added, the data dimension can extract data from the imported associated basic data table; the report supports data replication and manual input in the compiling process;
the data dimension is defined through a structure field, the structure field comprises a fixed field and an extension field, the fixed field is a universal field, and the extension field is a custom field and is used for configuration and use when the data dimension is extended;
the data processing module is used for extracting data corresponding to the data dimension from the relevant basic data table and then performing summarization calculation;
in the data processing module, each data dimension is defined with a calculation formula, and data is extracted from basic data through the calculation formula to carry out summarization calculation; the data dimension with the hierarchical relation is calculated in a calculation process preferentially, and then the data of the final data dimension is calculated step by step upwards;
in the data processing module, error correction is carried out by establishing a comparison formula between one data dimension and the associated data dimension, and if the data dimension and the associated data dimension do not meet the association comparison formula, the system sends out a warning;
the approval display module submits the configured report to an approval end for display;
the related dimensions have a hierarchical relation, primary dimension data are displayed by default in the approval display module, a hierarchical unfolding control is arranged at the primary dimension data, and the hierarchical unfolding space opens subordinate dimension data under the dimension data.
2. A method of multi-dimensional annual detail fund planning, the method being based on the multi-dimensional annual detail fund planning system of claim 1, characterized in that: the method comprises the following steps:
s1, acquiring a basic data table;
s2, creating a report, and adding dimension data based on user operation;
s3, extracting data from the basic data table by the added field corresponding to the dimension data, calculating and returning to the report;
in step S3, each data dimension is defined with a calculation formula, and data is extracted from basic data through the calculation formula to carry out summarization calculation; the data dimension with the hierarchical relation is calculated in a calculation process preferentially, and then the data of the final data dimension is calculated step by step upwards;
in step S3, error correction is performed by creating a comparison formula between one of the data dimensions and the associated data dimension, and if the data dimension and the associated data dimension do not satisfy the comparison formula, the system will issue a warning;
s4, generating an approval report after submitting approval.
3. A method of constructing a multi-dimensional annual detail fund planning system, the method being based on the multi-dimensional annual detail fund planning system of claim 1, characterized in that: the method comprises the following steps:
s1, constructing a data table structure, defining fields forming dimension data, and setting report data permission; and configuring a calculation formula and/or an association comparison formula of the field;
s2, creating a data calculation process of a data dimension;
and S3, defining a folding display interface for data approval.
CN202010752585.8A 2020-07-30 2020-07-30 Multi-dimensional annual detail fund planning system and method Active CN111913962B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010752585.8A CN111913962B (en) 2020-07-30 2020-07-30 Multi-dimensional annual detail fund planning system and method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010752585.8A CN111913962B (en) 2020-07-30 2020-07-30 Multi-dimensional annual detail fund planning system and method

Publications (2)

Publication Number Publication Date
CN111913962A CN111913962A (en) 2020-11-10
CN111913962B true CN111913962B (en) 2024-03-08

Family

ID=73287940

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010752585.8A Active CN111913962B (en) 2020-07-30 2020-07-30 Multi-dimensional annual detail fund planning system and method

Country Status (1)

Country Link
CN (1) CN111913962B (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112711412B (en) * 2020-12-29 2023-01-24 山东浪潮通软信息科技有限公司 Universal business plan compiling method and platform
CN113704259A (en) * 2021-08-24 2021-11-26 北京仁科互动网络技术有限公司 Data summarization method, device, electronic equipment, storage medium and program product

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2014079304A1 (en) * 2012-11-26 2014-05-30 中兴通讯股份有限公司 Report creation method, device and system
CN107705098A (en) * 2017-10-31 2018-02-16 远光软件股份有限公司 Method of summary is worked out in financing plans
CN108198065A (en) * 2018-03-20 2018-06-22 重庆市农业科学院 Agriculture construction project financial statement manages system and method

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8239299B2 (en) * 2007-02-26 2012-08-07 Microsoft Corporation Type-driven rules for financial intellegence

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2014079304A1 (en) * 2012-11-26 2014-05-30 中兴通讯股份有限公司 Report creation method, device and system
CN107705098A (en) * 2017-10-31 2018-02-16 远光软件股份有限公司 Method of summary is worked out in financing plans
CN108198065A (en) * 2018-03-20 2018-06-22 重庆市农业科学院 Agriculture construction project financial statement manages system and method

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
省级电力公司投资计划管理系统的设计与应用;詹伟;郭峰;王婕;刘芬;;电力信息化(第12期);全文 *
铁路企业全面预算管理系统的研发与应用;万婧昕;春意;刘承亮;;铁路计算机应用(第12期);全文 *

Also Published As

Publication number Publication date
CN111913962A (en) 2020-11-10

Similar Documents

Publication Publication Date Title
US20050055669A1 (en) Specification to ABAP code converter
CN101308490B (en) Dynamic report generation method and platform
KR102432104B1 (en) Systems and methods for determining relationships between data elements
US6957191B1 (en) Automated financial scenario modeling and analysis tool having an intelligent graphical user interface
US20050183002A1 (en) Data and metadata linking form mechanism and method
US7302444B1 (en) System for designating grid-based database reports
US20090150426A1 (en) Automatically generating formulas based on parameters of a model
CN102314424A (en) Dimension-based relational graph of files
CN111913962B (en) Multi-dimensional annual detail fund planning system and method
US20120253997A1 (en) Method for multi-dimensional accounting of business transactions and system therefor
CN109408043A (en) A kind of program creating method and device
CN102722537A (en) Database test data generation method and system thereof
CN106649232A (en) Method for automatically converting financial data into data capable of being understood by non-financial staff
JP5010749B1 (en) Accounting journal file data standardization system, audit system using the system, and programs thereof
US7461076B1 (en) Method and apparatus for creating a well-formed database system using a computer
CN112966482A (en) Report generation method, device and equipment
EP1745390A2 (en) Data and metadata linking form mechanism and method
CN202433952U (en) General network reporting system
CN101882147B (en) Curve data storage device and method
JP5261643B2 (en) Accounting journal file data standardization system and its program
CN106228439A (en) A kind of financial data management method and system
US11861735B1 (en) Method for generating a balance sheet that includes operating materials and supplies costs
US7987203B2 (en) Method of processing data for a system model
CN112131855A (en) Bank certificate template generation method and device
KR20150045851A (en) Pattern-based trading system, the fiscal account, automatic matching and accounting entry

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
TA01 Transfer of patent application right

Effective date of registration: 20240201

Address after: No. 1036, Shandong high tech Zone wave road, Ji'nan, Shandong

Applicant after: Inspur Genersoft Co.,Ltd.

Country or region after: China

Address before: 250000 No. 2877 Kehang Road, Suncun Town, Jinan High-tech District, Shandong Province

Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd.

Country or region before: China

TA01 Transfer of patent application right
GR01 Patent grant
GR01 Patent grant