SAP BW 7.5 SP4 powered by SAP HANA Overview & Roadmap Product Management SAP EDW (BW/HANA), SAP SE

Public

Legal disclaimer This 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 SAP intentionally or grossly negligent.

© 2016 SAP SE or an SAP affiliate company. All rights reserved.

Public

2

Highlights of SAP BW 7.5 SP4 Big Data

Simplification • • • • • •

Semantic Groups for Advanced DataStore Objects Enhancements for CompositeProvider Additional Object Editors in Eclipse InfoObjects Supporting Transitive Attributes Streaming Process Chains New BW Workspaces Scenarios

• • •

Platform Integration • •

SAP HANA Smart Data Integration via New HANA Source System in BW SAP HANA Optimized Transformations

© 2016 SAP SE or an SAP affiliate company. All rights reserved.

Extension Nodes as New “Warm” Data Concept Extended Near-line Storage Capabilities HADOOP as Near-line Storage

SAP BW 7.5, edition for SAP HANA • • •

Reduced Governance and Faster Time to Market Run SAP BW in Simplified Mode General Availability Planned for September 2016

Public Public

3

Simplification

Simplification – BW Modeling Tools in Eclipse Delivered Eclipse Editors in SAP BW

DataSource Composite Provider advanced DataStore Object

InfoObject

Semantic Groups Aggregation Level

Query Designer (complex queries)

Open ODS View

InfoSource InfoArea

Query Designer (simple queries)

OpenHub

SAP BW 7.4 SP9 / SP10 © 2016 SAP SE or an SAP affiliate company. All rights reserved.

SAP BW 7.5 SP1

SAP BW 7.5 SP4 Public

5

Simplification – Advanced DataStore Object Recap – New with SAP BW 7.4 Next generation of Data Store Object simplifies data modeling in SAP BW • Consolidate DataStore Objects and InfoCubes   Active Data

Change Log

Single type of BW object Settings to manage properties for certain services

• Combine InfoObject and field based modeling • New intuitive & modern modelling UI

Inbound Table

Optimized services Advanced DSO

SAP BW

SAP HANA

• High frequent data loads - based on optimized request management • Change of usage scenario without deletion of data • Up to 120 key fields • Optional SID entries for query performance optimization

SAP Note 2070577 2016 SAP SAP affiliate company. All rights reserved. © 2015 SAPSE SEororanan SAP affiliate company. All rights reserved.

Public Public

6

Simplification – Semantic Group for Advanced DataStore Objects New with SAP BW 7.5 SP4 New Highly Flexible Concept for Semantic Partitioning for Advanced DataStore Objects • Tool to create semantical partitioned data models • •

Based on a reference structure Each member can be changed independently

• Flexible definition of split criteria •

Pruning information is derived

• Generated advanced DataStore Objects remain individual objects including • •

CompositeProvider DTP filters

• Only generated objects will be transported into subsequent systems

© 2016 SAP SE or an SAP affiliate company. All rights reserved.

Public Public

7

Simplification – Enhancements of Advanced DataStore Object New with SAP BW 7.5 SP4 Dynamic Tiering •

Dynamic Tiering based on Extension Nodes

Selective Deletion with Reverse Image • • •

Propagate result of a selective deletion to BW targets Based on new change log request Roll back option

Snapshot Enablement • •

Differences between active table and newly loaded request written into change log as reverse images Propagate deletion of records in source to further BW targets (e.g. DataSource delivers full only)

New Process Chain Types •

© 2016 SAP SE or an SAP affiliate company. All rights reserved.

Clean up activities based on advanced DataStore Object type

Public Public

8

Simplification – CompositeProvider Recap – CompositeProvider with SAP BW 7.4 SAP and non SAP Applications

SQL

BICS

ODATA

CompositeProvider Combine the data of various applications

Model

View BW Workspace Table

Operational or Real-time Datamart

The new CompositeProvider with SAP BW 7.4 virtualization and consolidation • Combine BW InfoProviders and HANA artefacts via UNION or JOIN • Consolidation of existing InfoProvider types by new CompositeProvider  Successor to BW MultiProvider, BW InfoSet, existing CompositeProvider, TransientProvider on HANA Models, VirtualProvider on HANA Models

Faster Implementations of data model Classical DataWarehouse Schema

Agile Modelling & Prototyping

SAP BW Schema

SAP HANA Schema

More flexibility – additional business insights Completely processed on SAP HANA

External Database

Hadoop

ERP

2016 SAP SAP affiliate company. All rights reserved. © 2015 SAPSE SEororanan SAP affiliate company. All rights reserved.

BW

Public Public

9

Simplification – CompositeProvider CompositeProvider with SAP BW 7.5 Simplified User Experience • • • •

Easy creation process Conversion of existing MultiProvider and “old” CompositeProvider InfoArea Assignment Semantic grouping of output structures

New with SAP BW 7.5 SP4* • • •

Support of CompositeProvider with temporal joins to fully replace InfoSets Transfer tool from InfoSet to Composite Provider (incl. Queries) Runtime properties for Query Execution of each PartProvider available in Eclipse * See SAP Note 2326527 for important information's

2016 oror anan SAP affiliate company. All rights reserved. © 2016 2015SAP SAP SAPSE SE SE or an SAP SAP affiliate affiliate company. company. All All rights rights reserved. reserved.

Public Public

10 10

Simplification – DataSource Maintenance in Eclipse New with SAP BW 7.5 SP4

New Eclipse-based DataSource Editor in BW Modeling Tools SAP BW

   

Modern, intuitive Eclipse based UI Enhanced replication dialog New update dialog Remote repository based on information from source system (ODP only)

Source Systems Available for Modeling in Eclipse  SAP HANA, ODP, S-API (“extractors”)

© 2016 SAP SE or an SAP affiliate company. All rights reserved.

Public Public

11

Simplification – InfoObjects supporting Transitive Attributes New with SAP BW 7.5 SP4 Transitive Attributes for InfoObjects  Add navigational attributes of one InfoObject as navigation attributes to another InfoObject  Ability to extend a star schema to snow flaking • At present two levels are allowed InfoObject 0COSTCENTER

InfoObject 0PROFIT_CTR

Nav. Attr. 0COMP_CODE

0PROFIT_CTR

Nav. Attr. 0RESP_USER

0PCA_DEPART

0PCA_DEPART

Transitive Attribute (joined at runtime)

Increased Flexibility, Maintainability, Less Redundancy  Changes in parent InfoObjects do not affect children  Easier data provisioning / staging to InfoObjects (e.g. 3NF sources) and advanced DataStore Objects  Usage in CompositeProvider and Open ODS View to avoid redundancy © 2016 SAP SE or an SAP affiliate company. All rights reserved.

Public

12

Simplification – Streaming Process Chains New with SAP BW 7.5 SP4 Streaming is a New Operation Mode of a Process Chain  Process data in real-time  High frequent execution

Streaming Mode as Central Property Per Process Chain  Activated via Process Chain  Attributes  Streaming Mode  Process types that can trigger the chain in streaming mode: 

DTP (Hana Data Source, ODP) or START

 Process types that can be used and run in streaming mode: 

ADSO Activation, ABAP Program, Decision, AND, OR, EXOR

Improved Streaming Mode Monitoring

Specific Behavior for Failed Processes and Logging

© 2016 SAP SE or an SAP affiliate company. All rights reserved.

Public Public

13

Simplification – SAP BW Workspaces New with SAP BW 7.5 SP4 SAP BW Workspaces – Recap

Upload

Architected Data Mart FI

(Key-)Business User (local)

SAP BW

•

Enables key business users to create ad-hoc scenarios

•

Central data marts from the IT department can be combined, with local data to meet special requirements of the business department

•

See here for more information

SAP BW Workspace

New with SAP BW 7.5 SP4

Workspace for LOB FI Architected Data Mart CO

•

Enablement of Navigational Attributes in local CompositeProviders

•

BW Workspace as private Staging Area to transfer your data back into advanced DataStore Objects

•

Upload services (submit data)

Reference Workspace for LOB HR Architected Data Mart Production

SAP HANA © 2016 2016 SAP SAP affiliate company. All rights reserved. SAPSE SEororanan SAP affiliate company. All rights reserved.

IT User (central)

•

Workspace as local data acquisition area

•

Trigger local data load to central targets

•

Data Quality checks

Public Public

14

Platform Integration

Platform Integration – HANA Smart Data Integration for SAP BW Recap - HANA Smart Data Integration for SAP BW with SAP BW 7.5 SP1 New BW Source System Available

SAP BW

• New ability to leverage SAP HANA Smart Data Integration as provisioning technology • Using SDI Adapter in SAP BW • Simplified and unified source system connection to SDI, SDA and local SAP HANA sources with the HANA Source System in BW*

HANA Source System

Smart Data Access EIM: Smart Data Integration

SAP HANA REAL-TIME REPLICATION

ORACLE

DB2

MSSQL

SAP HANA

TWITTER

TERADATA

SAP HANA Smart Data Integration for SAP BW

DIRECT ACCESS

HADOOP

ODATA

FILE

• Adding real-time replication for various sources • Extends SAP HANA Smart Data Access capabilities with new source adapters** (Twitter, oData, file) • Supports direct access, (real time) replication and ETL for various sources – on premise and cloud

ASE

* Pilot only ** see full list of supported adapters

© 2016 SAP SE or an SAP affiliate company. All rights reserved.

Public Public

16

Platform Integration – HANA SDI New with SAP BW 7.5 SP4 SAP BW

Integration Scenarios with SAP BW – General Availability

CompositeProvider Virtual

OpenODS View Virtual

• Advanced DSO

DIRECT ACCESS

•

REAL TIME Streaming

UPSERT Table

INSERT Table

HANA DataSource

REPLICATION HANA

Smart Data Access Smart Data Integration

SAP HANA Table/View

•

•

Direct access to any Smart Data Integration (SDI) remote source* via Open ODS View SDI real-time replication managed by HANA DataSource •

UPSERT table for actual view / INSERT table for history preserving

•

Replicate source data in original format to BW (using HANA data types)

•

Inbuilt mapping of source data types to ABAP data types when using HANA DataSource in reporting or ETL loads within BW

•

Direct access from OpenODS View to HANA DataSource

•

Full / delta upload into advanced DataStore Objects

•

Real-time streaming from UPSERT / INSERT table into advanced DataStore Object possible

SAP HANA Multi-tenant Database Container (MDC) support for HANA DataSource (SAP BW 7.5 SP5, BWMT 1.15)** SAP HANA DataSource Integration with Streaming Process Chains

Table/View Remote Source

© 2016 SAP SE or an SAP affiliate company. All rights reserved.

* See Documentation: Data Provisioning Adapters ** See SAP Note 2312583 Public Public

17

Platform Integration – SAP HANA Optimized Transformations New with SAP BW 7.5 SP4

Application Server

BW 7.4 on HANA DSO / Advanced DSO

BW 7.5 on HANA DSO / Advanced DSO

• Standard transformations are optimized to be processed directly in SAP HANA where possible • ABAP-managed database procedure (AMDP) integration embedded in expert routines

Start-Field-End Routine

New with SAP BW 7.5 SP4 Activation

Database

Recap SAP BW 7.5

Activation

AMDP for Start-Field-End Routine

AMDP for Expert Routine

AMDP for Expert Routine

Data

Data

© 2016 SAP SE or an SAP affiliate company. All rights reserved.

• ABAP-managed Database Procedure (AMDP) available for start, field, and end routines • Support for DTP with error handling • Simulation Mode

Public Public

18

Big Data

Big Data – SAP HANA Extension Nodes for Dynamic Tiering in BW New with SAP BW 7.5 SP4 Enhanced Data Lifecycle Management for Warm Data

SAP HANA Master

Slave 1

Node

Easy to set up and significantly reduced administration effort

•

Support of all SAP HANA features for operations, updates and data management

Slave 3

Extension Slave 1 Slave 2

•

Extension Slave 2

Extension Slave 3

Typical Landscape Characteristics

Standby

•

Usage of standard SAP HANA nodes

• Simplified sizing formula „Standard“ Group: normal BW sizing strict CPU/RAM ratio

„Extension“ Group: higher data footprint relaxed CPU/RAM ratio *

 HOT Data location

 WARM Data location

See SAP Note 2317200 and blogs: Overview + Further Details © 2016 SAP SE or an SAP affiliate company. All rights reserved.

• Differentiation between “hot” and “warm” via BW application (definition of Object Groups) • Supported BW objects: PSA, write optimized DataStore Objects , advanced DataStore Objects • Optimized RAM/CPU ratio for warm data (Runs as “asymmetric” Scale-Out cluster)*

* Planned Public Public

20

Big Data – Near-Line Storage (NLS) with SAP IQ New with SAP BW 7.5 SP4 Recap SAP BW 7.5 SP1 • NLS support for advanced DataStore Objects with active tables* • Reporting value help (F4) can display posted values from near-line storage for advanced DataStore Objects*

InfoCubes

(Advanced) DSO

NLS Interface

SAP BW

SAP IQ

Interfac e

• CompositeProvider can use advanced DataStore Objects with NLS in specific join scenarios* • BW process type to create database statistics for NLS accesses (via virtual tables)

Enhanced Functionality with SAP BW 7.5 SP4 • All common types of advanced DataStore Objects for staging and reporting are supported

SAP HANA

• Partner Interface for Nearline Storage on Advanced DataStore Object * See SAP Note 2215265

© 2016 SAP SE or an SAP affiliate company. All rights reserved.

Public Public

21

Big Data – Near-Line Storage (NLS) with Hadoop New with SAP BW 7.5 SP4 Use HADOOP as Near-Line Storage for SAP BW • Store archived data in HADOOP

• Available for all NLS supported BW object types

InfoCubes

(Advanced) DSO

NLS Interface

SAP BW

Available for SAP BW powered by SAP HANA SPARK SQL HDFS

HIVE

• Full support for queries (near-line reading) • Leveraging SAP HANA smart data access •

Based on Apache Spark

• Recommended usage: cold, read-only data (typically aged data)

Available for SAP BW on AnyDB SAP HANA

• Support for archive data only •

© 2016 SAP SE or an SAP affiliate company. All rights reserved.

No support for query access, lookup and exceptional updates

Public Public

22

SAP BW 7.5, edition for SAP HANA

SAP BW Roadmap Driven by SAP HANA 2013

2012

SAP BW 7.3 SP5 powered by SAP HANA •

Performance Optimization

2015 SAP BW 7.4 SP5 powered by SAP HANA

•

Simplification and Virtualization

500 BW on HANA customers

2016 SAP SAP affiliate company. All rights reserved. © 2016 SAPSE SEororanan SAP affiliate company. All rights reserved.

2015/2016+ SAP BW 7.5 SP1 powered by SAP HANA

•

Simplification, HANA platform integration, Big Data scenarios

1200 BW on HANA customers

SAP BW 7.5, edition for SAP HANA •

SAP BW run simpler

3600+ BW on HANA customers

Public Public

24

SAP BW 7.5, edition for SAP HANA

SAP BW on AnyDB

SAP BW 7.5, edition for SAP HANA

SAP BW on SAP HANA

InfoObject

InfoObject DataStore Object MultiProvider InfoCube 3.x DataFlow SAP GUI Modelling

CompositeProvider Advanced DataStore Object

Run SAP BW 7.5 in Future Ready and Recommended Way •

General Availability SAP BW 7.5, edition for SAP HANA* planned for September 2016

•

Use only new SAP HANA specific modelling and data flow objects

•

No overhead due to legacy objects

•

Optimized data loads with high flexibility and agile administration

•

Intuitive Eclipse based modelling environment for main objects and query

•

All administration tools based on SAPUI5

•

New BW on HANA-optimized Business Content

OpenODS View

HybridProvider 7.x DataFlow

7.x Data Flow

TransientProvider VirtualProvider

Eclipse Modeling

InfoSet …..

SAP UI5 Administration

2016 SAP SAP affiliate company. All rights reserved. © 2016 SAPSE SEororanan SAP affiliate company. All rights reserved.

* runs as an SAP BW 7.5 SP4 add-on

Public Public

25

Miscellaneous

Miscellaneous New with SAP BW 7.5 SP4 New Enhanced Technical Content • • •

Data volume information to monitor the size of BW objects* Request overview for advanced DataStore Object Based on CDS technology for easier and simplified operations • •

Installation, loading and activation is NOT required Real-time access

* See SAP Note 2296290

Enhancements in Open ODS Views • • •

New Open ODS View creation wizard Navigational attributes from associated virtual InfoObject SAP HANA Multi-tenant Database Container (MDC) support (SAP BW 7.5 SP5, BWMT 1.15)** ** See SAP Note 2312583

Central Maintenance of BW Hierarchies via Web Dynpro Enhanced Feature Support of HANA View Generation*** *** See SAP Note 2317197 © 2016 SAP SE or an SAP affiliate company. All rights reserved.

Public Public

27

Miscellaneous New with SAP BW 7.5 SP4 Pushdown from OLAP to SAP HANA for • • • •

Formulas with exception aggregation Variable with replacement path Additional exception aggregations Dynamic selections

SAP HANA based extraction • • •

Support of DTP extraction from advanced DataStore Object including archive (NLS) SAP HANA performance improvements in Data Transfer Processes Extraction of very large data volumes with HANA processing*

* See SAP Note 2329819

© 2016 SAP SE or an SAP affiliate company. All rights reserved.

Public Public

28

Roadmap

This 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 SAP intentionally or grossly negligent.

Planned Roadmap SAP BW in context of SAP HANA Key Themes and Capabilities Today Integration with the SAP HANA Platform  

Leverage SAP HANA Smart Data Integration Further pushdown of data intensive functions

User Experience 

Eclipse based modeling for ADSO, CompositeProvider, Query Designer, InfoObject, OpenHub, InfoSource

SAP will continue to support RDBMS platforms

Integration with SAP HANA Platform 



Enhanced Advanced DSO (ADSO) features (planning support, inventory handling, etc.) Semantic Groups for Data Flows and ADSOs

Big Data Scenarios   

Real-time streaming for BW objects Support of HADOOP as NLS HANA extension nodes for warm data management

Exposing BW data models for SQL consumption 

Enhanced feature support of HANA view generation (pruning support, enablement of hierarchies)

Seamless transition into SAP HANA mixed scenarios

Integration with SAP HANA Platform 

SAP HANA mixed scenarios as integral part of SAP BW

User Experience  

Simplification 

Future Direction

Planned Innovations

Modern UI for Data Flow modeling SAPUI5 based scheduling, monitoring, and administration

Simplification  

Conversion tools for simple transition to SAP BW on HANA objects Enhanced integration with S/4HANA

Integration with Amazon Web Services (AWS)  Run SAP BW in an AWS instance Big Data Scenarios  Highly automated Data Lifecycle Management  NLS / Hadoop integration with SAP HANA Vora  Data access scenarios with Hadoop

User Experience 

All in modern UI

BW as part of the SAP HANA Data Warehouse  

Common orchestration and scheduling Tight collaboration with SAP HANA DW tooling

Integration with SAP S/4HANA  Smooth integration with SAP S/4HANA Analytics  New content scenarios

SAP BW 7.5, edition for SAP HANA 

General availability planned for September 2016

Feature Pack SAP BW 7.5 SP4

2016 - 2017

SAP HANA Data Warehouse Strategy

This 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 SAP intentionally or grossly negligent.

© 2016 SAP SE or an SAP affiliate company. All rights reserved.

Public

30

SAP – Data Warehousing Approaches Two Approaches Application driven approach, SAP BW as EDW application with integrated services • SAP BW as an application serves as a platform offering all required data warehousing services via one integrated repository

SAP BW Scheduling & Monitoring

Modeling

Planning

OLAP

Lifecycle Management

ETL

 No additional tools for modelling, monitoring and managing the data warehouse required, but can be integrated

SQL driven approach, SAP HANA with loosely coupled tools and platform services, logically combined  Database approaches require several loosely coupled tools to fulfill the necessary tasks with separate repositories  A combination of tools (such as best of breed) used to build the data warehouse © 2016 SAP SE or an SAP affiliate company. All rights reserved.

SAP HANA

Scheduling Tool

Modeling Tools

Planning Tool

Monitoring Tool

Lifecycle Management Tool

ETL Tool

SAP HANA

Public

31

Statement of Direction – Current Data Warehousing Portfolio

Planning and Definition

Execution and Delivery

2015

2016 - 2018 Analytics , BI Suite, Predictive

Analytics , BI Suite, Predictive

Power Designer

DWH Foundation Business Warehouse

Power Designer

Hadoop SAP HANA Vora

Market presence in Data Warehousing with a clear roadmap

Optional Components

SAP HANA DW Business Warehouse

DW Modeling

DW ETL & DM

SAP HANA Platform

HANA EIM

SAP HANA Platform

Analytics , BI Suite, Predictive

SAP HANA DW

SAP HANA DW

Vision

DW Foundation

HANA EIM Hadoop SAP HANA Vora

Strong and simplified offering with tight integration

SAP HANA Platform

Hadoop SAP HANA Vora

Convergence into one technology stack addressing BW and SQL based DW needs

This 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 SAP intentionally or grossly negligent.

© 2016 SAP SE or an SAP affiliate company. All rights reserved.

Public

32

Thank you Contact information:

Lothar Henkes VP, Product Management SAP EDW [email protected]