BI 2.0 을기반으로한 Dynamic Business Intelligence 박경도 Senior Sales Consultant 2008. 7. 8
SAP 2008 / Page 2 BI 2.0 의혁신
BI 환경의 5 가지혁신 1. 4. 2. 5. 3. SAP 2008 / Page 3
BI 2.0 핵심요소사용자 BI 1.0... on my desktop. BI 2.0. Visual. on my mobile. SAP 2008 / Page 4
BI 2.0 User-created Content D&B Thomson The Web Data Providers Search Web srvcs Unstructured Content BI 2.0 ERP, CRM, SCM Internal Data Sources Partner / Customer Data SAP 2008 / Page 5
BI 2.0 BI 1.0 On-premise only BI 2.0 On-premise AND ondemand (SOA) SAP 2008 / Page 6
BI 2.0 Instant Messaging User-created content Let us solve problems together Let us communicate Let us share data Mashups Let us develop together Let us share analytics SAP 2008 / Page 7
BI 2.0 VALUE Value: Value: SAP 2008 / Page 8
SAP 환경에서의 BI 2.0 구현 SAP 2008 / Page 9
Business Objects SAP Case 1 BW Only SAP BW Enterprise DW SAP BW SAP BW Business Intelligence Business Objects for SAP SAP BW ERP Other Data SAP BW Enterprise Data Warehouse SAP 2008 / Page 10
Business Objects SAP Case 2 SAP & Non-SAP Sources SAP BW DW Business Objects Across the Enterprise Non SAP DW Business Intelligence SAP BW ERP Other Data SAP and Non- SAP sources SAP 2008 / Page 11
Business Objects SAP Case 3 No BW BW Business Objects Across the Enterprise SAP ERP Enterprise Business Intelligence SAP BW ERP Other Data No BW SAP 2008 / Page 12
BUSINESS OBJECTS 의 SAP Data Approach Business Objects XI 3.0 SAP Solution SAP 환경을위한 2 가지접근방향 Direct Approach for SAP ERP and BW SAP Integration Kit SAP BI Data Source 1 2 Indirect (ETL) Approach for SAP Data Integrator Target Data Mart / Data Warehouse 3 SAP 2008 / Page 13
DIRECT Approach TO SAP Presentation Layer BusinessObjects InfoView SAP Enterprise Portal Other Corporate Portals BI Layer BusinessObjects Enterprise Voyager Crystal Reports Web Intelligence Xcelsius Direct Connectivity Layer BusinessObjects Direct Connectivity Layer? SAP R/3 SAP BW Universe Security 통합 Data Sources ERP ERP Data Structures BW Info Providers SAP 2008 / Page 14
Business Objects SAP Integration Kit Crystal Business Objects Reports XI Voyager Web intelligence SAP Integration Kit SAP Direct Connectivity BI Meta (UNIVERSE) Data Source OLAP/BAPI FI CO PA HR SD MM Etc. ABAP Dictionary InfoSet ABAP Query ABAP Function SAP ERP SAP BW ODS InfoSet ODS BW Query OLAP Processor Info Cube BW Repository SAP 2008 / Page 15
SAP ERP BW Reporting Direct Approach for SAP SAP ERP Data ) BW Key SAP 2008 / Page 16
SAP 2008 / Page 17 BI 사용자계층
ID Task Name Duration 3 Scope Phase 25 days 4 Project Kickoff 5 days 5 Project Management Work Stream 5 days 6 Project Initiation 5 days 7 Project Kickoff Meeting 0 days 8 Scope Defintion Document 18 days 9 Vision & Strategy Work Stream 10 days 10 Business Requirements Definition 10 days 11 Reporting Work Stream 8 days 12 Capabilities Mapping 2 days 13 Report Requirements Definition 6 days 14 Infrastructure Work Stream 10 days 15 Web Security Integration Requirements Definition 2 days 16 BOBJ Server Review 4 days 17 BOBJ Security Analysis 3 days 18 BOBJ Backup & Recovery Requirements Analysis 1 day 19 Data Work Stream 18 days 20 Source Systems Analysis 10 days 21 Data Model Requirements Definition 2 days 22 Data Mapping 3 days 23 Migration Requirements Definition 0.5 days 24 ETL Requirements Definition 0.5 days 25 DW Architecture Requirements Definition 1 day 26 Data Backup & Recovery Requirements Definition 0.5 days 27 DB Security Requirements Definition 0.5 days 28 Revised Project Plan 18 days 29 Project Management Work Stream 18 days 30 Scope Definition 13 days 31 Scheduling & Resource Planning 5 days 32 Project Plan Development 8 days 33 Risk Identification 18 days 34 Training Development Plan 2 days 35 Skills Development Work Stream 2 days 36 Training Plan Development 2 days 37 Scope Phase Review 2 days 38 Finalize All Documentation 2 days 39 Create Presentation 1 day 40 Customer Sign-Off 0 days 41 Design Phase 30 days 96 Build Phase 67 days 167 Deploy Phase 22 days 206 Evolve Phase 5 days Jan 4, '04 Jan 11, '04 Jan 18, '04 Jan 25, '04 Feb 1, '04 Feb 8, '04 Feb 15, '04 S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T Project Manager,Tech Team Lead,Subject Matter Expert,Data Architect,Technical Architect 1/9 Technical Architect,Internet Specialist,Security Administrator Technical Architect,BOBJ Administrator Subject Matter Expert,Tech Team Lead,Project Sponsor,Business User 1[50%],Business User 2[50%] Technical Architect,BOBJ Administrator Technical Architect,BOBJ Administrator Subject Matter Expert,Tech Team Lead Data Architect,Source System Expert 1,Source System Expert 2 Data Architect,Data Warehouse Architect Project Manager[50%] Tech Team Lead,Business User 1[50%],Business User 2[50%] Data Architect,Source System Expert 1,Source System Expert 2 Data Architect,BOBJ Administrator,Database Administrator Education Specialist,Project Sponsor Data Architect,CUST ETL Lead Data Architect,Data Warehouse Architect Data Architect,Database Administrator Data Architect,Database Administrator Project Manager[25%] Project Manager[25%] Project Manager[50%] Project Manager[50%],Education Specialist,Subject Matter Exper Project Manager[50%] 2/6 BI 사용자계층 Business Data Pool SAP 2008 / Page 18
ID Task Name Duration 3 Scope Phase 25 days 4 Project Kickoff 5 days 5 Project Management Work Stream 5 days 6 Project Initiation 5 days 7 Project Kickoff Meeting 0 days 8 Scope Defintion Document 18 days 9 Vision & Strategy Work Stream 10 days 10 Business Requirements Definition 10 days 11 Reporting Work Stream 8 days 12 Capabilities Mapping 2 days 13 Report Requirements Definition 6 days 14 Infrastructure Work Stream 10 days 15 Web Security Integration Requirements Definition 2 days 16 BOBJ Server Review 4 days 17 BOBJ Security Analysis 3 days 18 BOBJ Backup & Recovery Requirements Analysis 1 day 19 Data Work Stream 18 days 20 Source Systems Analysis 10 days 21 Data Model Requirements Definition 2 days 22 Data Mapping 3 days 23 Migration Requirements Definition 0.5 days 24 ETL Requirements Definition 0.5 days 25 DW Architecture Requirements Definition 1 day 26 Data Backup & Recovery Requirements Definition 0.5 days 27 DB Security Requirements Definition 0.5 days 28 Revised Project Plan 18 days 29 Project Management Work Stream 18 days 30 Scope Definition 13 days 31 Scheduling & Resource Planning 5 days 32 Project Plan Development 8 days 33 Risk Identification 18 days 34 Training Development Plan 2 days 35 Skills Development Work Stream 2 days 36 Training Plan Development 2 days 37 Scope Phase Review 2 days 38 Finalize All Documentation 2 days 39 Create Presentation 1 day 40 Customer Sign-Off 0 days 41 Design Phase 30 days 96 Build Phase 67 days 167 Deploy Phase 22 days 206 Evolve Phase 5 days Jan 4, '04 Jan 11, '04 Jan 18, '04 Jan 25, '04 Feb 1, '04 Feb 8, '04 Feb 15, '04 S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T Project Manager,Tech Team Lead,Subject Matter Expert,Data Architect,Technical Architect 1/9 Technical Architect,Internet Specialist,Security Administrator Technical Architect,BOBJ Administrator Subject Matter Expert,Tech Team Lead,Project Sponsor,Business User 1[50%],Business User 2[50%] Technical Architect,BOBJ Administrator Technical Architect,BOBJ Administrator Subject Matter Expert,Tech Team Lead Data Architect,Source System Expert 1,Source System Expert 2 Data Architect,Data Warehouse Architect Project Manager[50%] Tech Team Lead,Business User 1[50%],Business User 2[50%] Data Architect,Source System Expert 1,Source System Expert 2 Data Architect,BOBJ Administrator,Database Administrator Education Specialist,Project Sponsor Data Architect,CUST ETL Lead Data Architect,Data Warehouse Architect Data Architect,Database Administrator Data Architect,Database Administrator Project Manager[25%] Project Manager[25%] Project Manager[50%] Project Manager[50%],Education Specialist,Subject Matter Exper Project Manager[50%] 2/6 BI 사용자계층 Xcelsius, Mobile Voyager(Pioneer), Web Intelligence Crystal Report,, LiveOffice,Widget,,, Business Data Pool SAP 2008 / Page 19
BI 2.0 기반의 프리미엄 BI SAP 2008 / Page 20
Business Objects Web Intelligence 비즈니스오브젝트의 Web Intelligence 는리포팅과분석툴에서는가장앞서가는솔루션 Web Intelligence 의가치 정형 / 비정형리포트영역 최종사용자들의리포팅에쉽고직관적인터페이스제공 강력한질의및분석기능 고객요건 단순한사용자인터페이스와대규모사용을위한설계 하나의리포트에서 SAP와 non-sap 데이터를결합 풍부한기능들 SAP 연결성 비즈니스오브젝트엔터프라이즈유니버스 (Universes) 를통한연결 유니버스 (Universe) 가 OLAP BAPI를통해서 SAP NetWeaver BI에연결 접근대상 : BEx Queries 와 SAP BI InfoCubes SAP 2008 2007 / Page 21
Business Objects Web Intelligence SAP Connection Architecture Web Publish Content BO Enterprise Web Intelligence SAP ERP SAP BW Non-SAP Connection Method: Universe Generation Olap Bapis BW Object Types: BW Queries BW Cube MultiProviders SAP 2008 / Page 22
Voyager MOLAP Client Voyager Web 2.0 (Ajax) OLAP Voyager OLAP Servers (NetWeaver BI/BW, MSAS, Essbase, IBM DB2) (workspace) OLAP OLAP : % diff, % cont, variance : Prior Period, YTD, QTD, MA Filter, sort, ranking top / bottom, by value by % OLAP 데이터를분석하는비즈니스분석가와 OLAP 데이터를조회하는최종사용자들을위한 OLAP 분석툴 오픈데이터접근 (Open data Access) 하나의워크스페이스에서다수의 OLAP 소스에접근하고분석 하나의워크스페이스에서같은 OLAP 큐브에복수의뷰 (view) 제공 SAP 2008 2007 / Page 23
Business Objects Voyager SAP Connection Architecture Web Publish Content BO Enterprise Voyager SAP ERP SAP BW Non-SAP Crystal Drivers: OLAP BAPI BW Object Types: BW Queries BW InfoCube Multiproviders SAP 2008 / Page 24
엔터프라이즈리포팅의 Crystal Reports SAP 2008 2007 / Page 25
엔터프라이즈리포팅의 Crystal Reports SAP Connection Architecture Web Publish Content Crystal Reports BO Enterprise SAP ERP SAP BW Non-SAP Connection Method Crystal Drivers: InfoSet Open SQL R/3 Object Types: Transparent Tables Pool Tables Cluster Tables ABAP Queries ABAP Functions Z Tables InfoSets BAPI s Connection Method: Crystal Drivers: BW Query Infoset/Open SQL BW Object Types: InfoSet BW Query ODS Connection Method: ODBC JDBC Native SAP 2008 / Page 26
쌍방향시각화의 Xcelsius Xcelsius PDF,, (PPT). SAP 2008 2007 / Page 27
SAP 2008 2007 / Page 28 Business Objects MOBILE
MS Live Office Live Office 는마이크로소프트의파워포인트, 워드그리고엑셀에서 BI 리포트나대쉬보드를전개하고접근하는것을가능하게합니다. Live Office 의가치 Live Office 는문서, 스프레드시트, 프레젠테이션내에서 BI 데이터를통합 그결과로안전하고협력적인비즈니스결정과정에서오피스문서를다른사람들과공유 직관적인위저드 (wizard) 나툴바등을이용하여 Crystal Report 나 Web Intelligence 문서에있는데이터에쉽게연결하고선택가능 고객요건 BI를마이크로소프트오피스에통합 마이크로소프트오피스문서에접목되어있는 BI 데이터를쉽게사용하고공유 SAP 2008 2007 / Page 29
BI Widgets BI Widgets (PC ) BI. SAP 2008 2007 / Page 30
SAP 2008 / Page 31 사용자계층별 BI 프로세스
임원 / 관리자의 BI 프로세스 / Login Main Dashboard - View - Interactive View Business Xcelsius Widget BI 2.0 Tab View -KPIs View - -KPIs T Q & A Report/Analysis KPI / Alert Dashbard - What-if - Interactive SAP 2008 / Page 32
Power User 의 BI 프로세스 - KPIs View - Views Q & A Report/Analysis Power User Login Menu View MS Office -Business - Query & Analysis - Reporting Ad-Hoc Analysis & Reporting SAP 2008 / Page 33
Casual User 의 BI 프로세스 - Reports - Reports Q & A Report/Analysis Casual User Login Menu View MS Office Enterprise Reporting - Simple Querying - - Report Query Analysis & Reporting SAP 2008 / Page 34
SAP 2008 / Page 35
SAP 2008 / Page 36 Thank you!