sap innovation summer camp come with a curiosity …fm.sap.com/data/upload/files/07 sap innovation...

SAP Innovation Summer Camp

Come with a Curiosity – Leave with a Plan

Accelerators for Financials

Track Hosts:

Lars Buescher & Gilberto Henn

SAP AGS, July 2012

Finance Track Accelerators leveraging HANA today

© 2012 SAP AG. All rights reserved. 4

Agenda

Overview

HANA Application Accelerator

HANA Accelerators (side by side scenarios)

HANA Analytics

Summary


HANA Accelerators – Principle

DB Table

ERP System

ABAP-

Program

write

Copy of

DB Table

HANA DB re

ad

HANA DB is maintained as secondary DB in ERP and connected as RFC connection

Table replication

or line-wise inserts

Accelerated read


HANA Accelerators - Overview

HANA based Analytics (Operational Reporting)

• Business Suite data are replicated into HANA for reporting

purposes

• Enables extreme fast analytics

• On large data volumes

• Report models are build with the HANA Studio

• Predefined by SAP and delivered e.g. as Rapid Deployment Solution

(RDS)

• Custom built for specific customer needs

HANA as Accelerator for existing business processes

• Mass data (time consuming selects) are read from the HANA

database

• Application specific accelerators (e.g. CO PA or CO PC) read

data from HANA and leverage HANA specific performance

advantages (e.g. grouping or summarization of data)

• The generic Application Accelerator (HANA switch with new

Kernel SAP NW 7.21) redirects only specified data selects to

HANA and allows to leverage HANA for existing programs

without changes to them


Accelerators – Leveraging different aspects of HANA

Suite Accelerator

Partitioning of DB

Tables

Joins

Sum By / Group By

Calculation Views

OLAP Views

HANA Application Accelerator

Accelerators leveraging HANA today


Example for HANA Value Roadmap for

Operative Business and Business Intelligence

Accelerate existing

business processes

leveraging available

Accelerators +

Application Accelerator

New BW

Integrated

Planning

EPM /

BO

Selected ERP applications

...

ERP Reporting, Customer

Reports ,Batch Jobs

… Leverage

HANA Accelerators

Creates real realtime

Enterprise Data

warehouse

Enterprise Data Warehouse

on HANA STEP 2

Makes simulations real Strategic Planning Platform

on HANA STEP 3

STEP 1

Enables board-room

realtime Enterprise

Performance

Management

Enterprise Performance

Management on HANA STEP 4

Real Time Data

Mining

Selected Examples


Application Servers

HANA Application Accelerator - Architecture

HANA SLT

replication

Read O

nly

Transactional DB

Real Time

replication

SAP NW 7.21 Kernel on App.

Servers

HANA as a secondary DB

Tables / DB Views

Main program

Batch job name

Clients

SAP NW 7.21 Kernel installed

New non modifying ABAP add-on


HANA Application Accelerator – In Detail

Main benefit: Allows to leverage HANA for

current programs without changing them

without disruption

How it works: Runtime intensive table selects can

be redirected to the HANA database instead being

selected from the primary database

• Selected tables are replicated using SLT in near

real-time to the HANA database

• The following parameters identify the program

context for reading from the HANA database:

• Tables / DB Views

• Main program

• Batch job name (wildcards supported)

• On kernel level a select statement within this

configuration is redirected to HANA – no changes

on program required

HANA Application Accelerator consists of:

7.21Kernel: To be installed on all

application servers

Non modifying add-on to configure

scenarios

In addition:

SAP LT for real time replication


Summary: Application Accelerator

How it works

Read access to specific – time intensive – tables / program combinations is redirected to HANA and not to the primary

database

Those tables are replicated to HANA near real time with the SAP LT tool

Table read access to HANA is configured via a customizing the NW 7.21 kernel

Potential Candidates for Acceleration

Runtime intensive ERP transactions or CRM reports (Information Reports)

Period End Jobs, Reports that are executed typically in background

Strength

Allows to leverage HANA for current programs without changing them non disruptive

Using HANA for critical tables avoids transactional database access latency to data that are nor buffered

Only a few changes in ABAP reports necessary, which have to be optimized anyway to avoid nested table selects and loops

and to speed up the overall performance

Limitations

Application Accelerator can´t be used for programs where delayed replication of a table could lead to inconsistencies

No update scenarios during interactive reporting on replicated tables possible

The Application Accelerator does not leverage all HANA capabilities and does therefore not reach the same performance

as possible with Modeling in HANA Studio or with HANA specific accelerators


Application Accelerator – Scenario Definition

A scenario consists out of the tables to be accessed via the Suite Accelerator

It is recommended to define a scenario always with the main program:

Scenario Name

Main Program (sy-cprog)

Table Name (several entries)

Job name (optional)

A scenario is defined as XML File

Upload, Activation etc. with

Report RDA_MAINTAIN


Application Accelerator – Setup

Note’s 1666248 and 1694697 containing detailed information

These notes are only released on request; please contact your TQM in order to release these

notes

Identify Opportunity (EWA check – Solution Manager SP13) followed by HANA Feasibility

Check

Check technical prerequisites (HANA Client Library mandates Unicode system, as well as

specific operating systems / database systems

Obtain approval for the ABAP Add On (contact your TQM)

Install new 7.21 kernel - has to be installed on the application server(s)

Activation on (selected) servers with profile parameter rsdb/rda = on

Establish HANA as secondary database, see note 1597627

Define Programs / Scenarios for Suite Accelerator and relevant tables

Replicate identified tables


Use of HANA Switch Kernel

to accelerate Z reports

Possible combined usage scenario: Kernel Approach and

Accelerator or HANA Studio

HANA

ERP

Traditional DB

Z Report

SAP GUI

HANA

SBO BI 4.0

Platform or reach

client

ERP

Traditional DB

Z Report

SAP GUI

Use of HANA Studio

to accelerate report through BI 4.0

with HANA studio and BI 4. with Kernel

+

Proof Points



Customer Example 1

Project System Reporting

Project Infosystem Line Item Reporting

Setup:

Measurements are based on

transactions/reports with critical tables for

Project System where DB Access counts for

80% to 90% of the overall runtime.

Results:

Latency due to disc access can be avoided using HANA.

This means for the customer reporting cases an

acceleration of factor 5 to 8 (database part)

0

10000

20000

30000

40000

50000

60000

70000

80000

Oracle / PEP SAP HANA

0

10000

20000

30000

40000

50000

60000

70000

80000

Oracle / PEP SAP HANA

ms ms Primary DB Primary DB


Customer Example 2

Sales Order Reporting (Customer will go live in July 2012)

No. Of

Records

without HANA

(seconds)

with HANA

(seconds)

Improvement

factor

Query 1 1 million 32 0.07 457 times

faster


faster


faster

Query 4 1600 sec 200 sec 8 times faster

Queries 1-3 realized using HANA Studio, Query 4 using the HANA

Application Accelerator


Customer Example 3

Customer Reports (Customer will go live in August 2012)

354 x

119 x

22 x

1,2 x

2,2 x

1,6 x

times

faster


Customer Example 4

Customer Reports

Oracle

total(s) Oracle(DB)s

HANA

total(s)

HANA

DB(s)

Total

improvement

DB

Improvement

Report 1

Version 1 378.11 376.53 1.53 0.19 247 times 1981 times

Version 2 2394.44 2205.9 268.57 6.35 8.9 times 347 times

Version 3 1342.28 1237.1 114.32 6.29 11 times 196 times

Report 2

231.938 227.47 7.94 4.21 29 times 54 times


Customer Example 5

Customer Reports

Technical Preconditions for Application

Accelerator (HANA switch in new Kernel)



Installation New Kernel SAP NW 7.21

Upgrading to the 7.21 kernel does not

differ from the usual kernel update.

The 7.21kernel is - except the described

feature identical to the 7.20 kernel

It is released for productive usage (ABAP

environments) – combined ABAP / JAVA till

end 2012

Maintenance and support is analog to the

7.20kernel

Older SAP NW Kernel versions will run out

of maintenance by August 31st, 2012 (see

note: 1629598). Since customers need to

upgrade to the downward-compatible SAP

NW Kernel 7.20 over the next months

anyway, they can also alternatively install the

new SAP NW 7.21 Kernel to start leveraging

HANA

Please refer to SAP Note 1636252

describing the kernel upgrade in detail.

https://service.sap.com/sap/support/notes/1629598

HANA Accelerators



HANA Accelerators – Leveraging HANA to accelerate

specific ERP or Business Suite Programs

HANA Accelerators are new programs leveraging HANA to accelerate

current ERP or Business Suite Programs

They are optimized to benefit from the features HANA provides:

Table access leverages the performance benefits of HANA for grouping or

summarizing table content

Evaluation or access to large amount of data based on none-key fields

Required a change or to some extend a redesign of the program

Examples for Accelerators are:

– CO PA Accelerator

– Various CO Accelerators: Material Ledger Accelerator, Overhead Costing Accelerator, Line

Item Reporting for Cost Centers, Internal Orders and Projects

– Material Document List (in development)

Comparison – Specific HANA Accelerators vs. Application Accelerator

Where a HANA specific Accelerator is available (e.g. CO-PA accelerator) it should

be used for this purpose – typically faster than Application Accelerator and more

capabilities as specifically developed for this purpose

Often HANA Accelerators are combined with RDS packages (CO-PA; Operational

Reporting; …)

Both “techniques” can be used together on one e.g. ERP system


Accelerators – Focus on HANA Strengths

HANA DB has great performance:

Reading data

With “group by”

With where-clauses on non-indexed fields

Where operations can be performed in memory (count,

order by, analytical views) – pushing operations down to

the database

Complex Joins

Performance is similar to a conventional DB:

Reading whole table contents sequentially

Select Single

Repeated calls for the same data (buffered data)

Reading data with where-clauses using key fields or

indexes

Inserts

Deletes


Example: CO PA Accelerator - Functional Architecture In-Memory DB as 2nd DB to accelerate data selection in all CO-PA processes

CO

-PA

Re

ad-in

terfa

ce

SD

FI

OM

PC

OBJ

CRM

…

CO-PA

Database

ERP-Reporting &

BW-Upload

Costcenter-

allocation

Top-Down-

distribution

…

K81 K81.1

CO-PA

Line Items

K81 K81.3

Customer-def.

Aggregation

Levels

In Memory DB

Classic DB

„Best Choice of

Source“

Add Delta

Periodic

Update

Initial

Build


CO-PA Accelerator Accelerating Period-End Closing

Cost Center Allocation to CO-PA

Classic

DB

SD, FI, OM, PC, OBJ, CRM, …

Customer Material Branch Revenues

1000 P-100 Pump 100,-

2000 P-100 Pump 200,-

1000 P-200 Pump 300,-

1000 C-47 Cycle 100,-

1000 C-48 Cycle 150,-

3000 C-48 Cycle 150,-

Cost Center

60%

40%

Profitability-

segments

Distribution

according to

Revenues on

a level of

branch

CO-PA Read-

function

SAP HANA

DB

+ Delta

Accelerating Cost Center Allocation to CO-PA


CO-PA Accelerator Accelerating Period-End Closing

Selection of reference data Processing & posting

Processing & posting

time

ERP

ERP + HANA

Total runtime reduced

by 2-50% maximum

(case-dependent)

8 h 4 h

Allocation with CO-PA accelerator

Selection of reference data from

line items directly

Efficient access to data by any

criterion e.g. all data without product

attribute which needs to be allocated

to products

Allocation w/o CO-PA accelerator

Optimization of summarization

levels can be time-consuming

Read access for any field can be

difficult to support by indices


CO-PA data quantity structure

~ 220 Mio line items

~ 110 Mio CE4 items

ERP without

SAP HANA

ERP with

SAP HANA

Acceleration factor

CO-PA drilldown report “Sales”

• initial run for year 2011 480 sec 12 sec 40

• drilldown by Profit Center 280 sec 3 sec 90

CO-PA drilldown reports “ZPL09-EBITDA”

• initial run for period 1.2011 45 sec 5 sec 9

• drilldown by Record Type 45 sec 3 sec 15

CO-PA cost center allocation - cycle “C3770X”

• productive run 6.721 sec 1.136 sec 6

Existing ERP reports and allocations are accelerated with no changes to definitions

Report-Drilldown performance does not depend on availability of suitable aggregation levels

Any drilldown becomes possible e.g. by customer and product (not feasible before)

Period-end closing activity can ran faster w/o any changes in definitions

CO-PA Accelerator Performance Validation (Productive Customer-Data)


CO-PA Accelerator Result Slide provided by a Customer

CO-PA Accelerator implemented within 8 weeks (including test & production landscape).

No manual modeling or creation of analytical views in HANA needed.

Only replication of transactional CO-PA data needed.

Some figures about data volume:

– Total records in HANA: 550 Mio

– Total volume in HANA: 30 GB

– Total volume in ERP DB2:

580 GB uncompressed

140 GB compressed (on disk)

Number of posted records/day:

100.000 - 200.000

Initial replication took ~24 hours


CO-PA Accelerator Result Slide provided by a Customer


CO-PA Accelerator What Customers Say

Colgate Palmolive Perform analysis at unparalleled speed with SAP CO-PA

Accelerator - going live in just eight weeks Michael Crowe, Vice President Global Information Technology

Provimi Optimize profits with SAP CO-PA Accelerator – going live in just

three weeks Jean Charles Valette, Group Controller

BASF Accelerate response times dramatically and improve data reliability

to optimize business Andrew Pike, CIO Information Services

“

“

For more information, please visit our SAP HANA website: http://www.sap.com/hana/reviews/index.epx

http://www.sap.com/hana/reviews/index.epx

http://www.sap.com/hana/reviews/index.epx

http://smartdirectory.sap.corp:3080/Assets/asset.epx?mid=6bba6c94-5a3d-4b8d-b57e-8ca9bb9c1c64

http://smartdirectory.sap.corp:3080/Assets/asset.epx?mid=98d7ad18-4181-4379-865c-29312d8f91c3

http://www.sap.com/demos/richmedia/media/basf-hana-customer-testimonial-video.epx


FI / CO Accelerators – Further Information

SAP ERP rapid-deployment solution for profitability analysis with SAP HANA

http://service.sap.com/rds-hana-copa

The relevant RDS note for the CO-PA accelerator is 1632506.

If you take a look at the attachment to this note you’ll find the RDS quick guide which provides a comprehensive

overview of all relevant implementation notes. It also contains information on how to use the CO-PA Accelerator.

Note 1632506 SAP-ERP-RDS for Profitability Anylysis with SAP-HANA


SAP ERP rapid-deployment solutions for accelerated Finance and Controlling with SAP HANA

http://service.sap.com/rds-hana-fin

The “Finance and Controlling Accelerator” contains four implementation scenarios:

Scenario 1 – ERP Financial Accounting Accelerator with SAP HANA

Scenario 2 – ERP Controlling Accelerator with SAP HANA

Scenario 3 – ERP Material Ledger Accelerator with SAP HANA

Scenario 4 – ERP Production Cost Analysis with SAP HANA

The relevant RDS note for the “Finance and Controlling Accelerator” is 1656499. If you take a look at the attachments

to this note you’ll find the RDS quick guide which provides a comprehensive overview of all relevant notes ( technical

notes + consulting notes ) for the four implementation scenarios. ( See document

“HANA_FIN_HANA10_Quick_Guide_EN.pdf”. )

Note 1656499 SAP ERP RDS of accelerated FIN/CO with SAP HANA














HANA Analytics



Reporting: HANA Architecture

BI

Analysis

Native

Excel

Business

Explorer

Crytal

Reports

WebI Dashboard

Classical DB IMDB Realtime replication

(SLT)

HANA 1.0

Installed SAP landscape

ERP

NW 7.x

Full replication or extraction of all relevant

application tables (real-time / near real-time)

Non-disruptive for existing Suite customers,

i.e. no impact on productive system

No acceleration of existing applications,

no new application functionality

New analytical (i.e. read-only) capabilities

based on Views and SQLScript

(No ABAP in HANA.)

Virtual data model based on View hierarchies

for analytical consumption by BOBJ tools

IMDB is secondary persistency

All primary data reside in classical DB

BOE

HANA Modeler

HANA Content


SAP HANA Studio - Features

Information Modeler Features

Modeling

No materialized aggregates

Database views

Choice to publish and consume at 4 levels of modeling

Attribute View, Analytic View, Analytic View enhanced with Attribute View, Calculation View

Data Preview

Physical tables

Information Models

Import/Export

Models

Data Source schemas (metadata) – mass and selective load

Landscapes

Data Provisioning for SAP Business Applications (both initial load and replication)

Analytic Privileges / Security


SAP HANA Studio - Terminology

Information Modeler Terminology

Data

Attributes – descriptive data (known as Characteristics SAP BW terminology)

Measures – data that can be quantified and calculated (known as key figures in SAP BW)

Views

Attribute Views – i.e. dimensions

Analytic Views – i.e. cubes

Calculation Views – similar to virtual provider with services concept in BW

Hierarchies

Leveled – based on multiple attributes

Parent-child hierarchy

Analytic Privilege – security object


HANA Analytics and RDS Packages

RDS Packages for HANA

Set of HANA Studio models together with

implementation content that address a specific

area, e.g.

RDS for SAP ERP Operational reporting, provides

reports for:

– Financial Reporting

– Sales Reporting

– Purchasing reporting

– Shipping Reporting

RDS for CRM Pipeline Analytics

RDS Bank Analyzer RDS for financial reporting

with SAP HANA


SAP

CRM Rapid

Deployment

Solution

SAP ERP rapid-deployment solution for operational

reporting with SAP HANA™

Solution to provide compelling SAP ERP operational analytics quickly and affordably

Info Space

FIN Dashboard Purchasing

Dashboard

Sales

Dashboard

Crystal Reports Webi Reports

Pick from 3 Dashboards and

23 reports from the following

business areas:

Financial Reporting

Sales Reporting

Purchasing Reporting

Shipping Reporting

Master Data Reporting


Sales Dashboard

Summary



Summary

HANA Accelerators allow leverage HANA capabilities

to accelerate Business Processes and Operative

Reporting

The Application Accelerator allows to leverage

HANA with low effort for existing custom built

reports/programs (Z-reports/Z-programs) with a high

database share for the overall runtime

Application specific Accelerators leverage individual

features of HANA to overcome current bottlenecks in

applications or provide new capabilities

HANA Analytics to accelerate operative Reporting


The “Suite on HANA” innovation road map

AnyDB HANA DB

Client

SAP

Business

Suite

AnyDB

Client

SAP

Business

Suite

AnyDB HANA DB

BW SAP

Business

Suite

AnyDB HANA DB

Client

SAP

Business

Suite

AnyDB HANA DB

Apps SAP

Business

Suite

HANA DB

VDL

SAP Business Suite

HANA DB

Reporting Content Accelerators BW on HANA HANA Analytics HANA Apps Business Suite on HANA

Side-by-side scenarios Integrated scenario

Easy to start here

• wow UI

• low TCO

Easy to consolidate later

Client

ERP CRM SCM SRM PLM BW

Industry Applications


Long-Term Predictability

Maintenance Extension for SAP Business Suite

• To manifest the long-term predictability of the Business Suite and in support of the Innovation Strategy

and Roadmap the standard maintenance will be extended

• SAP extends mainstream maintenance for the Business Suite core applications1 to December 2020

1 SAP Business Suite includes the core applications (SAP ERP 6.0, SAP PLM 7.0, SAP CRM 7.0, SAP SCM 7.0, SAP SRM 7.0), supplementary

applications, and industry applications. 2 Mainstream Maintenance for SAP NetWeaver 7.0x ABAP will be extended through December 2020 and for NetWeaver 7.0x Java (also incl Dual

Stacks) until December 2017. 3 If JAVA based ERP Components are used an Update to at least SAP ERP EHP4 has to be performed until December 2017.

SAP ERP 6.03)

EHP4

EHP5

EHP6

2010 2011 2012 2013 2014 2015 2016 2017 2018 2020 2008 2005 2009 2006 2007

SAP CRM 7.0

SAP SCM 7.0

SAP SRM 7.0

2019

SAP NetWeaver AS ABAP 7.x2)

SAP

Business Suite 7 Core Applications

EHP13)

EHP23)

EHP33)

Longer

Maintenance

until 2020

Thank you

Peter Goebbels Vice President

Business Solution Architecture

Active Global Support

SAP AG Dietmar-Hopp-Allee 16

69190 Walldorf

Germany

Mobile: +49 160 3603176

E-Mail: [email protected]

sap innovation summer camp come with a curiosity …fm.sap.com/data/upload/files/07 sap innovation...

Documents