Скачать презентацию Roadmap from BW to BI Richard Brown SAP Скачать презентацию Roadmap from BW to BI Richard Brown SAP

9bc64341005e10066a9218bdcc58da1a.ppt

  • Количество слайдов: 84

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

Roadmap from BW to BI BW Overview BI Capabilities of Net. Weaver 2004 s Roadmap from BW to BI BW Overview BI Capabilities of Net. Weaver 2004 s Business Advantage of NW 2004 s Implementation Experience

Roadmap from BW to BI BW Overview BI Capabilities of Net. Weaver 2004 s Roadmap from BW to BI BW Overview BI Capabilities of Net. Weaver 2004 s Business Advantage of NW 2004 s Implementation Experience

SAP BW – A success story Active BW Customers How do you plan to SAP BW – A success story Active BW Customers How do you plan to leverage SAP BW? Mixed data: 64% Number of Users > 10, 000 1% 1, 000 - 10, 000 13% < 50 24% > 6, 500 Approximate Data Volume Are you satisfied with SAP BW? > 5 TB 1% 1 - 5 TB 23% 0 - 100 GB 26% Yes 95% 250 - 1, 000 23% SAP data only: 36% ã SAP AG 2002, Title of Presentation, Speaker Name 4 50 - 250 39% 500 GB - 1 TB 100 - 500 GB 18% 32% No 5%

Key Features of a Data Warehouse Data from across all relevant sources internal & 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 truth ã SAP AG 2002, Title of Presentation, Speaker Name 5

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

SAP Business Intelligence Self-service Reporting Dashboards Targeted reports Business Warehouse (BW) Business Content Credit SAP Business Intelligence Self-service Reporting Dashboards Targeted reports Business Warehouse (BW) Business Content Credit Control ã Sales SAP AG 2002, Title of Presentation, Speaker Name 7 Finance & Projects Sales Interfaces 3 rd Party Other

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

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

Business Managers Targeted Alert Driven ã SAP AG 2002, Title of Presentation, Speaker Name Business Managers Targeted Alert Driven ã SAP AG 2002, Title of Presentation, Speaker Name 10 Emailed

Executives ã SAP AG 2002, Title of Presentation, Speaker Name 11 Executives ã SAP AG 2002, Title of Presentation, Speaker Name 11

BW release 3. 5 Overview 1 2 3 4 5 ã Information Broadcasting Universal BW release 3. 5 Overview 1 2 3 4 5 ã Information Broadcasting Universal Data Connection Net. Weaver Integration Business Planning & Simulation (BPS) Advanced Analytic functionality SAP AG 2002, Title of Presentation, Speaker Name 12

Information Broadcasting via E-Mail In this example the Report was sent in an MHTML-Format 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. ã SAP AG 2002, Title of Presentation, Speaker Name 13

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

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

Information Broadcasting – BEx Portfolio Queries, Workbooks, BI Applications as KM Documents n KM Information Broadcasting – BEx Portfolio Queries, Workbooks, BI Applications as KM Documents n KM Document: Pre-calculated query, workbook or application n KM Link: Online BW report n Use KM Services for: u Subscription u Feedback u Discussion u Collaboration u Rating u TREX search u Notes u Download ã SAP AG 2002, Title of Presentation, Speaker Name 16

BW release 3. 5 Overview 1 2 3 4 5 ã Information Broadcasting Universal BW release 3. 5 Overview 1 2 3 4 5 ã Information Broadcasting Universal Data Connection Net. Weaver Integration Business Planning & Simulation (BPS) Advanced Analytic functionality SAP AG 2002, Title of Presentation, Speaker Name 17

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

BI Java Connectors for various data sources Leverages SAP Web. AS 6. 40 J BI Java Connectors for various data sources Leverages SAP Web. AS 6. 40 J 2 EE connectivity for SAP BW Basis for Universal Data Connect and BI Java SDK n Relational Sources u BI JDBC Connector l Industry Standard API for relational DBMS l Connectivity to 200+ JDBC drivers providing data access to: Oracle, MS SQL Server, Teradata, MS Access, DB 2, Sybase, Excel, text files (CSV), etc. l See http: //java. sun. com for more information u BI SAP Query Connector l Connectivity to operational SAP applications l SAP R/3, SAP CRM, Ad-hoc, operational n OLAP Sources u BI OLE DB for OLAP Connector l Industry Standard OLAP API for MS Windows platforms l Connectivity to MS Analysis Services, SAS, MS PTS, SAP BW u BI XMLA Connector l Web Service-based, platform-independent access to OLAP sources l Connectivity to MS Analysis Services, Hyperion, Micro. Strategy, MIS, SAP BW 3. x n The set of connectors will be extended in further SAP BW releases ã SAP AG 2002, Title of Presentation, Speaker Name 19

SAP BW – Non SAP-DW Integration Scenario Reporting Listing Personnel Deployment v Skills profile SAP BW – Non SAP-DW Integration Scenario Reporting Listing Personnel Deployment v Skills profile DW SAP HR Cubes BW SAP HR Data ERP ã SAP AG 2002, Title of Presentation, Speaker Name 20 Local Skills Database Non SAP-DW Various Sources

BW release 3. 5 Overview 1 2 3 4 5 ã Information Broadcasting Universal BW release 3. 5 Overview 1 2 3 4 5 ã Information Broadcasting Universal Data Connection Net. Weaver Integration Business Planning & Simulation (BPS) Advanced Analytic functionality SAP AG 2002, Title of Presentation, Speaker Name 21

BW and XI SAP BW Operational Data Store Standard Staging Realtime Data Acquisition Data. BW and XI SAP BW Operational Data Store Standard Staging Realtime Data Acquisition Data. Sources PSA PSA Near Realtime Info. Package SAP XI Delta-Queue Open Service http / SOAP my. SAP. com RFC (via BW Service-API) Delta-Queue ã SAP AG 2002, Title of Presentation, Speaker Name 22 realtime update

BW release 3. 5 Overview 1 2 3 4 5 ã Information Broadcasting Universal BW release 3. 5 Overview 1 2 3 4 5 ã Information Broadcasting Universal Data Connection Net. Weaver Integration Business Planning & Simulation (BPS) Advanced Analytic functionality SAP AG 2002, Title of Presentation, Speaker Name 23

Planning in my. SAP BI – Evolution Current Planning Environment my. SAP Financials SEM-BPS Planning in my. SAP BI – Evolution Current Planning Environment my. SAP Financials SEM-BPS Planning Future Planning Environment my. SAP Financials SEM-BPS Planning n n Financial Planning Applications n Modelling n Planning Framework n Process Coordination Financial Planning Applications my. SAP BI SAP BW n n ã Data Management Analysis SAP AG 2002, Title of Presentation, Speaker Name 24 Data Management Modelling n Planning Framework n Process Coordination n Analysis

Planning cycles Strategic Planning and Target setting on group level Operational Planning and Budgeting Planning cycles Strategic Planning and Target setting on group level Operational Planning and Budgeting in the business units Plan evaluation Reconciliation of operational plans with strategic targets Headcountplanning Production planning Operational Planning Sales planning Strategic Targets (Operating Profit + 4%, Market share+10%) August ã SAP AG 2002, Title of Presentation, Speaker Name 25 Marketing planning Strategic Planning December

SAP BI Planning Architecture User Interaction Presentation Planning Front Ends Portal based HTML in SAP BI Planning Architecture User Interaction Presentation Planning Front Ends Portal based HTML in GUI Excel Inplace Excel Client ALV Grid Open Interface and Web Services Business Logic Modeling Planning Framework Manual Planning/ Analysis Automatic Planning Process control Common Read / Write Interface DWH Layer Access / Storage Master Data Dimensional Data Acquisition ã SAP AG 2002, Title of Presentation, Speaker Name 26 Granular Data

BW release 3. 5 Overview 1 2 3 4 5 ã Information Broadcasting Universal BW release 3. 5 Overview 1 2 3 4 5 ã Information Broadcasting Universal Data Connection Net. Weaver Integration Business Planning & Simulation (BPS) Advanced Analytic functionality SAP AG 2002, Title of Presentation, Speaker Name 27

Advanced Ad-hoc Reporting ã • New web template for ad-hoc analysis • Extensibility: Easy 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 SAP AG 2004, Title of Presentation / Speaker Name / 28

Web Application Designer Chart Designer Wizard (Reduced Overview) Result ã SAP AG 2002, Title Web Application Designer Chart Designer Wizard (Reduced Overview) Result ã SAP AG 2002, Title of Presentation, Speaker Name 29

Data Mining Methods - Explorative Clustering ABC Classification A B n 20% of customers Data Mining Methods - Explorative Clustering ABC Classification A B n 20% of customers generate 60% of sales C Association Analysis Weighted Score Tables Weight Income Score … … … … … SAP AG 2002, Title of Presentation, Speaker Name 30 Age … ã Customer Gender

Data Mining Methods - Predictive Regression Decision Trees Complaints Age Gender Buy Sales Income Data Mining Methods - Predictive Regression Decision Trees Complaints Age Gender Buy Sales Income # of Products ? No No SAP AG 2002, Title of Presentation, Speaker Name 31 Gender M F Yes Income <=30 k No ã >4 <=4 Complaints Yes >30 k Yes

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

Composite Scenarios: Customer Retention Decision Trees ABC Classification A B Clustering C B At Composite Scenarios: Customer Retention Decision Trees ABC Classification A B Clustering C B At Risk A Loyal C Goal: Reduce Customer Churn Association Analysis Transfer Knowledge Cross-Selling Rules Marketing Campaign ã SAP AG 2002, Title of Presentation, Speaker Name 33

Roadmap from BW to BI BW Overview BI Capabilities of Net. Weaver 2004 s Roadmap from BW to BI BW Overview BI Capabilities of Net. Weaver 2004 s Business Advantage of NW 2004 s Implementation Experience

Net. Weaver 2004 s 1 2 3 4 5 ã Analytical Applications BI Accelerator Net. Weaver 2004 s 1 2 3 4 5 ã Analytical Applications BI Accelerator Enterprise Data Warehousing Enhanced Web & Excel Reporting Integrated Planning SAP AG 2002, Title of Presentation, Speaker Name 35

SAP Net. Weaver™ The total integration and application platform for lower TCO Unifies and SAP Net. Weaver™ The total integration and application platform for lower TCO Unifies and aligns people, information and business processes SAP Net. Weaver PEOPLE INTEGRATION Portal Collaboration INFORMATION INTEGRATION Bus. Intelligence Knowledge Mgmt Master Data Management PROCESS INTEGRATION Integration Broker Bus. Process Mgmt APPLICATION PLATFORM J 2 EE ABAP DB and OS Abstraction . . . ã SAP AG 2002, Title of Presentation, Speaker Name 36 LIFE CYCLE MANAGEMENT COMPOSITE APPLICATION FRAMEWORK Multi channel access n Integrates across technologies and organizational boundaries n A safe choice with full. NET and J 2 EE interoperability The business foundation for SAP and partners n Powers business-ready solutions that reduce custom integration n It’s SAP Enterprise Services Architecture increases business process flexibility

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

The SAP Net. Weaver BI Platform Powered by SAP Net. Weaver Data. Mart Data The SAP Net. Weaver BI Platform Powered by SAP Net. Weaver Data. Mart Data Warehouse Ad Hoc Query and Reporting Statutory Reporting Budget Plan/Forecast Balanced Scorecard Consolidation Modeling and Optimization Knowledge Management Content Management Business Proc. Management Web Presentation/Portal/Mgmt Reporting Data. Mart Strategic Enterp. Management SAP Net. Weaver Information Integration People Integration Process Integration Broker ERP/CRM/SCM/External Sources SAP delivers the complete, end-to-end, reliable and open BI Solution. ã SAP AG 2002, Title of Presentation, Speaker Name 38

Net. Weaver 2004 s 1 2 3 4 5 ã Analytical Applications BI Accelerator Net. Weaver 2004 s 1 2 3 4 5 ã Analytical Applications BI Accelerator Enterprise Data Warehousing Enhanced Web & Excel Reporting Integrated Planning SAP AG 2002, Title of Presentation, Speaker Name 39

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

WHAT IS “NEW” ANALYTICS? Questions & Insights lead to process improvement! “Is customer credit-worthy? 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? ” ã SAP AG 2002, Title of Presentation, Speaker Name 41

Visual Composer Model ã SAP AG 2002, Title of Presentation, Speaker Name 42 Visual Composer Model ã SAP AG 2002, Title of Presentation, Speaker Name 42

Net. Weaver 2004 s 1 2 3 4 5 ã Analytical Applications BI Accelerator Net. Weaver 2004 s 1 2 3 4 5 ã Analytical Applications BI Accelerator Enterprise Data Warehousing Enhanced Web & Excel Reporting Integrated Planning SAP AG 2002, Title of Presentation, Speaker Name 44

BI Accelerator Performance Optimization SAP Net. Weaver 2004 s provides various tools to increase BI Accelerator Performance Optimization SAP Net. Weaver 2004 s 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. n BI Accelerator A new paradigm for high performance data access. Query performance is boosted by orders of magnitude u Simultaneously the realignment processes roll-up and change run are improved significantly u HPA is used in connection with KM search engine TREX u Provides linear scalability and can fully leverage grid and adaptive computing capabilities u ã SAP AG 2002, Title of Presentation, Speaker Name 45

Target Stable Good Query Response Time – Independent Stable From Database Features, Query Response Target Stable Good Query Response Time – Independent Stable From Database Features, Query Response Time Caches, Aggregates, … Performance Improvement By Factor 10 in average, Very fast Up Response Time Queryto Factor 1000 ! BI Accelerator Support of New Hardware Paradigms like High Scalability Grid Computing, Adaptive Computing ã SAP AG 2002, Title of Presentation, Speaker Name 46 No Aggregate Maintenance, Low Maintenance Unnoticeable ‘Roll-up’, No Change Run

Innovation Column-Based Data Storage and Access / Vertical Table Decomposition In-Memory Processing What makes Innovation Column-Based Data Storage and Access / Vertical Table Decomposition In-Memory Processing What makes SAP BI with the BI accelerator so fast? Dictionary-based, Smart Compression Using Integers ã SAP AG 2002, Title of Presentation, Speaker Name 47 Highly Parallel Data Access / Horizontal Partitioning

Introducing BI Accelerator Appliance - 1 System performance declining when increasing utilization actionable information Introducing BI Accelerator Appliance - 1 System performance declining when increasing utilization actionable information Business User SAP Net. Weaver BI Server System Performance IT Department dat a data ã SAP AG 2002, Title of Presentation, Speaker Name 48 data

Introducing BI Accelerator Appliance Increase scalability and flexibility, w/o impacting architecture actionable information blade Introducing BI Accelerator Appliance Increase scalability and flexibility, w/o impacting architecture actionable information blade 2004 s Business User blade SAP Net. Weaver BI Server System Performance BI accelerator appliance 2004 s IT Department dat a data ã SAP AG 2002, Title of Presentation, Speaker Name 49 data

BI Accelerator of SAP Net. Weaver – Architecture Business Explorer Any Tool Analytic Engine BI Accelerator of SAP Net. Weaver – Architecture Business Explorer Any Tool Analytic Engine SAP Net. Weaver 2004 s Info. Cubes Data Acquisition Any Source SAP Net. Weaver BI ã SAP AG 2002, Title of Presentation, Speaker Name 50 Preferred Technology Partner SAP Net. Weaver 2004 s Preferred Hardware Partners HPA Engine Using Adaptive Computing

Net. Weaver 2004 s 1 2 3 4 5 ã Analytical Applications BI Accelerator Net. Weaver 2004 s 1 2 3 4 5 ã Analytical Applications BI Accelerator Enterprise Data Warehousing Enhanced Web & Excel Reporting Integrated Planning SAP AG 2002, Title of Presentation, Speaker Name 51

Modeling the EDW - Flexibility Data Modeling SAP Net. Weaver 2004 s provides additional Modeling the EDW - Flexibility Data Modeling SAP Net. Weaver 2004 s provides additional flexibility for implementing new data models and changing existing ones. n Re-Modeling Toolbox Changing Info. Cubes without rebuilding them from scratch – improved flexibility n Enhanced Data. Store objects (formerly: ODS objects) Improved performance and flexibility n Enhanced Info. Sets Improved flexibility u ã Integrate Info. Cubes into join condition SAP AG 2002, Title of Presentation, Speaker Name 52

Modeling the EDW - Data. Source Concept Data Acquisition SAP Net. Weaver 2004 s Modeling the EDW - Data. Source Concept Data Acquisition SAP Net. Weaver 2004 s improves and streamlines the Data. Source definition. In addition, it enhances remote access capabilities. n New Data. Source concept Unified and improved maintenance E. g. Web Service (XML), UD Connect u Additional Data. Sources enabled for remote access (including flat files and DB Connect) u n Enhanced remote capabilites Remote master data access – no data replication, low TCO u ã Remote access of master data from source systems SAP AG 2002, Title of Presentation, Speaker Name 53

Modeling the EDW - Transformation concept Transformation SAP Net. Weaver 2004 s significantly improves Modeling the EDW - Transformation concept Transformation SAP Net. Weaver 2004 s significantly improves transformation capabilities. The improved graphical UI contributes to decrease TCO. n Transformation Improved performance, flexibility and usability Graphical UI u Unification and simplification of transfer and update rules u New rule type: end routine u New rule type: expert routine (pure coding of transformation) u n Unit Conversion Capabilities for unit conversion during data load (and reporting) ã SAP AG 2002, Title of Presentation, Speaker Name 54

Running the EDW - Real-Time Data Acquisition Data Flow Control SAP Net. Weaver 2004 Running the EDW - Real-Time Data Acquisition Data Flow Control SAP Net. Weaver 2004 s improves and streamlines the data flow definition and the process chain set-up. In addition, it provides new real-time data acquisition capabilities that facilitate operational reporting: n Enhanced real-time data acquisition capabilities XML Web service u Direct push into PSA (instead of Service API/Delta Queue) Near-real-time Info. Package & DTP Daemon-based update from delta queue (BW Service API) u Daemon-based update of Data. Store objects (ODS layer) – including lean staging (with minimized logging) u ã SAP AG 2002, Title of Presentation, Speaker Name 55

EDW – Further enhancements Modeling the EDW n Data Warehousing Workbench u Improved usability EDW – Further enhancements Modeling the EDW n Data Warehousing Workbench u Improved usability and lucidity n Content Analyzer and Content Browser u New overview-, search- and analysis capabilities for Business Content Running the EDW n Process Chains u Additional functionality and process types n Data Quality u Improved error handling n Re-partitioning u Supports attaching, combining partitions or complete re-partitioning n New Analysis Authorization concept u Higher ã flexibility and simplified modeling SAP AG 2002, Title of Presentation, Speaker Name 56

Net. Weaver 2004 s 1 2 3 4 5 ã Analytical Applications BI Accelerator Net. Weaver 2004 s 1 2 3 4 5 ã Analytical Applications BI Accelerator Enterprise Data Warehousing Enhanced Web & Excel Reporting Integrated Planning SAP AG 2002, Title of Presentation, Speaker Name 57

Query, Reporting & Analysis – Designing a Report Standard formatting: Font styles (e. g. Query, Reporting & Analysis – Designing a Report Standard formatting: Font styles (e. g. bold, italic) and colors, etc. Group level changes with individual formattings Layout options, for example n n Height of rows, width of columns Multiline column headers Flexible positioning of fields Merger of cells Support of hierarchies Report design takes place in the Business Explorer (BEx) Report Designer - a new, VB. Net-based tool that allows to create formatted, print-optimized reports. ã SAP AG 2002, Title of Presentation, Speaker Name 58 Rules for the presentation of special characteristic values Integration of texts, pictures, and charts Header and footer for reports and pages

Query, Reporting & Analysis – Designing a Web Application n Model-driven BI application building Query, Reporting & Analysis – Designing a Web Application n Model-driven BI application building u Wizards for charts, maps, command editing u Wizard for layout elements (e. g. buttons) „Intellisense“ support for Web API developers Easy integration of native HTML commands u u Web application design takes place in the Business Explorer (BEx) Web Application Designer, a Visual Basic. NET-based, Unicode-compliant tool. ã SAP AG 2002, Title of Presentation, Speaker Name 59 n New layout elements (Tab strips etc. ) n New Web items n New chart types, e. g. GANTT chart, MTA chart n Design of planning aware business applications

Intuitive Ad-Hoc Analysis – BEx Web Analyzer Web-based Ad-hoc Design Leveraging Drag & Drop Intuitive Ad-Hoc Analysis – BEx Web Analyzer Web-based Ad-hoc Design Leveraging Drag & Drop n n n Easy navigation, when dropping characteristics on top of rows or columns Easy filtering, when dropping a characteristics to filter area Personalized Filters Saving and distribution of analysis results through strong portal integration Close integration to Information Broadcasting and Knowledge Management n Wizard-based definition of exceptions and conditions n Query creation on top of SAP BW and 3 rd party data (via XMLA Connectors) Drag and Drop ã SAP AG 2002, Title of Presentation, Speaker Name 60

BEx Web Printing Comfortable PDF based BEx Web printing n Any type of BEx BEx Web Printing Comfortable PDF based BEx Web printing n Any type of BEx Web query, Report or Web Application can be converted to PDF and printed n Leveraging the SAP Net. Weaver AS integration with Adobe Document Service n Adobe Acrobat Reader required, no plug-ins necessary n Printing options can be maintained globally or individually by an enduser pdf-conversion of a web item ã SAP AG 2002, Title of Presentation, Speaker Name 61

Excel integration - Workbook Design with BEx Analyzer Workbook Design Application-building in Excel (similar Excel integration - Workbook Design with BEx Analyzer Workbook Design Application-building in Excel (similar to Web Application Designer) New Options for Queries with 2 Structures n Excel Formulas allow access to any cell of the result set n Excel Formatting options can be fully leveraged for BEx Workbooks (e. g blank lines, fonts etc. n Combining Excel Formulas and Excel Formatting allows the design of High-End Formatted solution workbooks Integration of Business Planning ã SAP AG 2002, Title of Presentation, Speaker Name 62

Net. Weaver 2004 s 1 2 3 4 5 ã Analytical Applications BI Accelerator Net. Weaver 2004 s 1 2 3 4 5 ã Analytical Applications BI Accelerator Enterprise Data Warehousing Enhanced Web & Excel Reporting Integrated Planning SAP AG 2002, Title of Presentation, Speaker Name 63

Business Planning and Analytical Services – Wizard Mode Planning Model Design – Wizard Mode Business Planning and Analytical Services – Wizard Mode Planning Model Design – Wizard Mode – n Create a simple model of BI integrated planning by means of the Planning Wizard u Web based modeling environment for planning related tasks u Using ã the “Road map Pattern” SAP AG 2002, Title of Presentation, Speaker Name 64

Business Planning and Analytical Services – Planning Layout Design-time Query Design (BEx Query Designer) Business Planning and Analytical Services – Planning Layout Design-time Query Design (BEx Query Designer) Queries that are based on aggregation level are able to write back to the Info. Provider n Drilldown n Hierarchical data in rows and columns n Calculated key figures n Structures n Unit conversion BEx Web Application Designer § Create a layout § Configure a layout § Choose data binding § Configure interaction ã SAP AG 2002, Title of Presentation, Speaker Name 65 n. Alerts n. Conditions n. Graphics n. Ad-hoc currency n. Currency translation

Business Planning and Analytical Services – Run-time 2 Web Application Design – Example ã Business Planning and Analytical Services – Run-time 2 Web Application Design – Example ã SAP AG 2002, Title of Presentation, Speaker Name 66

Roadmap from BW to BI BW Overview BI Capabilities of Net. Weaver 2004 s Roadmap from BW to BI BW Overview BI Capabilities of Net. Weaver 2004 s Business Advantage of NW 2004 s Implementation Experience

Key Business Challenges Execution not aligned with Strategy not communicated clearly Individual objectives not Key Business Challenges Execution not aligned with Strategy not communicated clearly Individual objectives not aligned with strategy Poor measurement, and no corrective actions Ineffective Decision Making Processes Decisions delayed, or made on ‘gut feel’ only Key stakeholders not involved Solid information only available to small ‘elite’ Increasingly Complex Operational Environment Lack of insight into customer behaviour and trends Opportunities frequently missed Compliance Requirements Calls for transparency Increasing criticality of trustworthy data Budget Constraints Need to do more with less, and need to justify expenditures ã SAP AG 2002, Title of Presentation, Speaker Name 68

Business Advantage of NW 2004 s Ineffective Decision Making Processes Decisions delayed, or made Business Advantage of NW 2004 s Ineffective Decision Making Processes Decisions delayed, or made on ‘gut feel’ only Key stakeholders not involved Solid information only available to small ‘elite’ NW 2004 s - Analytical Applications Business actions based on informed decisions. ã SAP AG 2002, Title of Presentation, Speaker Name 69

Business Advantage of NW 2004 s Increasingly Complex Operational Environment Lack of insight into Business Advantage of NW 2004 s Increasingly Complex Operational Environment Lack of insight into customer behaviour and trends Opportunities frequently missed NW 2004 s - Enterprise Data Warehousing Truly scaleable solution Supporting all BI needs of the organisation ã SAP AG 2002, Title of Presentation, Speaker Name 70

Business Advantage of NW 2004 s Budget Constraints Need to do more with less, Business Advantage of NW 2004 s Budget Constraints Need to do more with less, and need to justify expenditures NW 2004 s - BI Accelerator Truly scaleable solution Lower administration cost Consistent and quick user response ã SAP AG 2002, Title of Presentation, Speaker Name 71

Business Advantage of NW 2004 s Execution not aligned with Strategy not communicated clearly Business Advantage of NW 2004 s Execution not aligned with Strategy not communicated clearly Individual objectives not aligned with strategy Poor measurement, and no corrective actions NW 2004 s - Integrated Planning Integration platform for analysis and planning. Planning systematically delivered to all levels of the organisation ã SAP AG 2002, Title of Presentation, Speaker Name 72

Roadmap from BW to BI BW Overview BI Capabilities of Net. Weaver 2004 s Roadmap from BW to BI BW Overview BI Capabilities of Net. Weaver 2004 s Business Advantage of NW 2004 s Implementation Experience

Deployment of BW SAP Penetration R/3 Reporting Information delivery in my. SAP solution Data Deployment of BW SAP Penetration R/3 Reporting Information delivery in my. SAP solution Data Warehouse where SAP is one of the ERP solution Analytical Application Standalone Data Warehouse BI Complexity ã SAP AG 2002, Title of Presentation, Speaker Name 74

Phased Roll Out Size Multi-Business Data Warehouse Business Unit Data Warehouse Think big but Phased Roll Out Size Multi-Business Data Warehouse Business Unit Data Warehouse Think big but start small Subject Specific Data Mart Time ã SAP AG 2002, Title of Presentation, Speaker Name 75

Start small and fast Scope of project Additional Subject areas Extending Content External Data Start small and fast Scope of project Additional Subject areas Extending Content External Data BW Content C o n c e p t s BW skill customer Delivery Cycles ã SAP AG 2002, Title of Presentation, Speaker Name 76

Rapid Implementation step by step Selected subject area Defined scope Business Content as a Rapid Implementation step by step Selected subject area Defined scope Business Content as a basis for implementation Minor but User-significant enhancements Achieve the 80% solution and demonstrate results Receive feedback n Incorporate into subsequent delivery cycles Rollout to other subject area (maybe in parallel) Parallel work in frontend, extraction and datamodel team Use the „power“ of BW n Extend with external data sources n Combine information from different applications ã SAP AG 2002, Title of Presentation, Speaker Name 77

Benefit of the Rapid Implementation § Rapid ROI / deliverable benefit to the business Benefit of the Rapid Implementation § Rapid ROI / deliverable benefit to the business § Establish positive view of the product within user base § Establish stable technology infrastructure early in project § Transfer overall product knowledge to ensure subsequent implementations are appropriately resourced § Train members of the implementation team ã SAP AG 2002, Title of Presentation, Speaker Name 78

Suolution Manager & Accelerated BW Method & Tools Highest Level : Maps to ASAP Suolution Manager & Accelerated BW Method & Tools Highest Level : Maps to ASAP Lowest Level : Incorporates BW-Specific Activities / Accelerators Key Enablers : Included to Assist the Customer and Consultant Evolving : Continually Being Refined and Enhanced by BW development and consulting ã SAP AG 2002, Title of Presentation, Speaker Name 79 experts in

Skills The skills required will be driven by the scope of the implementation Scope Skills The skills required will be driven by the scope of the implementation Scope of Implementation n Business Contents with minor enhancements? n Significant non-SAP data sources? n Enterprise Data Warehouse? Skills n n n ã BW Implementation experience Operational users SAP source knowledge Data Warehousing architecture BASIS / WAS knowledge SAP AG 2002, Title of Presentation, Speaker Name 80

Project Team Structure IT Business Key Users Project Maturity DW Architect BW Solution Architects Project Team Structure IT Business Key Users Project Maturity DW Architect BW Solution Architects Business Key Users BW Administrator ã SAP AG 2002, Title of Presentation, Speaker Name 81 Business Key Users

Implementation Team - Mix of Resource SAP/ Partner Consulting Effort Internal Time ã SAP Implementation Team - Mix of Resource SAP/ Partner Consulting Effort Internal Time ã SAP AG 2002, Title of Presentation, Speaker Name 82

Key Success Factors Management buy-in Involve user community early in the project life cycle Key Success Factors Management buy-in Involve user community early in the project life cycle Strong implementation team n Business understanding & empowerment n SAP skills n BW knowledge n DW skills Rapid, step-by-step, reiterative implementation n delivery cycle concept n early success n feedback ã SAP AG 2002, Title of Presentation, Speaker Name 83

Roadmap from BW to BI BW Overview BI Capabilities of Net. Weaver 2004 s Roadmap from BW to BI BW Overview BI Capabilities of Net. Weaver 2004 s Business Advantage of NW 2004 s Implementation Experience