SAP NetWeaver Business Warehouse powered by SAP

[
SAP NetWeaver Business Warehouse
powered by SAP HANA – Deep Dive
Rainer Uhle
Brian Wood
....
....
RUN COOLER
[ Agenda / Take away
The evolution of in-memory technology at SAP moves along
“We did it our way …”
Latest stage: SAP HANA Database as a full fledged in-memory
database
“ Ja – wir können ….”
SAP BW as one of the first applications fully enabled to leverage
the key strength of the new HANA In-memory database
Accelerated performance
Simplified administration and infrastructure
Dedicated optimizations available for specific
BW modeling objects
First Results from Customer Projects …
POCs and Ramp-Up
… next steps
LSA in times of HANA
Real Experience. Real Advantage.
together with
System Demos
Look&Feel …..
Non-disruptive ………
BWA like ……
HANA Optimizations
…..
Take away 1
The evolution of in-memory technology at SAP moves along
“We did it our way …”
In-memory technology has been offered for caching strategies in many ways so far at SAP (BW:
DB -, OLAP-, Query-Caching; BW Accelerator; APO Live Cache; …)
Caching guarantees better performance but also stands for replication, buffering, snapshooting,
read-only, invalidation after updates, reload, rebuild etc.
Realizing full support for an in-memory data base means much more …
[ In-Memory Computing Product - Vision
SAP High Performance Analytic Appliance
BI Clients
SAP
BusinessSuite
SAP
BusinessSuite
Mobile
SAP
BusinessWarehouse
New SAP
Applications
Further
Applications
In-Memory Computing Platform
This presentation outlines our general product direction and should not be relied on in making a purchase decision. 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.
Real Experience. Real Advantage.
[ The Evolution of SAP HANA – Landscape Options
SAP HANA 1.0 is an appliance to the application
(e.g. SAP ERP).
Its major benefit is increasing performance of transactional
reporting for one system.
SAP HANA 1.0 replicates /loads data using replication/
ETL tools
SAP HANA 1.0, SPS3 is the primary persistence for
SAP NetWeaver BW 7.3, SP5.
All functionality of SAP HANA 1.0 will still be available in
Release 1.0, SPS3.
All features of SAP NetWeaver BW are supported by
SAP HANA 1.0, SPS3
SAP HANA Vision is the next evolution step and long term
will also replace the data base of the ERP system.
Option „SAP HANA 1.0“
SAP ERP
SAP
HANA 1.0
RDBMS
Real Experience. Real Advantage.
RDBMS
Option „SAP HANA 1.0,
SPS3“
SAP NW BW
BWA
SAP NW BW
RDBMS
SAP HANA
Option „SAP HANA Vision“
SAP ERP
RDBMS
(*) Migrating to further SAP HANA releases is optional
SAP ERP
SAP ERP
SAP NW BW
„HANA Vision“
[ SAP NetWeaver BW7.3 Powered by SAP HANA
Added Value
Accelerated performance
BWA
Excellent query performance as proven
with BWA
Accelerated In-Memory planning capabilities
Performance boost for ETL processes
SAP NW BW
RDBMS
BW Upgrade
DB Migrate
SAP NW BW
SAP HANA
Simplified administration and infrastructure
DB and BWA merging in one instance for lower TCO
Simplified administration via one set of admin tools e.g.
for Data Recovery and High Availability
Column based storage with highly compression rates and
significantly less data to be materialized
No special efforts to guarantee fast reporting on any DB object
Simplified data modeling and reduced materialized layers
Integrated and embedded flexibility for Data Marts
This presentation outlines our general product direction and should not be relied on in making a purchase decision. 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.
Real Experience. Real Advantage.
Take away 2
Latest stage: SAP HANA Database as a full fledged in-memory database
“Ja – wir können ….”
DBSL available for SAP HDB
DBA Cockpit for Administration
BW Accelerator obsolete
[ Database Shared Library (DBSL)
Purpose: Open Platform Concept supporting several Standard RDBMS
The database-dependent
part of the SAP database
interface can
be found in its own
library that is dynamically
linked to the SAP kernel.
This database library
contains the Database
Shared Library (DBSL), as
well as libraries belonging
to the corresponding
database manufacturer.
These are either statically
or dynamically linked to
the database library.
Real Experience. Real Advantage.
[ Final Result -
SAP HANA Database Overview
(DBACOCKPIT)
Real Experience. Real Advantage.
[ After system migration: BW
Accelerator obsolete
In BW on a relational DataBase we had speedy query execution using
the BWA
In the BW system on HANA DB we do not need the BWA anymore
as data is stored in memory anyway
Check transaction RSDDBIAMON: SAP NetWeaver BW
Accelerator Monitor
Real Experience. Real Advantage.
[ SAP SMART Meter Analytics
BW on HANA based example
Dashboard
Instantly aggregate time
of use blocks
and total consumption
profiles
Segment customers
based on
energy consumption
patterns
Provide energy efficiency
benchmarking
This analysis is based on a
query accessing a Smart
Metering BW 7.3
MultiProvider with data
access in BW on HANA
BW on HANA Look&Feel:
BWA like Query
performance
out of the box
Real Experience. Real Advantage.
[ SAP NetWeaver BW7.3 Powered by SAP HANA
How Does BW 7.3 Running on HANA Differ from BW Running on xDB ?
SAP NetWeaver BW 7.x on
xDB
SAP NetWeaver BW 7.3 on HANA
SAP HANA-optimized DataStore
Objects
SAP HANA In-Memory platform
SAP HANA-optimized InfoCubes
In-Memory planning engine
Standard DataStore Objects
Data Base server and SAP
NetWeaver BWA
Standard InfoCubes
BW Integrated Planning
HANA Data Marts running
side-by-side BW
BWA
SAP NW BW
RDBMS
Consumption of HANA artifacts
created via HANA studio
BW staging from HANA
BW Upgrade
DB Migrate
SAP NW BW
SAP HANA
Migration without reimplementation - no disruption of existing scenarios
Real Experience. Real Advantage.
Take away 3
SAP BW as one of the first applications fully enabled to leverage the key strength of the new
HANA In-memory database
Accelerated performance
No special efforts to guarantee fast BWA like reporting on any DB object
Accelerated In-Memory planning capabilities
Performance boost for ETL processes (DSO Activation 5-10 times faster, InfoCube load 5 times faster )
Simplified administration and infrastructure
DB and BWA merging in one instance for lower TCO
Column based storage with highly compression rates and significantly less data to be materialized and managed
Simplified data modeling and reduced materialized layers
Dedicated optimizations available for different BW modeling objects
[ In-Memory Optimized DataStore Objects
Mapping Between Application Server and HANA DB
Activation Queue
Active Data
Change Log
(BW / ABAP)
Column based table
Former Load 5455 I 30
Actual Load 5455 I 20
DataStore
Request Activation
(HANA DB / C++)
History Index Valid from to
..5455 I 30...
..dt1......dt2
Main Index
......5455 I 20 ....valid from dt2
Delta Index
Standard column based
table
no primary key,
performance
advantage 20%
Real Experience. Real Advantage.
Temporal table
Calculation View
Before Image 5455 I -30
After Image 5455 I 20
Table replaced by calc
view (uses history index
to create a change log
view of
the data)
View calculates technical
key on the fly
Multiple updates for a
particular key are
consolidated into one
[ Delta Management and Consistent View in Column
Store
+
+ ++
Real Experience. Real Advantage.
[ DSO Load&Activation Performance – Overview
Example
DSO Type
Classic DSO
on RDBMS
Classic DSO
on HANA DB
HANA optimized
DSO
Loadtime
22 min
18 min
14 min
Activation Time
5650 secs
1923 secs
394 secs
Real Experience. Real Advantage.
[ SAP HANA-optimized InfoCubes
Faster Data Loads and Easier Modeling
Traditional InfoCubes tailored to a relational DB
consist of 2 Fact Tables and the according Dimension
tables
SAP HANA-optimized InfoCubes represent “flat”
structures without Dimension tables and E tables*:
Up to 5 times faster data loads (Lab Results)
Creation of DIM Ids no longer required
Simplified Data modeling
Faster remodeling of structural changes
After the upgrade to BW7.3, SP5 all InfoCubes
remain unchanged
Tool support for converting standard InfoCubes
Preliminary lab result: 250 Million records in 4
minutes
No changes of processes, MultiProvider,
Queries required
MD
MD
D
F
E
Facts
D
MD
MD
Conversion/New
… together with
System Demos
MD
MD
F
Facts
Look&Feel …..
Non-disruptive ………
MD
BWA likeMD……
*Tables for compressed data
HANA Optimizations
…..
This presentation outlines our general product direction and should not be relied on in making a purchase decision. 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.
Real Experience. Real Advantage.
[ Query performance
Proven Query Performance as Known from BWA
SAP NW BW
Query acceleration on BW InfoCubes
No replication – fast query access directly on
primary data persistence
Indexes on InfoCubes and InfoObjects no
longer required -> No Roll-ups, Change runs
In-memory Calculation Engine
TopN, BottomN,
Exception aggregation
Currency conversion
...
Snapshot Indexes for Virtual- and QueryProvider
Query acceleration on BW DataStore
Objects(DSO)
Query on
DSO, BW InfoSet
Query on
InfoCube, Masterdata
AnalyticIndex,
CompositeProvider
SAP HANA
SQL Engine
Calc Engine
Aggregation Engine on In-Memory data
Acceleration via In-Memory column storage
Additional acceleration via Logical Views to SIDs on top of DSO
No changes of processes, MultiProvider, Queries required
This presentation outlines our general product direction and should not be relied on in making a purchase decision. 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.
Real Experience. Real Advantage.
Take away 4
Next Steps
LSA in times of HANA
Simplification through Layer Reduction
HANA optimized SID Handling during Activation
Query Performance on DSOs
Near-line Storage (NLS) in times of HANA
BW based NLS Interface
Example: NLS with Sybase IQ
[ SAP HANA-optimized DataStore object
Simplification through Layer Reduction – PoC Example
Classical
Architecture
SAP HANAoptimized
Reporting
Aspects
Reporting directly on
DataStore objects
No replication to
InfoCubes / BWA
Significant reduction of
TCO/TCD and load
time improvements
Real Experience. Real Advantage.
[ SAP HANA-optimized DataStore object
SAP HANA-optimized SID Handling (Anti-Join)
0COMPCODE
0DEBITOR
0SALESORG
0AMOUNT
0DEBITOR
0000054
1
0001
0000001
1000
10
2
0001
0000021
1000
20
3
0001
0000054
1000
100
4
0001
0000001
1000
20
SELECT DISTINCT InfoObject
FROM Activation Queue
WHERE InfoObject NOT IN
SELECT *
FROM SID-Table
SELECT * FROM Activation Queue
0SALESORG
SID
1000
00008
0COMPCODE
0DEBITOR
0SALESORG
0AMOUNT
1
0001
0000001
1000
10
0DEBITOR
SID
2
0001
0000021
1000
20
0001
00005
0021
00006
0COMPCODE
SID
3
0001
0000054
1000
100
0001
00001
4
0001
0000001
1000
20
Activation Queue
Classical Architecture
Real Experience. Real Advantage.
SAP HANA-optimized
[ DSO SID Handling during Activation – Overview
Example
SID Condition
SIDs exist
SIDs missing
Activation Time
375 secs
485 secs
Real Experience. Real Advantage.
[ SID Handling with Anti-Join
Lab Results
Scenario Setup
Standard DataStore
Key Fields: 11
Data Fields: 37
Cardinality (distinct values):
3000
x4
x34
2500
R
u
n
t 2000
i
m
e 1500
30 characteristics < 100 rec
2411
2399
3 characteristics < 1000 rec
2 characteristics < 10.000 rec
1 characteristics < 1 Mio rec
Worst-Case
(empty SID tables)
Best-Case (SIDs
exist)
i
n
1000
s
e
c
10.3 Mio rec in Activation Queue
683
500
70
0
Anti-Join
Real Experience. Real Advantage.
Classical
1 characteristics = 10.3 Mio
[ Runtime Estimation – Process View
Based on Lab Results – 10 Mio rec Delta, 100 Mio rec Active
DataStore
on RDBMS
SIDs
available
HANA opt.
DataStore
SIDs not
available
HANA opt.
DataStore
SIDs
available
DataStore
on RDBMS
HANA opt.
DataStore
Real Experience. Real Advantage.
[ SAP HANA-optimized DataStore object
Reporting Performance DSO against InfoCube
Classical
Architecture
HANA
InfoCube optimized
SAP HANAReporting
optimized
DSO Reporting
Real Experience. Real Advantage.
[ Bill Inmon’s Corporate Information Factory & Near-Line
Storage
DSS Applications
Departmental Data Marts
Acctg Finance
Marketing
ERP
ERP
ERP
Sales
CRM
Changed
Data
ERP
Corporate
Applications
Staging Area
ETL
eComm.
EDW
Exploration
warehouse/
data mining
Global
ODS
local
ODS
Oper.
Mart
Granularity
Manager
Session
Analysis
Dialogue
Manager
Internet
Real Experience. Real Advantage.
Bus. Int.
Cookie
Cognition
Preformatted
dialogues
Cross media
Storage
Near line
Storage
Management
Archives
Web Logs
Source:Bill Inmon
[ The Nearline Storage Solution for SAP
NetWeaver BW
Based on the NearLine Storage Interface Development Partners can implement their Solutions for
Archiving and NLS into the SAP BW
3rd Party NLS Solutions
are implemented within the SAP BW ABAP Stack in partner specific namespaces
have to pass a certification process
can offer specific Application Area in the SAP Support Portal
have to be licensed in addition to SAP licenses
can have a different release cycle compared to SAP NetWeaver BW
NLS
Partner
Solution
Present development partners
Certified since SAP BW 7.0
(in alphabetical order of their products)
CBW® – PBS Software
Dynamic NearLine Access® - SAND Technology
DB2 Viper 9.5® - IBM
DataVard OutBoard 1.0
yes
yes
7.01 SP6
yes
(see also http://www.sap.com/ecosystem/customers/directories/SearchSolution.epx )
Real Experience. Real Advantage.
[ SAP NetWeaver BW Nearline Storage on PBS
CBW
With CBW PBS provides an add-on solution for the data retrieval of
archived/nearlined BW data.
On the basis of the SAP ADK files, the CBW solution creates aggregates on
the archive data and (optionally, if needed) index structures to enable a fast
retrieval option for the archived data directly from the end-user's original
query.
PBS CBW NLS IQ for Sybase Analytics Server IQ utilizes the Sybase
Analytics Server IQ as a nearline database and offers extremely fast query
response times.
Real Experience. Real Advantage.
[SAP BW powered by HANA and Sybase IQ
NLS
BW
InfoProvider
Near-line Storage
Archiving
Acquisition
HANA DB
Access - very frequently
Real Experience. Real Advantage.
frequently
Next generation near-line SMART
STORE solution for BW powered by HANA.
•Combining real-time analysis with cost-efficient
data storage
•Cost- + Performance-Optimized EDW
•Data lifecycle management
•Data Aging strategy
not frequently
rarely
[ SAP BW powered by HANA
NLS Example with PBS CBW and Sybase IQ
Real Experience. Real Advantage.
Vielen Dank!
Many Thanks!
[© 2012 SAP AG. Alle Rechte vorbehalten.
Weitergabe und Vervielfältigung dieser Publikation oder von Teilen daraus sind, zu
welchem Zweck und in welcher Form auch immer, ohne die ausdrückliche schriftliche
Genehmigung durch SAP AG nicht gestattet. In dieser Publikation enthaltene Informationen
können ohne vorherige Ankündigung geändert werden.
Google
Google
Google
Marken
Die von SAP AG oder deren Vertriebsfirmen angebotenen Softwareprodukte können
Softwarekomponenten auch anderer Softwarehersteller enthalten.
INTERMEC ist eine eingetragene Marke der Intermec Technologies Corporation.
Microsoft, Windows, Excel, Outlook, und PowerPoint sind eingetragene Marken der
Microsoft Corporation.
Bluetooth ist eine eingetragene Marke von Bluetooth SIG Inc.
IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x,
System z, System z10, z10, z/VM, z/OS, OS/390, zEnterprise, PowerVM, Power
Architecture, Power Systems, POWER7, POWER6+, POWER6, POWER, PowerHA,
pureScale, PowerPC, BladeCenter, System Storage, Storwize, XIV, GPFS, HACMP,
RETAIN, DB2 Connect, RACF, Redbooks, OS/2, AIX, Intelligent Miner, WebSphere, Tivoli,
Informix und Smarter Planet sind Marken oder eingetragene Marken der IBM Corporation.
Linux ist eine eingetragene Marke von Linus Torvalds in den USA und anderen Ländern.
Adobe, das Adobe-Logo, Acrobat, PostScript und Reader sind Marken oder eingetragene
Marken von Adobe Systems Incorporated in den USA und/oder anderen Ländern.
Oracle und Java sind eingetragene Marken von Oracle und/oder ihrer
Tochtergesellschaften.
UNIX, X/Open, OSF/1 und Motif sind eingetragene Marken der Open Group.
Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame und MultiWin
sind Marken oder eingetragene Marken von Citrix Systems, Inc.
HTML, XML, XHTML und W3C sind Marken oder eingetragene Marken des W3C®,
World Wide Web Consortium, Massachusetts Institute of Technology.
Apple, App Store, iBooks, iPad, iPhone, iPhoto, iPod, iTunes, Multi-Touch, Objective-C,
Retina, Safari, Siri und Xcode sind Marken oder eingetragene Marken der Apple Inc.
IOS ist eine eingetragene Marke von Cisco Systems Inc.
RIM, BlackBerry, BBM, BlackBerry Curve, BlackBerry Bold, BlackBerry Pearl, BlackBerry
Torch, BlackBerry Storm, BlackBerry Storm2, BlackBerry PlayBook und BlackBerry App
World sind Marken oder eingetragene Marken von Research in Motion Limited.
Real Experience. Real Advantage.
App Engine, Google Apps, Google Checkout, Google Data API, Google Maps,
Mobile Ads, Google Mobile Updater, Google Mobile, Google Store, Google Sync,
Updater, Google Voice, Google Mail, Gmail, YouTube, Dalvik und Android sind
oder eingetragene Marken von Google Inc.
Wi-Fi ist eine eingetragene Marke der Wi-Fi Alliance.
Motorola ist eine eingetragene Marke von Motorola Trademark Holdings, LLC.
Computop ist eine eingetragene Marke der Computop Wirtschaftsinformatik GmbH.
SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP BusinessObjects Explorer,
StreamWork, SAP HANA und weitere im Text erwähnte SAP-Produkte und
-Dienstleistungen sowie die entsprechenden Logos sind Marken oder eingetragene Marken
der SAP AG in Deutschland und anderen Ländern.
Business Objects und das Business-Objects-Logo, BusinessObjects, Crystal Reports,
Crystal Decisions, Web Intelligence, Xcelsius und andere im Text erwähnte BusinessObjects-Produkte und -Dienstleistungen sowie die entsprechenden Logos sind Marken
oder eingetragene Marken der Business Objects Software Ltd. Business Objects ist ein
Unternehmen der SAP AG.
Sybase und Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere und weitere im Text
erwähnte Sybase-Produkte und -Dienstleistungen sowie die entsprechenden Logos sind
Marken oder eingetragene Marken der Sybase Inc. Sybase ist ein Unternehmen der
SAP AG.
Crossgate, m@gic EDDY, B2B 360°, B2B 360°Services sind eingetragene Marken der
Crossgate AG in Deutschland und anderen Ländern. Crossgate ist ein Unternehmen der
SAP AG.
Alle anderen Namen von Produkten und Dienstleistungen sind Marken der jeweiligen
Firmen. Die Angaben im Text sind unverbindlich und dienen lediglich zu Informationszwecken. Produkte können länderspezifische Unterschiede aufweisen.
Die in dieser Publikation enthaltene Information ist Eigentum der SAP. Weitergabe und
Vervielfältigung dieser Publikation oder von Teilen daraus sind, zu welchem Zweck und
in welcher Form auch immer, nur mit ausdrücklicher schriftlicher Genehmigung durch
SAP AG gestattet.
[
Please remember to complete and return your
evaluation form following this session.
For ongoing education on this area of focus, visit the
Year-Round Community page at www.asug.com/yrc
[
Real Experience. Real Advantage.
]
Thank you for participating.
SESSION CODE:
INSERT SESSION CODE
34