Intelligent data analysis and display system and method based on ERP

Abstract

The invention discloses an intelligent data analysis and display system and method based on ERP. The system comprises a receiving unit used for receiving a user data analysis request; the acquisition unit is used for acquiring corresponding data information from the advanced table and acquiring a corresponding chart generator from the storage unit according to a request limiting condition; the generation unit is used for generating each statistical dimension advanced table according to a basic database in the ERP system; the storage unit is used for storing each statistical dimension advanced table, the chart generator, the data counter and the specification designer; the recommendation unit is used for recommending matched chart types or suite tables according to request limiting conditions; and the display unit is used for calling corresponding specification designers to display the generated charts. According to the method, the ERP basic data can be easily and efficiently analyzed, multi-dimensional and multi-mode charts and suite tables needed by users are generated, planning display is carried out, data support is provided for enterprise decision making, and the data analysis and display efficiency of an ERP system is improved.

Description

Technical Field

[0001] The present invention belongs to the field of data analysis and display, and in particular relates to an ERP-based intelligent data analysis and display system and method. Background Art

[0002] In many cases, data in ERP systems are displayed in the form of numerous data tables, which is not intuitive and inconvenient for users to view and understand certain relationships in the data, such as the changes in data corresponding to each month in a year, the percentage of a certain data in the total, etc. In these cases, users often make data into graphs such as curves, bar charts, pie charts, indicator charts, etc., so as to intuitively obtain the relationship between the data. In this regard, companies generally need to develop their own data analysis and display systems that can meet their own business needs.

[0003] However, when enterprises develop data analysis and display systems independently, there are many repetitive tasks, such as setting up coding projects, which leads to cumbersome development process, high development cost and waste of company resources. Therefore, intelligent data analysis systems and methods with better interactivity have become a research direction. Summary of the invention

[0004] In order to solve the deficiencies in the prior art, the present invention provides an intelligent data analysis and display system and method based on ERP. Through the advanced tables, chart generators, data statistics and specification designers preset in the ERP system, it is only necessary to input or select the request limitation conditions, and then input or select the chart type or set of tables according to the recommendation of the recommendation unit, and select the default chart type or set of tables. The chart generator can obtain the corresponding data information from the ERP database or the advanced table, and then through the statistical calculation of the data statistics and the graphic specification design of the specification designer, the multi-dimensional, multi-mode charts and sets of tables required by the user can be easily and efficiently generated for display, thereby improving system efficiency.

[0005] In order to achieve the above object, an ERP-based intelligent data analysis and display system according to one embodiment of the present invention includes:

[0006] A receiving unit, configured to receive a data analysis request from a user; the data analysis request includes a request limiting condition;

[0007] An acquisition unit, configured to acquire corresponding data information from the advanced table according to the request limiting condition, and acquire a corresponding chart generator from the storage unit;

[0008] A storage unit for storing an advanced table, a chart generator, a data statistician and a specification designer; the chart generator can call the corresponding data statistician and the advanced table to obtain chart parameters and generate a chart according to the request limit conditions;

[0009] A recommendation unit, used to recommend a chart type or set of charts that matches a request restriction condition according to a request restriction condition;

[0010] The display unit is used to call the corresponding specification designer to display the chart generated by the chart generator.

[0011] As an optional implementation, the request limiting conditions include but are not limited to data range, data time and chart type.

[0012] As an optional implementation, the request limitation condition can be obtained by input, selection or recommendation.

[0013] As an optional implementation, it also includes a generation unit for generating advanced tables of various statistical dimensions based on the basic database in the ERP system, wherein each record in the advanced table is a result of data statistics on the basic database in the smallest statistical unit, and the result of the data statistics is recorded and added for each smallest statistical unit.

[0014] As an optional implementation, the display unit can also provide a set of watch display functions.

[0015] As an optional implementation, the specification designer is a small SQL statement program written in advance according to the purpose of graphic specifications and capable of generating corresponding specification graphics. The specification designer calculates the coordinates of the upper left, lower left, upper right and lower right points of the graphic based on the height and position fields of the graphic, loads the frame of the graphic, and then loads the data of the graphic again to form a chart.

[0016] As an optional implementation, the advancement table includes a long-term advancement table and a temporary advancement table.

[0017] The present invention also provides an ERP-based intelligent data analysis and display method, which comprises the following steps:

[0018] S1. Receive a data analysis request from a user, wherein the data analysis request includes a request limiting condition;

[0019] The request limiting conditions include but are not limited to data range, data time and chart type;

[0020] S2. According to the request limiting conditions, recommending chart types or sets of tables that match the request limiting conditions;

[0021] S3. Determine the chart type or set of charts, including determining the height and position parameters of the chart;

[0022] The determination method includes two methods: accepting recommendation or autonomous input; and whether to perform graphic overlay;

[0023] S4. According to the request limiting conditions, obtain the corresponding statistical data information from the corresponding advanced table;

[0024] S5. According to the request limiting conditions, obtain the corresponding data statistics, chart generator and specification designer from the storage unit;

[0025] S6. Calculate the coordinates of the four corner vertices of the graphic according to the height and position parameters of the graphic using the specification designer, and then load the graphic frame according to the coordinate points;

[0026] S7. Utilize the data statistics device to collect statistics on the statistics in the called advanced table;

[0027] S8. Generate a chart using a chart generator based on statistical results as variable parameters, and load and display the chart in a graphics frame; also includes loading and displaying multiple graphics that have been selected for graphic overlay in one graphics frame, and adding a legend as a control as a front-end interaction to control the display of the multiple graphics.

[0028] As an optional implementation, the step S4. according to the request limiting condition, obtains corresponding statistical data information from the corresponding advanced table, specifically:

[0029] S41, determining the statistical data range, that is, the dimension, according to the request limiting condition;

[0030] S42: Determine whether there is a corresponding long-term advanced table according to the determined dimension, and if so, call the long-term advanced table; otherwise, generate a temporary advanced table according to the dimension and call it;

[0031] S43. Obtain corresponding statistical data from the called advanced table.

[0032] As an optional implementation, the step S5. according to the request limiting condition, obtains the corresponding data statistics device, chart generator and specification designer from the storage unit, specifically:

[0033] S51. According to the request limiting conditions, determine the specific statistical items and determine the type of chart used for statistics, the specific items corresponding to the fields in the advanced table;

[0034] S52. Obtain the corresponding data statistics according to the specific project;

[0035] S53. Obtain a corresponding chart generator according to the chart type or set of tables.

[0036] The beneficial effects of the present invention are:

[0037] 1. The present invention integrates data into advanced tables in advance in the database according to the smallest unit of different dimensions (days) when the business is idle. When users need to query data, they can perform rapid data analysis and display according to multiple dimensions such as date, department, company or level, and the analysis and display efficiency of the system is greatly improved!

[0038] 2. The present invention provides a specification designer. When loading the graphic display, the user only needs to determine the height and position of each graphic. The specification designer can be called when loading each graphic data to generate a chart at the specified position. This is simple and convenient, and is conducive to intuitive control of the graphic page layout.

[0039] 3. The present invention provides a recommendation unit that can recommend one or a set of various types of charts (sets of tables) that match the request conditions. The sets of tables display data analysis of various dimensions in a combined form, thereby improving the quality of data analysis and providing more comprehensive data analysis and display results. BRIEF DESCRIPTION OF THE DRAWINGS

[0040] Figure 1 It is a structural schematic diagram of an embodiment of an ERP-based intelligent data analysis and display system of the present invention;

[0041] Figure 2 It is a flow chart of an intelligent data analysis and display method based on ERP of the present invention;

[0042] Figure 3 It is a schematic diagram of the length setting of the chart loaded by the specification designer of the system of the present invention;

[0043] Figure 4 It is a schematic diagram of the state of graphic superposition display of the system of the present invention;

[0044] Figure 5 It is a schematic diagram showing a set of watches according to an embodiment of the present invention.

[0045] In the figure:

[0046] 1-A Figure, 2-B Figure, 3-C Figure, 4-D Figure, 5-Legend, 6-Link to detailed data table. DETAILED DESCRIPTION

[0047] In order to make the purpose, technical solutions and advantages of the present invention more clear, further description is given below in conjunction with the accompanying drawings and embodiments.

[0048] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device.

[0049] As attached Figure 1 , 2 As shown, the present invention provides an intelligent data analysis and display system based on ERP, which includes:

[0050] The receiving unit 101 is used to receive a data analysis request from a user; the data analysis request includes a request limiting condition;

[0051] The acquisition unit 102 is used to acquire corresponding data information from the advanced table according to the request limiting condition, and acquire a corresponding chart generator from the storage unit;

[0052] The generating unit 103 is used to generate an advanced table of each statistical dimension according to the basic database in the ERP system, wherein each record in the advanced table is a result of data statistics on the basic database in the smallest statistical unit, and the result of the data statistics is recorded and added in each smallest statistical unit.

[0053] The storage unit 104 is used to store the advanced table, chart generator, data statistics and specification designer of each statistical dimension; the chart generator can call the corresponding data statistics and advanced table to obtain chart parameters and generate charts according to the request limit conditions;

[0054] The recommendation unit 105 is used to recommend a matching chart type or set of charts according to a certain request qualification condition;

[0055] The display unit 106 is used to call the corresponding specification designer to display the chart generated by the chart generator.

[0056] In the embodiment of the present invention:

[0057] The receiving unit 101 is used to receive a data analysis request from a user; the data analysis request includes a request limitation condition. The request limitation condition can be obtained by input or selection, and the input request limitation condition needs to be determined by the authority. If the authority is exceeded, the corresponding statistical chart cannot be viewed.

[0058] The request limiting conditions in the receiving unit 101 include data range, data time, chart type, etc.

[0059] Furthermore, taking enterprise sales data as an example, the data scope is also the dimension, which includes geographical scope, level scope and classification scope. Taking geographical scope as an example, it can be the data of all branches in a province (city or district), such as Hebei Province or Tianjin City; taking level scope as an example, it can be the data of department level, small store level, account manager level, and the district under the account manager; taking classification scope as an example, it can be the data of best-selling goods, major categories of goods, minor categories of goods, channels, customer sources, sales gross profit, fund account balance, inventory, funds receivable, and funds prepayment.

[0060] Furthermore, the data time includes year, quarter, month, week, day or custom time.

[0061] Furthermore, chart types include [whole line split text], [bar chart], [line chart], [multi-scale line bar chart], [pie chart], [ring chart], [ring progress bar], [dashboard], [funnel chart], [list chart], [table], [indicator chart + year-on-year and month-on-month], [indicator chart + area chart], [indicator chart + bar chart], [indicator chart + progress bar], [bar chart + ranking], [trend chart and table], [multi-scale line chart], [area chart], [bar chart], [indicator chart], [map], [ranking chart], [subheading], etc.

[0062] In the embodiment of the present invention:

[0063] The acquisition unit 102 is used to acquire corresponding data information, data statistics, chart generator and specification designer from the advanced table according to the request limiting conditions.

[0064] Furthermore, corresponding data information is obtained from the advanced table, including determining the statistical data range, that is, the dimension, according to the request limitation conditions; judging whether there is a corresponding long-term advanced table according to the determined dimension, and if so, calling the long-term advanced table, otherwise generating a temporary advanced table according to the dimension and calling it; and obtaining corresponding statistical data from the called advanced table.

[0065] In the embodiment of the present invention:

[0066] The generating unit 103 is used to generate an advanced table of each statistical dimension according to the basic database in the ERP system.

[0067] Furthermore, the content of each record in the advanced table is the result of data statistics on the basic database in the smallest statistical unit, and the result of data statistics is modified on a daily basis, and records are added in each smallest statistical unit.

[0068] In the present invention, the minimum statistical unit is divided into five time levels, namely, year, quarter, month, week, and day. Each dimension has an advanced table of five time levels, and statistical records are modified or added respectively.

[0069] The ERP system stores multiple basic databases generated by the system, including sales basic database, capital basic database, expense basic database, personnel basic database, etc. The advanced table is a new database generated according to various statistical dimensions based on the basic database. Each record in the advanced table is the result of data statistics on the basic database in the smallest statistical unit of the advanced table.

[0070] Taking the time level "day" as an example, statistics are performed every day according to the set statistical dimension, and a new record is added to the daily advanced table of the statistical dimension. After one year, there will be 365 statistical records in the advanced table.

[0071] Taking the time level "week" as an example, statistics are still performed every day according to the set statistical dimension, and the record is modified or a new record is added in the weekly advanced table of the statistical dimension. In detail, if the day of the statistical data is Monday, a statistical result of Monday's data is added to the weekly advanced table as the record of this week (for example, the 15th week of 2023); the next day is Tuesday, the data of Monday and Tuesday are summarized, and the record data in the advanced table is modified; the third day is Wednesday, the data of Monday, Tuesday and Wednesday are summarized, and the record data in the advanced table is modified. This statistical modification continues until Sunday, that is, in the advanced table of the week time level, there is always only one record for the 15th week of 2023, but the data is modified and refreshed every day until the data statistics are completed on Sunday. When entering the statistics of the next week, a new record (for example, the 16th week of 2023) will be added and modified. One year later, there will be 4*12=48 statistical records in the advanced table.

[0072] Similarly, taking the time level "month" as an example, there is one record per month in the month advanced table. One year later, there are 12 statistical records in the advanced table.

[0073] Taking the time level "quarter" as an example, there is one record per quarter in the quarterly advanced table. One year later, there are 4 statistical records in the advanced table.

[0074] Taking the time level "year" as an example, there is one record per year in the year advanced table. One year later, there is one statistical record in the advanced table.

[0075] Furthermore, the number of entries in each level of advanced tables is determined according to the dimension. For example, for a dimension like "department collection", a collection month advanced table based on department collection will generate a monthly collection record for each department. For example, if there are ten departments, there will be 10 data records in a month, and 10*12 statistical records in a year.

[0076] Because the ERP system allows users to make necessary modifications to the basic database data within their authority, in order to synchronize with accurate data, these advanced table statistical data of the present invention will be recalculated and updated every day. However, a modification record filing module will also be added to the ERP system to comprehensively record the user's modification record, including user name, authority, modification time, specific modification plan, etc., for traceability.

[0077] Take the outlet company with branches across the country as an example. Its basic database has an order table, which contains all the order records for each day (for example, 5,000 orders per day). For a statistical dimension that may be used: "Guangzhou Branch". In the early morning of each day, the SQL statement applet (data statistics tool) is used to summarize and calculate the order data of the previous day from the daily order table to obtain a record of the total order transaction amount of the Guangzhou branch on that day. Then, a new record is added to the previously created "Guangzhou Branch Advanced Table", and then summarized by day. After one year, there are 365 statistical records in the advanced table of the day's time level. There are 12 statistical records in the monthly advanced table, 4 statistical records in the quarterly advanced table, and only 1 statistical record in the annual advanced table. Then, when the user needs to query data, in addition to customized ones such as March 5 to April 12, data statistics and display can be quickly performed according to the Guangzhou branch based on the date range of the daily advanced table. For other existing natural time periods, such as 2022, there is an existing statistical record in the annual advanced table. It is determined that no further data statistics are required, and the data can be directly called to generate charts for display. Therefore, the speed of data analysis and display has been fundamentally improved due to the data source.

[0078] In each dimension of the system, you can define 5 advanced tables (data tables) that have been calculated in advance. For example, orders, receipts, and activities will all calculate data in advance to generate 5 new data tables.

[0079] Advanced tables are called by their table names. Taking the dimension "Order" as an example, the names of the advanced tables at its five time levels are: BIC_D_DD--Order (Day); BIC_W_DD--Order (Week); BIC_M_DD--Order (Month); BIC_Q_DD--Order (Quarter); BIC_Y_DD--Order (Year). Taking the dimension "Collection" as an example, the names of the advanced tables at its five time levels are: BIC_D_SK--Collection (Day) BIC_W_SK--Collection (Week) BIC_M_SK--Collection (Month) BIC_Q_SK--Collection (Quarter) BIC_Y_SK--Collection (Year).

[0080] Advanced tables can be divided into two types, including long-term advanced tables and temporary advanced tables. Long-term advanced tables are tables that exist for a long time after they are generated, such as data about orders and receipts, etc. Temporary advanced tables are temporarily added for some statistical purposes and will be deleted after use to save space on system memory; or for too small dimensions, such as advanced tables created for individuals during query, this table will only exist for one day, and there will be a scheduled cleanup job every day.

[0081] Before the advanced table is generated, there is also a process of integrating and disassembling data. Before the basic database statistics are generated for the advanced table, there is generally a preprocessing process for the database, that is, to organize and integrate the data according to the requirements and store it in the derivative database of the basic database. This process requires data conversion, not only including the unification of data formats, but also usually requires data integration. Sometimes several basic databases may be integrated into a derivative database, and sometimes a basic database may be split into several derivative databases. The integrated and unified database can reduce the error of the analysis results and improve the analysis efficiency. For example, the number of households in the sales deposit, including: the current number / year-on-year / month-on-month / the number of deposits not converted into contracts, can be disassembled into: by category analysis indicators, including: the current number / year-on-year / month-on-month / the number of deposits not converted into contracts; by department analysis indicators, including: the current number / year-on-year / month-on-month / the number of deposits not converted into contracts, etc. For another example, the daily order table and the collection table are integrated into a table that contains both order and collection data to obtain the total transaction amount of an order for each department in each branch on that day.

[0082] The amount of data involved in report presentation is relatively large, and often the data of an entire year is analyzed in various dimensions. Therefore, to improve efficiency, it is necessary to integrate the data in the database in advance when the business is idle in each minimum time unit, and generate new records in the advanced table. For example, the data of the previous day should be integrated in the database and advanced tables in advance at dawn every day, and then when users need to query the data, they can quickly analyze and display the data in multiple dimensions based on date, department, company or level.

[0083] After actual testing and evaluation, it takes about ten minutes to directly check the real-time data to produce statistical charts for dimensional analysis without calculating and organizing the data in advance. However, after the above-mentioned advance and planned organization and calculation using the system's idle time, the same dimensional analysis statistical chart can be analyzed and displayed within 1 to 2 seconds, greatly improving system efficiency!

[0084] In the embodiment of the present invention:

[0085] The storage unit 104 is used to store the advanced tables of each statistical dimension, the chart generator, the data statistics and the specification designer. The chart generator, the data statistics and the specification designer are small SQL statement programs written in advance according to different needs, which are used to solve the technical problem that the user needs and the computer code are too closely combined and it is inconvenient to make personalized modifications.

[0086] Furthermore, the chart generator is a SQL statement applet written in advance according to the chart type and can generate the corresponding chart; the SQL statement applet contains multiple parameter variables required by different chart types, including title, unit, data, summary number, etc., which can be replaced according to the content of the advanced table, and the color parameter variable can be determined according to the input and recommended content.

[0087] Take a SQL statement applet with a "circular progress bar" graphic as an example:

[0088]

[0089] The chart generator can call the corresponding data statistics and advanced tables to obtain chart parameters and generate charts according to the request conditions.

[0090] Furthermore, the data statistics tool is a small SQL statement program that is pre-written according to the purpose of data statistics and can generate corresponding statistical results. The data statistics tool is called through its unique ID. Take the SQL statement program of "balance receivable" as an example:

[0091] EXEC P_BIC_YS

[0092] EXEC P_DROPTABLE 'TEMP[[constant][@USERID]]_BIC_QTYS_MX'

[0093] SELECT trade unit AS NAME, receivable balance AS VALUE,'10,000' AS UNIT INTO TEMP[[constant][@USERID]]_BIC_QTYS_MX FROM[BIQXS][BIC_DJ_QTYS][BIQXE] WHERE company = '[DT1 C2][OCXVALUE]'[[constant][@BIWHERE_ZZ]]

[0094] Furthermore, the specification designer is a small SQL statement program that is written in advance according to the purpose of graphic specifications and can generate corresponding specification graphics. Graphic specifications refer to the size and layout of the graphics when they are displayed, because when displaying graphics, it is often not necessary for each graphic to occupy a page. In many cases, multiple graphics with some associations need to be displayed together in proportion to facilitate viewing of data and analysis and comparison. However, the traditional processing method requires the user to program and set each graphic that needs to be displayed in size, which is time-consuming and laborious. In order to easily achieve the above purpose, the present invention provides a specification designer, which calculates the coordinate points of each graphic (the coordinates of the four points of the upper left, lower left, upper right, and lower right) according to the height and position fields of each graphic set by the user, and then loads the frame of the graphic, and then loads the data of each graphic again, and finally forms a chart. When loading, the user only needs to determine the height and position of each graphic, and can call the corresponding specification designer when loading each graphic data to generate a chart at the specified position.

[0095] Furthermore, regarding the position, users can simply set the ratio of the chart length to the entire row. For example, if a chart occupies 1 / 2 of the entire row, the length of the chart loaded by the specification designer will occupy half of the page width. This design makes it easy for users to use the specification designer to control the layout of the page globally.

[0096] As attached Figure 3 As shown (it should be noted here that in the attached Figure 3-5 In the figure, because it involves business data information that is inconvenient for users to disclose, the values ​​of specific data in the drawings that do not affect the technical features of the present invention are revised and smeared, which is hereby explained. ),A Figure 1 With B Figure 2 The position (length) is 1 / 2 of the proportion of the entire line, C Figure 3 The position (length) accounts for 1 / 3 of the entire line, D Figure 4 The position (length) accounts for 2 / 3 of the entire row. Combined with the height set by the user, the coordinate points of each graphic (the coordinates of the four points at the upper left, lower left, upper right, and lower right) can be calculated, and then the frame of the graphic is loaded, and then the data of each graphic is loaded again, and finally a chart is formed.

[0097] Furthermore, all charts are generated and displayed in order from top to bottom and from left to right by default.

[0098] And, as attached Figure 4In the present application, the graphics can be displayed in a superimposed manner using the above technical solution. For example, a multi-scale line bar graph can be superimposed on the graph at the same time to enhance the comparative analysis effect. A legend 5 showing each of the graphics is set on the superimposed graph, and the user can control whether to display all or a few of the graphics through the interactive operation of the front end. For example, for the legend as a ping-pong key (such as the attached Figure 4 Click on the number of households completion rate (%), collection completion rate (%), total completion rate (%)), click once and the corresponding graph will be displayed, click again and the corresponding graph will disappear, click again and it will be displayed again, each legend controls its corresponding graph, such as the above multi-scale line bar chart as an example, click the line chart icon, the line chart will disappear or appear; click the bar chart icon, the bar chart will disappear or appear. There is also a link 6 for a detailed data table, click to further display the detailed data table.

[0099] In the embodiment of the present invention:

[0100] The recommendation unit 105 is used to recommend a chart type or set of charts that match the request qualification conditions according to a certain request qualification condition, and also includes the height and position parameters of the recommended chart display;

[0101] In the process of collecting data for preprocessing and putting it into the database for analysis, in addition to converting data, organizing and integrating it into a new database, and generating advanced tables, you must also choose a good analysis and display method. Because in the process of data analysis and statistics, it does not mean that you only need to use one data analysis tool. Because the amount of data is different, the data results you want to get are also different, and different requirements have different requirements for data analysis, so the types of charts suitable for data analysis are also different.

[0102] The recommendation unit 105 of the present invention can provide one or a set of various types of charts (sets of tables) that match the request qualification conditions, because for many users, the knowledge of charts is not professional and comprehensive. According to their knowledge and understanding, users can often think of a certain chart or several charts, which often have limitations and affect the statistical and analytical effects of the data. The present invention provides a chart type or a set of various types of charts (sets of tables) that match the characteristics of the request qualification conditions based on the summary of data characteristics and excellent statistical effects of a wide range of users, which can improve the quality of data analysis and provide more comprehensive data analysis and display results.

[0103] Matching chart types, for example: the matching chart type for analyzing daily collection data is a bar chart or a line chart, so that you can intuitively see the volatility of daily data; if you only need to see the total collection amount for the current month or year, an indicator chart is enough, which is clearer and more intuitive; when analyzing task completion rate, use a circular progress bar to see the progress more intuitively.

[0104] For an indicator item, a business or a stage, a set of tables can more comprehensively reflect the data status and analysis results. A set of tables can be composed of multiple charts including indicator charts, statistical charts of various dimensions, etc. Figure 5 As shown, there are 13 charts in total in the table set, including the table set title expense whole line segmentation text, expense total amount indicator chart, company expense analysis bar chart, company expense analysis details table, major department expense analysis bar chart, major department expense analysis details table, department expense analysis bar chart, department expense analysis details table, category expense analysis bar chart, category expense analysis details table, salary expense trend analysis area chart, top ten expense trend analysis (annual) bar chart, expense details table. [Whole line segmentation text] is a graphic used as the table set title, which occupies the length of the entire line and is highly customizable.

[0105] Furthermore, the system can analyze and calculate each indicator item according to the built-in default dimension or the dimension set by the user, and generate a set of charts. Then, the specification designer can perform overall planning and design for the provided set of charts, so that they can be displayed in order and according to specifications (height, length). The order can be as shown in the attached Figure 5 As shown, the order of total, sub-order, dimension order, etc. The display rules may include: for charts displayed side by side, the sum of their lengths should be the entire row, and the heights should be adapted to each other to ensure the overall regular and neat display of the set of tables.

[0106] The set of tables displays data analysis of various dimensions in a combined form, improving the quality of data analysis and providing more comprehensive data analysis and display results.

[0107] As an embodiment, the recommendation unit 105 of the present application provides a recommended option of a chart type or a set of various types of charts (set of charts) for output display, and the user selects by "checking" or the like; for a certain chart in a set of various types of charts, the user can also choose whether to display it by "checking" or the like, and can also determine by simple and convenient "input" or accept by "checking" or the like the recommended display order, height or position parameters, etc., to control and modify the size of each graphic and the presentation status of the entire set of charts.

[0108] In the embodiment of the present invention:

[0109] The display unit 106 is used to call the corresponding specification designer to display the chart generated by the chart generator.

[0110] The purpose of displaying the chart after data analysis of the display unit 106 is to visualize the data analysis results. Through the previous sorting and analysis, corresponding results that can reflect data rules or data prediction trends are formed. Then, visualizing the data results can better improve the transparency of the meaning of data information, enhance users' understanding of the meaning of data, and help users to carry out business planning and subsequent business processing more conveniently and quickly.

[0111] Furthermore, the display unit 106 calls the specification designer when loading each graphic data, first calculates the coordinate points of each graphic (the coordinates of the four points of the upper left, lower left, upper right, and lower right) according to the height and position fields set by the user in each graphic configuration, then loads the frame of the graphic, and then loads the data of each graphic again. If an area chart or a pie chart is encountered, the horizontal and vertical coordinates of the bar chart are not required, but the center of the circle, the radius, etc. are determined to generate. The core of the graphic display of the present invention is on the data, and the horizontal and vertical coordinates, graphics and tables are dynamically generated according to the data. In addition, a link 6 is also provided on the graphic that can call and display the data table of the corresponding details.

[0112] In actual use, the ERP-based intelligent data analysis and display system provided by the present invention is operated according to the following method steps:

[0113] S1. Receive a data analysis request from a user, wherein the data analysis request includes a request limiting condition;

[0114] The request limiting conditions include data range, data time, chart type, etc.

[0115] Furthermore, the data scope, that is, the dimension, includes geographical scope, level scope, and classification scope.

[0116] Furthermore, the data time includes year, quarter, month, week, day, etc. In the present invention, day is the smallest statistical unit.

[0117] Furthermore, chart types include [whole line split text], [bar chart], [line chart], [multi-scale line bar chart], [pie chart], [ring chart], [ring progress bar], [dashboard], [funnel chart], [list chart], [table], [indicator chart + year-on-year and month-on-month], [indicator chart + area chart], [indicator chart + bar chart], [indicator chart + progress bar], [bar chart + ranking], [trend chart and table], [multi-scale line chart], [area chart], [bar chart], [indicator chart], [map], [ranking chart], [subheading], [data table], etc.

[0118] Before step S1, the process also includes the steps of creating a data statistics device, a chart generator and a specification designer.

[0119] S2. According to the request limiting conditions, recommending chart types or sets of tables that match the request limiting conditions;

[0120] S3. Determine the type of chart or table set;

[0121] There are two ways to handle this: one is to accept recommendations; the other is to input independently.

[0122] Furthermore, it also includes determining the height and position parameters of the chart, which are also divided into accepting the recommendation system or autonomous input parameters; it can also determine whether to perform graphic overlay;

[0123] S4. According to the request limiting conditions, obtain corresponding statistical data information from the corresponding advanced table, specifically:

[0124] S41, determining the statistical data range, that is, the dimension, according to the request limiting condition;

[0125] S42: Determine whether there is a corresponding long-term advanced table according to the determined dimension, and if so, call the long-term advanced table; otherwise, generate a temporary advanced table according to the dimension and call it;

[0126] S43. Obtain corresponding statistical data from the called advanced table.

[0127] S5. According to the request limiting conditions, obtain the corresponding data statistics, chart generator and specification designer from the storage unit, specifically:

[0128] S51. According to the request limiting conditions, determine the specific statistical items and determine the type of chart used for statistics; the specific items correspond to the fields in the advanced table, such as the amount of receipts, the number of orders, etc.;

[0129] S52. Obtain the corresponding data statistics according to the specific project;

[0130] S53. Obtain the corresponding chart generator according to the chart type or set of tables;

[0131] S6. Calculate the coordinates of the four vertices of the graphic, i.e., the coordinates of the upper left, lower left, upper right, and lower right points, according to the height and position parameters of the graphic using the specification designer, and then load the graphic frame (the default graphic frame is a rectangle) according to the coordinate points;

[0132] S7. Utilize the data statistics device to collect statistics on the statistics in the called advanced table;

[0133] S8. Generate a chart using a chart generator based on statistical results as variable parameters, and load and display the chart in a graphics frame; further, load and display multiple graphics that have been selected for graphic overlay in a graphics frame, and add a legend as a control to control the display of the multiple graphics as a front-end interaction.

[0134] For the set of tables, the system uses

[0135] Optionally, in this embodiment, a person of ordinary skill in the art may understand that all or part of the steps in the various methods of the above embodiments may be completed by instructing hardware related to the terminal device through a program, and the program may be stored in a computer-readable storage medium, and the storage medium may include: a flash drive, a read-only memory (ROM), a random access memory (RAM), a disk or an optical disk, etc.

[0136] If the integrated units in the above embodiments are implemented in the form of software functional units and sold or used as independent products, they can be stored in the above computer-readable storage medium. Based on such understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for enabling one or more computer devices (which can be personal computers, servers or network devices, etc.) to perform all or part of the steps of the methods of various embodiments of the present invention.

[0137] In the several embodiments provided in the present application, it should be understood that the disclosed client can be implemented in other ways. Among them, the device embodiments described above are only schematic, for example, the division of units is only a logical function division, and there may be other division methods in actual implementation, for example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, and the indirect coupling or communication connection of units or units can be electrical or other forms.

[0138] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, and may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0139] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0140] Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions and variations may be made to the embodiments without departing from the principles and spirit of the present invention, and that the scope of the present invention is defined by the appended claims and their equivalents.

[0141] The present invention and its embodiments are described above, which is not restrictive. The drawings show only one embodiment of the present invention, and the actual structure is not limited thereto. In short, if ordinary technicians in the field are inspired by it and do not deviate from the purpose of the invention, they can creatively design a structure and embodiment similar to the technical solution, which should fall within the protection scope of the present invention.

Claims

1. An intelligent data analysis and display system based on ERP, characterized in that: It includes: A receiving unit, used for receiving a data analysis request from a user; The data analysis request includes request limiting conditions; An acquisition unit, configured to acquire corresponding data information from the advanced table according to the request limiting condition, and acquire a corresponding chart generator from the storage unit; A storage unit for storing advanced tables, chart generators, data statistics and specification designers; The chart generator can call the corresponding data statistics device and advanced table to obtain chart parameters and generate a chart according to the request limit conditions; A recommendation unit, used to recommend a chart type or set of charts that matches a request restriction condition according to a request restriction condition; The display unit is used to call the corresponding specification designer to display the chart generated by the chart generator.

2. The ERP-based intelligent data analysis and display system according to claim 1 is characterized in that: The request limiting conditions include but are not limited to data range, data time and chart type.

3. The ERP-based intelligent data analysis and display system according to claim 1 is characterized in that: The request limiting condition can be obtained by input, selection or recommendation.

4. The ERP-based intelligent data analysis and display system according to claim 1 is characterized in that: It also includes a generating unit for generating an advanced table of each statistical dimension according to the basic database in the ERP system, wherein each record in the advanced table is a result of data statistics on the basic database in the smallest statistical unit, and the result of the data statistics is recorded and added in each smallest statistical unit.

5. The ERP-based intelligent data analysis and display system according to claim 1 is characterized in that: The display unit can also provide a function of displaying a set of watches.

6. The ERP-based intelligent data analysis and display system according to claim 1, characterized in that: The specification designer is a small program of SQL statements written in advance according to the purpose of graphic specifications and capable of generating corresponding specification graphics. The specification designer calculates the coordinates of the upper left, lower left, upper right and lower right points of the graphic based on the height and position fields of the graphic, loads the frame of the graphic, and then loads the data of the graphic again to form a chart.

7. The ERP-based intelligent data analysis and display system according to claim 4 is characterized in that: The advancement table includes long-term advancement table and temporary advancement table.

8. An intelligent data analysis and display method based on ERP, characterized in that: It includes the following steps: S1. Receive a data analysis request from a user, wherein the data analysis request includes a request limiting condition; The request limiting conditions include but are not limited to data range, data time and chart type; S2. According to the request limiting conditions, recommending chart types or sets of tables that match the request limiting conditions; S3. Determine the chart type or set of charts, including determining the height and position parameters of the chart; The determination method includes two methods: accepting recommendation or autonomous input; and whether to perform graphic overlay; S4. According to the request limiting conditions, obtain the corresponding statistical data information from the corresponding advanced table; S5. According to the request limiting conditions, obtain the corresponding data statistics, chart generator and specification designer from the storage unit; S6. Calculate the coordinates of the four corner vertices of the graphic according to the height and position parameters of the graphic using the specification designer, and then load the graphic frame according to the coordinate points; S7. Utilize the data statistics device to collect statistics on the statistics in the called advanced table; S8. Generate a chart using a chart generator according to the statistical results as variable parameters, and load and display the chart in a graphics frame; It also includes loading and displaying multiple graphics that have been selected for graphic overlay in a graphic frame, and adding a legend as a control to control the display mode of the multiple graphics as a front-end interaction.

9. The ERP-based intelligent data analysis and display method according to claim 8, characterized in that: The step S4. according to the request limiting condition, obtains corresponding statistical data information from the corresponding advanced table, specifically: S41, determining the statistical data range, that is, the dimension, according to the request limiting condition; S42: Determine whether there is a corresponding long-term advanced table according to the determined dimension, and if so, call the long-term advanced table; otherwise, generate a temporary advanced table according to the dimension and call it; S43. Obtain corresponding statistical data from the called advanced table.

10. The ERP-based intelligent data analysis and display method according to claim 9, characterized in that: The step S5. according to the request limiting conditions, obtains the corresponding data statistics device, chart generator and specification designer from the storage unit, specifically: S51. According to the request limiting conditions, determine the specific statistical items and determine the type of chart used for statistics, the specific items corresponding to the fields in the advanced table; S52. Obtain the corresponding data statistics according to the specific project; S53. Obtain a corresponding chart generator according to the chart type or set of tables.

Images