CN105373874A - ERP decision support system - Google Patents
ERP decision support system Download PDFInfo
- Publication number
- CN105373874A CN105373874A CN201510308919.1A CN201510308919A CN105373874A CN 105373874 A CN105373874 A CN 105373874A CN 201510308919 A CN201510308919 A CN 201510308919A CN 105373874 A CN105373874 A CN 105373874A
- Authority
- CN
- China
- Prior art keywords
- data
- module
- erp
- decision support
- support system
- 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.)
- Withdrawn
Links
Abstract
The invention relates to an ERP decision support system comprising a background data acquisition module, a data calculation and analysis module, a background system management module, a user account and password module, a front desk query and design data analysis and display module, and a fixed statement check module. The ERP decision support system is an auxiliary tool of an ERP system. By constructing a model base, a method base and a display support system, taking data warehouse, online analytical processing and data mining technologies as the basis, and generating dialyzable multidimensional presentation data by using data processing methods such as data extraction, cleaning, clustering, mining and predicting, operating properties or market rules that analysts want to investigate are obtained. The invention aims to provide decision support and analysis for enterprise management personnel and provide timely and accurate data information for policy makers of enterprises. The ERP decision support system has the advantages of simple operation, friendly interface, high security, flexible permission assignment and visual data analysis and summarization.
Description
Technical field
The present invention relates to decision support system (DSS), in particular, relate to a kind of ERP decision support system (DSS).
Background technology
After ERP implements, through corporate departments, the output of system-based data is safeguarded, ERP system data-base content is in detail abundant, but it is not very convenient that inquiry is got up, the mode of inquiry is excessively loaded down with trivial details too, even if cause much useful data can not be submitted to high-level leader easily, marketing decision-making can not be carried out according to SDA system data analysis very easily, our ERP data can not be fully utilized.
So we consider to utilize current system data base resource, develop a set of inquiry conveniently, kit (ERP decision support system (DSS)) simple to operate.
Summary of the invention
The object of the invention is the defect overcoming the existence of existing EPR system, realize datamation to upgrade, intellectual analysis, for enterprise management level provide in time, accurately, enterprise operation data analysis intuitively, for the decision-making development of business administration provides Data support, and a kind of new ERP decision support system (DSS) is provided, can realize information promptly and accurately, friendly interface simple to operate, Macro or mass analysis, the function such as access Internet.
The object of the invention to solve the technical problems realizes by the following technical solutions.According to a kind of ERP decision support system (DSS) that the present invention proposes, it comprises back-end data acquisition module, data computation analysis module, background system administration module, user account number crypto module, foreground queries design data analyzes display module and fixing form consults module.
The object of the invention to solve the technical problems also can be applied to the following technical measures to achieve further.
Aforesaid a kind of ERP decision support system (DSS), the main SQLSERVER of utilization of wherein said back-end data acquisition module writes trigger, every day timing acquiring data.
Aforesaid a kind of ERP decision support system (DSS), wherein said data computation analysis module mainly carries out data preparation, the basic data needed for generated query.
Aforesaid a kind of ERP decision support system (DSS), wherein said background system administration module mainly carries out module installation, the maintenance of operating personnel's account number cipher priority assignation and fixing form.
Aforesaid a kind of ERP decision support system (DSS), wherein said foreground queries design data is analyzed display module and is realized long-range inquiring stock, and analyzes the rationality of stock, to adjust inventory structures in time.
Aforesaid a kind of ERP decision support system (DSS), wherein said fixing form consults module by balance sheet monthly, cash flow statement, and the electronic version of profit and loss statement etc. uploads inquiry.
The present invention compared with prior art has obvious advantage and beneficial effect.By technique scheme, a kind of ERP of the present invention decision support system (DSS) can reach suitable technical progress and practicality, and has the extensive value in industry, and it at least has following advantages:
1, information promptly and accurately: data query is the data of the previous day, accomplishes renewal every day one.
2, friendly interface simple to operate: adopt browser/server (B/S) structure, both taken into account beautiful interface, flexible operation, and supported Internet/Intranet. again comprehensively
3, security of system: operating personnel determine authority by post, every operating personnel have oneself account number and password, operate after must first logging at every turn and can inquire about.
4, Macro or mass analysis: by the data in system, forms the form of word or figure by demand.
5, Internet is accessed: server is accessed Internet, and the place making each business personnel can go up internet all over the world can be inquired about.
Embodiment
Now the present invention will be described in detail in conjunction with specific embodiments.
A kind of ERP decision support system (DSS) of the present invention comprises back-end data acquisition module, data computation analysis module, background system administration module, user account number crypto module, foreground queries design data analyzes display module and fixing form consults module.
The function of back-end data acquisition module utilizes SQLSERVER to write trigger, and every day, timing acquiring data, comprising: personal information table, department information table, quarter bill, material code table, delivery advice of settlement master meter detail list, returning note master meter detail list, returned money list table, allowance table etc.
The function of data computation analysis module is after data acquisition every day, carries out data preparation, comprises the calculating to ledgers detailed account, the basic data needed for generated query.
The function of background system administration module carries out module installation, the maintenance (classify, upload, revise, delete) etc. of operating personnel's account number cipher priority assignation, fixing form.Wherein user class right assignment is as follows: keeper enjoys all power, comprises the arrangement to data, the maintenance of operator, uploading of set form form, to the maintenance and inquiry etc. of all data; High-level leader to the inquiry of all data, and the checking of each operator's authority, set form report query; Service department's logistics to oneself several great Qu of being responsible for inquire about; The inquiry of great Qu manager to Fu Biao great district business of controlling oneself; Business personnel to oneself the service inquiry that occurred.
User account number crypto module is mainly according to the rank (keeper, high-level leader, service department's logistics, great Qu manager, business personnel) of the post setting user of user oneself
ERP decision support system (DSS) is mainly write with ASP.NET, delphi, adopts SQLServer2000 database, and operating system adopts Windows98/NT/2000, and general frame is based on the DNA framework of Microsoft.
Foreground queries design data analyzes display module can realize long-range inquiring stock, and analyzes the rationality of stock, to adjust inventory structures in time; Can the inquiry of login page, the user management page (userspersonal information, user cipher revise), menu and each module; Can inquire about and comprise various ways, the inquiry of multiple conditioned disjunction compound condition, as can basis: the kind of date (time, month etc.), business personnel, great Qu, medicine, single medicine etc.; Can with word and figure (bar chart by analyzing, pie chart) mode inquires the form contrasting tendency more intuitively, such as: certain medicine in certain great Qu the sale tendency of a time period, certain business personnel sell achievement tendency, the sale ratio of several medicine in certain great Qu, contrast of certain medicine sales volume in several great Qu etc.
Fixing form consults module mainly by balance sheet monthly, cash flow statement, and the electronic version of profit and loss statement etc. uploads inquiry.
Realize an integrated data processing system that is intelligent, decision support efficiently, it needs based on the technology such as AI, statistics, analyze the original data of enterprise increasingly automatedly, make the reasoning of inductive, therefrom excavate potential pattern, the behavior of prediction client, help the decision maker of enterprise to adjust market strategy, reduce risks, make correct decision-making.System can not only lean on several model or method just can provide effective analysing and decision support for enterprise, therefore, system must be implemented on customized model bank and method base, this model bank and method base are that business data excavates the significant data basis with decision support, do not meet the model and method of enterprise practical situation, just can not analyze accurately and excavate.Native system is based upon just on model bank and method base and achieves an efficient decision support system (DSS) based on business intelligence.
The above, it is only preferred embodiment of the present invention, not any pro forma restriction is done to the present invention, although the present invention discloses as above with preferred embodiment, but and be not used to limit the present invention, any those skilled in the art, do not departing within the scope of technical solution of the present invention, make a little change when the technology contents of above-mentioned announcement can be utilized or be modified to the Equivalent embodiments of equivalent variations, in every case be the content not departing from technical solution of the present invention, according to technical spirit of the present invention to any simple modification made for any of the above embodiments, equivalent variations and modification, all still belong in the scope of technical solution of the present invention.
Claims (6)
1. an ERP decision support system (DSS), it is characterized in that, it comprises back-end data acquisition module, data computation analysis module, background system administration module, user account number crypto module, foreground queries design data analyzes display module and fixing form consults module.
2. a kind of ERP decision support system (DSS) according to claim 1, is characterized in that, the main SQLSERVER of utilization of wherein said back-end data acquisition module writes trigger, every day timing acquiring data.
3. a kind of ERP decision support system (DSS) according to claim 1, is characterized in that, wherein said data computation analysis module mainly carries out data preparation, the basic data needed for generated query.
4. a kind of ERP decision support system (DSS) according to claim 1, is characterized in that, wherein said background system administration module mainly carries out module installation, the maintenance of operating personnel's account number cipher priority assignation and fixing form.
5. a kind of ERP decision support system (DSS) according to claim 1, is characterized in that, wherein said foreground queries design data is analyzed display module and realized long-range inquiring stock, and analyzes the rationality of stock, to adjust inventory structures in time.
6. a kind of ERP decision support system (DSS) according to claim 1, is characterized in that, wherein said fixing form consults module by balance sheet monthly, cash flow statement, and the electronic version of profit and loss statement etc. uploads inquiry.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510308919.1A CN105373874A (en) | 2015-06-06 | 2015-06-06 | ERP decision support system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510308919.1A CN105373874A (en) | 2015-06-06 | 2015-06-06 | ERP decision support system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105373874A true CN105373874A (en) | 2016-03-02 |
Family
ID=55376053
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510308919.1A Withdrawn CN105373874A (en) | 2015-06-06 | 2015-06-06 | ERP decision support system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105373874A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108694525A (en) * | 2018-07-27 | 2018-10-23 | 平安科技（深圳）有限公司 | Information displaying method and device, computer installation and computer readable storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102467705A (en) * | 2010-11-15 | 2012-05-23 | 上海盛东国际集装箱码头有限公司 | Early warning mechanism for controlling operational risk of container terminal and method for implementing early warning mechanism |
| CN102708199A (en) * | 2012-05-18 | 2012-10-03 | 苏州佰思迈信息咨询有限公司 | Enterprise information data retrieval system |
| CN104392291A (en) * | 2014-09-05 | 2015-03-04 | 宁波和佳软件技术有限公司 | Financial service management information platform |
| CN104504543A (en) * | 2014-11-14 | 2015-04-08 | 镇江市新创计算机系统集成有限公司 | Project investment control and management system and use method thereof |
-
2015
- 2015-06-06 CN CN201510308919.1A patent/CN105373874A/en not_active Withdrawn
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102467705A (en) * | 2010-11-15 | 2012-05-23 | 上海盛东国际集装箱码头有限公司 | Early warning mechanism for controlling operational risk of container terminal and method for implementing early warning mechanism |
| CN102708199A (en) * | 2012-05-18 | 2012-10-03 | 苏州佰思迈信息咨询有限公司 | Enterprise information data retrieval system |
| CN104392291A (en) * | 2014-09-05 | 2015-03-04 | 宁波和佳软件技术有限公司 | Financial service management information platform |
| CN104504543A (en) * | 2014-11-14 | 2015-04-08 | 镇江市新创计算机系统集成有限公司 | Project investment control and management system and use method thereof |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108694525A (en) * | 2018-07-27 | 2018-10-23 | 平安科技（深圳）有限公司 | Information displaying method and device, computer installation and computer readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9418127B2 (en) | Method and system for designing business domain model, data warehouse model and mapping therebetween synchronously | |
| Babu | Business intelligence: Concepts, components, techniques and benefits | |
| US9740992B2 (en) | Data warehouse system | |
| CN110175788A (en) | A kind of smart city energy cloud platform | |
| CN104424595A (en) | Tax administration monitoring method and tax administration monitoring system thereof | |
| CN104731791A (en) | Marketing analysis data market system | |
| US20130132139A1 (en) | Method And System For Providing Business Intelligence Data | |
| CN104318414A (en) | Commodity inventory management information system | |
| CN101706926A (en) | Method for investigating and processing cigarette consumption information | |
| CN111639121A (en) | Big data platform and method for constructing customer portrait | |
| US20170270482A1 (en) | Enterprise performance management system and method | |
| CN105373874A (en) | ERP decision support system | |
| Saagari et al. | Data Warehousing, Data Mining, OLAP and OLTP Technologies Are Essential Elements to Support Decision-Making Process in Industries | |
| Cong | Research on financial risk management of E-commerce enterprises in the era of big data | |
| CN110807583A (en) | Configurable ERP role authority verification system and method based on RBAC | |
| US20150120369A1 (en) | Chemical and natural resource supply chain advanced planning and forecasting through massively parallel processing of data using a distributed computing environment | |
| Mokeeva et al. | Digitalization in remote banking service | |
| US10789653B1 (en) | Methods and systems for providing a global statement | |
| Şahinbaş et al. | Business intelligence application in the natural gas industry: A company case | |
| Xia | The design and implementation of distributed inventory management system based on the intranet architecture | |
| Zhang | Intelligent Operation of Financial Department in XX Furniture Enterprise under the Background of Digital Economy | |
| Sun et al. | The Construction and Research of Enterprise Accounting Data Analysis Platform under Big Data | |
| Li | Design and Optimized Application of Online Financial Management System Based on Internet of Things | |
| Ray et al. | Analysing the interface of business intelligence and enterprise resource planning | |
| Moçka et al. | Evaluation of Business Intelligence Maturity Level in Albania Banking Systems |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20160302 |
|
| WW01 | Invention patent application withdrawn after publication |