C H A P T E R 3 SQL Server 2005 SQL Server 2000SQL Server SQL Server 20052005
3.1 SQL Server 2005 Analysis Services 3.1.1 Unified Dimension Model (UDM) 3 ( Ad-Hoc) SQL Server 2005 E - R T-SQL(Star Schema) (Data Mart) (ETL) ( OracleERP SQL)SQLOracle Data Provider (Visualization) (Domain Know-how) 44
Data Source Data Model Tool OLAP Browser(1) SQL Server 2005 Unified Dimension Model (UDM)UDM OLAP versus Reporting 3.1 SQL Server 2005 (OLAP)(Measure Group)- E-RSQL Server 2005 SQL Server 2005 OLAP Browser(2) Reporting Tool(3) Reporting Tool(2) Reporting Tool(1) 3.1 SQL Server 2005 Analysis Services SQL Server 2005(Data Source View) OLE DB Provider(SQL Oracle) SQL Server 2005 Data Mining Office 2007 45
3 OLE DB ProviderXML/A (XML for AnalysisSQL Server 2005Web Services ) OLE DB Provider XML/A (Analysis Services for AnalysisSQL Server 2005 Web Services) Web ServicesSQL Server 2000(Pivot Table ServicesPTS) SQL Server 2005 SQL Server 2005 Friendly Name SQL Server 2005 (ROLAP)0% SQL Server 2005 UDM 46
Data Source Tool Analysis Services OLAP Browser(1) OLAP Browser(2) Reporting Tool(2) Reporting Tool(1) BI Applications 3.2SQL Server 2005 3.1.2 Analysis Services OLAP DTSDTS Visual Studio 2003SQL Server 2005 ( )Business Intelligence Development Studio 3.1 SQL Server 2005 Analysis Services Business Intelligence Development StudioVisual Studio 2005 BI Development Studio3.3 SQL Server Analysis Services SQL Server 2005 Data Mining Office 2007 47
3 SQL Server 2005 3.3 Visual Studio.Net ( ) Analysis Services XMLUDM 48
3.4 3.1 SQL Server 2005 Analysis Services 3.5 SQL Server 2005 Data Mining Office 2007 49
3 SQL Server 2005 Analysis ServicesOLE DB ODBCJDBC SQL Server 2005IBM DB2OLE DB Provider for DB2 ( DataMiningWindows3.6) 3.7 SQL Server 2005 3.6 50
3.1 3.7 UDM SQL Server 2005 Analysis Services SQL Server 2005 Data Mining Office 2007 51
3 SQL Server 2005 3.8 3.1.2 Analysis Services 2000 ETL Analysis Services 2005(Data Source View) OLE DB 52
Analysis Services 3.9 3.1 SQL Server 2005 Analysis Services SQL Server 2005 Data Mining Office 2007 53
3 SQL Server 2005 3.10 54
3.1 3.11 ()E-R SQL Server 2005 Analysis Services SQL Server 2005 Data Mining Office 2007 55
3 SQL Server 2005 3.12 // (SQL Oracle)3.13 56
3.1 3.13 (Foreign Key) (Primary Key) SQL Server 2005 Analysis Services SQL Server 2005 Data Mining Office 2007 57
3 SQL Server 2005 3.14 Schema FriendlyName 58
3.1 3.15 (One Version Truth) SQL Server 2005 Analysis Services ( N a m e Calculation) ( ) SQL Server 2005 Data Mining Office 2007 59
3 SQL Server 2005 3.16 3.17 60
3.1 SQL Server 2005 Analysis Services 3.17 3.1.3 SQL Server 2005 Data Mining Office 2007 61
3 3.18 SQL Server 2005 3.19 62
(Attribute) 3.20 3.1 SQL Server 2005 Analysis Services 3.20 3.21 SQL Server 2005 Data Mining Office 2007 63
3 3.21 SQL Server 2005 3.22 64
Excel 3.1 3.23 SQL Server 2005 Analysis Services SQL Server 2005 Data Mining Office 2007 65