Download
roadmap from bw to bi n.
Skip this Video
Loading SlideShow in 5 Seconds..
Roadmap from BW to BI PowerPoint Presentation
Download Presentation
Roadmap from BW to BI

Roadmap from BW to BI

290 Views Download Presentation
Download Presentation

Roadmap from BW to BI

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Roadmap from BW to BI Richard Brown, SAP UKI Head of Business Intelligence SAP UK & I

  2. Roadmap from BW to BI BW Overview BI Capabilities of NetWeaver 2004s Business Advantage of NW2004s Implementation Experience

  3. Roadmap from BW to BI BW Overview BI Capabilities of NetWeaver 2004s Business Advantage of NW2004s Implementation Experience

  4. SAP BW – A success story Active BW Customers > 6,500 Approximate Data Volume Are you satisfiedwith SAP BW? How do you planto leverage SAP BW? Number of Users > 10,000 > 5 TB 1% 1% Mixed data: 64% 1,000 - 10,000 Yes 13% < 50 1 - 5 TB 0 - 100 GB 95% 24% 23% 26% 250 - 1,000 23% SAP data only: 36% 500 GB - 1 TB 50 - 250 100 - 500 GB 18% 39% 32% No 5%

  5. Key Features of a Data Warehouse • Data from across all relevant sources internal & external to the business • Separated Transactional & Analytical environments • End user report creation • Cross functional & targeted reporting • Detailed & summary data • A single version of the the truth

  6. SAP Business Warehouse (BW) Anintegratedend-to-endData Warehouse solution • Powerful Information Analysis • Innovative, intuitive user interface • Powerful OLAP analysis • Web & MS Excel based front-ends • Easy integration with Portal Information Management • ‘Best of breed’ technologies • Rich Business Content -pre-configured Information models, reports, KPI’s and extractors • Industry Specific Business Content • Configurable to specific requirements Data Extraction • Built on the SAP Entity Model • SAP and non-SAP data extraction • Powerful Data Maintenance and Administration

  7. Self-service Reporting Dashboards Targeted reports Business Warehouse (BW) Business Content SAP Business Intelligence Other 3rd Party Finance & Projects Sales Interfaces Credit Control Sales

  8. SAP BI - Reporting and Analysis For All User Types • Authors and Analysts • Need to dig into the data – explore & find trends • Business Managers • Need personalized information specific to their function • Summary – but with the ability to drill down to the detail • Executives • High level analysis (dashboards) - alert to key business issues & actions

  9. SAP AG 2004, Title of Presentation / Speaker Name / 9 Authors & Analysts

  10. Targeted Emailed Alert Driven Business Managers

  11. Executives

  12. BW release 3.5 Overview 1 Information Broadcasting 2 Universal Data Connection 3 NetWeaver Integration 4 Business Planning & Simulation (BPS) Advanced Analytic functionality 5

  13. Information Broadcasting via E-Mail In this example the Report was sent in an MHTML-Format and is now available in the personal Inbox of the Receiver.

  14. What Are The Broadcasting Channels? • SAP Enterprise Portal 6.0 SP3 • Knowledge Management Folders (“BEx Portfolio”) • Available KM Services: e.g. Indexing & Search engines (TREX), Subscription, Downloads, Rating, etc. • Portal Content Catalog (part of the Portal Content Directory) • Collaboration rooms & discussion forums • Email • BW users, BW roles or email addresses • Online queries, workbooks & web applications are sent as URLs • Pre-calculated queries, workbooks & web applications are sent as attachments or as inline mail body (MHTML)

  15. What Are Reporting Documents? • Pre-calculated, online and offline reporting documents… • BI Web Applications - Dashboards, cockpits • BEx Analyzer Workbooks • Queries • ... in different formats ... • HTML • Device specific (Web Browser, Mobile devices, etc.) • BEx Analyzer Workbooks • Excel files • Emails using Multipart Html (MHTML) • ZIP Files • ... containing different kinds of information. • OLAP data, Alerts, Embedded Documents and Filter Navigation

  16. Information Broadcasting – BEx Portfolio Queries, Workbooks, BI Applications as KM Documents • KM Document: Pre-calculated query, workbook or application • KM Link: Online BW report • Use KM Services for: • Subscription • Feedback • Discussion • Collaboration • Rating • TREX search • Notes • Download

  17. BW release 3.5 Overview 1 Information Broadcasting 2 Universal Data Connection 3 NetWeaver Integration 4 Business Planning & Simulation (BPS) Advanced Analytic functionality 5

  18. Universal Data Integration • BI Java Connectors to provide access to various data sources (via interfaces JDBC, XMLA, OLE DB for OLAP, SAP Query) • Based on industry standards for interoperability (JDBC, XMLA, ODBO) • Universal Data Connect to integrate data into BW platform • BI Java SDK for custom built Java Applications 2. Universal Data ConnectSAP BW Integration BW SAP Enterprise Portal Universal Data Connect SAP SAP Query OLAP Staging BEx XMLA non SAP BI JavaSDK Custom-built Applications JDBC ODBO 1. BI Java Connectors JDBC, XMLA,ODBO, SAP Query 3. BI Java SDK Java API, Examples, Documentation

  19. BI Java Connectors • Connectors for various data sources •  Leverages SAP WebAS 6.40 J2EE connectivity for SAP BW •  Basis for Universal Data Connect and BI Java SDK • Relational Sources • BI JDBC Connector • Industry Standard API for relational DBMS • Connectivity to 200+ JDBC drivers providing data access to: Oracle, MS SQL Server, Teradata, MS Access, DB2, Sybase, Excel, text files (CSV), etc. • See http://java.sun.com for more information • BI SAP Query Connector • Connectivity to operational SAP applications • SAP R/3, SAP CRM, Ad-hoc, operational • OLAP Sources • BI OLE DB for OLAP Connector • Industry Standard OLAP API for MS Windows platforms • Connectivity to MS Analysis Services, SAS, MS PTS, SAP BW • BI XMLA Connector • Web Service-based, platform-independent access to OLAP sources • Connectivity to MS Analysis Services, Hyperion, MicroStrategy, MIS, SAP BW 3.x • The set of connectors will be extended in further SAP BW releases

  20. SAP BW – Non SAP-DW Integration Scenario Reporting Listing Personnel Deployment v Skills profile DW Local Skills Database Non SAP-DW SAP HR Cubes BW SAP HR Data Various Sources ERP

  21. BW release 3.5 Overview 1 Information Broadcasting 2 Universal Data Connection 3 NetWeaver Integration 4 Business Planning & Simulation (BPS) Advanced Analytic functionality 5

  22. PSA PSA PSA Delta-Queue Delta-Queue BW and XI SAP BW Operational Data Store Standard Staging Realtime Data Acquisition DataSources SAP XI Near RealtimeInfoPackage Open Service http / SOAP mySAP.com(via BW Service-API) RFC realtime update

  23. BW release 3.5 Overview 1 Information Broadcasting 2 Universal Data Connection 3 NetWeaver Integration 4 Business Planning & Simulation (BPS) Advanced Analytic functionality 5

  24. Current Planning Environment mySAP Financials SEM-BPS Planning • Financial Planning Applications • Modelling • Planning Framework • Process Coordination mySAP BI SAP BW • Data Management • Analysis Planning in mySAP BI – Evolution Future Planning Environment mySAP Financials SEM-BPS Planning • Financial Planning Applications mySAP BI SAP BW • Data Management • Modelling • Planning Framework • Process Coordination • Analysis

  25. Reconciliation of operational plans with strategic targets Headcountplanning Production planning Operational Planning Sales planning Marketing planning Strategic Targets (Operating Profit + 4%, Market share+10%) Strategic Planning December August Planning cycles Strategic Planning and Target setting on group level Operational Planning and Budgetingin the business units Plan evaluation

  26. User Interaction ODS SAP BI Planning Architecture Presentation Planning Front Ends HTML in GUI Excel Inplace Excel Client ALV Grid Portal based Open Interface and Web Services Business Logic Planning Framework Modeling Manual Planning/Analysis AutomaticPlanning Process control Common Read / Write Interface DWH Layer Access / Storage Dimensional Data Master Data Granular Data Master Data Data Acquisition

  27. BW release 3.5 Overview 1 Information Broadcasting 2 Universal Data Connection 3 NetWeaver Integration 4 Business Planning & Simulation (BPS) Advanced Analytic functionality 5

  28. SAP AG 2004, Title of Presentation / Speaker Name / 28 Advanced Ad-hoc Reporting • New web template for ad-hoc analysis • Extensibility: Easy support of customer adaptations in Web App Designer • Enhanced usability and new look-and-feel • New functionality within the template tool bar

  29. Web Application Designer Chart Designer Wizard (Reduced Overview) Result

  30. A B C Data Mining Methods - Explorative Clustering ABC Classification • 20% of customers generate 60% of sales Association Analysis Weighted Score Tables Weight

  31. No No No Yes Yes Yes Data Mining Methods - Predictive Regression Decision Trees Complaints >4 <=4 Complaints ? Gender Age Gender M F Buy Sales Income Income # of Products >30 k <=30 k

  32. Analysis Process Designer • Graphical modeling (drag&drop) and execution of Analysis Processes that make use of Data Mining to gain new insights and take action – closed loop • Examples of “Analysis Processes” would be the definition of ABC classes, the calculation of frequency distributions or the determination of Scoring information.

  33. A B C Composite Scenarios: Customer Retention Clustering Decision Trees ABC Classification B At Risk A Loyal C Goal: Reduce Customer Churn Association Analysis Transfer Knowledge Cross-Selling Rules Marketing Campaign

  34. Roadmap from BW to BI BW Overview BI Capabilities of NetWeaver 2004s Business Advantage of NW2004s Implementation Experience

  35. NetWeaver 2004s 1 Analytical Applications 2 BI Accelerator 3 Enterprise Data Warehousing 4 Enhanced Web & Excel Reporting Integrated Planning 5

  36. Unifies and aligns people, information and business processes Integrates across technologies and organizational boundaries A safe choice with full .NET and J2EE interoperability The business foundation for SAP and partners Powers business-ready solutions that reduce custom integration It’s SAP Enterprise Services Architecture increases business process flexibility SAP NetWeaver PEOPLE INTEGRATION Multichannel access Portal Collaboration INFORMATION INTEGRATION Bus. Intelligence Knowledge Mgmt Master Data Management COMPOSITE APPLICATION FRAMEWORK LIFE CYCLE MANAGEMENT PROCESS INTEGRATION Integration Broker Bus. ProcessMgmt APPLICATION PLATFORM J2EE ABAP DB and OS Abstraction ... SAP NetWeaver™The total integration and application platform for lower TCO

  37. The Business Intelligence Platform Web Presentation/Portal/Mgmt Reporting Presentation Consolidation Ad Hoc Query and Reporting Modeling and Optimization Statutory Reporting Balanced Scorecard CPM Applications Budget Plan/Forecast Business Proc. Management Content Management Knowledge Management DataMart DataMart DataMart DataMart BI Infrastructure Data Warehouse Integration Broker Data Sources ERP/CRM/SCM/External Sources Architecture Source: Gartner (CPM, 2004)

  38. Powered bySAP NetWeaver Strategic Enterp. Management Information Integration People Integration Process Integration SAP delivers the complete, end-to-end, reliable and open BI Solution. The SAP NetWeaver BI Platform Web Presentation/Portal/Mgmt Reporting Consolidation Ad Hoc Query and Reporting Modeling and Optimization Statutory Reporting Balanced Scorecard Budget Plan/Forecast SAP NetWeaver Business Proc. Management Content Management Knowledge Management DataMart DataMart DataMart DataMart Data Warehouse Integration Broker ERP/CRM/SCM/External Sources

  39. NetWeaver 2004s 1 Analytical Applications 2 BI Accelerator 3 Enterprise Data Warehousing 4 Enhanced Web & Excel Reporting Integrated Planning 5

  40. Customer Sales (CRM) Fulfillment(FC) Production (SCP) Logistics (SCE) Fin.-Dptm. (FIN) Controlling (BW) 1 3 2 Creation Sales Order Fulfillment Request Request Global ATP Global ATP Check 4 Creation & Release Delivery Request 5 Delivery Execution 6 8 7 Release ASN Update Inventory Accounting Update Inventory 9 Receives ASN WHAT IS “NEW” ANALYTICS? Example: Sales Order Fulfillment process Creation Purchase Order

  41. WHAT IS “NEW” ANALYTICS? Questions & Insights lead to process improvement! “Is customer credit-worthy?” “sufficient stock of inventory?” “extra effort costs $$$?” “360° View of the Customer” “smooth shipping Process?”

  42. Visual Composer Model

  43. NetWeaver 2004s 1 Analytical Applications 2 BI Accelerator 3 Enterprise Data Warehousing 4 Enhanced Web & Excel Reporting Integrated Planning 5

  44. BI Accelerator Performance Optimization SAP NetWeaver 2004s provides various tools to increase the data load and query performance significantly – among them the innovative high performance analytics approach. Thus, the implementation of large enterprise data warehouses is facilitated. • BI Accelerator A new paradigm for high performance data access. • Query performance is boosted by orders of magnitude • Simultaneously the realignment processes roll-up and change run are improved significantly • HPA is used in connection with KM search engine TREX • Provides linear scalability and can fully leverage grid and adaptive computing capabilities

  45. Target Performance ImprovementBy Factor 10 in average,Up to Factor 1000 ! Stable Good Query Response Time – IndependentFrom Database Features, Caches, Aggregates, … Very fast Query Response Time Stable Query Response Time BI Accelerator Support of New HardwareParadigms like Grid Computing, AdaptiveComputing No Aggregate Maintenance, Unnoticeable ‘Roll-up’, No Change Run Low Maintenance High Scalability

  46. Innovation In-Memory Processing Column-Based Data Storage and Access / Vertical Table Decomposition What makes SAP BI with the BI accelerator so fast? Highly Parallel Data Access / Horizontal Partitioning Dictionary-based, Smart Compression Using Integers

  47. Introducing BI Accelerator Appliance - 1 System performance declining when increasing utilization actionable information SAP NetWeaver BI Server Business User System Performance data data IT Department data data

  48. Introducing BI Accelerator Appliance Increase scalability and flexibility, w/o impacting architecture actionable information SAP NetWeaver BI Server BIaccelerator appliance 2004s blade Business User blade blade System Performance 2004s data data IT Department data data

  49. BusinessExplorer Any Tool Preferred Technology Partner SAP NetWeaver 2004s SAP NetWeaver 2004s Preferred Hardware Partners BI Accelerator of SAP NetWeaver – Architecture SAP NetWeaver BI HPA Engine Using Adaptive Computing AnalyticEngine InfoCubes DataAcquisition Any Source