Realization And Application Of Data Warehouse Dimension Modeling For Economic Benefit Module Of Guangdong Tobacco Decision Support System

With the development of Internet technology, business intelligence also has a good development, the new expand market method has spread to every industries in a short time, especially in the tobacco industry. In the process of use business intelligence trading, business data is stored in the system database. The business data can be used to record transactions fact With the accumulation of time and the increase of data the information behind the data is more valuable. Through the analysis of these data, the user’s consumption trend and the sales of goods can be present very good, the build of a data warehouse can achieve this purpose. Through the analysis of massive historical data, we can find out useful information in the business data.With the decision-making problem of GuangDong ZhongYan industrial company, this paper using data warehouse modeling theory process the business data, designs and implementation the dimensions data model which the leader’s concerned. This paper can help the leader to make decision by show the multi-dimensional data. The author completed work in the following issues:First, analyzed the whole process of enterprise development strategy through the board decision-makers demand and analysis the decision-makers concerned business subject, determine the dimensions, facts, granularity of each analysis themes.Secondly, research on dimensional modeling technology in detail and according the step of the four dimensional modeling methods:determine the business subject by analysis business, define the business processing granularity, selected the dimension of each fact table, confirm each fact table rows number type and design the related model.Thirdly, using IBM Cognos BI tool make physical view, business view, dimension view, show view to implement the model.Finally, the model is successfully applied in the decision-making process. This model can carry on the slice of business data by topic, cut into parts, ground up on application of rotary drill, drill, and OLAP operations, make relevant fixed business reports, automatic text briefing to assist to make decisions.