摘 要
OLAP技術是數據報表系統的進一步發展，是商業智能數據分析的核心技術，是企業決策支持的最佳選擇。它提供復雜計算、趨勢分析和多維建模能力，為用戶顯示直觀、易理解的圖形化數據分析，顯示企業當前的綜合信息形勢，以便企業管理者及時作出正確科學的決策，從而在激烈的競爭中勝出。
本設計的主要內容是對數據分析商業智能解決方案所需技術和方法進行初步的探討和實現。論文以微軟SQL Server 2005 Business Intelligence技術為背景，通過選取和比較相關技術，探討最適當用于實現數據分析商業智能解決方案的方法。同時，針對多維數據倉庫的構建標準和方式，對其應用實現進行詳細的分析；通過比較加深對OLAP商業智能系統優點的認識和理解。最后，設計對二維“學生信息”的多維分析和處理系統進行初步實現，使此學生基本信息的多維分析和處理系統具備多維數據分析和處理的特征，包括商業智能，統一維度模型和數據的提取、轉換和加載等。根據具體實現中所展現的數據分析OLAP商業智能強大功能和優勢，相信OLAP技術將在未來得到廣泛的應用和發展。
關鍵字：OLAP，數據倉庫，BI，多維數據庫，ETL
Two-dimensional “Students’ Information” Multidimensional Analysis and Processing
Abstract
The olap technology is the further development of data reports analysis, it's the core technology of business intelligence data analysis, and the best choice of enterprise decision support. It's apply complex calculate, trend analyze and multi-dimension modeling capability, supply users vertical, easy understanding graphical data analysis, show the current institution of enterprise, let the enterprise manager make correct society decision in time, and then win in the modern fierce competition.
The main content of the present design is to discuss and realize the techniques and methods requested by the data analysis business intelligence solution. On the background of the technique of Microsoft SQL server 2005 business intelligence, this paper discusses the best way of carrying out the data analysis Business Intelligence solution, by selecting and comparing with the relevant techniques. At the same time, aiming at the standards and methods of building multi-dimensional data dataware, and then performs detailed analysis on how to implement the application, by further recognizing and understanding the merits of olap business intelligence. At last, the present design implements two-dimensional “students’ information” multi-dimensional analysis and processing system, which enables reservation system to realize lots of characteristics of multi-dimensional analysis and processing , including business intelligence, uniform dimensional model , and data extracting , cleaning, transporting, loading and etc. According to the powerful function and advantages of olap Business Intelligence shown in the process of implementation, we believe that the techniques of olap will be widely used and develop rapidly in the near future.
Key words:OLAP ,Dataware ,BusinessIntelligence ,Multi-dimentional Database ,ETL
目 錄
1． 緒論 1
1.1 項目背景 1
1.2 國內外研究情況 1
1.3 相關概念和理論背景 3
2． 系統分析與實現的關鍵技術 5
2.1 商業智能 5
2.1.1 商業智能概念 5
2.1.2 微軟商業智能體系結構 6
2.1.3 微軟分析服務開發工具下的商業智能 6
2.2統一維度模型 8
2.3 數據提取、轉換和加載 9
3． 二維“學生信息”的多維分析和處理實現 12
3.1 系統開發工具的探討 12
3.2 系統開發環境及配置 13
3.2.1 系統硬件要求 13
3.2.2 系統軟件要求 13
3.2.3 SQL Server 2005 13
3.2.4 AdventureWorks示例數據庫與示例教程 13
3.2.5 SQL Server 2005 Reporting Service報表服務器配置 14
3.3 項目管理工具：Mindjet Manager Tool 14
3.4微軟OLAP系統解決方案 14
3.4.1 OLAP系統設計 14
3.5 創建“學生信息”OLAP解決方案 15
3.5.1 系統設計文檔 16
3.5.2 Cube多維數據集和維度設計 16
3.5.3 生成關系架構 17
3.5.4 ETL數據提取、轉換和加載 18
3.5.5 多維模型分析和處理 19
3.5.6 前端數據展現 21
3.6 測試 23
3.6.1 驗證數據源導入是否合理正確 23
3.6.2 驗證多維分析和處理是否科學 23
結 論 24
致 謝 25
參考文獻 26
