SAP Business IntelligenceOverview :Product Management BI, SAP AG SAP Business IntelligenceOverview


Agenda :Agenda Positioning / Value Proposition Data Warehousing - ETL BI Platform BI Suite SAP NetWeaver ‘04 Integration Business Content Roadmap


Agenda :Agenda Positioning / Value Proposition Data Warehousing - ETL BI Platform BI Suite SAP NetWeaver ‘04 Integration Business Content Roadmap


SAP BI – The Solution at a Glance :SAP Business Intelligence is an enterprise-class, complete, open and integrated solution that delivers actionable insights. SAP BI – The Solution at a Glance Data acquisition, data warehousing, OLAP, planning framework, BI tools, dashboards and analytical applications; with pre-configured content using best-practice models. Open, well documented APIs and interfaces along with full functionality to integrate structured and unstructured, heterogeneous data Scalable and reliable BI solution that is tightly integrated with SAP NetWeaver, source transactional systems and partner’s complementary tools Support decision-making requirements of the entire enterprise regardless of data sources of access methods Convert data into information, and ensure information is delivered at the right time to the right person in the right format to support business decision making.


Pain Points, Customers without a BI Solution :Pain Points, Customers without a BI Solution No central access: Data relelavnt for decision-making are spread in different systems across the IT landscape. Analyses are time consuming and not always consistent. Time Consuming: Often, decision makers have to spend too much time on finding relevant, timely information before they can even analyze it. Bad Performance: The response time of complex analyses in operational systems is often not acceptable. Complexity / IT-Dependency: Transactional systems often require additional programming efforts to retrieve relevant information. Employees without programming know-how are not able to run ad-hoc analyses. Missing business process support: Exceptions are not alerted to those who should know.


The Value of SAP BI :The Value of SAP BI Completeness: End-to-end BI solution incorporating data warehousing, OLAP, data mining, business intelligence tools and pre-defined business content. Openness: Allows to incorporate data from heterogeneous systems. Supports industry standards such as XML for Analysis or ODBO for reporting and analysis. Performance/Scalability: A proven solution with that generated and loaded a 5.5 Tb data warehouse. Business Orientation: Integrates business processes. Provides a centralized metadata repository with a consistent business semantic. Ready-to go templates and best-practices – horizontal and vertical business content. Actionable Information: Supports decision-making requirements of every user.


SAP BI – Key Capabilities :SAP BI – Key Capabilities Data Warehousing (SAP BW Administrator Workbench) Extraction, transformation, and loading Data warehouse management Business modeling BI Platform Online analytical processing (OLAP) Data Mining Alerting Meta Data Repository Planning Framework BI Suite of Tools (SAP BW Business Explorer) Query Design Managed Reporting and Analysis Visualization – Web Application Design Collaboration Pre-configured Business Content


Key Areas adressed with SAP BI :Key Areas adressed with SAP BI Openness Open Hub Service – dissemination of information UD Connect – directly access data to relational database tables and OLAP systems Support of industry standards (e.g. XML, XML for Analysis, JDBC etc.) Integration Integration of technology, tools and applications allowing cross-enterprise analytics and closed-loop scenarios Integration into the Enterprise Portal as single point of entry Integration of unstructured information such as documents, files, etc. Web Offering Interactive analysis of information via web and mobile devices Intuitive design of web applications Ad-hoc query design via the web


SAP Business Intelligence :SAP Business Intelligence Sources Data Warehousing BI Platform BI Suite Data Acquisition Access Open Interface a. Web Services Data Presentation User SAP Business Intelligence integrates all your corporate information so you can turn information into insight, insight into action, and action into improved business operations.


SAP BI Architecture :SAP BI Architecture


Agenda :Agenda Positioning / Value Proposition Data Warehousing - ETL BI Platform BI Suite SAP NetWeaver ‘04 Integration Business Content Roadmap


Extraction, Transformation and Loading :Extraction, Transformation and Loading …to get a complete view of your business Open for any source Flexible set of ETL capabilities Integration on application level Open to third-party tools Support of open standards


Operational Data Store and Data Warehouse layer :Operational Data Store and Data Warehouse layer Data Warehouse Non volatile Granular Integrated Historical foundation Built with ODS Objects Operational Data Store Operational Reporting Near Real-Time / Volatile Granular Built with ODS Objects Multidimensional Models Multidimensional analysis Aggregated view Integrated Built with InfoCubes ... to provide the right information for all users


SAP‘s Data Aquisition Strategy :E-Business Applications ^ Legacy Systems VSAM ADABAS SAP R/2 Non SAP BW Service API for SAP SAPComponents DB Connect/Flat File SAP‘s Data Aquisition Strategy PeopleSoft Oracle DataStage ETL Components


Transformation within BW data flow :Transformation within BW data flow Condition Handling Date Conversion Currency Conversion Concatenation ...


Transformation Library – List of Functions :Other functions: Skip record Abort package Check initial value User-defined functions, that can also be re-used in other transformation rules setup via BAdI (Business Add-In), e.g. to integrate self- defined function modules Transformation Library – List of Functions Mathematical functions: add, sub, mul, div, () CEIL / FLOOR ROUND, TRUNC EXP, FRAC ABS, SIGN SQRT LOG / LOG10 DIV / MOD trigonometric functions exponents String functions: substring concatenate to upper case shift left / right condense (no gaps) trim left / right strlen replace left / right Logical operators: =, , >, >=, <=, IF, AND, OR, NOT Date conversion: week_first_day (computes date (Monday) of cal. week) date_conv (converts external date format into internal format) date_diff (days between two dates) add_to_date (adds days to date) date_weekday (computes weekday from date) date_week (computes week from date) date_month (computes month from date) date_quarter (computes quarter from date) date_year (computes year from date) date_fiscyear (computes fiscal year from date) week_quarter (computes quarter from week) week_month (computes month from week) month_quarter (computes quarter from month) month_year (computes year from month)


BW Process Chains :BW Process Chains Automating the BW administration Graphical modelling and monitoring End-to-end monitoring Openness for all kinds of processes Scheduling


Open Hub Service - Details :Controlled distribution of consistent data Target: file or DB table Central monitoring Select filter criteria and columns Scheduling Full or delta mode ODS Objects Open Hub Service - Details


Agenda :Agenda Positioning / Value Proposition Data Warehousing - ETL BI Platform BI Suite SAP NetWeaver ‘04 Integration Business Content Roadmap


SAP BI Key Components :SAP BI Key Components Data Acquisition Common Read / Write Interface Open Interface and Web Services USER Interaction Access Business Logic Presentation Data Warehousing BI Platform BI Suite Summarized, Dimensional Data BI Services BI Suite Granular, Volatile Data ODS Master Data Drill-Down, Drill-Through, Drill-Across Pivoting What If Slice and Dice Gallery of ready-to-use Web Templates / Items Table, Chart Map Alert Monitor Context Menu Business Calculations Planning and Forecasts Exception Scanning Alerting Query Pre-Calculation Caching Background Printing Data Mining


OLAP Business Scenarios :OLAP Business Scenarios Examples for OLAP Business Scenarios Creation of complex formulas, down to cell level Usage of conditions and exceptions in reports Multi-currency handling Flexible hierarchy analysis Non-cumulative key figures to analyze data from inventory management data Elimination of internal business volume Market share analysis Slow moving items . . .


Metadata :Metadata Central Metadata Repository Central display of Metadata Objects Graphical view HTML based Download capabilities XML Metadata exchangge


Data Mining :Data Mining Data Mining Methods in SAP BW Classification Decision Tree Clustering Clustering Association Analysis Approximation Scoring Further Analyses ABC Classification Data Mining Definition Analytical approach that look for hidden data patterns and relationships in large databases Provides insights by analyzing past data and predicts future trends and behaviours Enables prospective decision-making as opposed to pure retrospective analysis


Analysis Process Designer :Analysis Process Designer Analysis Process Designer (APD) Scenario Data (available through all SAP BW storage media) can be explored within a multilevel process, applying advanced analytical methods in order to gain new insights from these data. The analytical results are persisted again within SAP BW. Examples ABC-classification (e.g. customer/vendor) Determination of the frequency distribution in datasets Development of Scoring information … Feature Description Interactive modeling (drag&drop) workbench for analysis processes Infrastructure to link up process elements, being sources (selection of data), targets (deployment of results), pre-processing (transformation) and visualization tools as well as data analysis methods. Analysis of data at every step of the analysis process


SAP BI – Planning & Simulation: BW-BPS :SAP BI – Planning & Simulation: BW-BPS Business Planning & Simulation in SAP BW Planning & Simulation Scenarios Research / Prognosis Estimating future situations and evaluating their impact on the enterprise Target Setting Setting goals and milestones Budgeting Evaluating and allocating resources for the achievement of targets Examples Sales Plan, Resource Plan, Cost Center Plan, Profitability Planning Benefits of offering BW-BPS with SAP BW No installation of SAP SEM Add-On necessary for usage of planning functionality One software installation only One support package cycle One project budget for planning and analysis


Business Planning & Simulation: Features :Business Planning & Simulation: Features Planning and analysis user interfaces Planning in Excel Planning in Web Interface Document management Analysis in Business Explorer (Excel and Web) Planning Framework MultidimensionalBusiness Structures Definition of work packages Hierarchy maintenance Version concept User authorizations Variables maintenance Planning functions Copy/delete Revaluate Top-down distribution Bottom-up aggregation Trend analysis What-if-analysis Simulation Planning sequences Automatic execution of planning functions Control and distribution of data Status and Tracking Monitor Retractors for distribution of data to operational systems Background processing of planning functions Modeling of Planning structures Automatic Planning Manual Planning ProcessControl


Agenda :Agenda Positioning / Value Proposition Data Warehousing - ETL BI Platform BI Suite SAP NetWeaver ‘04 Integration Business Content Roadmap


BEx Overview Agenda :BEx Overview Agenda BI End User Requirements Business Explorer (BEx) Product Capabilities Query, Analysis & Reporting BEx Web & BEx Analyzer BEx Information Broadcasting Conclusion


BEx Overview Agenda :BEx Overview Agenda BI End User Requirements Business Explorer (BEx) Product Capabilities Query, Analysis & Reporting BEx Web & BEx Analyzer BEx Information Broadcasting Conclusion


SAP BI Delivers a Comprehensive Solution :SAP BI Delivers a Comprehensive Solution Authors and analysts Need advanced analysis functionality and ad-hoc data exploration capabilities Require useful, manageable tools Executives and knowledge workers Require personalized information in context via an intuitive user interface Want predefined analysis paths and the option of in-depth analysis of summary data Information consumers Need a snapshot of a particular data set to perform their operational tasks Do not interact extensively with the data.


SAP BI User Categories :Information Consumption, Portal-based Deployment, and Executive Reporting 60 % OLAP Analysis and Power Reporting 30 % Authoring and Ad-hoc Query 10 % SAP BI User Categories Analytical functionality and flexibility Required training investment and cost High High Low Low


The Business Explorer: SAP‘s BI Suite :The Business Explorer: SAP‘s BI Suite


BEx Overview Agenda :BEx Overview Agenda BI End User Requirements Business Explorer (BEx) Product Capabilities Query, Analysis & Reporting BEx Web & BEx Analyzer BEx Information Broadcasting Conclusion


BEx Query, Analysis & Reporting :BEx Query, Analysis & Reporting Key Capabilities Unlimited Web and Mobile access via Automatic Device Recognition The system allows access to BI data from any Web Browser or Mobile device Alert framework The system can push BI alerts to end-users via SMS, e-mail and Portal Apps. Data Precalculation for Online and Offline Scenarios Allows to pre-calculate SAP BW data to have it available immediately if needed without having to go through the OLAP Business Content Broad range of extendable dataproviders and queries provided 1:n Personalization allows for one query to serve multiple users Open Analysis Framework Supporting standards like XML/A and OLE DB for OLAP


BEx Query, Analysis & Reporting :BEx Query, Analysis & Reporting BEx Query Designer Ease-of use via drag & drop Personalized access Comfortable formula editor for calculations access to any BW Data Provider Windows-based component Web interface for intuitive ad-hoc design & analysis


BEx Query, Analysis & Reporting :BEx Query, Analysis & Reporting Analysis Capabilities Analyze different aspects of the business Multi-dimensional views Generic navigation and interaction (slice and dice, drill-down, drill-thru, pivoting, ...) Hierarchy navigation Time dependency Currency conversion (e.g. different per column) Versioning, Aggregation rules Global, enterprise-wide use Multi-language, multi-currency Intelligent Services Alerting to identify and handle exceptions, Pro-active notification Conditions Data Mining OLAP cache Multi-user cache for BW queries for enhanced performance


Analysis Process Designer :Analysis Process Designer Analysis Process Designer (APD) Scenario Data (available through all SAP BW storage media) can be explored within a multilevel process, applying advanced analytical methods in order to gain new insights from these data. The analytical results are persisted again within SAP BW. Examples ABC-classification (e.g. customer/vendor) Determination of the frequency distribution in datasets Development of Scoring information … Feature Description Interactive modeling (drag&drop) workbench for analysis processes Infrastructure to link up process elements, being sources (selection of data), targets (deployment of results), pre-processing (transformation) and visualization tools as well as data analysis methods. Analysis of data at every step of the analysis process


BEx Query, Analysis & Reporting :BEx Query, Analysis & Reporting Reporting Capabilities Tabular Reporting Query with diverse columns in free alignment No distinction between characteristics and key figures Option to switch between tabular and OLAP view Foundation for formatted reporting with Crystal Reports Desktop or web Analyze data from different sources SAP or non-SAP Extendable reporting templates provided with Business Content


BEx Query, Analysis & Reporting Integration with Crystal Reports :BEx Query, Analysis & Reporting Integration with Crystal Reports Out of the box presentation-quality reporting Reports and documents optimized for printing and sharing Broad range of pre-defined Crystal reports: legal, financial, etc SAP BW and non-SAP BW data in a single report Seamless portal integration Schedule and view Crystal reports in managed web environment Offline reporting and viewing of reports


BEx Overview Agenda :BEx Overview Agenda BI End User Requirements Business Explorer (BEx) Product Capabilities Query, Analysis & Reporting BEx Web & BEx Analyzer BEx Information Broadcasting Conclusion


BEx Web: Key Capabilities :BEx Web: Key Capabilities Provide and analyze information via a Web Browser (PC or mobile) Ease-of use Zero Footprint Quick ROI Packaged BI web applications and predefined BI Patterns Alerting Pro-active notification Analytical complexity when needed Full interactivity or guided navigation depending on end-user requirements Filter Drill-down Slice and dice flat lists etc. BEx Web Analyzer for Power Users Performance HTML Compression Precalculated or cached data optional usage of the Portal cache


BEx Web: Design of BI Web Applications :BEx Web: Design of BI Web Applications BEx Web Application Designer Offers the ability to create a wide range of easy to use Web Apps Direct access via Web & Mobile devices Build intuitive & custom BW Web Applications Cockpits / Dashboards DropDowns, Radio Buttons Tickers Charts & Maps Guided Navigation Device specific output generation Portal integration APIs for further web design


BEx Web Application Example :BEx Web Application Example Example: Analyze Sales vs. Market Potential in the States of the US


BEx Web Application Example :BEx Web Application Example


BEx Web: BI Patterns for Quick ROI :BW Business Content will be based on consistent UI Patterns (starting November 2004) Pattern 1 (“Casual User”) Pattern 2 (“Information Consumer”) Pattern 3 (“Knowledge Worker”) Pattern 4 (“Analyst”) BEx Web: BI Patterns for Quick ROI low high BI knowledge


Information Consumer Pattern (all features) :Information Consumer Pattern (all features)


BEx Web Application Framework :InfoProvider BEx Web Application Framework Web Design Tool (optional) OLAP Processor BEx Web Application Designer BEx Query Designer BW Server with SAP Web AS Web Service Charting Engine Web Browser HTML Templates


BEx Analyzer :BEx Analyzer Share and analyze information via a Windows Desktop using MS Excel Queries & Solution Workbooks embedded in MS Excel Wide Range of delivered content Additional MS Excel Functionality (Calculations, Charts etc.) VBA Programming Workbook Precalculation Seamless integration of Query Designer Seamless integration between BEx Web & BEx Analyzer


BEx Overview Agenda :BEx Overview Agenda BI End User Requirements Business Explorer (BEx) Product Capabilities Query, Analysis & Reporting BEx Web & BEx Analyzer BEx Information Broadcasting Conclusion


BEx Information Broadcasting (1) :BEx Information Broadcasting (1) Information Broadcasting allows the distribution of BI information ... via different channels ... () E-Mail () Enterprise Portal ... in different formats ... () HTML, MHTML () BEx Analyzer Workbooks () ZIP Files … of different sources … () BI Web Applications - Dashboards, cockpits () BEx Analyzer Workbooks () Queries … in different modes… () Online & pre-calculated


BEx Information Broadcasting (2) :BEx Information Broadcasting (2) Information Broadcasting supports different business scenarios () Event based (“Intelligent push”) Integration into process chains E.g. If new data is loaded into the data container (InfoCube) () Ad hoc BEx Broadcasting Wizard for one-step distribution () Scheduled BEx Broadcaster Guided scheduling times (for end users / information consumers) Scheduling at any time (for power users / administrators)


Slide 52:User-Type Specific Information Broadcasting


Information Broadcasting – BEx Portfolio :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


Information Broadcasting & Collaboration Rooms :Information Broadcasting & Collaboration Rooms Queries, Web Applications & Workbooks can be broadcasted into Collaboration Rooms Collaboration Rooms Services Chat Application Sharing Notes Meeting Pad Discussion Forums Instant Messaging My Portal Contacts


The Broadcaster Wizard :The Broadcaster Wizard The BEx Broadcaster Wizard can be conveniently launched from the context menu


BEx Overview Agenda :BEx Overview Agenda BI End User Requirements Business Explorer (BEx) Product Capabilities Query, Analysis & Reporting BEx Web & BEx Analyzer BEx Information Broadcasting Conclusion


SAP BI Delivers a Comprehensive Solution :SAP BI Delivers a Comprehensive Solution Authors and analysts Need advanced analysis functionality and ad-hoc data exploration capabilities Require useful, manageable tools Executives and knowledge workers Require personalized information in context via an intuitive user interface Want predefined analysis paths and the option of in-depth analysis of summary data Information consumers Need a snapshot of a particular data set to perform their operational tasks Do not interact extensively with the data. Executives and Knowledge Workers: BEx delivers.. Easy to use web applications with eg. push buttons, drop downs, interactive charts Role based and personalizable access from any web browser and mobile device Pro-active alerting with extensive drilldown capabilities Authors and analysts: BEx delivers.. Windows and Web based Query & AdHoc Query Design Intuitive design tool for Dashboards Intuitive Distribution & Broadcasting channels Powerful OLAP capabilities and seamless Integration into MS Excel Information Consumers: BEx delivers.. Pattern based Business Content (e.g. for casual users, information consumers…) flat reports and/or guided navigation Integrated KM services


Business Explorer – Users, Needs and Functions :Business Explorer – Users, Needs and Functions Query, Analysis & Reporting BEx Web & BEx Analyzer EP Integration & Information Broadcasting Knowledge Worker Analyst / Author Information Consumer Query Design Ad hoc Query Design OLAP Analysis Web Application Design / VB macros Web Application Publishing Static and / or Guided Navigation BEx Analyzer / BEx Web Analyzer / Web Queries Solution Workbooks Web Applications / Dashboards BEx Broadcaster BI iViews BEx Broadcaster Wizard BEx Portfolio Pro-Active Alerts


Download Scheduler for Offline Reporting :Download Scheduler for Offline Reporting Scheduled or immediate Download Web Templates, Excel Sheets Excel Sheets Web Templates Web Templates (optimized for PDAs)


Information Deployment :Information Deployment Personalized information and decision support for all users Share and analyze business information Analytics in context Collaborative BI Seamless Integration of BI Web Applications into the Enterprise Portal


Overview: BW Open Analysis Interfaces and BI Java SDK Architecture :OLE DB for OLAP Based Component Object Model (COM) Driver (DLLs) installation on clients Windows platform only OLAP BAPIs Business Application Programming Interface Based on Remote Function Call (RFC) RFC library available on any SAP platform XML for Analysis Based on XML as exchange format Based on HTTP/SOAP protocol Any platform Overview: BW Open Analysis Interfaces and BI Java SDK Architecture BI Java SDK Object Oriented Java API for consuming XMLA services Encapsulates communication protocol (HTTP,SOAP), MDX generation and parsing Web API aimed at Web designers that want to create Web applications for highly individual scenarios based on Java Script, Dynamic HTML and/or ABAP OO XML Query Result Simple Web Service-based interface for accessing BW queries or query views XML as result format ODS Read BAPI Interface for accessing data from ODS objects Open Hub Service Interface for mass data transfer from SAP BW to 3rd party products Delta capabilities and enhanced monitoring


Agenda :Agenda Positioning / Value Proposition Data Warehousing - ETL BI Platform BI Suite SAP NetWeaver ‘04 Integration Business Content Roadmap


SAP Netweaver™ Turning Enterprise Services Architecture Vision Into Reality :SAP Netweaver™ Turning Enterprise Services Architecture Vision Into Reality SAP Netweaver™ Composite Application Framework PEOPLE INTEGRATION Multi channel access Portal Collaboration INFORMATION INTEGRATION Bus. Intelligence Master Data Mgmt Knowledge Mgmt PROCESS INTEGRATION Integration Broker BusinessProcess Mgmt APPLICATION PLATFORM J2EE DB and OS Abstraction ABAP Life Cycle Mgmt … The open integration and application platform for TCO reduction Integrate people, information and processes… … in 1 hub … … across technologiesand organizations. Enterprise-scale Java and ABAP application platform .NET and WebSphere interoperability and extensibility Pre-configured with business content Adapters to non-SAP


Information Integration and BI :Information Integration and BI DB and OS Abstraction SAP Netweaver™ Information Integration People Integration Knowledge Management Knowledge Management Integrate & unify multiple sources of unstructured content Common services Indexing, classification, search Publish & subscribe Authoring, versioning, … Rating, discussion forum, … For use in business applications & stand-alone What it means for BI: Base decisions on hard & soft facts Common context for reports & documents Explain insights and definitions (e.g. terminology) Annotate BI data and meta-data Share & disseminate insights Participate in knowledge management services Enterprise search


People Integration & Business Intelligence :People Integration & Business Intelligence DB and OS Abstraction SAP Netweaver™ Information Integration People Integration Portal Simplify the life of the user Role-based & personalized Unify complex application landscape Any source, secure & robust Provide task context Enable new composite applications What it means for BI: Empower more people within & beyond the enterprise Disseminate the right information to the right user at the right time Alert timely and allow for immediate action BI for the masses Close the loop from insights to action Task context Seamless navigation


Collaboration & Business Intelligence :Collaboration & Business Intelligence DB and OS Abstraction SAP Netweaver™ Information Integration People Integration Collaboration Enable teams Easily share information and applications across roles Communicate in real-time or asynchronously Manage team activity SAP and non-SAP collaboration technologies What it means for BI: Support the decision making processes Broadcast BI data to teams and individuals Integrate data into collaboration rooms Send alerts to teams & individuals Subscription services  The Solution: Information Broadcasting Powered by SAP BI


Web Application Server & Business Intelligence :Web Application Server & Business Intelligence DB and OS Abstraction SAP Netweaver™ Information Integration Application Platform Process Integration People Integration Web Application Server Homogeneous infrastructure for J2EE-based and ABAP-based applications Brings together the benefits of a proven, scalable and reliable infrastructure with the interoperability and flexibility of Web Services technology Powerful Java platform What it means for BI: Complete database and operating system portability Consistent user accecess Common alert framework


Universal Data Integration :Universal Data Integration Universal Data Integration BI Java Connectors to provide access to any data (relational, OLAP) Based on industry standards for interoperability (JDBC, XMLA, ODBO) Universal Data Connect to integrate data into the BW platform BI Java SDK for custom built Java Applications SAP OLTP non SAP SAP Query XMLA JDBC ODBO BI JavaSDK OLAP Custom-built Applications SAP Enterprise Portal Universal Data Connect 1. BI Java Connectors JDBC, XMLA, ODBO, SAP Query 2. Universal Data ConnectSAP BW Integration 3. BI Java SDK Java API, Examples, Documentation BEx BW Staging SAP BW


BI Java Connectors :BI Java Connectors Connectors for various data sources  Leverages SAP Web AS 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 190+ 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 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 The set of connectors will be extended in further SAP BW releases


SAP Web AS Integration – BI Web Services :SAP Web AS Integration – BI Web Services BI Web Services Definition of Web Service A Web Service is a software component that can be described, discovered and executed using open Internet standards such as WSDL (Web Service Description Language), SOAP, XML, HTTP For the caller or sender, a service is a black box that may require input and delivers a result. Web Service cover the provision of services for integration within an enterprise, as well as cross-enterprise services on top of any communication technology stack, whether synchronous or asynchronous Web Services are a new feature of SAP Web AS 6.40 Scenarios and Features Following Features are released as web services and can be accessed via open standards XML Data Load XML for Analysis: Connection of 3rd party front-end vendors to BW OLAP Engine XML Query Result Set (additional query format XML in addition to XLS and CSV) Example: XML Data Load The meta data for the XML Data Load (function module, DataSource, data fields) can be queried via WSDL The caller can now use XML and HTTP/SOAP to push data into the SAP BW delta queue Example: XML Query Result Set Easy to call: Compatibility Prerequisite: SAP Web AS 6.40


SAP Web AS Integration – Central Alert Framework :SAP Web AS Integration – Central Alert Framework The distribution of BW alerts via the central alert framework leverages functions of two SAP NetWeaver components: SAP BW and SAP WebAS. The central alert framework provided by the WebAS can serve as the central hub distributing alerts from all installed applications. The central alert framework of the SAP WebAS, provides the following additional functions: Send short text message via SMS or Pager. Send long text message via e-mail as well as via Fax. Recipients have the option to subscribe/unsubscribe for the alert. Existing alerting scenarios (using the Reporting Agent alerting options) can be adapted easily for alerting scenarios using the central alert framework of the WebAS. Both scenarios may be run in parallel.


BW Alerts: Options with SAP BW :BW Alerts: Options with SAP BW Web Application Server Reporting Agent BEx Query with Exception Central Alert Framework BW Send an E-Mail Create an Alert Monitor Entry Export via BAdI Send a Short Text via SMS or Pager Send a Long Text via E-Mail or Fax Other Applications


Exchange Infrastructure & BI :Exchange Infrastructure & BI DB and OS Abstraction SAP Netweaver™ Information Integration Process Integration People Integration Exchange Infrastructure Provides a technical infrastructure for XML-based message exchange Delivers business-process and integration knowledge to the customer Provides an integrated toolset for building new business scenarios by defining and maintaining all integration-relevant information What it means for BI: XI delivers message based realtime data Complements the session-oriented(scheduled) data load Real-time data address Operational Reporting requirements


SAP Exchange Infrastructure (XI) Integration :SAP Exchange Infrastructure (XI) Integration Inbound Message Processing Scenario Global Spend Scenario SAP XI as single point to channel information exchange between various systems Using SAP XI as additional source for SAP BW Event-driven and transaction-oriented New Guideline with SAP BW Guideline of integrating SAP XI 2.0 and 3.0 as a SAP BW source on basis of existing technologies (XML, http/SOAP) Compatibility Prerequisite:SAP XI 2.0or SAP XI 3.0


Master Data Management & BI :Master Data Management & BI DB and OS Abstraction SAP Netweaver™ Information Integration People Integration Master Data Management SAP MDM enables companies to store, augment, and consolidate master data Ensures consistent distribution to all applications and systems within the IT landscape. What it means for BI: Content consolidation Master Data Harmonization Central Master Data Management


SAP BW / MDM Integration Scenarios (1) :SAP BW / MDM Integration Scenarios (1) SAP MDM deliveres identifying navigational attributes for SAP BW Master data is mainly managed in the MDM Clients For Content Consolidation master data has to be load into the MDM system, where the Content Integrator Engine consolidates the master data by finding duplicate records based on predefined matching processes.Global key mapping information is the result of this process. MDM key mapping information can be used in BW as a grouping attribute for global analysis needs


MDM Content Consolidation and SAP BW :MDM Content Consolidation and SAP BW SAP MDM SAP BW SAP ERP MATNR MATNR MATNR MATNR 1 ERP Solutions Business ContentAreas Operational Reporting(localized, unified) XI MDM Scenario 1:Content Consolidation Identifying Attr.


SAP BW / MDM Integration Scenarios (2) :SAP BW / MDM Integration Scenarios (2) Dedicated Consolidated InfoObjects as MDM Business Content in BW For Master Data Harmonization reasons master data is mainly created in MDM and can be enhanced with local aspects after the distribution to the MDM Clients Consolidated Info Objects in BW are capable to implement the entire master data description from MDM in BW. Local aspects of master data administration have to be loaded seperately from the MDM clients into the BW


Master Data Harmonization between BW and MDM :Master Data Harmonization between BW and MDM Material CRM Products Articles ... SAP MDM SAP BW SAP ERP MATNR ... ... ... General Products 2 Operational Reporting(localized, identified) Strategic(global, consolidated) All Global Attr. Global Attr. Global and local Attributes XI MDM Scenario 2:MD Harmonization


Agenda :Agenda Positioning / Value Proposition Data Warehousing - ETL BI Platform BI Suite SAP NetWeaver ‘04 Integration Business Content Roadmap


Business Content – Definition :Business Content – Definition Predefined, role-based and task-oriented information models Provide technical definitions, such as extraction and transformation rules Predefined templates for reporting and analysis. For various industries and business areas


SAP BW Business Content Benefits :SAP BW Business Content Benefits Ready-to-go reports, data models, extractors, transformations Significant cut down of implementation time and costs Easily extensible Integrated view of corporate data Immediate access to interpreted information Consistency Rich set of standard key performance indicators Best practice models Integration of e-Business and ERP systems Tight integration with mySAP applications Integration with non-SAP data Web-enabled Validated and comparable information Cross-system/cross-application


Business Content – Overview (1) :Business Content – Overview (1) Customer Relationship Management Financial Accounting Controlling Strategic Enterprise Management Human Capital Management Product Lifecycle Management Supply Chain Management Supplier Relationship Management Cross X Marketplaces Non SAP System Integration Tealeaf (E-Analytics) Oracle Oracle Financials (General Ledger and Oracle Receivable) AC Nielsen (Market Analytics) Dun & Bradstreet (Market Analytics)


Slide 84:Aerospace and Defense Apparel and Footwear Automotive Chemicals Consumer Products Distributor Reseller Management Financial Services Banking Insurances Financial Service Provider Profit Analyzer Healthcare High Tech Media Oil&Gas Pharmaceuticals Public Sector Real Estate Retail Service Providers Telco Utilities Business Content – Overview (2) Industry Solutions


Customer – and Partner Content :Customer – and Partner Content Customer / Partner Content Scenario Customers centrally create templates which can be rolled out to subsidiaries (Enterprise DWH) Partners create own content which can be delivered individually to interested customers Feature Description Release of feature, which has been piloted in SAP BW 3.0B Content for objects in SAP BW as well as extractors in Service API in SAP source systems This denotes content in addition to SAP delivered Business Content Content can be shipped via transports Support of partner content only by partner Partner Content can be certified by SAP


Agenda :Agenda Positioning / Value Proposition Data Warehousing BI Platform BI Suite Netweaver Integration Business Content Roadmap


Roadmap – Timeline and Focal Points :Roadmap – Timeline and Focal Points Q1/2003 Q1/2004 2005 SAP Netweaver BW 7.0 SAP BW 3.5 Information Broadcasting Universal Data Integration Embedded BI – Integration into SAP Netweaver Business Planning & Simulation Unicode SAP BW 3.1 BI Content 3.2 Add-On BI Content 3.3 Add-On BI Content 3.5.1 Add-On BI Content 3.5.2 Add-On BI for the Expanded Enterprise Active Business Intelligence Integrated planning Advanced user experience BI Content 3.1 Add-On BI Content 3.5.3 Add-On Start of Ramp-Up


Copyright 2004 SAP AG. All Rights Reserved :Copyright 2004 SAP AG. All Rights Reserved No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice. Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors. Microsoft®, WINDOWS®, NT®, EXCEL®, Word®, PowerPoint® and SQL Server® are registered trademarks of Microsoft Corporation. IBM®, DB2®, DB2 Universal Database, OS/2®, Parallel Sysplex®, MVS/ESA, AIX®, S/390®, AS/400®, OS/390®, OS/400®, iSeries, pSeries, xSeries, zSeries, z/OS, AFP, Intelligent Miner, WebSphere®, Netfinity®, Tivoli®, Informix and Informix® Dynamic ServerTM are trademarks of IBM Corporation in USA and/or other countries. ORACLE® is a registered trademark of ORACLE Corporation. UNIX®, X/Open®, OSF/1®, and Motif® are registered trademarks of the Open Group. Citrix®, the Citrix logo, ICA®, Program Neighborhood®, MetaFrame®, WinFrame®, VideoFrame®, MultiWin® and other Citrix product names referenced herein are trademarks of Citrix Systems, Inc. HTML, DHTML, XML, XHTML are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts Institute of Technology. JAVA® is a registered trademark of Sun Microsystems, Inc. JAVASCRIPT® is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape. MarketSet and Enterprise Buyer are jointly owned trademarks of SAP AG and Commerce One. SAP, SAP Logo, R/2, R/3, mySAP, mySAP.com and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All other product and service names mentioned are trademarks of their respective companies.