Roadmap von SAP BW auf HANA und SAP S/4HANA

09-06-2016

© Atos - For internal use

99,5% Die Menge an Daten die aktuell in Organisationen nicht genutzt werden Quelle: Bain & Co, February 2015

Entwicklung von Unternehmen die Daten nutzbringend einzusetzen…

 Was passierte in der Vergangenheit?

 Warum passierte es?

 Was wird passieren?

 Was machen wir?

Desriptive

Diagnostic

Predictive

Prescriptive

Die Treiber werden analytische Services….

Analytische Auswertungen

Analytische Auswertungen

Business Applikationen

Analytische Auswertungen

Analytische Auswertungen

Aktuelle Situation

Business Apps

Business Apps

Analytische Auswertungen

Business Apps

Business Apps

Zukünftige Situation

HANA BW on HANA FIORI

7

| 09-06-2016 | Markus Michler| © Atos

HANA Live

HANA apps

SAP HANA Schlagwörter…

HANA

A

B

A B+

Any DB

D

+ Neue Big-Data Integration + Performance-Boost + Wiederverwendung von existierenden Investitionen

B

+ Erster Schritt zu HANA + In-memory Performance für ERP & DWH + Wiederverwendung von existierenden Investitionen + Lastausgleich im ERP/DWH - Keine Konsolidierung der IT-Landschaft

None

Business Warehouse

Wählen Sie die Richtung

C

B+

+ Embedded BW: Leistung & Funktionen + Konsolidierung der IT-Landschaft - Migration von BW in ERP

None

Any DB

HANA

SAP ERP

D

+ Keine Migration nötig - Keine neuen Innovationen von SAP - Langzeit Instandhaltung ? - Performanceprobleme bleiben

8

| 09-06-2016 | Markus Michler| © Atos

C

+ Konsolidierung der IT-Landschaft

+ Echtzeit Operational-Reporting - Keine DWH Funktionalitäten - Analytische Anwendungen bspw. Planung müssen migriert werden

Roadmap zu Szenario A: BW auf HANA

Any DB

A 9

| 09-06-2016 | Markus Michler| © Atos

BW zu HANA Migration Service Packet

“Turn your business challenges into business opportunities. If you can measure your business you can improve it”

Migration Workshop with Customer

Step 1

Gate 1

BWHousekeeping with general checks and preparation of Migration

Step 2

Tasks: • Pre-Requisite Checks eg. Migration Checklist Coding Report Sizing Report • Creation of Migration plan

Tasks: • defined Housekeeping activities at FP • re-run Sizing Report

Output: • Define migration strategy • Define testing strategy • Fixprice-Offer for Step2 (Housekeeping) and Step 3 (technical Migration)

Output: • System Cleanup • Data Reduction Decrease HANA Sizing

Optional: • Consultancy HW-configuration • Consultancy HW-Purchasing and SW-Licensing

10

| 09-06-2016 | Markus Michler| © Atos

Gate 2

Technical Migration

Gate 3

Step 3

complete Migration at FP • Migration from relational DB to HANA • Coding adjustment based on coding report • Testing

Output: • all BW functionalities run as before migration • faster performance on Dataloading and reporting

Optimization

Gate 4

Live on SAP BW on HANA

Step 4

Conversion to HANAoptimized dataflow based on T&M

Initial workshop incl. strategy and migration plan in fixed price Offering.

Migrations Möglichkeiten ▶ Greenfield: Aufbau von neuen Strukturen und BW Architekturen ▶ In Place Migration: Niedriger Migrationsaufwand, aber höheren Risiken ▶ Copy, Upgrade & Migrate: Niedrige Migrationsrisiken mit hohen Kosten und langer Migrationsdauer

11

| 09-06-2016 | Markus Michler| © Atos

BW on HANA – Data Model Optimization

InfoCubes sind notwendig ▶ Nicht unterbrechbare Migration von BW auf HANA ▶ Nicht kumulative Kennzahlen ▶ Komplexe Geschäftslogik ▶ BW Integiererte Planung

Echtzeit Reporting on DOSs

12

| 09-06-2016 | Markus Michler| © Atos

BI Virtualisierung: Der Ansatz von HANA ▶ SAP BI Architektur wird sich stark vereinfachen und eliminiert Redundanz – Verringerung der Reporting Latenz – Vereinfachung des Datenflusses, direkte Kalkulationen in HANA – Erweiterungen: Neue Algorithmen bspw. für Predictive Analytics ▶ Zwei Optionen dieser Strategie mit Business Warehouse und direkt auf der HANA DB

13

| 09-06-2016 | Markus Michler| © Atos

Roadmap von Szenario C: ERP HANA, kein BW

HANA

C 14

| 09-06-2016 | Markus Michler| © Atos

ERP HANA, kein BW

Analytical Frontend

SAP BO

FIORI Launchpad Crystal Reports Design Studio Analysis WebIntelligence Lumira

Built-In BI Applications Multidimensional Reports

Query Browser

KPI Modeler

Analytical Apps

dependent on ERP release

XS Engine (Web Resources and oDATA Services)

Analytical Backend

HANA (virtual tables)

SAP Query Views

Customer Views Reuse Views Private Views

Operational Systems

any DB NONSAP

| 09-06-2016 | Markus Michler| © Atos

HANA (physical tables new data models ACDOCA MATDOC)

SLT

15

SAP ERP

Customer Views

SAP HANA virtuelles Datenmodell ▶ Virtual Data Model wird direkt auf der HANA DB erstellt und konfiguriert – Direkter Zugriff auf physische und virtuelle Tabellen – Einsetzbarkeit zusätzlicher Applikationen wie SAP BO Data Services als EDWL Tool – Modellierung im SQL Standard, eigenes Transport- & Berechtigungswesen – Restriktionen in der Nutzung bekannter SAP BI Funktionalitäten (bspw. Planung, Stammdatenmodellierung,…)

16

| 09-06-2016 | Markus Michler| © Atos

Roadmap zu Scenario B: ERP und BW auf HANA

| 09-06-2016 | Markus Michler| © Atos

Any DB

HANA

A

B

BW auf HANA und ERP auf HANA

Analytical Frontend

SAP BO

FIORI Launchpad Crystal Reports Design Studio Analysis WebIntelligence Lumira

Built-In BI Applications Multidimensional Reports

Query Browser

KPI Modeler

Analytical Apps

dependent on ERP release

Business Warehouse Business Query

Analytical Backend

HANA

Virtual Provider

Smart Data Acess

CDS Views

(virtual tables)

HANA Native

Data Mart

Operational Systems

any DB NONSAP

| 09-06-2016 | Markus Michler| © Atos

HANA

EDWL Core

SAP ERP Operational Data Store

18

(physical tables new data models ACDOCA MATDOC)

Virtualisierung von den Datenmodellen ▶ SAP BW verbleibt als zentraler Reporting Zugang ▶ Virtualisierung der ERP Datenmodelle für das Echtzeit Reporting ▶ Externe Datenfluss verbleibt ▶ Nutzung von neuen SAP BI Objekten (SAP BW 7.4 SP8) ▶ Modellierung von Composite Provider in SAP HANA Studio:

19

| 09-06-2016 | Markus Michler| © Atos

Roadmap von Szenario B+: Embedded BW

All-in One HANA

Any DB

HANA a)

A 20

| 09-06-2016 | Markus Michler| © Atos

B

B+

HANA Big Picture Architektur Analytical Frontend

SAP BO

FIORI Launchpad Crystal Reports Design Studio Analysis WebIntelligence Lumira

Built-In BI Applications Multidimensional Reports

Query Browser

KPI Modeler

Analytical Apps

HANA System Backend

Embedded BW Business Query

Analytical Backend

HANA

Virtual Provider

(virtual tables)

CDS Views

HANA Native

Data Mart

Operational Systems

any DB NONSAP

| 09-06-2016 | Markus Michler| © Atos

HANA

EDWL Core

SAP ERP Operational Data Store

21

(physical tables new data models ACDOCA MATDOC)

ThyssenKrupp

Accelerated and integrated finance reporting with SAP BW on HANA Business Challenge ▶ ▶ ▶ ▶

Improvement of the final preparations – easy and transparent Handling of group-wide relevant financial and controlling data within a central system for data processing and reporting Provisioning of near real-time data for total records and single documents in full detail Comprehensive reporting on the basis of large amount of data for complex analysis

Solution ▶

▶ ▶

Implementation of an Enterprise Data Warehouse based on the innovative inmemory technology SAP HANA for evaluation of group-wide financial and controlling data SAP HANA optimized data flows for ad-hoc data update out of the previous systems One cockpit as a front-end for the entire data processing control

Benefits ThyssenKrupp AG is a German multinational conglomerate corporation based in Duisburg and Essen, Germany. The corporation consists of 670 companies worldwide. While ThyssenKrupp is one of the world's largest steel producers, the company also provides components and systems for the automotive industry, elevators, escalators, material trading and industrial services.

22

▶

▶ ▶ ▶

| 09-06-2016 | Markus Michler| © Atos

High-performance multidimensional analysis of group-wide data based on all relevant corporate dimensions down to the level of individual documents (e.g. management structure, countries, customers, …) Independent processing of the data by company users using a central front-end for automated loading, registering, reposting and validating Complete transparency about the specific company status during the entire final preparations The innovative character of this in-memory solution enables the administration and the usage of mass data (Big Data) and additionally builds the basis for the use of future-oriented technologies

Open Grid Europe

SAP BW on HANA Proof of Concept (PoC) Business challenges ▶ ▶

Higher requirements towards the current SAP Business Intelligence (BI) architecture of Open Grid Europe (OGE) Optimization of data loading process and reduction of loading times to fulfill regulatory framework conditions and prevent increasing data volume

Solution ▶ ▶ ▶

Open Grid Europe, with its head office in Essen, operates Germany's largest transportation network that is approx. 12,000 km in length. The customer’s staff of around 1,800 combine decades of experience in technology, operation and marketing.

▶ ▶

▶

Benefits ▶ ▶

23

Evaluation of possible fields of application of a SAP BW on HANA system within the SAP BI landscape of OGE Support with the identification, composition and description of suitable scenarios Modeling of selected scenarios, with regard to a performance optimization through HANA technology, on Atos’ internal systems (SAP BW on HANA and SAP BW reference system with relational database) Measurement and analysis of processing speed on both systems Presentation of the resulting validations and recommendations in a PoC-document (e. g. technical properties of HANA as well as comparison and interpretation of measurements) Execution of a HANA sizing analysis

| 09-06-2016 | Markus Michler| © Atos

Decision reliability based on a Proof of Concept  Presentation of value and assessment of advantages of SAP BW on HANA within the enterprise Ensuring major flexibility, better performance and higher processing speed by using HANA

Danke

Atos, the Atos logo, Atos Consulting, Atos Worldgrid, Worldline, BlueKiwi, Bull, Canopy the Open Cloud Company, Yunano, Zero Email, Zero Email Certified and The Zero Email Company are registered trademarks of the Atos group. May 2015. © 2015 Atos. Confidential information owned by Atos, to be used by the recipient only. This document, or any part of it, may not be reproduced, copied, circulated and/or distributed nor quoted without prior written approval from Atos.

09-06-2016

© Atos - For internal use