Design Tobacco Decision Support System Data Warehouse Dimensional Model Implementation And Application Of Guangdong

In recent years, data warehouse decision support system is becoming more popular, it can help decision makers to find information of commercial value from the vast amounts of business data for efficient decision-making, to enhance the competitiveness of enterprises in the industry as a whole. With the continuing reform of the tobacco system, in this increasingly competitive tobacco industry, the Guangdong Tobacco aware of how to use information technology, data warehouse technology and decision analysis techniques convert the massive enterprise business data into useful decision-making data,it is a Guangdong Tobacco powerful magic weapon competition with other Tobacco enterprise. Tobacco Guangdong traditional decision-making process is based on the company’s office, marketing department, comprehensive planning department, ministry of production management, financial management division extracted from their department’s business systems data related business, then aggregated to the office of the board of directors, office of the board of directors based on the five sectors of business data, manually generate monthly board briefing, the management of the board according to the board of directors briefing develop enterprise development strategy, this process of manual decision-making consumes a lot of manpower and material resources and the efficiency is too slow.This paper according to the Guangdong Tobacco in decision-making process problems, combine data warehouse dimensional modeling techniques with Guangdong Tobacco industry "One project","MES production control system, to building decision-makers are concerned about business subjects dimensional model. To assist the decision-making layer for efficient decision making by multiple data display mode.The main work of this paper are as follows:①Through investigation and research and detailed analysis of the board of directors in decision making and the whole process of enterprise development strategy, and with the use case diagram analysis the attention of decision-making layer business subject,each subject analysis of dimensions,fact,particle size is determined,ready for the follow-up design.②The dimensional modeling technology is studied and according to the four steps of dimensional modeling method:Business analysis to determine the business subject, defined business processing granularity, Selected for each fact table dimension, determine the form of each fact table row numeric facts design of industrial production and marketing analysis model, analysis model of commercial sales, brand development model.③se IBM BI tool Cognos making physical view, business view, dimensional view, presentation view and publish to generate models.④uccessful applied model to decision-making data show the business data by subject, slicing, dicing, drill-up, drill-down, rotation OLAP application operation.The final application results show that dimensional model built efficient decision support system for decision-making data show, for decision-makers provide real-time operating dynamic and development trend of the industry and the company, provide information support for management decision-making activities, provide real-time business intelligence analysis for decision-making layer, auxiliary macro-control, improve the decision-making management level, enhance the comprehensive competitiveness of the enterprises.