1
2
3
; BPR 4
5
6
7
Jonathan Wu(2002) Intelix,Inc.(2001) (Online Analytical Processing, OLAP) ( ) 8
Key Performance Index, Knowledge Management, 9
ERP SCM CRM VIEW OLAP OLAP & ERP
Data Data Warehouse DPS Data Access ERP Staging Area & Brower Data Mart(s) MES Users Stage Data DW Ex: Sales BY Subject Web FOCUS Server FIN MS DM OLAP Server HR Oracle 1.MS Office XP Reports 2.Oracle Within Lagacy Server 3.IBI Web Focus 11
12
13
14
DBMS ERP Flat Files Decision Stream ETL Data Warehouse or Data Mart Impromptu (Client, Web) ETL KPI PowerPlay (Client, Web) Visualizer (Client, Web) Upfront () GartnerGroup(2001) 1 (Business Intelligence Platforms) (Development) (Deployment) 2 (Business Intelligence Tools) (Data Mining) 3 (Enterprise Business Intelligence Suites; EBISs) (Query) (reporting) 4 (Query & Reporting Tools) 2-5 (Enterprise Resource Planning, ERP) (Customer Relationship Management, CRM) (Supply Chain Management, SCM) (ExtractTransform and Load, ETL) (Integration Brokers, IBs) (Date Web 15
Warehouse) (Data Mart) EBISs EBISs (Multidimensional OLAP) (1) EBISs (RDBMs) OracleMicrosoft IBM Oracle 9i Microsoft SQL Server IBM OEM Hyperion Essbase IBM Miner OLAP Data Mining OLAP Data Mining (2) (EBISs) (Query) (reporting) EBISs EBISs 16
(Scalability) (Usability) (Manageability) EBISs EBISs (BI Portal) Web BI Portal EBISs (Collaborative BI) (BI Portal) (Q&R Tools) (EBIS) (OLAP) (Data Warehouse) (Data Mining) (Data Mark)/ODS (BIP) (ETL) (IBs) ERP CRM SCM Legacy. 2-5 17
18
19
20
21
() 2002 4 Business ObjectsMicrosoftOracleSAS Business Objects Cognos EBISs HyperionMicrosoft Oracle 1.Business Objects Business Objects 1990 EBISs Web Intelligence Business Object OLAP Business Objects Client/server Java Applet ActiveX Web Intelligence DHTML XML 22
Info View Broadcast (BI Portals) PDA (Developer Suite) SAP R/3OraclePeople Soft RDT(Rapid Deployment Templates) Business Objects (CORBAJavaActiveXXML ) 80 1 150 500 Client/Server Web Unit Broadcast Info View Unix BI (KM) (EIP) Analytic Tools Business Objects Web Intelligence Portals & Reporting BI Platforms Business Obj. InfoView InfoView Mobil Buoadcast Agent Business Query Business Obj. Administrator Developer Suite OLAP Access Pack RDTs Business Record Package Legacy 2-6Business Objects 23
2.Cognos Cognos Business Objects EBISs Cognos ETL (Decision Stream )OLAP (Power Play) (Impromptu ) (Visualizer ) (4Thought Scenario ) (Upfront ) Cognos 120 1 8 200 Business ObjectsCognos (Business Objects ) ( 3 ) Cognos Interweave Right Information SystemsRelational MattersLEX2000 Business Objects Upfront Business Objects BI Analytic Tools Power Play Visualizer Scenario 4Thought Portals & Reporting BI Platforms Cognos Upfront Impromptu Cognos Decision Stream Transformer OLAP Access Pack MOLAP Business Record Package Legacy 2-7 Cognos 24
3.Hyperion Hyperion (BI Platform) (Development) (Deployment) (Maintenance) Hyperion Essbase (MDBMs) Application Builder J2EE Integration Server 200 Hyperion Essbase (MOLAP) Hyperion OLAP Hyperion Essbase Cognos Power Play (Third-Party) Hyperion (RDBMs) Oracle Microsoft Hyperion Analytic Tools Hyperion Analyzer Portals & Reporting BI Platforms Hyperion Analysis Portal Q&R Reports Spreadsheet Client Hyperion Essbase OLAP Server Integration Server Essbase Objects Application Builder Web Gateway Business Record Package Legacy 2-8Hyperion 25
4.Micorsoft Gartner Group Microsoft Oracle IBM Microsoft Microsoft SQL Server Analysis Services DTS PivotTable Decision Trees Clustering Cube Meta Data Services Microsoft Repository Cube Microsoft Analysis Services SQL Server Cube Meta Data Services SQL Server Analysis Services SQL Server Microsoft SQL Server OfficeIE Media Player Hyperion EssbaseOracle Express Unix OLAP Hyperion EssbaseOracle ExpressSAP BW Microsoft 26
Analytic Tools Portals & Reporting Microsoft Analysis Server Decision Tree Microsoft English Query Excel VB Function BI Platforms Analysis Services PivotTable Service Meta Data Services Business Record Package Legacy 2-9Microsoft () GartnerGroup Business Objects Congnos (2-10) MiicroStrategyActuateCrystal Brio MicroStrategy EBISs BI Platform MicroStratery 6.0 7.0 Windows Web MicroStrategy Business Objects Cognos EBISs 2001 (2-11) HyperionMicrosoftOracle SAS Hyperion 27
Oracle Microsoft Microsoft Oracle (Challengers) Oracle Infobuilders Microsoft (Leaders)Bus.Obj Cognos Actuate Microstrategy CA Crystal Brio AiphaBlox Hummingbird (Niche Players 2-10 28
(Challengers) (Leaders) Sap Microsoft Oracle SAS PeopleSoft Hyperion Crystal Microstrategy Applix Comshare CA AiphaBlox Sagent Whitelight Niche Players () Microsoft OracleSAPNCR Business Objects Brio Acential Cognos ( ) ERP ( )CRM/DW ( ) 2-12 ( Business Objects ) ( Brio 29
30 ) ( SybaseBusiness Objects ) 1 (ACT) (experforma).net 2-12 () 1. GartnerGroup ( 2-13) (EBISs) (BI Portals) ACT Microsoft SAS Sybase SAP CA NCR Oracle ERP (BO). CRM/DW/BI (Sybase) (Applix) (Info.Bulider) Reseller (BO) (Brio,Acential) (Cogons) (Info.Bulider)
ERPCRM 1~2 SAPPeopleSoftBaan CA Siebel (BI Web Services) (Collaborative BI) BI/CRM ERP/BI Slow-moving Fast-moving Alerting XML enablement Mobile and Wireless BI BI Portals Thin Client OLAP EBISs BI Platforms B2B BI Web Reporting Financial BI Application BI Web Services Data Mining Collaborative BI 2-13 2. GartnerGroup 4 ( 2-14) 31
( ) 3 Fai Crystal Brio Business Objects Sagent Cognos Actuate MicroStrategy Consolida Whitelight Hyperionl IBM Microsoft Applix SAS Oracle Expand NCR PeopleSoft Siebe CA Baan SAP Partnersh Ascential Informatica Acta Hummingbird DataMirror 3. 32
10 11 2001~2005 33
34
35
36
37
38
39
40
E Power Play Impromptu E 41
() () : ; E-BusinessBusiness Week 42
43 ( )
44
45
46
47
iptop 48
49
50
51
52
53
1.Browser-based 2. e 3. MIS 4. 5. 6. 7. (CA ) 8. e 54
55
56
57
() Failover Support) Internet 58
(Impromptu) (PowerPlay) 59
ETL (Decision Stream )OLAP (PowerPlay ) (Impromptu ) (Visualizer ) (4Thought Scenario ) (Upfront ) 60
Network Computing : 4-7 Information Brio Intelligence MicroStrategy Microsoft Series7 Builders 6.6 7i Data WebFocus4.3.6 Analyzer 20% 没 61
62
决 63
64
65
66
67
68
69
70
71
087238700-6117 E-mail hcyeh@npic.edu.tw 2. 3. 4. 5. 6. 7. 8. 9. LXXII
1. 2. 3. 4. 5. 6. e-mail LXXIII
1. 2. ( ) 1. 2. 1.? 2.? (1) 1.1 1.2 1.3 1.4 LXXIV
(2) 2.1. 2.2 2.3 (3) 3.1 3.2 (4) 4.1 4.2 4.3 4.4 LXXV
4.5 ( ) 5.? 6.? LXXVI
LXXVII