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

BW Overview

194 Vues Download Presentation
Télécharger la présentation

BW Overview

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

  1. Roadmap from BW to BI BW Overview BI Capabilities of NetWeaver 2004s Business Advantage of NW2004s Implementation Experience www.solitairesoft.com

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

  3. 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% www.solitairesoft.com

  4. 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 www.solitairesoft.com

  5. 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 www.solitairesoft.com

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

  7. 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 www.solitairesoft.com

  8. SAP AG 2004, Title of Presentation / Speaker Name / 8 Authors & Analysts www.solitairesoft.com

  9. Targeted Emailed Alert Driven Business Managers www.solitairesoft.com

  10. Executives www.solitairesoft.com

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

  12. 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. www.solitairesoft.com

  13. 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) www.solitairesoft.com

  14. 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 www.solitairesoft.com

  15. 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 www.solitairesoft.com

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

  17. 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 www.solitairesoft.com

  18. 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 www.solitairesoft.com

  19. 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 www.solitairesoft.com

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

  21. 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 www.solitairesoft.com

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

  23. 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 www.solitairesoft.com

  24. 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 www.solitairesoft.com

  25. 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 www.solitairesoft.com

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

  27. SAP AG 2004, Title of Presentation / Speaker Name / 27 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 www.solitairesoft.com

  28. Web Application Designer Chart Designer Wizard (Reduced Overview) Result www.solitairesoft.com

  29. Interesting, right? This is just a sneak preview of the full presentation. We hope you like it! To see the rest of it, just click here to view it in full on PowerShow.com. Then, if you’d like, you can also log in to PowerShow.com to download the entire presentation for free.