WIXLIB

SAP BW/4HANACustomerEDW Product ManagementFebruary 2017 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer1

DisclaimerThis presentation is not subject to your license agreement or any other agreement with SAP. SAP has noobligation to pursue any course of business outlined in this presentation or to develop or release anyfunctionality mentioned in this presentation. This presentation and SAP's strategy and possible futuredevelopments are subject to change and may be changed by SAP at any time for any reason without notice.This document is provided without a warranty of any kind, either express or implied, including but not limitedto, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. SAPassumes no responsibility for errors or omissions in this document, except if such damages were caused bySAP intentionally or grossly negligent. 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer2

What is an Enterprise Data Warehouse?Functions of the Enterprise Data Warehouse (EDW)Characteristics Consolidates data across theenterprise Standardized data model Supports decision makingAnalyticsBusiness Intelligence, Predictive, PlanningFeedingexternalsystemsData WarehouseBig Data“Single Point of Truth”HadoopPlanning &ForecastStreamingVirtual AccessETLData SourcesSAP, non-SAP, On premise, Cloud 2017 SAP SE or an SAP affiliate company. All rights reserved.ELTMain Tasks Define common semantics Harmonize data values Establish a ‘single version oftruth’ Provide a single, comprehensivesource of current and historicalinformation Keep copy of source data toensure independency of sourceand support the unknownCustomer3

Modern Challenges for Enterprise Data WarehousesData Different Locations – cloud, data lakes Additional Types – behavioral data, IoT(Structured and Unstructured) Higher Volumes – 40% growth YoYPeople Better Performance – real-time results Greater Scope – predictive, agile analytics Added Value – new & unused data ( 85%) 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer4

SAP Business Warehouse - Today16000 SAP BW Customers8000 SAP BW 7.3 / 7.4 Customers4000 Vast majority use SAP BW as central EDW,harmonizing many source systemsEmbedded into mission critical businessprocessesContinuously growing SAP HANA adoptionStrategy to run simple with SAP BWSAP BW on SAP HANA Customers 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer5

SAP BW/4HANA – The Next Generation Data WarehouseSAP BW 7.3powered bySAP HANAPerformanceoptimizationSAP BW 7.4powered bySAP HANASimplification andVirtualizationSAP BW 7.5powered bySAP HANASimplification,HANA platformintegrationBig DatascenariosSAP BW/4HANAStarterAdd-onFor SAP BW/4HANAcustomers onlyIntroducing SAP BW/4HANAUse transfer toolsto make system readyfor SAP BW/4HANABuilt for Cloud and on premiseRequires SAP BW 7.5SP 4 or higher20122013 2017 SAP SE or an SAP affiliate company. All rights reserved.2015The Next Generation Data WarehouseLogical Data WarehousingInternet of ThingsIntegrates with Big Data2016Customer6

THE NEXT GENERATION DATA WAREHOUSEANNOUNCING SAP BW/4HANASAP BW/4HANA is a new data warehouse solution is highly optimized for SAP HANA solves analytics problems in seconds that take other systems days accelerates solution development means you have one version of the truth is ready for the internet of things at petabyte scaleSimplicityOpennessSAP BW/4HANADesign PrinciplesModernInterfaceHighPerformanceThe transition from standard SAP BW to SAP BW/4HANA can be compared with the transition of the SAP Business Suite to SAPS/4HANA. As part of this transition, SAP BW/4HANA will drastically reduce the number of data objects to be stored and maintained,similar to the elimination of aggregates in SAP S/4HANA. 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer7

SAP BW/4HANABenefit from SAP Modern Data Warehouse CapabilitiesBusiness AgilityCloud ReadyModern Data WarehouseThe flexibility tocompete in real timePrototype new ideas ona Cloud that grows withyour businessHigh performance,future-proof platform forall new challenges 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer8

SAP BW/4HANA HighlightsSimplicityOpenness– Simplified Data Structures Native SQL access Simplified Data Flows Simplified Data Integration Data Lifecycle Management Consolidated Source SystemsModern InterfaceHigh Performance New Business User UX In-Memory Data Warehousing New Modeler UX Algorithm Pushdown New Administrator UX Advanced Analytics 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer9

SimplicitySimplified Data StructuresSimplified Data FlowsData Lifecycle Management 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer10

SAP BW/4HANA – Simplified Data Structures Number of Modelling object typesreduced from 10 to 4 No complex data structures(extended star schema)VirtualizationClassic SAP BW1MultiProvider2InfoSet3CompositeProvider4Virtual Provider5Transient Provider6InfoCube7DataStore Object8Hybrid Provider9PSA Table10InfoObjectSAP BW/4HANA1CompositeProvider2Open ODS View3Advanced DataStore Object4InfoObject Greater control of data persistencyand virtualization Support for external, structuredand unstructured data 2017 SAP SE or an SAP affiliate company. All rights reserved.Persistency Field or InfoObject based ModellingCustomer11

SAP BW/4HANA – Simplified Data FlowsFrom Layered Scalable Architecture (LSA) to LSA SAP BW/4HANA (LSA )Classic SAP BW (LSA)VirtualizationVirtualization, Virtual Data edDWHtop down ModellingIntegrated DWHbottom up Modellingtop down ModellingData MartsRaw DWHmandatorylayerRaw DWHStagingoptionallayersdependingon requiredbusinessand servicelevelSourceService Level 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer12

SAP BW/4HANA – Simplified Data FlowsVirtual Data MartsDataMartsIntegratedDWHtop down Modellingbottom up Modelling Report at any layer of the DataWarehouse with speed andflexibilitySAP BW/4HANA (LSA )Raw DWHStagingSourceService Level 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer13

SAP BW/4HANA – Simplified Data FlowsDataMartsIntegratedDWHtop down Modelling Virtually combine data acrosslayersVirtualizationbottom up Modelling Report at any layer of the DataWarehouse with speed andflexibilitySAP BW/4HANA (LSA )Raw DWHStagingSourceService Level 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer14

SAP BW/4HANA – Simplified Data Flows Business and service level drivenDataMartsIntegratedDWHtop down Modelling Virtually combine data acrosslayersVirtual Data Martsbottom up Modelling Report at any layer of the DataWarehouse with speed andflexibilitySAP BW/4HANA (LSA )Raw DWHStagingSourceService Level 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer15

SAP BW/4HANA – Simplified Data Flows Business and service level driven Combining bottom-up and topdown modelling approaches –allows for agile and flexibledevelopmentDataMartsIntegratedDWHtop down Modelling Virtually combine data acrosslayersVirtual Data Martsbottom up Modelling Report at any layer of the DataWarehouse with speed andflexibilitySAP BW/4HANA (LSA )Raw DWHStagingSourceService Level 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer16

SAP BW/4HANA – Simplified Data FlowsLogical Data Warehousing with SAP BW/4HANA Non-hierarchical, loosely coupled Information Areas Clear service definitions Communication, Integration, Orchestration rulesData LakeVirtual DataMartsERP,SAP unication, Integration & OrchestrationSAP HANA & BW gingRaw DWHIntegrated DWH 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer17

SAP BW/4HANA – Data Lifecycle ManagementScale SAP BW/4HANA using in-built data temperature managementSAP HANAMasterNodeSlave 1Slave 3SAP IQ /ExtensionSlave 1Slave 2ExtensionSlave 2ExtensionSlave 3HadoopStandbyHot SAP HANA in-memoryWarm SAP HANA Extension NodeCold Near-line StorageDefaultBy aDSO or partitionBy data time slice 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer18

OpennessNative SQL accessSimplified Data IntegrationSimplified Source Systems 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer19

SAP BW/4HANA – Native SQL AccessSAP HANASAP InfoObjectSAP BW/4HANA logic and data canbe exposed to SAP HANAAutomaticallyGeneratedCalculationView *CalculationViewCalculationView *CalculationViewCalculationView *HANA View/ TableCalculationView *Automatic generation of SAP HANAviews allows: SQL logic on top of generatedviewsSQLaccess tofront –endtools SQL access for front-end tools* SAP BW/4HANA Generated HANA view 2017 SAP SE or an SAP affiliate company. All rights reserved. Combined data from native SAPHANAGenerated SAP HANA views are partof SAP BW/4HANA lifecycle and SAPBW/4HANA securityCustomer20

SAP BW/4HANA – Simplified Data IntegrationSAP BW/4HANAODP Source SystemHANA Source SystemSAP HANAfull/delta load/real-timereplicationEIM – Smart Data urcesAdapterHive3rd opText Replicate data in real-time (HANASDI based replication or via ODP especially with ODP-SLT) Access data virtuallyODQASE, ECC,HANALeverages SAP HANA EIM to providenew data provisioning opportunitiesStructured Social Media EmailSLTExtractorsBWABAPCDSBusinessByDesign Load data using optimizedprocessingOr automatically switch between thedifferent methodsCheck full list of supported SDI sources here 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer21

SAP BW/4HANA – Simplified Source SystemsAll SourcesClassic SAP BW1DB Connect2UD Connect3SAP Data Services4BAPI/PartnerWeb ServicesUploadSAP Sources/File1HANA Source System6ODP7Extractor (SAPI)8BW9Web Services *10File 2017 SAP SE or an SAP affiliate company. All rights reserved.Number of Source System Typesreduced from 10 to 4 HANA Source System for all databaseand file connectivityHANA Source SystemBig Data5SAP BW/4HANA2Big Data**3ODP ODP Source System for SAP backendsystems and SLT File Source System Big Data Source System4File* Planned** Connectivity to Spark (SQL) Destination already possible with the HANA Source System in BW 7.50on HANACustomer22

Modern InterfaceNew Business User UXNew Modeler UXNew Administrator UX 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer23

SAP BW/4HANA – New Modelling User InterfaceSAPGUISAP BW/4HANA Modelling Toolsintegrated with SAP HANA Studio 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer24

SAP BW/4HANA – New Business User InterfaceSAP BusinessObjects Analysis OfficeSAP BusinessObjects CloudBW Business Explorer (BEx)SAP BusinessObjects Design Studio 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer25

SAP BW/4HANA – New Interface for AdministratorsABAP Process Chain MonitorUI5-based Process Chain Monitor 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer26

High PerformanceIn-Memory Data WarehousingAlgorithm PushdownAdvanced Analytics 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer27

SAP BW/4HANA – In-memory Data WarehousingQuery all data at the speed of SAP HANANo Aggregates or Roll-up ProcessesNo Performance Specific ObjectsFewer IndexesFaster Loading and Processing 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer28

SAP BW/4HANA – Algorithm Push-downSAPonBWAnyDBon AnyDBBWSAP BW/4HANAData ModellingOLAPData Data ModellingOLAPData ManagementPlanningPlanningAny DBSAP HANASignificant performance gain throughpush-down of operations/calculations OLAP Engine, complex querycalculations(e.g. exception aggregation) Planning functions(e.g. disaggregation)Pushdown Data management(e.g. transformation logic) 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer29