CN111353288B - Report processing method, system, device and computer readable storage medium - Google Patents
Report processing method, system, device and computer readable storage medium Download PDFInfo
- Publication number
- CN111353288B CN111353288B CN202010140257.2A CN202010140257A CN111353288B CN 111353288 B CN111353288 B CN 111353288B CN 202010140257 A CN202010140257 A CN 202010140257A CN 111353288 B CN111353288 B CN 111353288B
- Authority
- CN
- China
- Prior art keywords
- analysis
- report
- information
- index
- result list
- 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
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 63
- 238000004458 analytical method Methods 0.000 claims abstract description 304
- 238000012545 processing Methods 0.000 claims abstract description 46
- 238000004364 calculation method Methods 0.000 claims description 18
- 238000004590 computer program Methods 0.000 claims description 3
- 238000000034 method Methods 0.000 abstract description 9
- 230000008569 process Effects 0.000 abstract description 5
- 238000010586 diagram Methods 0.000 description 11
- 238000007405 data analysis Methods 0.000 description 10
- 230000006870 function Effects 0.000 description 6
- 239000000284 extract Substances 0.000 description 5
- 238000007726 management method Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 3
- 238000012546 transfer Methods 0.000 description 3
- 230000002776 aggregation Effects 0.000 description 2
- 238000004220 aggregation Methods 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 2
- 238000009417 prefabrication Methods 0.000 description 2
- 238000012552 review Methods 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 230000001149 cognitive effect Effects 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000000737 periodic effect Effects 0.000 description 1
Classifications
-
- 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/26—Visual data mining; Browsing structured data
-
- 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/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- General Business, Economics & Management (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- Game Theory and Decision Science (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a report processing method, a report processing system, a report processing device and a computer readable storage medium. The report processing method comprises the following steps: constructing a report model data pool of a table structure by adopting the dimension information and the index information which are mutually associated, and filling data information corresponding to the dimension information and the index information into the report model data pool; searching the display type in the analysis report; adding analysis content in the analysis report to an analysis result list according to the display type; and (3) circulating the analysis result list, matching, searching and replacing index information and/or parameter information in the analysis result list, and adding the replacement result to the analysis result list. The technical scheme of the invention can reasonably process and analyze the report data so as to provide reference for the decision of a user.
Description
Technical Field
The present invention relates to the field of report data processing, and in particular, to a report processing method, system, apparatus, and computer readable storage medium.
Background
Reasonable processing and analysis of report data can bring great convenience to users of report data processing systems. For example, an enterprise manager needs to grasp the business state of an enterprise in real time, and conduct data analysis through financial and business data indexes to judge whether the business state of the enterprise is healthy, prevent management and control loopholes in advance, and conduct corresponding decisions. However, many enterprise management software is only presented with report data, and lacks data analysis, decision reference and subsequent guidance opinion. Therefore, the technical scheme capable of reasonably processing and analyzing the report data is necessary.
Furthermore, any discussion of the background throughout the specification is not an admission that such background is necessarily prior art to the type of prior art that was known to those skilled in the art, and that any discussion of the prior art throughout the specification is not an admission that such prior art is widely known or forms part of the common general knowledge in the field.
Disclosure of Invention
The present invention aims to solve at least one of the technical problems existing in the prior art or related art.
In order to achieve the first object of the present invention, an embodiment of the present invention provides a report processing method, including the steps of: constructing a report model data pool of a table structure by adopting the dimension information and the index information which are mutually associated, and filling data information corresponding to the dimension information and the index information into the report model data pool; searching the display type in the analysis report; adding analysis content in the analysis report to an analysis result list according to the display type; and (3) circulating the analysis result list, matching, searching and replacing index information and/or parameter information in the analysis result list, and adding the replacement result to the analysis result list.
The aim of the embodiment is to help the user to reasonably process and analyze report data so as to provide reference for the decision of the user. The report processing method of the embodiment can be used in various scenes or fields such as enterprise data analysis, report display application, enterprise resource planning and the like. The embodiment extracts models such as report models, reports, index information, dimension information, analysis reports and parameters and the like to display corresponding report data analysis results, extracts original data to a report model data pool through system prefabrication and user configuration model metadata, assembles the report data and displays the analysis reports to a front-end interface. By providing report interpretation analysis and decision function, the embodiment can enable the enterprise manager to view report data and provide data intelligent analysis and decision reference support for the enterprise manager.
In addition, the technical scheme provided by the embodiment of the invention can also have the following additional technical characteristics:
in the above technical solution, the display types include: the steps of adding the analysis content in the analysis report to the analysis result list according to the display type include specifically: judging the display type as necessary, and adding analysis content into an analysis result list; or judging the display type as index display, calling a fetch engine to calculate an index value, and adding the index value to an analysis result list; or judging the display type as conditional display, searching the analysis formulas in the analysis report, matching, searching and replacing index information and/or parameter information in the analysis formulas, calculating the analysis formulas and adding analysis contents to an analysis result list according to the calculation results.
Through the steps, the analysis content in the analysis report can be correspondingly added into the analysis result list according to the specific display type, so as to be used for subsequent processing calculation.
In any of the above technical solutions, the step of calculating an analysis formula and adding analysis contents to the analysis result list according to the calculation result specifically includes: and judging that the calculation result is true, and adding the analysis content to an analysis result list.
With this embodiment, after the parameter information and the index information are replaced, the expression value can be calculated by the memory. Wherein if the expression value is true, the analysis content in the analysis report is added to the analysis result list for further analysis processing.
In any of the above technical solutions, the steps of matching, searching and replacing the index information and/or the parameter information in the analysis formula specifically include: searching a parameter value list to obtain a parameter value corresponding to the parameter information through matching the parameter information in the analysis formula of the regular expression, and replacing the parameter information by the parameter value; and searching an index value list through index information in the regular expression matching analysis formula to acquire an index value corresponding to the index information, and replacing the index information by the index value.
In this embodiment, the regular expression is used to perform search matching and query replacement to obtain index information and/or parameter information conforming to a certain or some modes or rules, and replace the index information and/or parameter information with specific parameter values or index values, so as to help the user obtain the required analysis result.
In any of the above embodiments, the condition display is a single condition display, and the index value is a single value index value calculated by transmitting index information to the fetch engine.
In this embodiment, under the condition of single condition display, the dimension information in the analysis report is not required to be transmitted, and only the index information is required to be transmitted to the number acquisition engine to acquire the index single value. Therefore, the present embodiment can ensure the analysis efficiency of data analysis.
In any of the above solutions, the display type is a complex condition display, and the index value is a list of index values calculated and obtained by transmitting the index information and the dimension information to the fetch engine.
The implementation transmits the transmission index information and the dimension information to the fetch engine respectively, and calculates the required index value list according to the transmission index information and the dimension information so as to replace the index information. Therefore, the embodiment can ensure the analysis accuracy of data analysis.
To achieve the second object of the present invention, an embodiment of the present invention provides a report processing system, including: the modeling unit is used for constructing a report model data pool of the table structure by adopting the dimension information and the index information which are mutually related, and filling data information corresponding to the dimension information and the index information into the report model data pool; the first processing unit is used for circulating an analysis report contained in the report model, searching a display type in the analysis report and adding analysis contents in the analysis report to an analysis result list according to the display type; and the second processing unit is used for circularly analyzing the result list, matching, searching and replacing index information and/or parameter information in the analysis result list, and adding the replacement result to the analysis result list.
By providing report interpretation analysis and decision function, the embodiment can enable the enterprise manager to view report data and provide data intelligent analysis and decision reference support for the enterprise manager.
In the above technical solution, the report processing system further includes: and the display unit is suitable for displaying the analysis result generated according to the analysis result list.
The display unit of the embodiment can receive and acquire the final processing result of the report processing system for the report information and display the final processing result so as to facilitate the browsing and review of a user.
To achieve the third object of the present invention, an embodiment of the present invention provides a report processing apparatus, including: a memory storing a client program; a processor executing a client program; the method comprises the steps of a report processing method implemented by any one of the invention when a processor executes a client program.
The report processing device in this embodiment implements the steps of the report processing method implemented in any embodiment of the present invention, so that the report processing device has all the beneficial effects of the report processing method implemented in any embodiment of the present invention, and will not be described herein.
To achieve the fourth object of the present invention, an embodiment of the present invention provides a computer-readable storage medium including: the computer readable storage medium stores a computer program which, when executed, implements the steps of the report processing method as any one of the implementations of the invention.
The computer readable storage medium of the present embodiment implements the steps of the report processing method as any implementation of the present invention, so that the method has all the advantages of the report processing method as any implementation of the present invention, and will not be described herein.
Drawings
The foregoing and/or additional aspects and advantages of the invention will become apparent and may be better understood from the following description of embodiments taken in conjunction with the accompanying drawings in which:
FIG. 1 is a flowchart illustrating a first step of a report processing method according to some embodiments of the invention;
FIG. 2 is a flowchart illustrating a second step of a report processing method according to some embodiments of the invention;
FIG. 3 is a flowchart illustrating a third step of a report processing method according to some embodiments of the invention;
FIG. 4 is a fourth flowchart illustrating steps of a report processing method according to some embodiments of the invention;
FIG. 5 is a flowchart illustrating a fifth step of a report processing method according to some embodiments of the invention;
FIG. 6 is a flowchart illustrating a sixth step of a report processing method according to some embodiments of the invention;
FIG. 7 illustrates a first system component diagram of a report processing system in accordance with some embodiments of the invention;
FIG. 8 illustrates a second system component diagram of a report processing system in accordance with some embodiments of the invention;
FIG. 9 is a schematic diagram illustrating the system components of a report processing apparatus according to some embodiments of the invention;
FIG. 10 is a diagram illustrating an application architecture of a report processing method according to some embodiments of the invention;
FIG. 11 illustrates a system model diagram of a report processing method according to some embodiments of the invention;
FIG. 12 is a flowchart illustrating seventh steps of a report processing method according to some embodiments of the invention;
FIG. 13 is a first noun paraphrasing diagram of a report processing method according to some embodiments of the invention;
FIG. 14 is a second noun paraphrasing diagram illustrating a report processing method according to some embodiments of the invention;
FIG. 15 is a third noun paraphrasing diagram illustrating a report processing method according to some embodiments of the invention;
FIG. 16 is a fourth noun paraphrasing diagram illustrating a report processing method according to some embodiments of the invention;
FIG. 17 is a schematic diagram of a fifth noun paraphrasing method of the report processing method according to some embodiments of the invention;
FIG. 18 is a schematic diagram illustrating a sixth noun paraphrasing method of the report processing method according to some embodiments of the invention.
The correspondence between the reference numerals and the component names in fig. 9 to 11 is:
100: report processing system, 110: modeling unit, 120: first processing unit, 130: second processing unit, 140: display unit, 200: report processing device, 210: memory, 220: a processor.
Detailed Description
In order that the above-recited objects, features and advantages of the present invention will be more clearly understood, a more particular description of the invention will be rendered by reference to the appended drawings and appended detailed description. It should be noted that, in the case of no conflict, the embodiments of the present application and the features in the embodiments may be combined with each other.
In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention, however, the present invention may be practiced in other ways than those described herein, and therefore the scope of the present invention is not limited to the specific embodiments disclosed below.
Report processing methods, systems, apparatuses, and computer-readable storage media according to some embodiments of the present invention are described below with reference to fig. 1 through 18.
Example 1
As shown in fig. 1, the present embodiment provides a report processing method, which includes the following steps:
s102, constructing a report model data pool of a table structure by adopting dimension information and index information which are mutually associated, and filling data information corresponding to the dimension information and the index information into the report model data pool;
s104, searching a display type in an analysis report contained in the circulation report model;
s106, adding analysis contents in the analysis report to an analysis result list according to the display type;
s108, circulating the analysis result list, matching, searching and replacing index information and/or parameter information in the analysis result list, and adding the replacement result to the analysis result list.
In this embodiment, the concepts and meanings of the dimension information, the index information, the report model, the report, the analysis report, and the parameter information are specifically as follows. Dimension information refers to key information that business documents can query the group, such as document date, customer, department, project, etc. The index information refers to key data information such as amount, quantity and the like which can participate in aggregation, such as amount of collection, sales quantity and the like. The report model refers to index aggregation grouped according to dimension information, for example, the report model is a receivable analysis report model, which is a receivable amount counted according to dimensions of document date, clients, departments, projects and the like. Statement refers to the presentation of customer financial and business data in a chart form. The analysis report contains analysis indexes and analysis results, and is interpretation and analysis of report data. For the parameter information, the index information in the analysis report accords with the parameter value to display the corresponding analysis result, for example, the analysis overdue days are larger than a plurality of days to be warned.
The application architecture of the report interpretation data analysis is shown in fig. 2. Specifically, a user terminal, such as a PC terminal, can input related data for generating a report. According to the report processing method of the embodiment, report modeling is performed according to the related data provided by the user side as a basis, and the report data is stored. When the report analysis is performed, according to specific requests from a user side such as a PC side or a mobile phone side, the report processing method of the embodiment extracts stored data to an original data extraction layer, establishes a report model data pool, and performs front-end display on the data from the report model data pool through various report forms such as a high-level billboard, multidimensional analysis, a fixed report, index analysis, a mobile billboard and the like by an application program interface (English name: application Programming Interface, chinese name: API).
As shown in fig. 3, the report processing method of the present embodiment establishes a report model data pool table structure according to the dimension information and the index information that are associated with each other. After the data pool table structure is determined, filling data into the report model data pool according to specific access rules in the dimensions and indexes, finally generating a report and an analysis report, and obtaining a final analysis report.
In step S102 of the present embodiment, the data in the report model data pool for constructing the table structure has the following characteristics: the index of each piece of data is aggregated by dimension information. The data pool can be filled by timing tasks or by interface re-fetching. In step S104 of the present embodiment, one report prefabricated by the background model includes a plurality of analysis reports, so that the analysis report included by the report model needs to be circulated first, that is: searching a plurality of analysis reports corresponding to a certain report. Each analysis report contains a display type, analysis content, an analysis formula, analysis dimensions, and report names, and step S104 looks up the display type in the analysis report so that the analysis content in the analysis report can be added to the analysis result list according to the display type in step S106. The specific manner in which the analysis content is added to the analysis result list needs to be determined according to the specific display type of the analysis report. After the analysis content in the analysis report is added to the analysis result list, since the analysis content in the analysis report also contains the index information or the parameter information, the analysis result list is circulated in step S108, each analysis content is searched, the index information and the parameter information of the analysis content in the analysis report are replaced through the steps of matching, searching and replacing, and then the analysis content and the parameter information are added to the list which finally displays the analysis result.
The aim of the embodiment is to help the user to reasonably process and analyze report data so as to provide reference for the decision of the user. The report processing method of the embodiment can be used in various scenes or fields such as enterprise data analysis, report display application, or enterprise resource planning (English name: enterprise Resource Planning, english abbreviation: ERP). In order to achieve the above objective, the present embodiment extracts models such as report model, report, index information, dimension information, analysis report, and parameters, so as to display the analysis result of the corresponding report data. According to the embodiment, the original data is extracted from the report model data pool through system prefabrication and user configuration model metadata, and the report data is assembled and the analysis report is displayed on a front-end interface. By providing report interpretation analysis and decision function, the embodiment can enable the enterprise manager to view report data and provide data intelligent analysis and decision reference support for the enterprise manager.
Example two
The present embodiment provides a report processing method, which further includes the following technical features in addition to the technical features of the foregoing embodiment.
The display types include: must display, index display and condition display. As shown in fig. 4, the step of adding the analysis content in the analysis report to the analysis result list according to the display type specifically includes: and S202, judging that the display type is necessary to be displayed, and adding analysis content to an analysis result list. Or as shown in fig. 5, the step of adding the analysis content in the analysis report to the analysis result list according to the display type specifically includes: and S204, judging the display type as index display, calling a fetch engine to calculate an index value, and adding the index value to the analysis result list. Or as shown in fig. 6, the step of adding the analysis content in the analysis report to the analysis result list according to the display type specifically includes: s206, judging the display type as conditional display, searching an analysis formula in the analysis report, matching, searching and replacing index information and/or parameter information in the analysis formula, calculating the analysis formula, and adding analysis contents to an analysis result list according to a calculation result.
In this embodiment, the specific manner of adding the analysis content to the analysis result list needs to be determined according to the specific display type of the analysis report. Specifically, when the display type is necessary, then the analysis content is directly added to the analysis result list through step S202. When the display type is index display, the access engine is called in step S204, calculates an index value through the report model data pool, and adds the index value to the analysis result list. When the display type is a conditional display, then the analysis formula in this analysis report is searched for through step S206.
Through the steps, the analysis content in the analysis report can be correspondingly added into the analysis result list according to the specific display type, so as to be used for subsequent processing calculation.
Example III
The present embodiment provides a report processing method, which further includes the following technical features in addition to the technical features of any one of the foregoing embodiments.
As shown in fig. 7, the step of calculating an analysis formula and adding analysis contents to an analysis result list according to the calculation result specifically includes:
and S302, judging that the calculation result is true, and adding the analysis content to an analysis result list.
With this embodiment, after the parameter information and the index information are replaced, the expression value can be calculated by the memory. Wherein if the expression value is true, the analysis content in the analysis report is added to the analysis result list for further analysis processing.
Example IV
The present embodiment provides a report processing method, which further includes the following technical features in addition to the technical features of any one of the foregoing embodiments.
As shown in fig. 8, the steps of matching, searching and replacing the index information and/or the parameter information in the analysis formula specifically include:
s402, searching a parameter value list through the parameter information in the regular expression matching analysis formula to acquire a parameter value corresponding to the parameter information, and replacing the parameter information by the parameter value;
s404, index information in the analysis formula is matched through the regular expression, an index value list is searched for to obtain index values corresponding to the index information, and the index values are adopted to replace the index information.
The analysis formula is an expression containing index information and parameter information. For example, one analytical formula may be: { index 1} + { index 2} ] [ parameter ]. Wherein, the index information is bracketed by a bracket "{ }" and the parameter information is bracketed by a bracket "[ ]". By regular expression @ "\ [..? And matching the parameter information in the analysis formula, obtaining the parameter value through searching the parameter table, and replacing the parameter information corresponding to the analysis formula. By regular expression @ "\{..times? And } ", index information in the analysis formula is matched, the analysis dimension of the analysis report is searched, information such as the index, the dimension and the like is transferred, and the number taking engine is called, calculates the index value and replaces the index information corresponding to the analysis formula. Wherein, when the single condition is displayed, the single value index is obtained, and when the complex condition is displayed, the index value list is obtained. It should be noted that the regular expression of this embodiment is also called a regular expression (english name: regular Expression, abbreviated as regex, regex p or RE in code), and can be used to retrieve and replace text conforming to a certain pattern or rule.
Example five
The present embodiment provides a report processing method, which further includes the following technical features in addition to the technical features of any one of the foregoing embodiments.
The condition display is a single condition display, and the index value is a single value index value calculated by transmitting index information to the fetch engine.
In other words, the condition display specifically includes both cases of a single condition display and a complex condition display. Under the condition of single condition display, the dimension information in the analysis report is not required to be transmitted, and only index information is required to be transmitted to the number acquisition engine to acquire index single values.
Example six
The present embodiment provides a report processing method, which further includes the following technical features in addition to the technical features of any one of the foregoing embodiments.
The display type is a complex condition display, and the index value is a list of index values calculated by transmitting index information and dimension information to the fetch engine.
In other words, in the case of complex condition display, the present embodiment needs to transfer the transfer index information and the dimension information to the fetch engine respectively, and calculate together to obtain the required index value list according to the transfer index information and the dimension information, so as to replace the index information.
Example seven
As shown in fig. 9, the present embodiment provides a report processing system 100, including: a modeling unit 110, a first processing unit 120, and a second processing unit 130. The modeling unit 110 constructs a report model data pool of the table structure using the dimension information and the index information associated with each other, and fills data information corresponding to the dimension information and the index information into the report model data pool. The first processing unit 120 loops the analysis report contained in the report model, searches for a display type in the analysis report, and adds analysis contents in the analysis report to the analysis result list according to the display type. The second processing unit 130 loops through the analysis result list, matches, searches, and replaces index information and/or parameter information in the analysis result list, and adds a replacement result to the analysis result list.
In this embodiment, the index of each piece of data in the report model data pool is aggregated according to the dimension information. One report prefabricated by the background model contains a plurality of analysis reports. Each analysis report contains a display type, analysis content, analysis formulas, analysis dimensions, and report names. The specific manner in which the analysis content is added to the analysis results list needs to be determined according to the specific display type of the analysis report. After the analysis content in the analysis report is added to the analysis result list, the analysis content in the analysis report also contains index information or parameter information, so that the embodiment circulates the analysis result list, searches each analysis content, replaces the index information and the parameter information of the analysis content in the analysis report through the steps of matching, searching and replacing, and then adds the index information and the parameter information into the list which finally displays the analysis result.
By providing report interpretation analysis and decision function, the embodiment can enable the enterprise manager to view report data and provide data intelligent analysis and decision reference support for the enterprise manager.
Example eight
As shown in fig. 10, this embodiment provides a report processing system 100, which further includes the following technical features in addition to the technical features of any of the above embodiments.
The report processing system 100 further includes: and a display unit 140, wherein the display unit 140 is adapted to display the analysis result generated according to the analysis result list.
In this embodiment, the display unit 140 is used for displaying the analysis result to the user in the form of a report for the user to read and review. The display unit 140 may be communicatively connected to the second processing unit 130, so as to receive and display the final processing result of the report processing system 100 for report information.
Example nine
As shown in fig. 11, the present embodiment provides a report processing apparatus 200, including: a memory 210 and a processor 220. The memory 210 stores a client program. The processor 220 executes the client program. Wherein the processor 220, when executing the client program, implements the steps of the report processing method according to any of the embodiments of the present invention.
Examples ten
The present embodiment provides a computer-readable storage medium including: the computer readable storage medium stores a computer program which, when executed, implements the steps of the report processing method according to any of the embodiments of the present invention.
In summary, the beneficial effects of the embodiment of the invention are as follows: the embodiment of the invention can enable an enterprise manager to check report data and provide data intelligent analysis and decision reference support for the enterprise manager by providing report interpretation analysis and decision function.
DETAILED DESCRIPTION OF EMBODIMENT (S) OF INVENTION
The embodiment provides a report processing method, which firstly adopts dimension information and index information which are mutually related to construct a report model data pool of a table structure, and fills data information corresponding to the dimension information and the index information into the report model data pool. Furthermore, the report processing method of the present embodiment loops the analysis report included in the report model, and searches for the display type in the analysis report. Then, the report processing method of the present embodiment adds the analysis content in the analysis report to the analysis result list according to the display type. Finally, the report processing method of the embodiment circularly analyzes the result list, matches, searches and replaces index information and/or parameter information in the analysis result list, and adds the replacement result to the analysis result list.
Specifically, as shown in fig. 12, the report processing method of the present embodiment specifically includes the following steps:
s502, searching a report analysis result;
s504, searching an analysis formula of an analysis result;
s506, searching parameters and replacing the parameters in the analysis formula;
s508, searching an index value and replacing the index value in the analysis formula;
s510, calculating an analysis formula;
if the calculation result is true, step S512 is executed, and if the calculation result is false, the process is ended.
S512, searching analysis contents of the analysis result;
s514, replacing parameters in analysis content;
s516, replacing indexes in analysis contents;
and S518, adding analysis content to the analysis report list.
As shown in fig. 13, the report processing method of the present embodiment may be used to analyze an account balance data report, where the index information includes account balance, and the dimension information includes various storage tools or storage modes such as banks, weChat payment, cash, etc., and after generating a report model data pool with the index information and the dimension information, the following periodic collection can be used as an analysis index to obtain a corresponding analysis result.
As shown in fig. 14, the report processing method of the present embodiment may be used to analyze a report of funds inflow data, where the index information includes total funds inflow, and the dimension information includes various funds inflow sources such as sales, processing income, interest income, etc., and after the index information and the dimension information are used to generate a report model data pool, the report model data pool may be compared with the same period of the past year, so as to obtain a corresponding analysis result.
As shown in fig. 15, the report processing method of the present embodiment may be used to analyze a corresponding receipt data report table, where the index information includes accounts receivable, the dimension information includes sources of accounts receivable, and after generating a report model data pool with the index information and the dimension information, the corresponding analysis result may be obtained by taking the year or month as a period unit.
As shown in fig. 16, the report processing method of the present embodiment may be used to analyze an inventory funds data report, which generates a report model data pool with index information and dimension information, and then obtains the ratio of inventory funds in the total amount of assets.
As shown in fig. 17, the report processing method of the present embodiment may be used to analyze a report of funds outflow data, and after generating a report model data pool with index information and dimension information, a specific ratio of various payouts in the total funds outflow amount may be obtained.
As shown in fig. 18, the report processing method of the present embodiment may be used to analyze a payable funds data report, and after generating a report model data pool according to the index information and the dimension information, a specific ratio of payable funds required by various payees in the total payable funds can be obtained.
The report processing method of the present embodiment will be described by taking an analysis report as an example. The payable analysis report presents the total payable ranking of the suppliers and performs data analysis.
Table 1 lists the report model data pools for the analysis report payable of the table structure. Wherein the dimension information includes vendor dimension information and expiration date dimension information. The index information includes total amount payable index information. And inserting the provider dimension information, the expiration date dimension information and the total amount payable index information which are corresponding to each other into a report model data pool to obtain report model data required by subsequent processing, so as to be used for report presentation and data analysis.
TABLE 1
| Vendor identity number | Vendor coding | Vendor name | Expiration date | Total amount payable |
| 1 | 001 | Supplier 01 | 2019-12-01 | 100 |
| 2 | 002 | Supplier 02 | 2019-12-02 | 200 |
| 3 | 003 | Supplier 03 | 2019-12-03 | 300 |
After the report model data pool is constructed, the embodiment searches the analysis report corresponding to the analysis report, circulates each analysis report, and searches the display type in the analysis report. The display types are classified into a must display, a single condition display, a complex condition display, and an index display. The specific model of the analytical report is shown in Table 2. Each analysis report contains a display type, analysis content, an analysis formula, an analysis name, and a report name. In table 2, { OverdueApCount } represents overdue payoff index information, and [ ApCountWarning ] represents overdue pen parameter information.
TABLE 2
In this embodiment, the display type of the analysis report is a single condition display, so the specific manner of adding the analysis content in the analysis report to the analysis result list according to the display type in this embodiment is as follows: searching an analysis formula in the analysis report, matching, searching and replacing index information and/or parameter information in the analysis formula, calculating the analysis formula and adding analysis contents to an analysis result list according to a calculation result.
Specifically, in this embodiment, after parameter information ApCountWarning is matched with parameter information in the analysis formula by using a regular expression, a parameter value corresponding to the parameter information ApCountWarning is obtained to be 2 by looking up a parameter table, so that the analysis formula after parameter replacement is { oversdueapcount } >2. Furthermore, in this embodiment, index information in the analysis formula is matched through the regular expression, so that the index information overdueApCount is matched, and since the display type is not complex condition display, the dimension information in the analysis report does not need to be transferred, and only the index information overdueApCount needs to be transferred to the number engine to obtain the index single value. The fetch engine is divided into a stored process calculation, a data pool calculation and a data table calculation according to a prefabricated index table. The fetch engine calculates the index value as 5, and therefore the analysis formula after replacing the index parameter is 5>2.
After the analysis content in the analysis report is added to the analysis result list according to the display type, the analysis content in the analysis report also contains index information or parameter information, so that the analysis result list is circulated, each analysis content is searched for, matched, searched for and replaced with the index information and the parameter information, and then the analysis content is added to the final analysis result list.
Specifically, in this embodiment, the analysis formula after the parameter information and the index information are replaced is calculated through the memory, and the authenticity of the calculation result is determined. Wherein, since the determination result for the formula "5>2" is true, the analysis content "there is a overdue payment record: the { OverdueApCount } pen "is added to the analysis results list. And obtaining the replaced analysis content as 'overdue payment record' by matching, searching and replacing indexes and parameters in the analysis content: 5 pens).
Through the mode, the intelligent analysis and interpretation of the report data can be realized, and the required report information and analysis results are provided for the user according to the needs of the user.
In summary, the beneficial effects of the embodiment of the invention are as follows: the report processing method of the embodiment of the invention provides an intelligent analysis function, which can lead an enterprise manager to reduce the cognitive cost, maximally extract key information helpful for enterprise management and provide subsequent suggestions and executable operations. The report processing method of the embodiment of the invention can dynamically display the intelligent analysis report, and can save the management cost of the user and improve the management efficiency on the basis of giving out reasonable suggestions to the user through data processing.
It should be noted that in the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in a claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention may be implemented by means of hardware comprising several distinct elements, and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means may be embodied by one and the same item of hardware. The use of the words first, second, third, etc. do not denote any order. These words may be interpreted as names.
While preferred embodiments of the present invention have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. It is therefore intended that the following claims be interpreted as including the preferred embodiments and all such alterations and modifications as fall within the scope of the invention.
The above is only a preferred embodiment of the present invention, and is not intended to limit the present invention, but various modifications and variations can be made to the present invention by those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (10)
1. The report processing method is characterized by comprising the following steps of:
constructing a report model data pool of a table structure by adopting dimension information and index information which are mutually associated, and filling data information corresponding to the dimension information and the index information into the report model data pool;
searching a display type in an analysis report contained in a circulation report model;
adding analysis content in the analysis report to an analysis result list according to the display type;
and circulating the analysis result list, searching each analysis content, replacing index information and/or parameter information of the analysis content in the analysis report in the analysis result list through steps of matching, searching and replacing, and adding a replacement result into the analysis result list.
2. The report processing method of claim 1, wherein the display type includes: -must display, index display and condition display, said step of adding the analysis content in said analysis report to a list of analysis results according to said display type comprising in particular:
determining that the display type is necessary to display, and adding the analysis content to the analysis result list; or (b)
Judging the display type as index display, calling a fetch engine to calculate an index value, and adding the index value to the analysis result list; or (b)
Judging the display type as conditional display, searching an analysis formula in the analysis report, matching, searching and replacing index information and/or parameter information in the analysis formula, calculating the analysis formula and adding the analysis content to the analysis result list according to a calculation result.
3. The report processing method according to claim 2, wherein the step of calculating the analysis formula and adding the analysis content to the analysis result list according to the calculation result specifically comprises:
and judging that the calculation result is true, and adding the analysis content to the analysis result list.
4. The report processing method according to claim 2, wherein the steps of matching, searching and replacing the index information and/or the parameter information in the analysis formula specifically include:
matching parameter information in the analysis formula through a regular expression, searching a parameter value list to obtain a parameter value corresponding to the parameter information, and replacing the parameter information by the parameter value;
and matching index information in the analysis formula through a regular expression, searching an index value list to acquire an index value corresponding to the index information, and replacing the index information by the index value.
5. The report processing method of claim 4, wherein,
the condition display is a single condition display, and the index value is a single value index value calculated and acquired by transmitting index information to the fetch engine.
6. The report processing method of claim 4, wherein,
the display type is a complex condition display, and the index value is a list of index values calculated and acquired by transmitting index information and dimension information to an access engine.
7. A report processing system, comprising:
the modeling unit adopts dimension information and index information which are mutually associated to construct a report model data pool of a table structure, and fills data information corresponding to the dimension information and the index information into the report model data pool;
the first processing unit is used for circulating an analysis report contained in a report model, searching a display type in the analysis report and adding analysis contents in the analysis report to an analysis result list according to the display type;
and the second processing unit is used for circulating the analysis result list, searching each analysis content, replacing index information and/or parameter information of the analysis content in the analysis report in the analysis result list through steps of matching, searching and replacing, and adding a replacement result to the analysis result list.
8. The report processing system of claim 7, further comprising:
and the display unit is suitable for displaying the analysis results generated according to the analysis result list.
9. A report processing apparatus, comprising:
a memory storing a client program;
a processor executing the client program;
wherein the processor, when executing the client program, implements the steps of the report processing method of any of claims 1 to 6.
10. A computer-readable storage medium, comprising:
the computer readable storage medium stores a computer program which, when executed, implements the steps of the report processing method of any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010140257.2A CN111353288B (en) | 2020-03-03 | 2020-03-03 | Report processing method, system, device and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010140257.2A CN111353288B (en) | 2020-03-03 | 2020-03-03 | Report processing method, system, device and computer readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111353288A CN111353288A (en) | 2020-06-30 |
| CN111353288B true CN111353288B (en) | 2024-03-29 |
Family
ID=71195849
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010140257.2A Active CN111353288B (en) | 2020-03-03 | 2020-03-03 | Report processing method, system, device and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111353288B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8204809B1 (en) * | 2008-08-27 | 2012-06-19 | Accenture Global Services Limited | Finance function high performance capability assessment |
| CN103984755A (en) * | 2014-05-28 | 2014-08-13 | 中国地质大学（北京） | Multidimensional model based oil and gas resource data key system implementation method and system |
-
2020
- 2020-03-03 CN CN202010140257.2A patent/CN111353288B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8204809B1 (en) * | 2008-08-27 | 2012-06-19 | Accenture Global Services Limited | Finance function high performance capability assessment |
| CN103984755A (en) * | 2014-05-28 | 2014-08-13 | 中国地质大学（北京） | Multidimensional model based oil and gas resource data key system implementation method and system |
Non-Patent Citations (2)
| Title |
|---|
| 动环集中运维管理平台应用探析;任帅;;通信电源技术(03);全文 * |
| 建立实时KPI系统;洪波;;中国电力企业管理(14);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111353288A (en) | 2020-06-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11681694B2 (en) | Systems and methods for grouping and enriching data items accessed from one or more databases for presentation in a user interface | |
| CN102549563B (en) | Semantic trading floor | |
| US20090157630A1 (en) | Method of extracting data and recommending and generating visual displays | |
| CN111125343A (en) | Text analysis method and device suitable for human-sentry matching recommendation system | |
| US20080147601A1 (en) | Method For Searching Data Elements on the Web Using a Conceptual Metadata and Contextual Metadata Search Engine | |
| Quarati et al. | Do researchers use open research data? Exploring the relationships between usage trends and metadata quality across scientific disciplines from the Figshare case | |
| AU2014281604B2 (en) | System and method for text mining documents | |
| US20190065455A1 (en) | Intelligent form creation | |
| CN113393306A (en) | Product recommendation method and device, electronic equipment and computer readable medium | |
| CN111310032A (en) | Resource recommendation method and device, computer equipment and readable storage medium | |
| CN113836429A (en) | Book recommendation method, terminal and storage medium | |
| CN110928903A (en) | Data extraction method and device, equipment and storage medium | |
| CN109636303B (en) | Storage method and system for semi-automatically extracting and structuring document information | |
| Owda et al. | Financial discussion boards irregularities detection system (fdbs-ids) using information extraction | |
| CN110009796A (en) | Invoice category recognition methods, device, electronic equipment and readable storage medium storing program for executing | |
| CN111353288B (en) | Report processing method, system, device and computer readable storage medium | |
| US7827164B2 (en) | System for obtaining, managing and providing retrieved content and a system thereof | |
| US11328005B2 (en) | Machine learning (ML) based expansion of a data set | |
| Esteva et al. | Data mining for “big archives” analysis: A case study | |
| CN113836430A (en) | Book recommendation method, terminal and storage medium | |
| CN110765118B (en) | Data revision method, revision device and readable storage medium | |
| KR20190100533A (en) | Database module using artificial intelligence, economic data providing system and method using the same | |
| CN116225522A (en) | Method and device for generating software prototype, electronic equipment and storage medium | |
| CN114297228A (en) | ES server query method, ES server query device and computer-readable storage medium | |
| CN114168842A (en) | Recommendation method and device, electronic equipment and 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |