BW Overview BI Capabilities of NetWeaver 2004s Business Advantage of NW2004s Roadmap from BW to BI Implementation Experience www.solitairesoft.com
BW Overview BI Capabilities of NetWeaver 2004s Business Advantage of NW2004s Roadmap from BW to BI Implementation Experience www.solitairesoft.com
SAP BW – A success story Active BW Customers > 6,500 How do you plan to leverage SAP BW? Mixed data: 64% SAP data only: 36% Are you satisfied with SAP BW? Yes 95% No 5% 50 - 250 39% 1,000 - 10,000 13% < 50 24% > 10,000 1% 250 - 1,000 23% Number of Users 100 - 500 GB 32% 500 GB - 1 TB 18% > 5 TB 1% 0 - 100 GB 26% 1 - 5 TB 23% Approximate Data Volume www.solitairesoft.com
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
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 Powerful Information Analysis Innovative, intuitive user interface Powerful OLAP analysis Web & MS Excel based front-ends Easy integration with Portal An integrated end-to-end D ata W arehouse solution SAP Business Warehouse (BW) www.solitairesoft.com
SAP Business Intelligence Dashboards Targeted reports Other 3 rd Party Sales Interfaces Credit Control Sales Finance & Projects Self-service Reporting Business Warehouse (BW) Business Content www.solitairesoft.com
SAP BI - Reporting and Analysis For All User Types A uthors 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
SAP AG 2004, Title of Presentation / Speaker Name / 8 Authors & Analysts www.solitairesoft.com
Business Managers Alert Driven Targeted Emailed www.solitairesoft.com
Executives www.solitairesoft.com
Information Broadcasting 1 Universal Data Connection NetWeaver Integration Business Planning & Simulation (BPS) 4 3 2 BW release 3.5 Overview Advanced Analytic functionality 5 www.solitairesoft.com
In this example the Report was sent in an MHTML-Format and is now available in the personal Inbox of the Receiver. Information Broadcasting via E-Mail www.solitairesoft.com
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
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
Information Broadcasting – BEx Portfolio 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 Queries, Workbooks, BI Applications as KM Documents www.solitairesoft.com
Information Broadcasting 1 Universal Data Connection NetWeaver Integration Business Planning & Simulation (BPS) 4 3 2 BW release 3.5 Overview Advanced Analytic functionality 5 www.solitairesoft.com
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 SAP non SAP SAP Query XMLA JDBC ODBO BI Java SDK OLAP Custom-built Applications SAP Enterprise Portal Universal Data Connect 1. BI Java Connectors JDBC, XMLA,ODBO , SAP Query 3. BI Java SDK Java API, Examples , Documentation BEx BW Staging 2. Universal Data Connect SAP BW Integration www.solitairesoft.com
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
SAP BW – Non SAP-DW Integration Scenario ERP DW Reporting SAP HR Cubes BW Local Skills Database Non SAP-DW Various Sources SAP HR Data Listing Personnel Deployment v Skills profile www.solitairesoft.com
Information Broadcasting 1 Universal Data Connection NetWeaver Integration Business Planning & Simulation (BPS) 4 3 2 BW release 3.5 Overview Advanced Analytic functionality 5 www.solitairesoft.com
DataSources BW and XI PSA realtime update Delta-Queue mySAP.com (via BW Service-API) SAP BW http / SOAP Near Realtime InfoPackage Standard Staging Operational Data Store Realtime Data Acquisition Delta-Queue Open Service PSA PSA RFC SAP XI www.solitairesoft.com
Information Broadcasting 1 Universal Data Connection NetWeaver Integration Business Planning & Simulation (BPS) 4 3 2 BW release 3.5 Overview Advanced Analytic functionality 5 www.solitairesoft.com
Planning in mySAP BI – Evolution Future Planning Environment mySAP BI SAP BW Data Management Modelling Planning Framework Process Coordination Analysis mySAP Financials SEM-BPS Planning Financial Planning Applications SEM-BPS Planning Financial Planning Applications Modelling Planning Framework Process Coordination mySAP BI SAP BW Data Management Analysis Current Planning Environment mySAP Financials www.solitairesoft.com
Planning cycles August December Strategic Planning Strategic Planning and Target setting on group level Operational Planning Operational Planning and Budgeting in the business units Headcountplanning Sales planning Production planning Marketing planning Reconciliation of operational plans with strategic targets Strategic Targets (Operating Profit + 4%, Market share+10%) Plan evaluation www.solitairesoft.com
SAP BI Planning Architecture Data Acquisition Automatic Planning Manual Planning/ Analysis Process control Access / Storage Master Data Master Data Dimensional Data Granular Data ODS Common Read / Write Interface Planning Framework DWH Layer Business Logic Planning Front Ends Presentation Open Interface and Web Services Modeling Portal based Excel Inplace Excel Client ALV Grid HTML in GUI User Interaction www.solitairesoft.com
Information Broadcasting 1 Universal Data Connection NetWeaver Integration Business Planning & Simulation (BPS) 4 3 2 BW release 3.5 Overview Advanced Analytic functionality 5 www.solitairesoft.com
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
Web Application Designer Chart Designer Wizard (Reduced Overview) Result www.solitairesoft.com
Data Mining Methods - Explorative A B C 20% of customers generate 60% of sales Clustering ABC Classification Association Analysis Weighted Score Tables Customer Age Gender Income … … … … … … … … Score … … Weight www.solitairesoft.com
? Age Sales Complaints # of Products Gender Income Buy Yes No Complaints Gender Income Data Mining Methods - Predictive >4 <=4 M F <=30 k >30 k Regression Decision Trees No No Yes Yes www.solitairesoft.com
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.
Composite Scenarios: Customer Retention A B C ABC Classification Decision Trees Clustering B C A Loyal At Risk Association Analysis Cross-Selling Rules Marketing Campaign Transfer Knowledge Goal: Reduce Customer Churn www.solitairesoft.com
BW Overview BI Capabilities of NetWeaver 2004s Business Advantage of NW2004s Roadmap from BW to BI Implementation Experience www.solitairesoft.com
Analytical Applications 1 BI Accelerator Enterprise Data Warehousing Enhanced Web & Excel Reporting 4 3 2 NetWeaver 2004s Integrated Planning 5 www.solitairesoft.com
SAP NetWeaver ™ The total integration and application platform for lower TCO 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 COMPOSITE APPLICATION FRAMEWORK PEOPLE INTEGRATION Multi channel access Portal Collaboration INFORMATION INTEGRATION Bus. Intelligence Master Data Management Knowledge Mgmt PROCESS INTEGRATION Integration Broker Bus. Process Mgmt APPLICATION PLATFORM J2EE DB and OS Abstraction ABAP LIFE CYCLE MANAGEMENT ... www.solitairesoft.com
Architecture Source: Gartner (CPM, 2004) Web Presentation/Portal/Mgmt Reporting Modeling and Optimization Consolidation Balanced Scorecard Budget Plan/Forecast Statutory Reporting Ad Hoc Query and Reporting DataMart DataMart DataMart DataMart Data Warehouse Integration Broker ERP/CRM/SCM/External Sources Business Proc. Management Content Management Knowledge Management Presentation CPM Applications BI Infrastructure Data Sources The Business Intelligence Platform www.solitairesoft.com
Web Presentation/Portal/Mgmt Reporting Modeling and Optimization Consolidation Balanced Scorecard Budget Plan/Forecast Statutory Reporting Ad Hoc Query and Reporting DataMart DataMart DataMart DataMart Data Warehouse Integration Broker ERP/CRM/SCM/External Sources Business Proc. Management Content Management Knowledge Management Process Integration Strategic Enterp. Management Powered by SAP NetWeaver SAP NetWeaver People Integration Information Integration SAP delivers the complete, end-to-end, reliable and open BI Solution. The SAP NetWeaver BI Platform www.solitairesoft.com
Analytical Applications 1 BI Accelerator Enterprise Data Warehousing Enhanced Web & Excel Reporting 4 3 2 NetWeaver 2004s Integrated Planning 5 www.solitairesoft.com
Controlling (BW) Logistics (SCE) Sales (CRM) Production (SCP) Fulfillment (FC) Fin.-Dptm. (FIN) Customer Creation & Release Delivery Request 4 Update Inventory Accounting 7 Update Inventory 6 Delivery Execution 5 Request Global ATP 2 Global ATP Check 3 Receives ASN 9 Release ASN 8 1 Creation Sales Order Fulfillment Request Creation Purchase Order WHAT IS “NEW” ANALYTICS? Example: Sales Order Fulfillment process www.solitairesoft.com
WHAT IS “NEW” ANALYTICS? “360° View of the Customer” “Is customer credit-worthy?” “smooth shipping Process?” “sufficient stock of inventory?” “extra effort costs $$$?” Questions & Insights lead to process improvement! www.solitairesoft.com
Visual Composer Model www.solitairesoft.com
www.solitairesoft.com
Analytical Applications 1 BI Accelerator Enterprise Data Warehousing Enhanced Web & Excel Reporting 4 3 2 NetWeaver 2004s Integrated Planning 5 www.solitairesoft.com
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 www.solitairesoft.com
Target BI Accelerator Very fast Query Response Time Stable Query Response Time High Scalability Low Maintenance Performance Improvement By Factor 10 in average, Up to Factor 1000 ! Stable Good Query Response Time – Independent From Database Features, Caches, Aggregates, … Support of New Hardware Paradigms like Grid Computing, Adaptive Computing No Aggregate Maintenance, Unnoticeable ‘Roll-up’, No Change Run www.solitairesoft.com
Innovation Column-Based Data Storage and Access / Vertical Table Decomposition In-Memory Processing Highly Parallel Data Access / Horizontal Partitioning Dictionary-based, Smart Compression Using Integers What makes SAP BI with the BI accelerator so fast? www.solitairesoft.com
Introducing BI Accelerator Appliance - 1 SAP NetWeaver BI Server data data data data actionable information Business User IT Department System Performance System performance declining when increasing utilization
SAP NetWeaver BI Server Introducing BI Accelerator Appliance data data data actionable information Business User IT Department System Performance Increase scalability and flexibility, w/o impacting architecture BI accelerator appliance blade blade blade data 2004s 2004s
BI Accelerator of SAP NetWeaver – Architecture SAP NetWeaver BI HPA Engine Using Adaptive Computing Data Acquisition InfoCubes Analytic Engine Any Source SAP NetWeaver 2004s Preferred Technology Partner Preferred Hardware Partners SAP NetWeaver 2004s Business Explorer Any Tool www.solitairesoft.com
Analytical Applications 1 BI Accelerator Enterprise Data Warehousing Enhanced Web & Excel Reporting 4 3 2 NetWeaver 2004s Integrated Planning 5 www.solitair e soft.com
Modeling the EDW - Flexibility Data Modeling SAP NetWeaver 2004s provides additional flexibility for implementing new data models and changing existing ones. Re-Modeling Toolbox Changing InfoCubes without rebuilding them from scratch – improved flexibility Enhanced DataStore objects (formerly: ODS objects) Improved performance and flexibility Enhanced InfoSets Improved flexibility Integrate InfoCubes into join condition www.solitairesoft.com
Modeling the EDW - DataSource Concept Data Acquisition SAP NetWeaver 2004s improves and streamlines the DataSource definition. In addition, it enhances remote access capabilities. New DataSource concept Unified and improved maintenance E.g. Web Service (XML), UD Connect Additional DataSources enabled for remote access (including flat files and DB Connect) Enhanced remote capabilites Remote master data access – no data replication, low TCO Remote access of master data from source systems www.solitairesoft.com
Modeling the EDW - Transformation concept Transformation SAP NetWeaver 2004s significantly improves transformation capabilities. The improved graphical UI contributes to decrease TCO. Transformation Improved performance, flexibility and usability Graphical UI Unification and simplification of transfer and update rules New rule type: end routine New rule type: expert routine (pure coding of transformation) Unit Conversion Capabilities for unit conversion during data load (and reporting) www.solitairesoft.com
Running the EDW - Real-Time Data Acquisition Data Flow Control SAP NetWeaver 2004s 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: Enhanced real-time data acquisition capabilities XML Web service Direct push into PSA (instead of Service API/Delta Queue) Near-real-time InfoPackage & DTP Daemon-based update from delta queue (BW Service API) Daemon-based update of DataStore objects (ODS layer) – including lean staging (with minimi zed logging ) www.solitairesoft.com
EDW – Further enhancements Modeling the EDW Data Warehousing Workbench Improved usability and lucidity Content Analyzer and Content Browser New overview-, search- and analysis capabilities for Business Content Running the EDW Process Chains Additional functionality and process types Data Quality Improved error handling Re-partitioning Supports attaching, combining partitions or complete re-partitioning New Analysis Authorization concept Higher flexibility and simplified modeling www.solitairesoft.com
Analytical Applications 1 BI Accelerator Enterprise Data Warehousing Enhanced Web & Excel Reporting 4 3 2 NetWeaver 2004s Integrated Planning 5 www.solitairesoft.com
Query, Reporting & Analysis – Designing a Report Designing a Report 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. Standard formatting: Font styles (e.g. bold, italic) and colors, etc. Group level changes with individual formattings Layout options, for example Height of rows, width of columns Multiline column headers Flexible positioning of fields Merger of cells Support of hierarchies Rules for the presentation of special characteristic values Integration of texts, pictures, and charts Header and footer for reports and pages www.solitairesoft.com
Query, Reporting & Analysis – Designing a Web Application Designing a Web Application Web application design takes place in the Business Explorer (BEx) Web Application Designer, a Visual Basic .NET-based, Unicode-compliant tool. Model-driven BI application building Wizards for charts, maps, command editing Wizard for layout elements (e.g. buttons) „Intellisense“ support for Web API developers Easy integration of native HTML commands New layout elements (Tab strips etc.) New Web items New chart types, e.g. GANTT chart, MTA chart Design of planning aware business applications www.solitairesoft.com
Intuitive Ad-Hoc Analysis – BEx Web Analyzer Web-based Ad-hoc Design Leveraging Drag & Drop 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 Wizard-based definition of exceptions and conditions Query creation on top of SAP BW and 3rd party data (via XMLA Connectors) Drag and Drop www.solitairesoft.com
BEx Web Printing Comfortable PDF based BEx Web printing Any type of BEx Web query, Report or Web Application can be converted to PDF and printed Leveraging the SAP NetWeaver AS integration with Adobe Document Service Adobe Acrobat Reader required, no plug-ins necessary Printing options can be maintained globally or individually by an end-user pdf-conversion of a web item www.solitairesoft.com
Excel integration - Workbook Design with BEx Analyzer Application-building in Excel (similar to Web Application Designer) New Options for Queries with 2 Structures Excel Formulas allow access to any cell of the result set Excel Formatting options can be fully leveraged for BEx Workbooks (e.g blank lines, fonts etc. Combining Excel Formulas and Excel Formatting allows the design of High-End Formatted solution workbooks Integration of Business Planning Workbook Design
Analytical Applications 1 BI Accelerator Enterprise Data Warehousing Enhanced Web & Excel Reporting 4 3 2 NetWeaver 2004s Integrated Planning 5 www.solitairesoft.com
Business Planning and Analytical Services – Wizard Mode Planning Model Design – Wizard Mode – Create a simple model of BI integrated planning by means of the Planning Wizard Web based modeling environment for planning related tasks Using the “Road map Pattern”
Business Planning and Analytical Services – Planning Layout Design-time Drilldown Hierarchical data in rows and columns Calculated key figures Structures Unit conversion Alerts Conditions Graphics Ad-hoc currency Currency translation Query Design (BEx Query Designer) Queries that are based on aggregation level are able to write back to the InfoProvider BEx Web Application Designer Create a layout Configure a layout Choose data binding Configure interaction www.solitairesoft.com
Business Planning and Analytical Services – Run-time 2 Web Application Design – Example www.solitairesoft.com
BW Overview BI Capabilities of NetWeaver 2004s Business Advantage of NW2004s Roadmap from BW to BI Implementation Experience www.solitairesoft.com
Key Business Challenges Ineffective Decision Making Processes Decisions delayed, or made on ‘gut feel’ only Key stakeholders not involved Solid information only available to small ‘elite’ Execu tion not aligned with Strategy Strategy not communicated clearly Individual objectives not aligned with strategy Poor measurement, and no corrective actions 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
Business Advantage of NW2004s NW 2004s - Analytical Applications Business actions based on informed decisions. Ineffective Decision Making Processes Decisions delayed, or made on ‘gut feel’ only Key stakeholders not involved Solid information only available to small ‘elite’ www.solitairesoft.com
Business Advantage of NW2004s NW 2004s - Enterprise Data Warehousing Truly scaleable solution Supporting all BI needs of the organisation Increasingly Complex Operational Environment Lack of insight into customer behaviour and trends Opportunities frequently missed www.solitairesoft.com
Business Advantage of NW2004s NW 2004s - BI Accelerator Truly scaleable solution Lower administration cost Consistent and quick user response Budget Constraints Need to do more with less, and need to justify expenditures www.solitairesoft.com
Business Advantage of NW2004s NW2004s - Integrated Planning Integration platform for analysis and planning. Planning systematically delivered to all levels of the organisation Execu tion not aligned with Strategy Strategy not communicated clearly Individual objectives not aligned with strategy Poor measurement, and no corrective actions www.solitairesoft.com
BW Overview BI Capabilities of NetWeaver 2004s Business Advantage of NW2004s Roadmap from BW to BI Implementation Experience www.solitairesoft.com
Deployment of BW R/3 Reporting Information delivery in mySAP solution Data Warehouse where SAP is one of the ERP solution Standalone Data Warehouse Analytical Application BI Complexity SAP Penetration www.solitairesoft.com
Multi-Business Data Warehouse Phased Roll Out Business Unit Data Warehouse Subject Specific Data Mart Size Time Think big but start small www.solitairesoft.com
Start small and fast Scope of project BW skill customer Additional Subject areas Extending Content External Data BW Content Delivery Cycles Co n c e p t s www.solitairesoft.com
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 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 Extend with external data sources Combine information from different applications www.solitairesoft.com
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 www.solitairesoft.com
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 experts in development and consulting www.solitairesoft.com
Skills The skills required will be driven by the scope of the implementation Scope of Implementation Business Contents with minor enhancements? Significant non-SAP data sources? Enterprise Data Warehouse? Skills BW Implementation experience Operational users SAP source knowledge Data Warehousing architecture BASIS / WAS knowledge www.solitairesoft.com
Project Team Structure DW Architect BW Solution Architects BW Administrator Business Key Users Business Key Users Business Key Users IT Business Project Maturity www.solitairesoft.com
Implementation Team - Mix of Resource SAP/ Partner Internal Time Consulting Effort www.solitairesoft.com
Key Success Factors Management buy-in Involve user community early in the project life cycle Strong implementation team Business understanding & empowerment SAP skills BW knowledge DW skills Rapid, step-by-step, reiterative implementation delivery cycle concept early success feedback www.solitairesoft.com
BW Overview BI Capabilities of NetWeaver 2004s Business Advantage of NW2004s Roadmap from BW to BI Implementation Experience www.solitairesoft.com