The Many Faces of HANA

– A look at BW4HANA, S/4, SoH

and SoH and HANA Live Reporting
Dr. Bjarne Berg
PricewaterhouseCoopers
This Presentation Comprises:
• Introduction
• SAP BW on HANA
• SoH and HANA Live Reporting
• S/4HANA Embedded Analytics and Reporting
• SAP HANA certified hardware solutions,
• HANA Sizing, MDC, MCOD, MCOS, VM and Cloud
• Conclusion
Introduction – Dr. Berg
This Presentation Comprises:
• Introduction
• SAP BW on HANA
• SoH and HANA Live Reporting
• S/4HANA Embedded Analytics and Reporting
• SAP HANA certified hardware solutions,
• HANA Sizing, MDC, MCOD, MCOS, VM and Cloud
• Conclusion
 SAP BW on HANA, Edition, and BW4HANA
SAP BW 7.5
SAP HANA
BW 7.5 BW 7.5 BW4HANA
Powered by HANA Edition for HANA (SP 4 or higher)
BW/4HANA BW 7.5 on SAP HANA BW on
(B4H) Traditional RDBMS

•SAP GUI Modeling interface •SAP GUI Modeling interface

There is a difference between •Eclipse Modeling
interface
•Eclipse Modeling
interface •InfoObject •InfoObject
•MultiProvider •MultiProvider

• BW 7.5 Powered by HANA •InfoObject •InfoObject •InfoSets

•TransientProvider
•InfoSets
•TransientProvider
• Edition for SAP HANA •CompositeProvider •CompositeProvider •VirtualProvider
•HybridProvider
•VirtualProvider
•HybridProvider
• BW4HANA. •OpenODS View •OpenODS View •Aggregates (summary tables)
•InfoCube (star-schema)
•Aggregates (summary tables)
•InfoCube (star-schema)
•Advanced •Advanced •Reportable DSO •Reportable DSO
Operational Data Operational Data •Write-optimized DSO •Write-optimized DSO
Store (ADSO) Store (ADSO) •Persistent Staging Area (PSA) •Persistent Staging Area (PSA)
•BW 7.x DataFlows •BW 7.x DataFlows
•7.x DataFlows •7.x DataFlows •BW 3.x DataFlows •BW 3.x DataFlows

You can migrate objects manual or through the transfer tool. This is compatibility
mode plus objects transferred, using the transfer tool and the execution of
RS_B4HANA_CHECK_ENABLE report in the “Save New Mode”.
 Getting to BW4HANA

BW on
NEW BW BW 7.3 and 7.4
Traditional
Installations on HANA
RDBMS

Greenfield Upgrade and Migrate

SAP HANA
BW/4HANA BW 7.5 on SAP HANA

•SAP GUI Modeling interface

•Eclipse Modeling •Eclipse Modeling
Preparation •InfoObject
interface interface
•MultiProvider
•InfoObject and •InfoObject •InfoSets
Conversion •TransientProvider
•CompositeProvider •CompositeProvider •VirtualProvider

•OpenODS View •OpenODS View

•HybridProvider
•Aggregates (summary tables)
•InfoCube (star-schema)
Getting there: you can use DMO or
•Advanced
Operational Data
Store (ADSO)
•Advanced
Operational Data
Store (ADSO)
•Reportable DSO
•Write-optimized DSO
•Persistent Staging Area (PSA)
traditional upgrades (in-place) as a
•7.x DataFlows •7.x DataFlows
•BW 7.x DataFlows
•BW 3.x DataFlows migration option.
 An Architected Data Mart on SAP BW on HANA
Rea
l Ex
am p
le
This application was built on
• SAP S/4 on HANA application
(transaction system)

• SAP BW/4HANA
(data warehouse)

• Design Studio 1.6

(dashboarding tool)

The key idea is to leverage SAP technology to its fullest, so that customers with SAP
ECC, SoH or S/4, as their transaction system can easily install the solution
An Architected Data Mart on SAP BW on HANA
Consolidate Book Income GL to Tax Risk Effect Tax Cash Tax SAP Business Objects
d Drill Down Reconciliation Provision Analytics Rate (Actual/Plan) Enterprise and
Report Reconciliation Analytics Analytics
Design Studio v 1.6

SAP BW 7.5
on HANA 2.0
FIGL Consolidated FIGL Provision
Composite Balances Composite
Provider Composite Provider Provider
Architected Data Mart

FIGL FIGL Line Org. CoA Consolidated Provision Legal Entity Tax CoA
Balances items Master Account Balances aDSO Master Account
Master InfoObject Master
InfoObject

Rea
l Ex
a mp
FIGL FIGL Line Consolid Legal CoA Tax Provision Legal Entity Tax CoA
le
Balances items ated Entity Map Account aDSO Master Account
Balances Table Map Table Table Master Table

FIGL FIGL Line Company GL Account Consolidated Financial Tax

Provisioning
Note: Red items are custom content
Balances Items Code Standard Balances and Tax
Standard Standard Standard Extractor Data Data specific, all other are standard SAP objects
Extractor Extractor Extractor
Oracle and Provisioning
BPC
SAP Suite on HANA, and S/4 HANA Finance other sources software

SAP Data Source Systems External Source Systems

 Leveraging Fast Advanced DataStore Objects in SAP (ADSO)

Rea
l Ex
am p
le
Data is stored in Advanced
DataStore objects in the
data warehouse (SAP BW)

Some are standard content

is SAP, while others are
extended data stores for
tax specific data

Using BW DataStore that customer’s IT staff are already familiar with, the data
integration can easily be extended to any clients specific needs
 An Architected Data Mart on SAP BW on HANA
Rea
l Ex
Data mapping is am p
le
using standard SAP
tools and pre-
delivered content.

Additional user
mapping of
accounts (CoA) is
available in the
application.

During upgrades of the SAP system, data mapping is taken care of standard BW content,
and only client specific mapping is done by the users in the application
An XS application on HANA to add Comments to Dashboards

Rea
l Ex
a mp
le

Using an XS application
on SAP HANA users can
add comments and
Insights directly into any
The dashboards are collaborative tools for sharing of Insights dashboard
between analysts, management and executives.
 Cool Features: The SAP XS Comment Application

The comment
section are
developed as an
SAP XS on
HANA
application that
can be tailored to
specific client
needs

The standard Development Workbench for SAP HANA is used so that

additional features can be quickly added
 An Architected Data Mart on SAP BW on HANA
Rea
l Ex
a mp
le
By using standard
BW queries that
SAP customers
are already
familiar with, data
can easily be
extended to any
clients specific
needs

The queries are built on the standard BW query tool from the HANA studio
 Cool Feature: Table Toggle and Download to Excel, CSV or PDF

For all dashboards

user can toggle
between graphs
and detailed data Data can be
tables exported to Excel,
CSV, printed as a
PDF or sent by
email as an
attachment

Users always have access to the underlying data for any graphs or map in the
application
 Ad-hoc querying in Design Studio on HANA
Rea
l Ex
am p
le

By using a BW
Query that expose all Ad-Hoc User defined
Reporting
fields in the
underlying
CompositeProvider
in HANA, users have
access to all data and
can built their own
reports on-the-fly

Reports can be built by end users by simply clicking and

dragging the fields into the report
 Cool HANA Features: Access to Financial Data at Detailed Levels
Summary graphs
of sub-totals

With the speed of

SAP HANA, access to
billions of records are
executed in 1-3
seconds. Therefore,
the application can
provide access to all
details.
Drill down to
details

Users can add

comments and
observations
The whole Chart-of-Accounts (CoA) with 10,000+ accounts and 200 million+ rows is available
in the drill-down and data is read at the detailed level in sub-second speed
This Presentation Comprises:
• Introduction
• SAP BW on HANA
• SoH and HANA Live Reporting
• S/4HANA Embedded Analytics and Reporting
• SAP HANA certified hardware solutions,
• HANA Sizing, MDC, MCOD, MCOS, VM and Cloud
• Conclusion
HANA Live Overview

SAP HANA Live is targeted

to those companies that run
SAP Business Suite
applications on SAP HANA.

The views inside can also be

combined with data from non-
SAP applications.

Installing the HANA Live system on your transaction system can be

done in a matter of hours
 The SAP HANA Live Browser

To make it easier to locate

and understand the views,
SAP has created an SAP
HANA Live browser tool.

Basically, this web page

provides information about
all the content available after
you have installed SAP
HANA Live on your
transaction system

The HANA Live browser can be accessed by navigating to

http://<WebServerHost>:80<SAPHANAinstance>/sap/hba/explorer/index.html in your web browser
Example: Extending a HANA Live View

To avoid affecting the many sub-

components in the VDMs, you have
to cover some basics before beginning
any enhancements.

For example, when creating a new

information view within SAP HANA
studio, there is a Copy From: option
to that you should select

By using this option, you can copy a standard pre-delivered SAP HANA Live
view and then extend it.
 SAP Live Extension Assistant

SAP offers a tool to that assists with the

view copying and extension process
called SAP Live Extension Assistant.
This tool automates much of the
process, thereby reducing the effort
required to add additional fields to your
SAP HANA view.
Using this tool enables you to copy and
extend reuse and query views within
SAP HANA Live.

Copying the view in this way assures that you are not impacting others using the standard view, and also
speeds up the development process. This way, you only have to focus on the additions you are making
and do not have to know all the underlying complexity that may exist in the views (some have 8 to 10
nested views and custom joins).
Reporting on SAP HANA Live with BusinessObjects

In general, reporting in the SAP BusinessObjects suite is

done on top of a universe when consuming SAP HANA
Live data. The universe layer provides a customizable
semantic layer between the SAP HANA calculation views
and the end-reporting tool.

In order to use the real-time reporting capabilities of SAP

HANA Live, the query views are used straight on top of
the Business Suite and no data is moved to the EDW (like
in BW).

It is important to note that some of the newer SAP data visualization and reporting tools (such as SAP Lumira) have native
connectivity to SAP HANA and can skip the need to connect through a BusinessObjects universe, allowing you to connect
directly to the views.

This direct connection to SAP HANA query views can allow for less latency in reporting, which
means even faster front-end execution of reports and visualizations.
Alternatives to Using Universes– Lumira Example

As an alternative to using BusinessObjects universes,

certain SAP reporting tools, such as:
 Lumira,
 Design Studio
 Analysis for Office

can natively consume SAP HANA views or S/4

HANA Embedded Analytics (ABAP based CDS).
.

This means that a universe is not required and data can be consumed directly from the
underlying HANA system through the HANA Live views and S/4HANA Embedded
Analytics you might have created or extended.
This Presentation Comprises:
• Introduction
• SAP BW on HANA
• SoH and HANA Live Reporting
• S/4HANA Embedded Analytics and Reporting
• SAP HANA certified hardware solutions,
• HANA Sizing, MDC, MCOD, MCOS, VM and Cloud
• Conclusion
The difference between SAP HANA Live &
S/4HANA Embedded Analytics
SAP HANA Live and S/4 Embedded
Analytics are both standard SAP delivered
content for real-time operational reporting.

They are based on different technology:

1.SAP HANA Live uses native SAP HANA
SQL views

S/4HANA. CDS views can be

2.SAP HANA S/4HANA Embedded Analytics maintained in ABAP for
is based on ABAP-managed core data Eclipse, while native HANA
services (CDS) of the ABAP layer in SAP SQL views are maintained in
HANA Studio.
S/4 HANA Embedded Analytics and ALPs

S/4 HANA has pre-delivered Analytical

List Packages (ALPs).

Image s Source: Thomas Flekenstein SAP SE 2017

These are similar to content in HANA Live, The S/4 HANA Embedded Analytics consist of VDMs,
and developers also get a tool to build their Queries, Fiori Apps, Cockpits, reports and many other
components
own ALPs
S/4 HANA Embedded Analytics Available Content

S/4 HANA Embedded Analytics

has 197 Fiori applications (available as
of Cloud edition 1702 Feb 2017)

Available Fiori
Functional Area
Applications
Finance 94
Manufacturing 31
Others 25
Purchasing 29
Sales and Distribution 18
Total 197
This Presentation Comprises:
• Introduction
• SAP BW on HANA
• SoH and HANA Live Reporting
• S/4HANA Embedded Analytics and Reporting
• SAP HANA certified hardware solutions
• HANA Sizing, MDC, MCOD, MCOS, VM and Cloud
• Conclusion
HANA Hardware Options

Notes:
1. All POWER8 servers from
IBM are now also certified to
run HANA

2. In 2017 (now) Intel Broadwell

processors are available with
20-24 cores
Key HANA Hardware Options
The World’s fastest SAP BW 7.5 Edition for HANA
SAP HANA Technology is changing very fast and new systems can handle billions of rows
and thousands of queries per hour
Data Load Query Performance
Average Total Runtime of Compliance with the
Average No. of Total No.of Average No. of
Main No. of run time a highly complex SAP Benchmark
Date System Processors 1.3 billion records records accessed records
Memory queries per query Council, audited and
records accessed per by queries accessed per
per hour query (standard test certified by SAP SE
(sec) query (Billions) query
(sec) senario - sec)
Intel Xeon Processor E7-8894 v4, 2.40 GHz, * Current
Lenovo
4 processor / 96 cores World
X3850 Certification number:
02/07/17 2 TB - 64 KB L1 cache 4 hrs 9 min 4,273 50,527,264 0.84 215.903 50,527,264 2 min 34 sec Record (as
Single 2017003
- 256 KB L2 cache per core of March
node
- 60 MB L3 cache per processor 10, 2017)
Intel Xeon Processor E7-8890 v4, 2.20 GHz,
Vendor A 4 processor / 96 cores
Certification number:
02/07/17 Single 2 TB - 64 KB L1 cache 5 hrs 56 min 4,007 52,746,943 0.90 211.357 52,746,943 2 min 39 sec
2017004
node -256 KB L2 cache per core
- 60 MB L3 cache per processor
Intel Xeon Processor E7-8880 v4, 2.20 GHz,
Vendor B 4 processor / 88 cores
Certification number:
12/07/16 Single 2 TB - 64 KB L1 cache 4 hrs 55 min 3,464 50,885,970 1.04 176.269 50,885,970 2 min 58 sec
2016062
node -256 KB L2 cache per core
- 55 MB L3 cache per processor
Intel Xeon Processor E7-8890 v4, 2.20 GHz,
Vendor C 4 processor / 96 cores
Certification number:
08/24/16 Single 1 TB - 64 KB L1 cache 5 hrs 58 min 1,972 51,816,937 1.83 102.183 51,816,937 3 min 22 sec
2016043
node -256 KB L2 cache per core
- 60 MB L3 cache per processor
Source: SAP SE, March 2017 and Dr. Berg
This Presentation Comprises:
• Introduction
• SAP BW on HANA
• SoH and HANA Live Reporting
• S/4HANA Embedded Analytics and Reporting
• SAP HANA certified hardware solutions
• HANA Sizing, MDC, MCOD, MCOS, VM and Cloud
• Conclusion
HANA Sizing Tool for Existing
BW Implementations (cont.)
To increase speed, you can
suppress analysis tables with
SAP has an updated tool that generates a report less than 1 MB size
significantly better for sizing SAP BW than
using the QuickSizer

This tool should be used by all existing BW

implementations for sizing (QuickSizer is only The higher precision
you run the estimate
for new implementations) at, the longer the
program is going to
This program takes into consideration existing run
databases, table types, and includes the effects
of non-active data on the HANA system

With 8 parallel processors and 10TB database, it is not unusual

to see 3-5 hours runtime
SAP BW on HANA Automated
Sizing Tool
Since timeouts are common when running the sizing
program, you can temporarily change the parameter in
rdisp/max_wprun_time to 0 in BW transaction RZ11.
Finally, you estimate the growth for the system as a
percentage or as absolute growth.

The output is stored in the file you specified and

the file can now be emailed to hardware vendors
for sizing input and hardware selection

This program is referenced in SAP Notes 1909597 and

1736976 on the SAP Service Marketplace
SAP S/4 HANA Automated Sizing
Tool
There is also a sizing tool for SoH and for S/4 migrations

Use the report called /DF/HDB_SIZING

It is found in SAP Note: 1872170 Thanks to Hisham Gawish, 2017
HANA Sizing Options – Summary from SAP

Thanks to Sebastian Schmitt, SAP SE, 2017

Key Cloud Options
Save Money with MCOD and MCOS
1. You may not need separate hardware for sandbox and development environments
2. Using Multiple Components One Database (MCOD) and/or Multiple Components One System
(MCOS) you can simplify the number of hardware environments you need

a) SAP BW on SAP HANA

b) SAP Finance and Controlling Accelerator for the material ledger
c) ERP operational reporting with SAP HANA
d) SAP Finance and Controlling Accelerator: Production Cost Planning
e) SAP Rapid Marts
f) SAP COPA Accelerator
g) SAP Operational Process Intelligence
h) SAP Cash Forecasting
i) SAP Application Accelerator/Suite Accelerator
j) Smart Meter Analytics

In addition to custom developed datamarts, all items above can run in an MCOD
setup (see SAP Note 1666670 for more details)
Example from Real Company - BW HANA System
Landscape
MCOS

Note that the QA and Production system are kept the same size so that performance tests
are accurate and so that the QA system can be used as for disaster recovery
Multitenant Database Containers (MDC) Deployments

APPLICATIONS •A tenant database is a single database container

Application A Application B •You can save money by running multiple tenant
databases on a single HANA system
SAP HANA
•MDC is supported for production systems and
System
Database
you can backup for each tenant database

Tenant Tenant
•You can manage resources such as memory and
Database Database CPU for each of the tenant databases

MDC became available with SP-9 of HANA in 2015!

MDC Deployments Details
MDC can be used in Platform & Enterprise Cloud
For on-premise it can replace most MCOS deployments and
many of the MCOD scenarios
There is no virtualization overhead, and scale-out systems with
standby nodes is supported
You can use SQL to query across databases:
I.e., SELECT *
FROM schema1.Customers AS tab1, db2.schema2.Customers as tab2
Individual database backups and WHERE tab2.column2 = ‘Johnson’
restores can be done from HANA Studio
NOTE: Attribute and analytic views must be converted to calculation views
to be used as remote tenant dat abase objects

• The privilege “Database Admin” allows you to separate admin access to each database
• You can convert a HANA system to MDC, but it cannot be converted back
(command: hdbnsutil –convertToMultiDB)
 MDC Monitoring

The HANA
cockpit can
monitor both the
system and tenant
databases

You can connect to any system and

tenant database using HANA studio.
The DBA Cockpit can
also be used to
monitor databases
This Presentation Comprises:
• Introduction
• SAP BW on HANA
• SoH and HANA Live Reporting
• S/4HANA Embedded Analytics and Reporting
• SAP HANA certified hardware solutions
• HANA Sizing, MDC, MCOD, MCOS, VM and Cloud
• Conclusion
Reference to More Comprehensive Information:

• Introduction to SAP HANA – SAP Press, Bjarne Berg, Penny Silvia and
Rob Frye. ISBN-978-1-4932-1408-2
https://www.sap-press.com/sap-hana_4160

• SAP HANA Sizing details for all apps

http://tinyurl.com/HANASizing

• SAP S/4HANA Embedded Analytics – A detailed Walkthrough

 http://tinyurl.com/S4Embedded
How to contact me:

Dr. Bjarne Berg

[email protected]