Through building a data warehouse which is used to support manufacturing inventory analysis, according to the analysis theme, this paper extracted, purified and integrated the historical data which is accumulated by the enterprise in a long term and distributed in the various heterogeneous systems, and store them in the data warehouse fact table; through the establishment of the data cube, it generate the aggregated data with different particle size, as well as provide on-line analytical processing technology (OLAP), to provide users data query analysis with multi-angle, multi-granularity, visualization, which can solve many problems difficult to solve in the inventory analysis in traditional enterprise information processing systems.
