Nouveauts BW 7 4 on HANA Speakers NameDepartment

Nouveautés BW 7. 4 on HANA Speaker’s Name/Department (delete if not needed) Month 00, 2013 Customer

SAP BW Today (September 2013) 14500+ Customers 200 New Installations/Month 3500+ BW 7. 3 Customers Vast majority: Central EDW, harmonizing many source systems Embedded into mission critical business processes 500+ BW on HANA Customers © 2013 SAP AG. All rights reserved. Customer 2

SAP Business Warehouse Powered by SAP HANA QUERY REPORTING ANALYTICS SAP BOBJ Busines Intelligence DATA MODELING SAP Net. Weaver BW SAP HANA PLATFORM Analytical / Planning Engine Data Management Data Storage Dramatically Improved Performance Simplified Administration and Streamlined Landscape Unlock The Power of Your Data Across The Enterprise Improved decision making, faster reporting, and the most up-to-date information Reduced administration and lower TCO Self-service access to all information at the most granular level © 2013 SAP AG. All rights reserved. Customer 3

SAP BW on HANA – Smarter, simpler, more efficient How Does BW running on RDBMS differ from BW running on HANA ? Customer value of SAP BW powered by SAP HANA SAP Net. Weaver BW SAP BW on HANA Data Modeling Process Orchestration Data Modeling Planning OLAP Data Management BWA Push Down RDBMS Traditional Stack © 2013 SAP AG. All rights reserved. Data Schema & Data Excellent query performance for improved decision making Performance boost for Data Load processes for decreased data latency Accelerated In-Memory planning capabilities for faster planning scenarios Flexible combine EDW with HANA-native data for real-time insights and decision making Data persistency layers are cut off and reduced administration efforts Simplified data modeling and remodeling Data intensive functions are pushed down from BW to HANA as the Primary Database for BW and Foundation for new Applications HANA Stack Customer 4

Push Down List Planned with SAP BW 7. 4, SP 5 and future SPs on HANA BW / BEX Query Designer Analytic Manager OLAP Features pushed down to HANA in BW 7. 3 x • Hierarchy Handling Part I • Restricted key figures • Exception Aggregation CNT for quantity key figures without unit conversion • Exception Aggregation of currency key figures with optional currency conversion BW Query BW Application Server Calculation and Planning Engine Calc. -views / Calc. scenarios Row & Column Storage In Memory Database © 2013 SAP AG. All rights reserved. OLAP Features pushed down to HANA in BW 7. 4 SP 5 • Processing of further query scenarios in HANA (Joins, Union, etc. ) • Avoid intermediate result set materialization (e. g. Exception Aggregation) OLAP Features pushed down to HANA in BW 7. 4 SP 6 and beyond • Handling of inventory keyfigures • Stock coverage keyfigure • Hierarchy Handling Part II • Formula exception aggregation Customer 5

SAP BW 7. 4, SP 5 – Overview Planned with SAP BW 7. 4, SP 5 on HANA Enhanced Data Modeling Common Eclipse based Modeling Tools BW/HANA Smart Data Access providing the logical EDW Easy integration of external data models with Open ODS Layer Further reduce data layers in BW via Operational Data Provisioning BW Queries, ODATA, MDX, SQL BW Virtualization Layer Architected Datamart Layer Push down further processing logic to HANA Transformations EDW Core Layer Transformations Open Operational Data. Store Layer HANA tables, views Data. Store Objects BW Schema HANA Schema Agile Datamarts BW Workspaces BW Analytic Manager HANA Analysis Processes BW Transformations PAK – Pushing down more planning semantics Enhanced mobile enablement Converged planning solutions BW Content optimized for HANA External Sources © 2013 SAP AG. All rights reserved. Customer 6

HANA Smart Data Access for SAP BW

Smart Data Access Planned with SAP BW 7. 4, SP 5 on HANA Enhanced Business Flexibility by providing “the logical EDW” Query Data Federation in diverse EDW landscapes • Smart data access – read access to relational and non-relational sources via ODBC • Enables access to remote data access just like “local” table • Supports data location agnostic development • No special syntax to access heterogeneous data sources • BW based Analytic Services on external data BW Virtualization Layer Composite Provider, Open ODS View HANA Tables Virtual Tables Scenario HANA Smart Data Access Layer IQ Teradata Hadoop © 2013 SAP AG. All rights reserved. ASE SAP HANA • Make other DWHs transparent to HANA • Non-disruptive evolution from virtual table to persistent structure by establishing ETL without major effort • Consolidating / rationalizing the DWH landscape • Consumption of HANA datamart scenarios from second HANA database Customer 8

Field based modeling in BW on virtual HANA Tables Planned with SAP BW 7. 4, SP 5 on HANA Virtual Access BW Managed Persistence * Virtual Access BW Query Open ODS Layer Open ODS View Virtual DSO w/ fields* Persistent BW on HANA Virtual Table Smart Data Access Table/View * Pilot only (Note 1922533) © 2013 SAP AG. All rights reserved. Table/View External Sources Open ODS View offers • Metadata object as an abstraction layer for underlying source object • HANA virtual tables as supported source objects via SDA • Querying on field level • Supported for Teradata, Sybase ASE/IQ, Hadoop • Optimized Query execution by pushing down to HANA • Supported scenarios: - Virtual Access - Persistent Access * o Switch from Virtual to Persistent * o Based on Field based DSO including DTP and Transformation o Direct staging into DSO bypassing PSA o No need to adjust existing queries Easy assignment of semantics • Underlying object (Table, DB View, Data. Source) can be tagged as Text, Master data or Facts • Single fields of the object can be linked to already existing Open ODS Views or Info. Objects Customer 9

Data Provisioning

Operational Data Provisioning (ODP) Technology Planned with SAP BW 7. 4, SP 5 on HANA Subscriber / Consumer Provider SLT * SAP Data. Services Operational Data Provisioning SAP ERP Extractors ODQ HANA Views * Target BW * Source BW © 2013 SAP AG. All rights reserved. Embedded Analytics Unified technology for data provisioning and consumption Enables extract once deploy many architectures for sources Unified configuration and monitoring for all provider and subscriber types Time stamp based recovery mechanism for all provider types with configurable data retention periods Highly efficient compression enables data compression rates up to 90% in Operational Delta Queue (ODQ) Quality of service: „Exactly Once in Order“ for all providers Intelligent parallelization options for subscribers in high volume scenarios *) New with SAP BW 7. 4 Customer 11

Simplified data provisioning from SAP ERP and SAP BW Planned with SAP BW 7. 4, SP 5 on HANA Provider ERP Extractors SAP BW DTP w/o PSA ODP Data. Source Operational Delta Queue (ODQ) Extractors (BW SAPI Data. Sources) Table ERP Source System © 2013 SAP AG. All rights reserved. DTP w/o PSA DSO ODP Data. Source Info. Cube Operational Delta Queue Master. Data DSO • Direct Update to BW Info. Providers – PSA not required - Scheduled or real – time daemon - Automatic change notification for daemon • Consumption by multiple subscribers Provider BW • Enables direct staging between Info. Providers of source and target BW systems • PSA not required • Consumption of ODQ by multiple BW subscribers and SAP Data Services Benefits Table • • Simplified data flow PSA no longer required Flexible recovery options Stream lined system communication - Synchroneous RFC replaces ALE/IDoc Customer 12

Given SAP ERP Business Content Data. Source with Direct Access Example: Financials - Customer Balances (0 FI_AR_20) BCT Data. Source © 2013 SAP AG. All rights reserved. 1. ODP Source System – SAP Extractors 2. Data. Source 3. Fields 4. Extractor Capabilities Customer 13

New ODP Source System Types in BW 7. 40 ODP for SAPI Sources ODP for SLT supported DBMSs © 2013 SAP AG. All rights reserved. Customer 14

Open ODS View - Seen via SAP BO Analysis for MS Excel © 2013 SAP AG. All rights reserved. Customer 15

Architecture with source systems, ODP/SLT system and Subscribers Source System SAP Net. Weaver ECC DMIS Application table Logging table DB trigger Any. DB § Subscriber Systems ODP/SLT System SAP Net. Weaver BW SAP LT Repl. Server DMIS ODP Framework RFC DMIS ODP Framework User SAP Data Services ODQ ODP Rep API ODP Framework HTTP Webservice DMIS 2011 SP 5 (SAP LT Replication Server 2. 0 Add-on) required on: source systems, ODP/SLT system, SAP BW system (for source system also possible with DMIS 2011 SP 3/SP 4 and DMIS 2010 SP 8/SP 9 with SAP Note 1863476) § ODP Framework required on: ODP/SLT system and Subscriber systems Current Subscribers for the ODP/SLT Scenario § SAP NW Business Warehouse (release >= 7. 30) § SAP Business Objects Data Services 4. 2 SP 1 (RTC Q 4/2013) © 2013 SAP AG. All rights reserved. Customer 16

Eclipse based Modeling Tools

Common modeling tools Planned with SAP BW 7. 4, SP 5 on HANA BW Modeling Tools SAP HANA Studio Eclipse Platform © 2013 SAP AG. All rights reserved. ABAP Development Tools Common user experience via a central, unified modeling environment Attractive, flexible and simplified BW modeling tools Harmonization BW and HANA modeling environments Integration of BW and HANA models in one modeling approach Integrated development & modeling environment across – SAP HANA Modeler, – BW Modeling o New developed native Eclipse based modeling tools for Open ODS View and New Composite. Provider – ABAP Development Tools – … Customer 18

HANA Analysis Processes

HANA Analysis Process Planned with SAP BW 7. 4, SP 5 on HANA Enhanced analysis capabilities Execute HANA-native functions directly on BW Info. Provider data e. g. : BW Process Management – Clustering, association algorithms, regression analysis, anomaly detection, weighted score, exponential smoothing, etc. Source Function Target BW Info. Provider AFL(PAL, …), Procedure, L-Script, R-Script BW Info. Provider © 2013 SAP AG. All rights reserved. Execute complex and data intensive processes on HANA without loosing the integrity and integration with the BW environment Materialize the result of a HANA Analysis Process in HANA for further processing – automated Supporting also a scheduled batch processing use case Customer 20

HAPs in details Planned with SAP BW 7. 4, SP 5 on HANA Sources Most BW Info. Provider Database tables Supported procedures/algorithms AFL-functions (PAL, …) L-script, R-script, SQL-script procedure. Supported output Analytic Index (modeled/generated/virtual), DSO, database table HAP Input (“stacked HAPs”) Staging integration © 2013 SAP AG. All rights reserved. stand-alone, triggered via APIs from applications, process chain variant, source of a DTP Customer 21

Transformations

SAP HANA optimized Transformations Application Server Planned with SAP BW 7. 4, SP 5 on HANA BW 7. 3 x on any. DB BW 7. 3 x on HANA BW 7. 4 on HANA DSO DSO Activation Transformation Database Activation Transformation Data © 2013 SAP AG. All rights reserved. Data Next level of performance in data staging for BW on HANA Standard Transformations are gradually optimized to be processed directly in SAP HANA by generating according DB procedure First set of Transformations optimized i. e. : – – – Mappings Conversions (time, currency, units) Formulas Read Master Data, Read from DSO Expert routine for HANA SQL script. . . Sources: PSA, DSOs, Info. Cubes, SPOs, Composite. Provider, Multi. Provider Targets: DSO Customer 23