CN113822028A - Report for realizing aggregation of multiple discrete indexes and report configuration method - Google Patents
Report for realizing aggregation of multiple discrete indexes and report configuration method Download PDFInfo
- Publication number
- CN113822028A CN113822028A CN202111141819.6A CN202111141819A CN113822028A CN 113822028 A CN113822028 A CN 113822028A CN 202111141819 A CN202111141819 A CN 202111141819A CN 113822028 A CN113822028 A CN 113822028A
- Authority
- CN
- China
- Prior art keywords
- report
- model
- module
- management
- configuration
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0637—Strategic management or analysis, e.g. setting a goal or target of an organisation; Planning actions based on goals; Analysis or evaluation of effectiveness of goals
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
Abstract
The invention belongs to the technical field of big data statistical analysis of an industrial internet management platform, and particularly discloses a report form for realizing aggregation of a plurality of discrete indexes and a report form configuration method, which comprises the following steps: s1, creating a report configuration interface on the industrial intelligent management platform, wherein the report configuration interface is associated with the index management type on the industrial intelligent management platform; s2, configuring the function module of the report configuration interface according to the requirement; and S3, after the configuration is completed, the industrial intelligent management platform reads the data in the index management type according to the configured function module, and aggregates the data according to the configuration of the function module to generate a required aggregated report, wherein the aggregated report can be downloaded. The method can solve the problems that the existing report can not meet the requirement of single-dimensional data display and comparison across index types, and if the Excel is adopted to summarize report data, the workload is large, and errors are easy to occur.
Description
Technical Field
The invention belongs to the technical field of big data statistical analysis of an industrial internet management platform, and particularly relates to a report form for realizing aggregation of a plurality of discrete indexes and a report form configuration method.
Background
The industrial internet management platform is an industrial intelligent management platform for providing cloud services for enterprises, and at present, the industrial internet management platform basically supports equipment management, production management, material management and the like for the enterprises. Specific index management types can be divided under each large management module according to actual services, for example, equipment management items include equipment maintenance indexes, equipment point inspection indexes, equipment startup and shutdown indexes, equipment loss indexes and the like. The specific index management is functional modules which respectively and independently run, so that a data report formed in the management process is separately counted according to the index management type, the data is scattered, the data report under each index is formed by accumulative counting in a new adding mode, and the data amount of the report is inevitably large along with the accumulation of the service time.
The report has large data volume and non-visual information volume, and can not carry out single-dimensional data display and comparison across index types, for example, enterprise managers want to use equipment as a single dimension, and display the maintenance duration/frequency, the shutdown duration/frequency and the point inspection duration/frequency of the equipment through one table across indexes; or the enterprise manager wants to see the maintenance duration/times, response duration and rework times of the employee. The existing method is to download related reports, search, screen, summarize and the like in excel, and has large workload and easy error.
Disclosure of Invention
The invention aims to provide a report for realizing aggregation of a plurality of discrete indexes and a report configuration method, which are used for solving the problems that the existing report cannot meet the requirement of single-dimensional data display and comparison across index types, and if the report data is summarized by adopting Excel, the workload is large and errors are easy to occur.
In order to achieve the purpose, the technical scheme of the invention is as follows: a report configuration method for realizing aggregation of a plurality of discrete indexes comprises the following steps:
s1, creating a report configuration interface on the industrial intelligent management platform, wherein the report configuration interface is associated with the index management type on the industrial intelligent management platform; the report configuration interface comprises the following functional modules needing configuration: the system comprises a product module, a report model module, a calculation mode module, a report name module, a statistical dimension module, a header display field module and a query condition module, wherein the product module belongs to the report model module;
s2, configuring the function module of the report configuration interface according to the requirement;
and S3, after the configuration is completed, the industrial intelligent management platform reads the data in the index management type according to the configured function module, and aggregates the data according to the configuration of the function module to generate a required aggregated report, wherein the aggregated report can be downloaded.
Furthermore, the product modules comprise equipment management, production management, quality management and material management.
Further, the report model module is associated with the corresponding affiliated product module, and the report model module included in the equipment management comprises a fault maintenance model, a fault rate model, a spare part model, a point inspection model, a switching machine model, a machining model, an equipment state model, a flow recording model, a loss model, a six-source reporting model, an MTTR model and an MTBF model; the report model module included in the production management comprises a flow recording model and a production management model; the report model module included in the quality management comprises a flow recording model and a quality inspection model; the report model module included in the material management comprises a flow recording model, an in-out storage model and a coping model; the model in the report model module can be selected more; the statistical dimension module comprises a statistical dimension common to the selected report model modules, and the selected report model modules comprise at least one same statistical dimension; the statistical dimension is a statistical field of each report in the index management type, a statistical field in a selected report model module is selected from the header display field module, and the header display field module comprises a general field and respective specific fields in the selected report model module; the query condition module is used for editing specific conditions of query and filtering the report.
Further, the calculation modes include daily, weekly, monthly, yearly, quarterly, semi-annually, and yearly.
The technical scheme of the invention also provides a report for realizing the aggregation of a plurality of discrete indexes, and the report is generated according to the report configuration method for realizing the aggregation of the plurality of discrete indexes.
The beneficial effects of this technical scheme lie in: according to the technical scheme, the report configuration interface is established on the industrial intelligent management platform, the related functional modules are configured, a user can obtain visual reports only by filling the related functional modules according to requirements, the user can directly analyze the reports, and compared with the prior art, the method and the system for managing the reports have the advantages that the data of a plurality of reports need to be merged, screened, summarized and the like.
Drawings
Fig. 1 is a flowchart of a report configuration method for implementing aggregation of multiple discrete indicators according to the present invention.
Detailed Description
The following is further detailed by way of specific embodiments:
the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Example one
Substantially as shown in figure 1: a report configuration method for realizing aggregation of a plurality of discrete indexes comprises the following steps:
s1, creating a report configuration interface on the industrial intelligent management platform, wherein the report configuration interface is associated with the index management type on the industrial intelligent management platform; the report configuration interface comprises the following functional modules needing configuration: the system comprises a product module, a report model module, a calculation mode module, a report name module, a statistical dimension module, a header display field module and a query condition module, wherein the product module belongs to the report model module; the product module comprises equipment management, production management, quality management and material management; the report model module is associated with the corresponding product module, and the report model module contained in the equipment management comprises a fault maintenance model, a fault rate model, a spare part model, a point inspection model, a switching machine model, a processing model, an equipment state model, a flow recording model, a loss model, a six-source reporting model, an MTTR model and an MTBF model; the report model module included in the production management comprises a flow recording model and a production management model; the report model module included in the quality management comprises a flow recording model and a quality inspection model; the report model module included in the material management comprises a flow recording model, an in-out storage model and a coping model; the model in the report model module can be selected more; the statistical dimension module comprises a statistical dimension common to the selected report model modules, and the selected report model modules comprise at least one same statistical dimension; the statistical dimension is a statistical field of each report in the index management type, and a statistical field in the selected report model module is selected from the table head display field module; the report head display field module comprises a general field and respective specific fields in the selected report model module; the query condition module is used for editing specific query conditions and filtering the report; the calculation modes comprise daily calculation, weekly calculation, monthly calculation, annual calculation, quarterly calculation, semiannual calculation and annual calculation;
s2, configuring the function module of the report configuration interface according to the requirement;
and S3, after the configuration is completed, the industrial intelligent management platform reads the data in the index management type according to the configured function module, and aggregates the data according to the configuration of the function module to generate a required aggregated report, wherein the aggregated report can be downloaded.
The following is illustrated by way of example:
(1) the product module selects equipment management, the report model module automatically imports a report model related to the equipment management, a maintenance model and a maintenance model are selected, the calculation mode selects calculation according to the day, the report name is set as an equipment aggregation report, and the common statistical dimensions of the maintenance model and the maintenance model comprise an object, personnel, an organization and a date. Counting dimension selection objects, and selecting names, numbers and organizations by using general fields; selecting the maintenance times for a specific field in the maintenance model, and selecting the maintenance times for a specific field in the maintenance model; the header of the report is thus confirmed and finally the query condition, for example the device name a, is entered, and the final form is presented as follows:
| serial number | Name (R) | Numbering | Organization name | Number of times of maintenance | Number of times of maintenance |
| 1 | Device A | 001 | Production department | 4 | 2 |
| 2 | Device A | 002 | Production department | 2 | 5 |
| 3 | Device A | 003 | Item department | 5 | 1 |
| 4 | Device A | 004 | Item department | 1 | 4 |
| … | … | … | … | … | … |
Counting dimension selecting personnel, general field selecting personnel name, organization name, specific field selecting maintenance times in the maintenance model, and specific field selecting maintenance times in the maintenance model; the header of the report is thus confirmed and finally the query conditions are entered, for example the names of the people, say zhang san, lie si, wang wu, thanks six, and the final table is presented as follows:
| serial number | Name of person | Organization name | Number of times of maintenance | Number of times of maintenance |
| 1 | Zhang San | Production department | 15 | 30 |
| 2 | Li Si | Production department | 20 | 18 |
| 3 | Wang Wu | Item department | 10 | 25 |
| 4 | Xie Liu | Item department | 13 | 10 |
| … | … | … | … | … |
Counting dimension selection organization mechanisms, selecting organization mechanism names by using a general field, selecting maintenance times by using a specific field in a maintenance model, and selecting maintenance times by using a specific field in the maintenance model; the header of the report is thus confirmed and finally the query terms, e.g., the name of the organization, production department, project department, development department … are entered, and the final form is presented as follows:
counting dimension selection dates, general field selection dates, specific field selection maintenance times in the maintenance model, and specific field selection maintenance times in the maintenance model; the header of the report is thus confirmed, and finally the query conditions are entered, for example, the date interval is "2021.7.15-2021.07.31", and the final table is presented as follows:
| serial number | Date | Number of times of maintenance | Number of times of maintenance |
| 1 | 2021.7.15 | 1 | 0 |
| 2 | 2021.7.16 | 2 | 1 |
| 3 | 2021.7.17 | 0 | 2 |
| … | … | … | … |
(2) The product module selects equipment management, the report model module automatically imports a report model related to the equipment management, a maintenance model and a maintenance model are selected, the monthly calculation is selected as a calculation mode, and the report name is set as an equipment aggregation report; the statistical dimension selection object, the general field selection name, the specific field selection maintenance times and duration (seconds) in the maintenance model, and finally the query conditions, such as equipment a, equipment B, equipment C, and equipment D …, are input, and the final table is presented as follows:
example two
A report for realizing aggregation of a plurality of discrete indexes is generated according to a report configuration method for realizing aggregation of a plurality of discrete indexes in the first embodiment. The report can be directly used for data analysis, and the data is in the same report, so that a client can more visually find indexes of various data sources such as maintenance times, maintenance times and the like of a certain device at a glance, for example, if the client wants to analyze the linear relation between the maintenance time and the maintenance times, the data inquired by the scheme can be directly analyzed algebraically; the aggregated data can better reflect the multidimensional property of the data, for example, whether the maintenance force is proper or not, whether the maintenance degree is proper or not, the service life of the equipment and the like can be obtained by analyzing the maintenance times and the maintenance duration of the equipment, and the subjective activity, the maintenance level, the employment degree and the like of personnel can be obtained by analyzing the response duration and the maintenance duration of the dimensionality of the personnel; the maintenance times and the maintenance duration of the organization and the MTTR and MTBF are analyzed to determine whether the production management is reasonable and the defects exist.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus.
The foregoing is merely an example of the present invention, and common general knowledge in the field of known specific structures and characteristics is not described herein in any greater extent than that known in the art at the filing date or prior to the priority date of the application, so that those skilled in the art can now appreciate that all of the above-described techniques in this field and have the ability to apply routine experimentation before this date can be combined with one or more of the present teachings to complete and implement the present invention, and that certain typical known structures or known methods do not pose any impediments to the implementation of the present invention by those skilled in the art. It should be noted that, for those skilled in the art, without departing from the structure of the present invention, several changes and modifications can be made, which should also be regarded as the protection scope of the present invention, and these will not affect the effect of the implementation of the present invention and the practicability of the patent. The scope of the claims of the present application shall be determined by the contents of the claims, and the description of the embodiments and the like in the specification shall be used to explain the contents of the claims.
Claims (5)
1. A report configuration method for realizing aggregation of a plurality of discrete indexes is characterized in that: the method comprises the following steps:
s1, creating a report configuration interface on the industrial intelligent management platform, wherein the report configuration interface is associated with the index management type on the industrial intelligent management platform; the report configuration interface comprises the following functional modules needing configuration: the system comprises a product module, a report model module, a calculation mode module, a report name module, a statistical dimension module, a header display field module and a query condition module, wherein the product module belongs to the report model module;
s2, configuring the function module of the report configuration interface according to the requirement;
and S3, after the configuration is completed, the industrial intelligent management platform reads the data in the index management type according to the configured function module, and aggregates the data according to the configuration of the function module to generate a required aggregated report, wherein the aggregated report can be downloaded.
2. The report configuration method for realizing aggregation of a plurality of discrete indexes according to claim 1, wherein: the product modules comprise equipment management, production management, quality management and material management.
3. The report configuration method for realizing aggregation of a plurality of discrete indexes according to claim 2, wherein: the report model module is associated with the corresponding product module, and the report model module contained in the equipment management comprises a fault maintenance model, a fault rate model, a spare part model, a point inspection model, a switching machine model, a processing model, an equipment state model, a flow recording model, a loss model, a six-source reporting model, an MTTR model and an MTBF model; the report model module included in the production management comprises a flow recording model and a production management model; the report model module included in the quality management comprises a flow recording model and a quality inspection model; the report model module included in the material management comprises a flow recording model, an in-out storage model and a coping model; the model in the report model module can be selected more; the statistical dimension module comprises a statistical dimension common to the selected report model modules, and the selected report model modules comprise at least one same statistical dimension; the statistical dimension is a statistical field of each report in the index management type, a statistical field in a selected report model module is selected from the header display field module, and the header display field module comprises a general field and respective specific fields in the selected report model module; the query condition module is used for editing specific conditions of query and filtering the report.
4. The report configuration method for realizing aggregation of a plurality of discrete indexes according to claim 3, wherein: the calculation modes include daily, weekly, monthly, yearly, quarterly, semi-annually, and yearly.
5. A report for realizing aggregation of a plurality of discrete indexes is characterized in that: the report generated by the report configuration method for realizing the aggregation of the plurality of discrete indexes according to any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111141819.6A CN113822028A (en) | 2021-09-28 | 2021-09-28 | Report for realizing aggregation of multiple discrete indexes and report configuration method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111141819.6A CN113822028A (en) | 2021-09-28 | 2021-09-28 | Report for realizing aggregation of multiple discrete indexes and report configuration method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113822028A true CN113822028A (en) | 2021-12-21 |
Family
ID=78921523
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111141819.6A Pending CN113822028A (en) | 2021-09-28 | 2021-09-28 | Report for realizing aggregation of multiple discrete indexes and report configuration method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113822028A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114416832A (en) * | 2022-01-26 | 2022-04-29 | 重庆允丰科技有限公司 | Method for configuring formula field and report and computer storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104636393A (en) * | 2013-11-13 | 2015-05-20 | 航天信息股份有限公司 | Self-adaptation report form establishing method based on user self-definition behavior analysis |
| CN109933771A (en) * | 2019-03-22 | 2019-06-25 | 广州市玄武无线科技股份有限公司 | A kind of automatic merging method of report, device, equipment and storage medium |
| CN112183379A (en) * | 2020-09-29 | 2021-01-05 | 国网天津市电力公司 | Report-oriented multi-dimensional management analysis method and system |
| CN112861494A (en) * | 2021-02-05 | 2021-05-28 | 青岛海信网络科技股份有限公司 | Road network data-based visual report generation method, equipment and storage medium |
| CN113342821A (en) * | 2021-06-29 | 2021-09-03 | 深圳前海微众银行股份有限公司 | Report configuration method, device, equipment and computer storage medium |
-
2021
- 2021-09-28 CN CN202111141819.6A patent/CN113822028A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104636393A (en) * | 2013-11-13 | 2015-05-20 | 航天信息股份有限公司 | Self-adaptation report form establishing method based on user self-definition behavior analysis |
| CN109933771A (en) * | 2019-03-22 | 2019-06-25 | 广州市玄武无线科技股份有限公司 | A kind of automatic merging method of report, device, equipment and storage medium |
| CN112183379A (en) * | 2020-09-29 | 2021-01-05 | 国网天津市电力公司 | Report-oriented multi-dimensional management analysis method and system |
| CN112861494A (en) * | 2021-02-05 | 2021-05-28 | 青岛海信网络科技股份有限公司 | Road network data-based visual report generation method, equipment and storage medium |
| CN113342821A (en) * | 2021-06-29 | 2021-09-03 | 深圳前海微众银行股份有限公司 | Report configuration method, device, equipment and computer storage medium |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114416832A (en) * | 2022-01-26 | 2022-04-29 | 重庆允丰科技有限公司 | Method for configuring formula field and report and computer storage medium |
| CN114416832B (en) * | 2022-01-26 | 2022-11-15 | 重庆允丰科技有限公司 | Method for configuring formula field and report and computer storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US5970476A (en) | Method and apparatus for industrial data acquisition and product costing | |
| JP6707564B2 (en) | Data quality analysis | |
| US8335730B2 (en) | Scorecard reporting system | |
| US7904319B1 (en) | Computer-implemented systems and methods for warranty analysis | |
| US8332772B2 (en) | Providing structured visualizations of expressions in an expressions editor | |
| Sacu et al. | BIDM-The Business Intelligence Development Model. | |
| US11966870B2 (en) | System and method for determination of recommendations and alerts in an analytics environment | |
| US20070192157A1 (en) | Interactive system for managing, tracking and reporting work and staff performance in a business environment | |
| US7937415B2 (en) | Apparatus and method for stripping business intelligence documents of references to unused data objects | |
| CN113822028A (en) | Report for realizing aggregation of multiple discrete indexes and report configuration method | |
| US20070239587A1 (en) | System and Method For Dynamically Utilizing and Managing Financial, Operational, and Compliance Data | |
| US20140279333A1 (en) | Contract automation apparatus, method, and computer program product | |
| JP2014116016A (en) | Business management system with predefined alert | |
| Lucas Jr | An empirical study of a framework for information systems | |
| Prokhorov et al. | Development of a master data consolidation system model (on the example of the banking sector) | |
| CN103473305A (en) | Method and system for performing decision-making process show in statistic analysis | |
| US7912809B2 (en) | Data management system for manufacturing enterprise and related methods | |
| US20130290065A1 (en) | Method and System to Analyze Processes | |
| CN109582742A (en) | A kind of self-service query system based on on-line analytical processing | |
| Haley et al. | The benefits of data warehousing at Whirlpool | |
| Rodríguez et al. | Analyzing compliance of service-based business processes for root-cause analysis and prediction | |
| WO2001046866A2 (en) | Data restructurer for flattening hierarchies | |
| Ferreira | Telco Voice Traffic: Database Construction and Visualization | |
| Ray et al. | Analysing the interface of business intelligence and enterprise resource planning | |
| Ćorić et al. | Business Process Management in Insurance Case of Jadransko Insurance Company |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20230615 Address after: Room 1-1-18, Unit 1, Building 4, No. 1580 Zhiyun Avenue, Yudong Street, Banan District, Chongqing, 401320 Applicant after: Chongqing Yunfeng Technology Co.,Ltd. Address before: 408300 building a, 59 Chaoyang Road, Dianjiang Industrial Park, Chongqing Applicant before: Chongqing Yuncheng Internet Technology Co.,Ltd. |
|
| TA01 | Transfer of patent application right |