Welcome to the HANA Stream Sponsored by:

BW on HANA Implementation Tips & Tricks based on customer experiences

DISCLAIMER •This presentation outlines SAP’s 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.

3

AGENDA 1. About RS 2. BW on HANA 3. BW on HANA Upgrade and Migrate 4. Lessons Learnt / Tips and Tricks

5. Customer experience 6. What’s happening next 4

RS – leading high service distributor of electronics and maintenance products worldwide Strong Brands

57% eCommerce

800K Catalogues

2,500 Major Suppliers

500,000 Products

> 1m Customers

17 Distribution Centres

44,000 Parcels Daily

90+% of World GDP

The world’s distributor of choice

5

BI at RS (Pre- HANA) A 5.5 TB BW 7.0 system (Oracle): •

22 markets (4 more to follow in next 9 months)

•

850 users

•

47,000 executions on 2500 unique queries per month

•

150 query developers, 400+ new queries per month

•

12,000 queries in production

•

2 daily batches ; UK and Thailand time

•

Extractors from CRM / ERP, Open Hubs to FTP locations & Oracle interface

•

Predominantly BW 3.5 Queries through BeX analyzer

•

BI7 Queries, limited use of BI7 Analyzer

•

BW 3.5 & BI7 Web Templates

•

Performance & batch challenges

•

BI a strategic imperative 6

SAP BW Today (September 2013)

14500+

Customers

200

New Installations/Month

Vast majority: Central EDW, harmonizing many source systems Embedded into mission critical business processes

500+

BW on HANA Customers

7

3500+

BW 7.3 Customers

SAP BW on HANA – Smarter, simpler, more efficient How Does BW running on RDBMS differ from BW running on HANA ?

SAP BW on HANA

Data Modeling

Process Orchestration

Process Orchestration

SAP NetWeaver BW

Planning OLAP Data Management

RDBMS

Traditional Stack

Customer value of SAP BW powered by SAP HANA

Data Modeling Planning OLAP Data Management

Push Down

Data Schema & Data

HANA Stack 8

• Excellent query performance • Performance boost for Data Load processes • Accelerated In-Memory planning capabilities • Flexible combine EDW with HANA-native data • Data persistency layers are cut off • Simplified data modeling and remodeling

The Project Approaches New Installation

In-place Migration

Copy, Upgrade + Migrate

9

BW on HANA preparation • • • • • • • •

Do a little research http://www.saphana.com/docs/DOC-2112 Understand HANA Memory Usage http://www.saphana.com/docs/DOC-2299 Read the Master Guides http://www.saphana.com/community/implement Follow Sizing Guide Note 1736976 - Sizing Report for BW on HANA Find out System Prerequisites End-to-End Implementation Roadmap http://help.sap.com/nw731bwhana#section2 Find out the impact to your BW Add-ons, Bobj, etc. Read latest notes Note 1600929 - SAP BW powered by SAP HANA DB: 10 Information

BW on HANA preparation • Archive & Delete to decrease the migration time and Target DB Size – Note 706478 - Preventing Basis tables from increasing considerably • Upgrade to BW 7.3 latest Support Pack level and Split ABAP and JAVA Stacks • Update Kernel Patches latest release • Upgrade to Solution Manager 7.1 latest Support Pack • Install Post-Copy Automation (PCA) Tool if you do not want an in-place migration • Implement Notes to Use BW->HANA Tools – ZBW_HANA_CHECKLIST Note 1729988 – ZBW_ABAP_ANALYZER Note 1847431 • Start updating your data flows to be more Hana compliant • SUSE Linux Training / Hana Admin Training 11

Project Preparation

Wk18

Wk17

Wk16

Wk15

Wk14

Wk13

Wk12

Wk11

Wk10

Wk9

Wk8

Wk7

Wk6

Wk5

Wk4

Contracts and Resource Mobilisation Project Kick Of Event

BW Sandbox Hardware & Software in place & available (BW 7.31) Completion of BW upgrade pre requisites BW Technical upgrade - Sandbox System BW Hana Migration-Sandbox System BW on HANA Sbx completion / acceptance BW Dev HANA Hardware & Software in place & available (BW 7.31) BW Development Upgrade & Migartion Dev Test BW remediation / error fix BW on HANA Dev completion / acceptance Completion of BW upgrade pre requisites Realisation - BW BW QA Cutover - Upgrade & Migration QA Test & Hanna RB BW remediation / error fix BW on HANA QA completion / acceptance System copy from Production completed Check Prerequisites for Upgrade BW Technical Upgrade onto designated environment Migrate to Production HANA Testing Trial Rollback Activity & DR and HA Testing Trial Cutover completion / acceptance HANA Prod't Hardware & Software in place & available + Back Up BWUpgrade & HANA Migration Cut Over -Production System Go-Live

Sandbox

Development QA / Test

Trial Cutover

Production

BW on HANA Go- Go-Live Preparation Acitivites Live Go-Live - BW Upgrade & Hana Migration Support

Wk3

Activites

Wk2

Phase

Wk1

High Level illustrative plan

Post Go-Live Support

12

LESSONS LEARNT Tips and Tricks

13

Lessons Learnt • Copy BW production to a sandbox and perform a full regression test. • Plan for a formal Trial Cutover. • Test Backups/Restores. • For Issues, review the latest HANA Notes and HANA revisions. • Refine Project activities and Cutover Tasks. • Verify Table Consistency and partitioning of BW tables on the database. 14

Tips & Tricks When upgrading from 7.x to 7.3 and migrating • Use the latest delivered Business Content version of certain objects like time characteristics. • Changes in behaviour of start and end routines in 7.3 • Check Transformations with Constants. In some cases transformation for keyfigures is converted to 'No Transformation‘. Implement 1709947 before the upgrade • Latest patches for BI Java components 15

Tips & Tricks When upgrading from 7.x to 7.3 and migrating • The way exception aggregation is dealt with in 7.3 has changed. • Extra checks in packages resulting in warning messages. • SAPGUI 7.3 does not have BEx 3.x components as standard.

16

CUSTOMER EXPERIENCE

17

SAP NetWeaver BW Powered by SAP HANA

18

SAP BW on SAP HANA Upgraded / migrate a 5.5 TB BW 7.0 system (Oracle) to a 2TB BW7.3 system running on HANA in 19 weeks project led by SAP Early Days, but already a significant performance improvement: – Cost Based CoPa load, 250k records, down on average down from 15 minutes to 5 minutes. – Billing Condition Data, extract 650k records from ECC into DSO split by year and activated,15 minutes down to 10. – EMEA batch finishing 3 to 4 hours earlier – Open Hub, write to a file, reading 13.5 million records outputting 10 million records with ABAP code to remove records using lookups: – 4.5 hours with Oracle – 17 hours in HANA – 40 minutes after optimising the code for HANA

350,000.000

01/09/2013 03/09/2013 05/09/2013 07/09/2013 09/09/2013 11/09/2013 13/09/2013 15/09/2013 17/09/2013 19/09/2013 21/09/2013 23/09/2013 25/09/2013 27/09/2013 29/09/2013 01/10/2013 03/10/2013 05/10/2013 07/10/2013 09/10/2013 11/10/2013 16/10/2013 18/10/2013 20/10/2013 22/10/2013 24/10/2013 26/10/2013 28/10/2013 30/10/2013 01/11/2013 03/11/2013 05/11/2013 07/11/2013 09/11/2013 11/11/2013 13/11/2013 15/11/2013 17/11/2013 19/11/2013

BW ‘database time’ Time DataManager

300,000.000

250,000.000

200,000.000

150,000.000

100,000.000

50,000.000

0.000

Compression – x4

Existing BW

HANA

BW

1.6TB

App Server

5.5TB

5.5 TB  1.6TB 4X compression 21

SAP BW on SAP HANA – End User Feedback

“This is a massive timesaver”

“The daily reports for European Daily are now an ‘ad hoc’ report, push the button.... a few seconds later there “

BW on HANA - Future

23

BW on HANA – Planned Innovations •

SAP NW BW 7.3 on SAP HANA

Upcoming planned release

•

SAP HANA specific features – Performance boost for data loading, query response time and In-memory planning

Enhanced Data Modeling  BW/HANA Smart Data Access providing the logical EDW  Easy integration of external data models with Open ODS Layer  Composite Provider for enhanced support of “Mixed Scenarios”  Common Eclipse based Modeling tools

–

SAP HANA-optimized InfoCubes and Data Store Objects

–

Simplified and faster data modeling/remodeling

–

“Not active” data concept

–

SAP NetWeaver BW and SAP HANA Mixed Scenarios (BO Explorer, BW Virtual Master Data, etc.)

–

Support of Semantic Partitioned Objects and enhanced partitioning for write optimized DSOs

–

Simplified system landscape

Platform independent highlights* – Graphical data flow modeling and enhanced support of 3.x-> 7.x data flow migration

Push down further processing logic to HANA  BW Analytic Manager  HANA Analysis Processes  BW Transformations  BW Planning Semantics BW Content optimized for HANA

–

Semantic Partitioned Objects (SPO)

Simplified High Performance Planning

–

Rapid prototyping of Ad Hoc scenarios via BW Workspaces

 “BPC Unified”

–

NLS based on Sybase IQ

–

DSO planning

–

Tighter integration with SAP Data Services

(Release SAP NW BW 7.3 SP9; SAP NW BW 7.31 SP7) * SAP will continue to support RDBMS platforms

 Capabilities of BW IP, BPC, and HANA Data Provisioning  Operational Data Provider (Release SAP NW BW 7.4 SP5)

Thank You!

Contact information: Ketan Adani SAP UK Ltd 07808575077

Graham Wiffen RS Components Ltd 07973812951