Providing real-time, built-in analytics with S/4HANA. Jürgen Thielemans, SAP Enterprise Architect SAP Belgium&Luxembourg

(1)

Providing real-time, built-in analytics with S/4HANA

Jürgen Thielemans, SAP Enterprise Architect

(2)

(3)

Situation today: OLTP and OLAP separated, one-way streets only

“Sema

nti

c

Wall”

No write-back

No real-time reporting

Relational

table design

OLTP- System of Records:

“Information in” only

Data replication:

■

Usually not real-time, long-running ETL-Jobs

(Extraction-Transfer-Load)

■

Redundant data storage

OLAP - System of Engagement:

“Information out” only

(4)

Combining transactions and analytics on a single in-memory platform

• Instant Insight to Action on Live Data

• One Copy of the Data

• No ETL and Batch Processing

• Decisions and Actions on Old Data

• Multiple Copies of the Data

(5)

(6)

Types of Analytics – Data Warehouse / Data Marts

Types of reporting access scenarios – Data Marts / Data Warehouse

• High variety of information sources

• Extensive information needs

Different kinds of Data Marts for various Use Cases

Operational

Data Mart

Visibility

Direct / Database

Replication

Data Marts

(Audit / SOX)

Federated

Queries / ETL

Agile

Data Marts

Ad-Hoc |

Self-Service BI

ETL / ELT/

Replication

Data

Warehouse/

EDW

Consolidated

view

ETL / ELT /

Replication

Transactional |

System of Record

Systems of Record & Engagement

Transactional | Analytical |

Real Time

Data Mart

Real Time

Streams /

Feeds

Event | Machine

ETL / ELT/ Replication

Federation of Data & Query

All sources

Predictive

(7)

SAP HANA Information Views

(8)

Types of Analytics – Data Warehouse / Data Marts

Specific Operational Data Marts: Virtual Data Models

Operational

Data Mart

Visibility

Direct / Database

Replication

Transactional |

System of Record

Transactional system

Database Layer, e.g. SAP HANA

Physical Tables

Virtual Data Model

View

(9)

SAP Business Suite real-time analytics architecture (SAP HANA Live)

Atomic

Instantaneous

Pre-defined

HANA Database Layer

Virtual Data Model on Physical Tables

Analytical Apps and BI Clients

e.g. SAP BusinessObjects BI

SAP Business Suite Application

Hybrid Transactional and Analytical

Applications

e.g. SAP Smart Business cockpits

• No latency

• No data duplication

• Ready-to-use content

(10)

(11)

Today transactions and analytics are handled separately

but in reality, business processes are often a sequence of…

Enter Order

_{Churn Probability}

Check Customer

Adjust discount

_percentage

transaction

analysis

transaction

Analyze yield and

scrap of plants

Send email to all plant

managers above/below

certain thresholds

Create new employee

salary data

Check updated salary

projection for cost

(12)

Purchase Request: 4711

Material :

Supplier :

Default Discount :

… :

Supplier Overview for Material

515 Embedded multidimensional

report shows suppliers for

the entered Material No. and

their Delivery Performance +

trading volume

1 Navigate to a full screen

_{version of the report and}

perform multidimensional

analysis , personalize report

and share data.

3 Built-in Analytics – Imagine, one day we will have…

Bi-directionally embedded Analytics in a transaction screen

Supplier Delivery

Performance Trading Volume Last Year

100 98%

550 K€

101 95%

1.230 K€

102 94%

270 K€

101 A supplier is selected in the report,

and its ID and other relevant data is

transferred to the corresponding

fields in the Activity.

2

Personalize

Current month

(13)

Continue with…

Supplier Delivery

Performance Trading Volume Last Year

100 98%

550 K€

101 95%

1.230 K€

102 94%

270 K€

Supplier Overview for Material 515

Personalize

Current month

More concepts?

Integration into SAP Smart Business

Visualize using SAP BI

(14)

The new Built-in Analytics Vision

Extraction to SAP BW*

Generic SAP BI clients and Analytical Apps

e.g. SAP BusinessObjects Analysis for Office, SAP

BusinessObjects Design Studio, Smart Business cockpits

Built-In Analytics:

Hybrid Transactional and Analytical Applications

e.g. SAP Embedded BI or SAP Smart Business cockpits

Read-access for

Fact Sheets

Search

*This way SAP enables existing BW extractors to also support Simple Finance and other Innovations in SAP S/4HANA

HANA Platform

Application Tables

External Sources / IOT

Virtual Data

Model

Virtual Data Model

for Search, operational and analytical processing

_Extensions

Customer

Specific Analytics Models

Customer Extensions

SAP HANA

Platform

Virtual Data

Model

(15)

SAP S/4HANA real time analytics architecture

Atomic

Instantaneous

Pre-defined

HANA Database Layer

SQL-Runtime-Views on Physical Tables

ABAP Layer

Virtual Data Model, based on Core Data Services (CDS)

Analytical Apps and BI Clients

e.g. SAP BusinessObjects BI

SAP S/4HANA Application

Hybrid Transactional and Analytical

Applications

e.g. SAP Smart Business cockpits

• Full ABAP Lifecycle Integration

• Supporting ERP authorizations

• Supporting ERP hierarchies

• Part of the general Extensibility concept

• Supporting more business cases

(analytics, search, fact sheets, planning,…)

• No latency

• No data duplication

• Ready-to-use content

• Integration scenarios with SAP BW

(16)

Types of Analytics – Data Warehouse / Data Marts

Virtual Data Models as part of transactional systems

Example: SAP S/4HANA

SAP S/4 HANA

Database Layer,

e.g. SAP HANA

Physical Tables

Virtual Data Model

(based on open CDS)

View

UI’s

BI

Smart Business

Finance

Business

Transactions

Logistics

Etc.

(17)

(18)

(19)

SAP S/4HANA Analytics + SAP Business Warehouse

Comprehensive operational + historical analytics and planning powered by SAP HANA

All analytics requirements fulfilled with one unified solution

Data Integration Scenarios are possible in multiple hybrid system setups



Strategic and tactical



Integration, harmonization,

cross-system consistency



Consumption



Planning



Multi-sourced data



Preconfigured content



Data lifecycle



Data governance



Full-blown analytical suite



Operational data



Real-time



Lightweight modeling and

consumption



Extensible



Uniform



Basis for multiple

embedded use cases



Model reuse in analytical

applications

SAP Business Warehouse on SAP HANA

SAP S/4HANA Analytics

Multi-channel Unified User Experience

SAP S/4HANA

(incl. Virtual Data Model)

SAP NetWeaver New

S AP A pp s Pa rt ne r Ap ps

SAP HANA PLATFORM

SA P Net W ea ve r BW

Database Services (include SAP HANA Views) Synchronizations Services

(20)

(21)



SAP Business Suite 4 SAP HANA provides enhanced analytical capabilities

due to the architecture based on SAP HANA – the

value proposition gets

enhanced by the unique possibilities given with the new architecture, including

reimagined simplified business processes, user experience and business

decisions



The new concept of one semantic layer for search, operational and

analytical processing using open CDS views optimized for SAP HANA

technology and infrastructure, allows

real-time operational reporting and will

be rolled out in all deployments of S/4HANA, cloud and on premise



S/4HANA Analytics complements and does not replace SAP Business

Warehouse (powered by SAP HANA)



With

SAP Smart Business our latest generation of decision supporting

applications

powered by S/4HANA and SAP Fiori combining

new working models with a consumer-grade, multi-channel user

experience.

(22)

Thank you

Contact information:

F name MI. L name

Title

Address