SAP BW/4HANA Overview And Road Map

Transcription

SAP BW/4HANA – Overview and Road MapProduct Management, SAP Data WarehousingSeptember, 2019PUBLIC

DisclaimerThe information in this presentation is confidential and proprietary to SAP and may not be disclosed without the permission of SAP.Except for your obligation to protect confidential information, this presentation is not subject to your license agreement or any other serviceor subscription agreement with SAP. SAP has no obligation to pursue any course of business outlined in this presentation or any relateddocument, or to develop or release any functionality mentioned therein.This presentation, or any related document and SAP's strategy and possible future developments, products and or platforms directions andfunctionality are all subject to change and may be changed by SAP at any time for any reason without notice. The information in thispresentation is not a commitment, promise or legal obligation to deliver any material, code or functionality. This presentation is providedwithout a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for aparticular purpose, or non-infringement. This presentation is for informational purposes and may not be incorporated into a contract. SAPassumes no responsibility for errors or omissions in this presentation, except if such damages were caused by SAP’s intentional or grossnegligence.All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ materially fromexpectations. Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates,and they should not be relied upon in making purchasing decisions. 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC2

AgendaOverviewProduct Road MapConversion Paths 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC3

Overview

SAP Data Warehousing - Statement of directionEstablish SAP Data Warehousing as the leading datawarehousing offering in order to enable the IntelligentEnterprise: Cloud-, on-premises and hybrid deploymentsSAP Data WarehousingSAP Data Warehouse Cloud Logical data warehousing support Integration of any data type and sourceSAP HANA Cloud Scale out to high data volumes and data lakes Out-of-the-box and cross-industry business content Continuous innovations in SAP Data Warehouse Cloud,SAP SQL Data Warehousing and SAP BW/4HANASAP SQLData WarehousingSAP HANAON-PREMISESHYBRID 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICSAP BW/4HANASAP HANACLOUD5

SAP BW/4HANA – The Evolution From SAP BW/4HANA 1.0 to 2.0 The next generation data warehouse Builds on the innovations of SAP BWpowered by SAP HANA Leaves behind the legacy of SAP BWon any DB Enhanced Data Tiering Optimization(DTO) options to reduce TCO Enhanced Master Data Loads Tight integration with SAP Data Hub Analytical Engine Improvements Data Tiering Optimization (DTO) tomanage hot, warm and cold data tiers2016 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC Unified UI for all SAP BW/4HANAModeling Aspects (DTP andTransformation Editor) SAP's vision for a modernpackaged data warehousingsolution SAP BW/4HANA Web Cockpit assingle entry point for administrationand monitoring Simplified in every aspect of datawarehousing New Storage Options for DataTiering Optimization (DTO)20172018 Smart integration of all businessapplications and modern datasources20197

SAP BW/4HANA ArchitecturePlanningBusiness User Tools3rd PartyAnalyticsSAP AnalyticsBPC PlanningSAP BW/4HANA is a new (innovation) code line not part of and does not depend on aNetWeaver delivery based on the ABAP applicationserver and SAP HANADeveloperToolsSAP BW/4HANA ApplicationWorkspacesAnalytical Open HubData WarehousingODP running on premise or in the cloud not the legal successor of SAP BWpowered by SAP HANA the “logical successor” of SAP BWpowered by SAP HANA 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICSAP HANA PlatformSAP HANAModellingToolsArchiveODPAFLCalcEngDBEIMSDASAP IQ/HADOOPFileSources3rdPartyETLNonSAPSAPSourcesSAP VoraHadoop8

SAP BW/4HANA Design PrinciplesHigh PerformanceOpennessSimplicityModern Interface10-100x faster queryperformanceEasier accessto all informationReduceddevelopment effortsNew user interface forall usersPowerful transitiontoolsLeverage huge amountsof data in real timefor competitive advantageWork with HANA in BWmode, or in native SQLmode, or bothGet up and runningsooner and keeprunning at lower costSimplify access foreveryone, not justdatabase expertsConvert models, flows,and data from SAP BWto SAP BW/4HANA 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICConversion9

Simplicity: Simplifying the ModelsClassic SAP BW No complex data structures(extended star schema)Virtualization Number of Modelling object typesreduced from 10 to 4 (60% ual Provider5Transient Provider6InfoCube7DataStore Object1CompositeProvider2Open ODS View3DataStore Object (advanced)4InfoObjectField or InfoObject based modellingGreater control of data persistencyand virtualizationSupport for external, structured andunstructured data 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICPersistency SAP BW/4HANA8Hybrid Provider9PSA Table10InfoObject10

Simplicity: Simplifying the DataflowsVirtualization/ Virtual Data Marts Report at any layer of the DataWarehouse with speed and flexibility Combining bottom-up and top-downmodelling approaches allows for agileand flexible developmenttop down Modelling Business and service level drivenArchitectedData Martbottom up Modelling Virtually combine data across layersmandatorylayerPropagation Layer/Integrated DWHOpen ODS Layer/Raw DWHoptionallayersdepending onbusinessneedsand requiredservice levelStaging Layer/Corporate MemorySource 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC11

Simplicity: Simplifying the Data Aging ProcessScale SAP BW/4HANA usingData Tiering Optimization(DTO) Consistent approach for hot,warm and cold dataAllocate temperature bypartitionDisplace data automaticallybetween hot, warm and coldstorageSupport for cold storage inSAP HANA Vora (diskengine) and Hadoop FileSystem (HDFS)Support for multipleextension nodes 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICSAP HANAExtension NodesSAP IQHadoopHot DataWarm DataCold DataSAP HANA in-memorySAP HANA in-memoryExtension Node with relaxedmemory requirementsSAP IQ / Hadoop storage /SAP VoraAllocate by aDSO or aDSOAllocate by aDSO or aDSOAllocate by aDSOpartitionpartitionpartitionAutomatic Displacement of Data12

Simplicity: New Chart Types for SAP Analytics Cloud on SAPBW/4HANA 2.0Feature DescriptionNew SAP Analytics Cloud Chart Types Support for additional chart types with SAC Liveconnection Waterfall ChartGeospatialTime SeriesVariance ChartLinked Analysis with more than one dimensionConditionsTuple FilterBenefits New visualization capabilities 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC13

Openness: Comprehensive Access to all DataSAP BW/4HANA simplifies dataintegration, offering comprehensiveaccess to external systems Number of source system typesreduced from 10 to 4 Replicate data in real-time (HANASDI based replication or via ODP especially with ODP-SLT) Access data virtuallySAP BW/4HANAHANASource SystemODPSource SystemLoad data using optimizedprocessingSAP HadoopExtractors SLTBWHIVEABAPCDSdataloadBig DataSAP DataNon-SAP DataSocial Media Structured 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICFileSource SystemSAP HANAODQ Big DataSource SystemFileSPARK VORAHadoopFileBusinessByDesign14

Openness: Big Data Integration with SAP Data HubStore & onsole3rd RSESTREAMCOPYBATCHSAP BW/4HANAMODELLINGSAP Data HubMasterMasterDataDataHadoop(HDFS) 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICExample ScenarioOrchestrateSAP PA / SparkScala / PythonSAP Analytics CloudAccess Combine refined big data with enterprisedata and corporate master data Extract or federate data intoSAP BW/4HANA Ingest data into S3 as landing zone for dataOrchestrate and schedule all related processesImplement transformations and data pipelinesHarmonize data structures and look up ofreference data Execute operations on large data volumes15

Openness: Big Data Integration with SAP Data HubIntegration with SAP Data Hub StartData Hub Task Workflows fromBW/4HANA Process Chain SpecificProcess Type “Data HubWorkflow” StartBW/4HANA Process Chain from SAPData Hub Task Workflow Transferdata from SAP BW/4HANA to SAPData Hub (SAP Vora) using SAPBW/4HANA Data Transfer Tasks Governand manage SAP BW Metadataassets from SAP Data Hub Metadatacatalog 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC16

Openness: Data Integration SAP BW/4HANA 2.0Feature DescriptionData Integration Scenarios New DataStore Object setting “WriteInterface Enabled“ to write directly intoInbound Queue Support for Standard- and StagingDataStore Objects Integration for: SAP Data ServicesSAP Cloud Platform Integration (CPI)SAP NetWeaver PI (planned for Q2/2019)SAP Data Hub Integration (planned for H2/2019) Successor for SAP Web Service andSAP Data Services Source System(manual conversion) No open support for ETL partnersBenefits Cost savings Simplification 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC17

Openness: Data Integration from SAP S/4HANA Cloud toSAP BW/4HANA 2.0Feature DescriptionSAP S/4HANA Cloud Integration Technical framework and connectivity (HTTP /SOAP based) between SAP BW/4HANA andSAP S/4HANA Cloud (communication scenario) Application based ABAP CDS Content forextraction (e.g. financials, logistics, ) Planned for SAP S/4HANA Cloud 1905 Status Quo: see SAP Note 2674373 SAP Help Portal for further information Easy to extend and support for custom ABAPCDS ViewsBenefits Cost savings Simplification 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC18

Openness: Flexible Access to Enterprise DataSAP BW/4HANASAP onViewOpen ODSViewCalculationView *DataStoreObjectSAP BW/4HANA logic and data can beexposed to SAP HANA throughautomatically generated HANA viewsallowing:CustomCalculationViewsSQL logic on top of generated views Combined data from nativeSAP HANA SQL access for front-end toolsAnalyticsCalculationViewHANATables/ ViewsInfoObject CalculationView* Planned forBW/4HANA 2018/2019 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC19

Openness: SQL View for Look-ups on DataStore ObjectsFeature DescriptionDataStore Object Look-up SQL View SAP BW/4HANA 2.0 creates a External SAPHANA SQL View on ADSOs Exposes only fields/InfoObjects of the ADSO, no joinwith text, master data Also includes fields considered not reporting-relevant AMOUNT fields included in internal and externalformat (i.e. with and without decimal shift) Covers all ADSO partitions – hot, warm and cold Automatically created for all ADSOs, no usermaintenance required(/ Namespace /A adsonm 8) More information available in SAP Note 2723506Benefits Provides Access for Lookups, JOINs, etc. inSQL Transformations or for SAP HANA nativeaccess Enhanced support for mixed scenarios 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC20

Modern UI: BW/4HANA Modeling Tools in EclipseDelivered Eclipse Editors in SAP BW/4HANAOverview Unified UI for all BW/4HANA Modeling Single point of entry for modeling tasks inSAP BW/4HANASource SystemData Flow ObjectProcess ChainIntegrationDataStore Object(optimized editor) SAP GUI no longer required for modelingtoolsTransformationData TransferProcess (DTP)Currency Translation TypeBenefits Reduced efforts and easy to use Faster time to valueUnit Conversion TypeDocument StoreApplicationComponentKey Date Derivation TypeSAP BW/4HANA 1.0 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICSAP BW/4HANA 2.021

Modern Interface: Faster to Learn, Easier to UseDeveloper User Interface – Introducing the new Dataflow Modeller 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC22

Modern UI: BW Modeling Tools in EclipseNew Features with SAP BW/4HANA 2.0SAP BW/4HANA Modeling Tools Enhanced Data Flow Copy (more than one copy,definition on object level) DataFlow: Display of HANA View(s) inCompositeProvider Optimized Data Store Object Editor Data Store Object remodeling in Eclipse andexecution in SAP BW/4HANA Web Cockpit Data Tiering Optimization – cold storeconnection configurable on object level Simplified Search New Editors: Currency Translation Type, UnitConversion Type and Key Date Derivation HDI consumption Asynchronous object activation – editor is notblocked during activation Process Chain Integration 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC23

Modern UI: New DataStore Object Remodeling Capabilities withSAP BW/4HANA 2.0Feature DescriptionDataStore Object Remodeling New option in DSO editor - Remodeling Enables new modeling approaches (start agileand move to more guided data models EDW vs.DataMart) Available on Field or InfoObject selection in theFields Tree Remodeling options: Replace by InfoObjectReplace by FieldFill with Value of InfoObject (must exist in current ADSO)Fill with Value of Field (must exist in current ADSO)Filled by Constant ValueBenefits Flexibility to enhance/change data modelswithout reloading Low remodeling effort and easy to use Higher Productivity 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC24

Modern UI: SAP BW/4HANA Web CockpitOverviewSAP BW/4HANA Web Cockpit Following SAP Fiori design patterns Single point of entry for administration tasks inSAP BW/4HANA Unified user experience Extensible for own applications and groups Modifiable for user context and authorizations 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC25

Modern UI: SAP BW/4HANA Web CockpitNew Features with SAP BW/4HANA 2.0SAP BW/4HANA Web Cockpit Simplified Search Personalization, Subscription & Notifications Enhanced Master Data Maintenance Data Volume & Data Selection Statistics Execute and Schedule Remodeling Requests Data Tiering Summary & Maintenance (partitionmanagement) Data Protection Management (Worklist &Notifications) Analysis Authorization Editor External SAP Hana View Management Enhanced Process Chain Maintenance (InfoArea) Direct File Upload to Data Store Objects 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC26

Modern UI: ABAP CDS Views for SAP BW/4HANA StatisticsFeature DescriptionStatistics SAP BW/4HANA application statistics availableas ABAP CDS Views New Content to replace former TechnicalContent for: Current query performance Process Chain and Data Transfer Process Data Volume Statistics & Data Store Object Request Delivered with SAP BW/4HANA 2.0: Data Volume History statistics Data Selection statistics Extraction/Staging support for statistics dataBenefits Out of the box access to SAP BW/4HANAapplication statistics Web UI accessible from multiple devices Configurable to build custom monitoring 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICData Volume Statistics Dashboard in the SAP BW/4HANA Web CockpitBW/4HANA Web CockpitCustom QueriesExtr./ StagingABAP CDS ViewsStatistic Tables27

Modern UI: SAP BW/4HANA Web Administration ToolsProcess Chain Modeler and Monitor State-of-the-artmodeling UI Intuitive,comprehensive monitoring toolfor detailed error analysis and recovery 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC28

Modern Interface: Faster to Learn, Easier to UseBusiness User Interface – Integration with SAP Analytics (on-premise and cloud) 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC29

High Performance: Analytical Engine with SAP BW/4HANA 1.0* AutomatedQuery Execution Mode Optimizerincluding machine learning QueryCell based Documents for addingcomments** Enhancedperformance by optimized query parallelization for Analysis for Office** QueryCatalog Search Advancedreporting features for Analysis forOffice**** A blog for detailed information is available** available with Analysis Office 2.7*** SAP Analysis for Microsoft Office Road Map 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC30

High Performance: Analytic Engine with SAP BW/4HANA 2.0* *New FeaturesAnalytic Engine Conditions calculated in SAP HANA (push-down) TopN, BottomN, LessThan, GreaterThan, NotBetween, RSECADMIN (maintain analytic authorization) in SAPBW/HANA Web Cockpit Variable Type BRF (used for customer definedvalidations, derivations and calculations) Read Access Logging (RAL) integration for advancedauditing Custom Exception Aggregation and IF Operator forAnalysis Office and SAC SAP Analytics Cloud Adoption through SAP BW LiveConnection including new Chart SupportBenefits Provides Access for Lookups, JOINs, etc. in SQLTransformations or for SAP HANA native access Enhanced support for mixed scenarios 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC* A blog for detailed information is available31

High Performance: Enabling Advance AnalyticsSAP sInfoProviderInfoProvider/ IndexPredictionsSAP PredictiveAnalyticsSAP HANAPALR-ScriptAutomated Procedure(UDF, AFL) 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICEnhance data with AdvancedAnalytics using HANA specificlibraries (AFL), R-Script or acustom HANA procedure Predictive Text Analysis Data Mining Machine Learning33

Data Protection Management inSAP BW/4HANA 2.0

Data Protection & Privacy: Data ProtectionWorkbench – MotivationSituation today Personal data is increasingly protected by laws (e.g. EU GDPR) SAP BW/4HANA offers capabilities for Data Protection & Privacy support(see security guide SAP BW/4HANA) Generic deletion capabilities in SAP BW/4HANA are independent of Business Suite handling SAP ILM ensures retention management in operational systems and is used to support dataprotection & privacy complianceChallenge Improved support and tight integration of SAP BW/4HANA with SAP ILM to delete replicatedpersonal data in SAP BW/HANA after the end of purpose of the data.Approach SAP ILM notification framework allows to persist notifications of deleted(personal) data during ILM processes Replicate notifications from SAP ILM to SAP BW/4HANA Data Protection Workbench supports: Identify InfoProviders containing sensible data Selective deletion of corresponding transactional- and master data recordsThis presentation is not subject to your license agreement or any other agreement with SAP. SAP has no obligation to pursue any course of business outlined in this presentation or to develop or release any functionality mentioned in this presentation.This presentation and SAP's strategy and possible future developments 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 limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by

Apr 01, 2019 · SAP BW/4HANA –The Evolution From SAP BW/4HANA 1.0 to 2.0 The next generation data warehouse Builds on the innovations of SAP BW powered by SAP HANA Leaves behind the legacy of SAP BW on any DB Data Tiering Optimization (DTO) to manage hot, warm and cold data tiers Enhan