CN113672594A - BI report system suitable for logistics supply chain business - Google Patents
BI report system suitable for logistics supply chain business Download PDFInfo
- Publication number
- CN113672594A CN113672594A CN202110975601.4A CN202110975601A CN113672594A CN 113672594 A CN113672594 A CN 113672594A CN 202110975601 A CN202110975601 A CN 202110975601A CN 113672594 A CN113672594 A CN 113672594A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- management
- definition
- authority
- 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
- 238000007726 management method Methods 0.000 claims abstract description 29
- 238000012800 visualization Methods 0.000 claims abstract description 18
- 238000004458 analytical method Methods 0.000 claims abstract description 12
- 238000013523 data management Methods 0.000 claims abstract description 11
- 238000012545 processing Methods 0.000 claims abstract description 11
- 238000004140 cleaning Methods 0.000 claims abstract description 8
- 230000008520 organization Effects 0.000 claims abstract description 4
- 238000000034 method Methods 0.000 claims description 16
- 238000005553 drilling Methods 0.000 claims description 6
- 230000000694 effects Effects 0.000 claims description 6
- 238000012360 testing method Methods 0.000 claims description 6
- 230000008859 change Effects 0.000 claims description 5
- 230000008569 process Effects 0.000 claims description 4
- 210000001503 joint Anatomy 0.000 claims description 3
- 238000012544 monitoring process Methods 0.000 abstract description 4
- 230000010354 integration Effects 0.000 abstract description 2
- 238000005259 measurement Methods 0.000 description 6
- 238000011161 development Methods 0.000 description 4
- 230000008901 benefit Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000000007 visual effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000000737 periodic effect Effects 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
Images
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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a BI report system suitable for logistics supply chain business, the BI report system includes: the system comprises a data center, data processing, data display, a data tool and authority management; the data center comprises element data management, service packet data management and a self-service data set; the data processing comprises data cleaning, data relation processing and data packet management; the data display comprises a data index template, a report template definition, a visualization attempt, an operation visualization analysis, a KPI visualization analysis and an OLAP visualization analysis; the data tool comprises a data source definition, a data item definition, a data cleaning rule definition, a chart component package, a KPI component package and an OLAP component package; the authority management comprises organization management, user management, role definition, data authority, function authority and menu function management. The BI report system of the invention integrates the existing data in enterprises, can realize the data monitoring of the integration link, and find the short board in business operation.
Description
Technical Field
The invention belongs to the technical field of logistics, and particularly relates to a BI report system suitable for logistics supply chain business.
Background
With the continuous development of enterprise scale and business and the requirement of informatization and digital transformation, in the whole management process, different report data are needed to visually know business operation and management conditions at different stages and different posts and different roles, and different report requirements are generated along with the change and development of business, so that the traditional report informatization system and technology cannot meet the requirement of rapid change of enterprises.
The existing report technology has two main types, one is to implement customization development in the system, and the other is to form a report by extracting data through a BI tool. However, the customization development is inefficient, and the realization result is not matched with the requirement of the demand side, so that the operation of the business and the timely requirement of the business cannot be supported quickly. From past project experience, the client generally has the requirement of extracting data through a BI tool to form a report; however, when the customer has such a requirement, the customer can only rely on an external product or directly develop a corresponding function in a corresponding business system, thereby affecting the performance, stability and the like of the corresponding system and simultaneously increasing the cost of the project.
The method is used for effectively integrating the existing data in the enterprise, rapidly and accurately providing the report forms and providing decision bases, and is very necessary for helping the enterprise to make business operation decisions based on the data.
Disclosure of Invention
In order to solve the problems in the prior art, the invention provides a BI report system suitable for logistics supply chain business, which can realize data monitoring of a comprehensive link and find short boards in business operation by using a BI tool through data integration. The technical problem to be solved by the invention is realized by the following technical scheme:
a BI report system adapted for logistics supply chain services, comprising: the system comprises a data center, data processing, data display, a data tool and authority management;
the data center comprises element data management, service packet data management and a self-service data set;
the data processing comprises data cleaning, data relation processing and data packet management;
the data display comprises a data index template, a report template definition, a visualization attempt, an operation visualization analysis, a KPI visualization analysis and an OLAP visualization analysis;
the data tool comprises a data source definition, a data item definition, a data cleaning rule definition, a chart component package, a KPI component package and an OLAP component package;
the authority management comprises organization management, user management, role definition, data authority, function authority and menu function management.
Further, the data management can be directly connected with the database of the customer service system, wherein various types of data are included.
Furthermore, the data set is used for outputting data according to a syntax supported by a data source, the attribute of the first field is determined, and the measurement data is either measurement data or attribute data, and the measurement data can be operated as follows: 1) the grammar can be verified, the data can be previewed directly, and the grammar can not be saved when the grammar is wrong; 2) and supporting the uploading preview function of the EXCEL file and the CSV file, and testing whether the interface file can be opened.
Further, the BI report system applicable to the logistics supply chain business is interactively connected with the information management system, the physical control system and the financial system.
A BI report generation method suitable for logistics supply chain business comprises the following steps:
the data source defines: defining a data connection mode comprising a data connection account and a connection mode;
data set: defining a data set for the project, wherein the data set comprises information such as corresponding tables, fields and the like;
and (3) associating the data sets: the association is carried out on multiple data sets, and the linkage effect is achieved in the report form display process;
data drilling: the drilling relation is configured for the report form, so that the effect of grading display is achieved;
defining a report form: defining a template, and making the template in modes of icon tools, direct dragging and the like;
and (3) permission configuration: configuring corresponding authority for the report form, and defining specific viewable users and roles;
and (4) report release: and making a finished report, and issuing the report to each role or directly providing the report to a corresponding display platform in a URL (uniform resource locator) form for butt joint display.
Furthermore, the data set is used for outputting data according to a syntax supported by a data source, the attribute of the first field is determined, and the measurement data is either measurement data or attribute data, and the measurement data can be operated as follows: 1) the grammar can be verified, the data can be previewed directly, and the grammar can not be saved when the grammar is wrong; 2) and supporting the uploading preview function of the EXCEL file and the CSV file, and testing whether the interface file can be opened.
Further, the report includes a normal report form and a cross report form.
Furthermore, the above-mentioned common report forms can only use one data set at a time, and can perform editing functions on each field, such as field color, and for digital fields, a threshold value can be set, and when a numerical value is reached, a color change function can be set, and a column can also be added as a statistic value.
Compared with the prior art, the invention has the beneficial effects that:
1. the method is suitable for the BI report system of the logistics supply chain business, integrates the existing data in the enterprise by using a BI tool, quickly and accurately provides a report and provides a decision basis, helps the enterprise to make a business operation decision based on data, can realize data monitoring of a comprehensive link, and finds a short board in business operation;
2. the BI report system has the advantages of multi-style visualization, solves the tabular single report style through the data BI, and can define various chart reports in a user-defined mode, wherein the chart reports comprise 3D warehouse bitmap display, visual large-screen display and the like;
3. the BI report system can solve the problems of large difficulty and low speed of operation of a large number of manual reports, liberates hands to derive excels from each business system, assembles and prints the reports, and can generate reports very easily through a data BI tool;
4. the BI report system can solve the problem that multiple data sources are difficult to be integrated, different service data are put together, and data can be processed and output very easily according to requirements through data association.
Drawings
FIG. 1 is a block diagram of the BI reporting system of the present invention.
FIG. 2 is a flowchart of a BI report generation method of the present invention.
Detailed Description
The present invention will be described in further detail with reference to specific examples, but the embodiments of the present invention are not limited thereto.
Example 1:
the embodiment provides a BI reporting system suitable for logistics supply chain business, which includes: the data center comprises element data management, business package data management and a self-service data set, the data processing comprises data cleaning, data relation processing and data package management, the data display comprises a data index template, report template definition, visualization attempt, operation visualization analysis, KPI visualization analysis and OLAP visualization analysis, the data tool comprises a data source definition, a data item definition, a data cleaning rule definition, a chart component package, a KPI component package and an OLAP component package, and the authority management comprises organization management, user management, role definition, data authority, function authority and menu function management. The BI report system of the embodiment can realize data monitoring of a comprehensive link and discover short boards in business operation by using a BI tool and integrating data.
Data management, which can be directly connected to the database of the customer service system, includes various types of data. First, the data source is identified, and the data generation is periodic. 1) Commonly used relational databases, Mysql, Oracle Postgresql SQL server, etc. The connection of the database can be realized only by simply placing the connection driving package under the lib directory under Tomcat. 2) And connecting a database such as hive of mongodb big data with a common non-relational database.
The data set is used for outputting data by a grammar supported on the basis of a data source, and determining whether the attribute of a first field is metric data or attribute data, wherein the metric data can be operated as follows: 1) the grammar can be verified, the data can be previewed directly, and the grammar can not be saved when the grammar is wrong; 2) and supporting the uploading preview function of the EXCEL file and the CSV file, and testing whether the interface file can be opened.
The BI reporting system applicable to the logistics supply chain business of the embodiment is interactively connected with the information management system, the physical control system and the financial system. The existing data in the enterprise are integrated, the report forms are rapidly and accurately provided, the decision basis is provided, and the enterprise is helped to make business operation decisions based on the data.
Example 2:
the embodiment provides a BI report generation method suitable for logistics supply chain business, wherein the BI report adopts the BI report system of the embodiment 1, and the generation method comprises the following steps:
the data source defines: defining a data connection mode comprising a data connection account and a connection mode;
data set: defining a data set for the project, wherein the data set comprises information such as corresponding tables, fields and the like;
and (3) associating the data sets: the association is carried out on multiple data sets, and the linkage effect is achieved in the report form display process;
data drilling: the drilling relation is configured for the report form, so that the effect of grading display is achieved;
defining a report form: defining a template, and making the template in modes of icon tools, direct dragging and the like;
and (3) permission configuration: configuring corresponding authority for the report form, and defining specific viewable users and roles;
and (4) report release: and making a finished report, and issuing the report to each role or directly providing the report to a corresponding display platform in a URL (uniform resource locator) form for butt joint display.
The data set is used for outputting data by a grammar supported on the basis of a data source, and determining whether the attribute of a first field is metric data or attribute data, wherein the metric data can be operated as follows: 1) the grammar can be verified, the data can be previewed directly, and the grammar can not be saved when the grammar is wrong; 2) and supporting the uploading preview function of the EXCEL file and the CSV file, and testing whether the interface file can be opened.
The report of the present embodiment includes a normal report form and a cross report form.
In the common report form, only one data set can be firstly used at a time, the editing function can be carried out on each field, such as field color, the threshold value and the like can be set for digital fields, the color change function can be set when the numerical value is reached, and a column can be added as a statistic value.
Cross report form: for reports that may involve an in-table statistical analysis function, cross-reporting may be used similar to the data perspective function in excel.
The BI report system generated by the BI report generation method has the advantage of multi-style visualization, and various chart reports can be customized through solving a tabular single report style through data BI, wherein the chart reports comprise 3D warehouse bitmap display, visual large-screen display and the like; the problems of large difficulty and low speed of operation of a large number of manual reports can be solved, Excel is derived from each business system by hands, the printed reports are assembled, and the reports can be generated very easily through a data BI tool; the problem that multiple data sources are difficult to collect can be solved, different service data are put together, and data can be processed and output very easily according to requirements through data association.
The foregoing is a more detailed description of the invention in connection with specific preferred embodiments and it is not intended that the invention be limited to these specific details. For those skilled in the art to which the invention pertains, several simple deductions or substitutions can be made without departing from the spirit of the invention, and all shall be considered as belonging to the protection scope of the invention.
Claims (8)
1. A BI report system suitable for logistics supply chain business is characterized in that: the method comprises the following steps: the system comprises a data center, data processing, data display, a data tool and authority management;
the data center comprises element data management, service packet data management and a self-service data set;
the data processing comprises data cleaning, data relation processing and data packet management;
the data display comprises a data index template, a report template definition, a visualization attempt, an operation visualization analysis, a KPI visualization analysis and an OLAP visualization analysis;
the data tool comprises a data source definition, a data item definition, a data cleaning rule definition, a chart component package, a KPI component package and an OLAP component package;
the authority management comprises organization management, user management, role definition, data authority, function authority and menu function management.
2. The BI report system for logistics supply chain services of claim 1, wherein the data management system is directly connected to the database of the customer service system, and comprises various types of data.
3. The BI reporting system as claimed in claim 1, wherein the data set is a syntax supported by a data source for outputting data, and the attribute of the first field is determined as metric data or attribute data, and the metric data is operable: 1) the grammar can be verified, the data can be previewed directly, and the grammar can not be saved when the grammar is wrong; 2) and supporting the uploading preview function of the EXCEL file and the CSV file, and testing whether the interface file can be opened.
4. The BI reporting system as recited in claim 1, wherein the BI reporting system is interactively connected to an information management system, a logistics management system and a financial system.
5. A BI report generation method suitable for logistics supply chain business is characterized by comprising the following steps:
the data source defines: defining a data connection mode comprising a data connection account and a connection mode;
data set: defining a data set for the project, wherein the data set comprises information such as corresponding tables, fields and the like;
and (3) associating the data sets: the association is carried out on multiple data sets, and the linkage effect is achieved in the report form display process;
data drilling: the drilling relation is configured for the report form, so that the effect of grading display is achieved;
defining a report form: defining a template, and making the template in modes of icon tools, direct dragging and the like;
and (3) permission configuration: configuring corresponding authority for the report form, and defining specific viewable users and roles;
and (4) report release: and making a finished report, and issuing the report to each role or directly providing the report to a corresponding display platform in a URL (uniform resource locator) form for butt joint display.
6. The BI report generation method for logistics supply chain business as claimed in claim 5, wherein the data set is output by syntax supported by data source, and the attribute of the first field is determined to be metric data or attribute data, and the metric data is operable: 1) the grammar can be verified, the data can be previewed directly, and the grammar can not be saved when the grammar is wrong; 2) and supporting the uploading preview function of the EXCEL file and the CSV file, and testing whether the interface file can be opened.
7. The BI report generation method for logistics supply chain services of claim 5, wherein the report includes a normal report form and a cross report form.
8. The BI report generation method for logistics supply chain services of claim 7, wherein the common report form only needs to first one dataset at a time, and can perform editing functions on each field, such as field color, for digital fields, a threshold value can be set, and when a numerical value is reached, a color change function can be set, and a column can be added as a statistic.
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2021106392355 | 2021-06-08 | ||
| CN202110639235 | 2021-06-08 |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113672594A true CN113672594A (en) | 2021-11-19 |
Family
ID=78545654
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110975601.4A Pending CN113672594A (en) | 2021-06-08 | 2021-08-24 | BI report system suitable for logistics supply chain business |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113672594A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070203935A1 (en) * | 2006-02-28 | 2007-08-30 | Business Objects, S.A. | Apparatus and method for selecting a subset of report templates based on specified criteria |
| CN103942266A (en) * | 2014-03-27 | 2014-07-23 | 上海巨数信息科技有限公司 | Data analysis method capable of achieving self-defining of complex service computational logic on basis of OLAP |
| CN110457368A (en) * | 2019-07-26 | 2019-11-15 | 广州市广百物流有限公司 | A kind of method for visualizing of supply chain, system and storage medium |
| CN110618983A (en) * | 2019-08-15 | 2019-12-27 | 复旦大学 | JSON document structure-based industrial big data multidimensional analysis and visualization method |
| CN112348448A (en) * | 2020-11-30 | 2021-02-09 | 鲁班(北京)电子商务科技有限公司 | Supply chain cooperative web system based on micro-service and big data processing |
| CN112565432A (en) * | 2020-12-07 | 2021-03-26 | 厦门锐特信息技术有限公司 | IoT system suitable for logistics supply chain service |
-
2021
- 2021-08-24 CN CN202110975601.4A patent/CN113672594A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070203935A1 (en) * | 2006-02-28 | 2007-08-30 | Business Objects, S.A. | Apparatus and method for selecting a subset of report templates based on specified criteria |
| CN103942266A (en) * | 2014-03-27 | 2014-07-23 | 上海巨数信息科技有限公司 | Data analysis method capable of achieving self-defining of complex service computational logic on basis of OLAP |
| CN110457368A (en) * | 2019-07-26 | 2019-11-15 | 广州市广百物流有限公司 | A kind of method for visualizing of supply chain, system and storage medium |
| CN110618983A (en) * | 2019-08-15 | 2019-12-27 | 复旦大学 | JSON document structure-based industrial big data multidimensional analysis and visualization method |
| CN112348448A (en) * | 2020-11-30 | 2021-02-09 | 鲁班(北京)电子商务科技有限公司 | Supply chain cooperative web system based on micro-service and big data processing |
| CN112565432A (en) * | 2020-12-07 | 2021-03-26 | 厦门锐特信息技术有限公司 | IoT system suitable for logistics supply chain service |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10853387B2 (en) | Data retrieval apparatus, program and recording medium | |
| US10459940B2 (en) | Systems and methods for interest-driven data visualization systems utilized in interest-driven business intelligence systems | |
| CN103106188B (en) | The graphical analytic system of data model and graphical analytical approach | |
| US8234240B2 (en) | Framework for providing metrics from any datasource | |
| CN104991975A (en) | Data query method and system of electric power business systems | |
| US20120173476A1 (en) | System and Method for Rule-Based Asymmetric Data Reporting | |
| US20070021992A1 (en) | Method and system for generating a business intelligence system based on individual life cycles within a business process | |
| US20080270469A1 (en) | Business metrics aggregated by custom hierarchy | |
| US20050108631A1 (en) | Method of conducting data quality analysis | |
| US20030195765A1 (en) | Data exchange method and system | |
| CN103605651A (en) | Data processing showing method based on on-line analytical processing (OLAP) multi-dimensional analysis | |
| US9824471B2 (en) | Automatic generation of hierarchy visualizations | |
| CN114462133A (en) | Digital twin technology equipment product-based carbon footprint digital accounting method and system | |
| CN101877080A (en) | Method for automatically generating configuration of bill of material (BOM) | |
| CN104463666A (en) | Audit analyzing system | |
| CN104899143A (en) | Software peer review system realizing device for providing DM (Data Mining) | |
| CN109190984B (en) | Data processing system and method based on data cube model | |
| CN108509198B (en) | Neutral BOM-based product electronic album construction method | |
| KR101829198B1 (en) | A metadata-based on-line analytical processing system for analyzing importance of reports | |
| CN110751452B (en) | Workflow management system, method and storage medium | |
| CN113672594A (en) | BI report system suitable for logistics supply chain business | |
| CN114124743B (en) | Method and system for executing full-link inspection rule of data application | |
| US7149739B1 (en) | System and method for performing ratio planning | |
| US20150363711A1 (en) | Device for rapid operational visibility and analytics automation | |
| CN115982213A (en) | BI data analysis method, system 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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20220614 Address after: 19 baohezhuang village, Changyang Town, Fangshan District, Beijing 102445 Applicant after: He Jingping Applicant after: XIAMEN SINOSERVICES INFORMATION TECHNOLOGY CO.,LTD. Address before: 361022 3f-a462, Zone C, innovation building, software park, torch high tech Zone, Xiamen, Fujian Applicant before: XIAMEN SINOSERVICES INFORMATION TECHNOLOGY CO.,LTD. |
|
| TA01 | Transfer of patent application right | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20211119 |
|
| RJ01 | Rejection of invention patent application after publication |