SAP HANA erfolgreich im Einsatz Jürgen Karnstädt HP SAP Competence Center Walldorf Mai 2014 New possibilities with SAP HANA Technical feasibility is given Real-Time Sensing and Responding Search Big Data Mobile Cloud Real-Time Enterprise with SAP HANA Social Analytics Real-Time Planning and Simulations Predictive Analysis Real-Time Reporting and Analysis SAP HANA scenarios SAP HANA Innovation Overview HANA Accelerators Client SAP HANA DB Side-by-side scenarios In seconds Accelerating existing transactions of the Business Suite More insight Exploring data loaded from Business Suite on any level of detail • CO-PA RDS • … • Ops. Reporting RDS • … © 2014 SAP (Schweiz) AG. All rights reserved. Supercharged BW Speed up your BW without disruption • BW on SAP HANA Apps AnyDB BW SAP HANA DB Apps VDL AnyDB SAP Business Suite PLM SAP HANA DB BW SRM AnyDB SAP Business Suite SAP Business Suite SCM SAP HANA DB (VDL) Business Suite on HANA Strateic Investments) Client SAP Business Suite / non-SAP HANA Apps CRM AnyDB Client BW on HANA ERP SAP Business Suite HANA Analytics SAP HANA DB Integrated scenario Innovation Functional apps natively built on SAP HANA, with or without Business Suite integration All-in-one – ultimate Business Suite solution fully integrated with and optimized for SAP HANA as database • CRM on HANA • Cash Forecasting • Smart Meter Analytics …… 4 CO-PA (Profitability Analysis) Report © 2014 SAP (Schweiz) AG. All rights reserved. • CO-PA (Profitability Analysis) • Function in ERP • Used for Management Reporting 5 Sample CO-PA Drilldown Report Co. Co. Co. A B C MANUFACTURER Report and drilldown structures DISTRICT Glass Cera- Plastic mics District 3 District 2 District 1 Company Distr. channel Product group Region Manufacturer Customer grp District CO- PA data basis PRODUCT GROUP Glass Cera- Plastic mics District 3 District 2 District 1 PRODUCT GROUP © 2014 SAP (Schweiz) AG. All rights reserved. Analysis of "Plastic" from manufacturer "Co. B" 3 Co. Co. Co. A B C DISTRICT Analysis of Product Group "Plastic" 2 MANUFACTURER Co. Co. Co. A B C MANUFACTURER Analysis of Product Group "Ceramics" 1 DISTRICT Glass- Cera- Plastic mics District 3 District 2 District 1 PRODUCT GROUP 6 SAP HANA – CO-PA Accelerator Many customers are using that side-car approach to start with HANA SAP ERP 1 HANA Instance CO-PA HANA DB CO-PA reports are reading directly from HANA instead of the ERP database database. any DB Customer Example Allocation costs The data is replicated regularly to the HANA-system. Oracle HANA 126 s 6s Distribution sampling on customer level 32 s 2s Reporting: P&L Material view 63 s 6s 686 s 31 s Custom programs: sales variance © 2014 SAP (Schweiz) AG. All rights reserved. 7 HANA @ Warehouse Stock Simulation – Flow Initial Challenge: Calculation and reporting applications were separated from the very beginning in SAP-ERP and SAP-EWM …BUT ERP-reporting performance was still critical Solution: Usage of HANA-DB as accelerator Cumulative DB-operations were in average 20 to 60 times faster Read and aggregation of 3 Mio. sets needs with ORACLE DB 50.000ms Read and aggregation of 3 Mio. sets needs with HANA DB 820ms © 2014 SAP (Schweiz) AG. All rights reserved. Elapse time Oracle Hana 8 SAP BW System landscape - SAP BW on HANA Storage Database ServerOracle Oracle Database 11g SAP HANA Appliance BW Accelerator 8x Blades © 2014 SAP (Schweiz) AG. All rights reserved. 9 Results with SAP HANA Simple business intelligence system landscape after migration to SAP HANA Number of servers without HANA 8 2 1 Number of servers with HANA 1 1 1 0 ABAP Instance JAVA Instance DB Server BW Blades 1 ABAP InstanceJAVA Instance DB Server BWA Blades Database size in TB 4.2 Database size in TB 0.35 HANA Oracle Reduce number of server‘s from 12 sever‘s to 3 server‘s © 2014 SAP (Schweiz) AG. All rights reserved. 10 Results with SAP HANA Performance – Data load and activation process AR Reporting 3 Mio. records factor 170 Billing Documents 1,1 Mio records factor 30 11400 Min. 132 Min. 66 Min. HANA HANA Parallel Without HANA 2010 Min. Without HANA 8 Min. Load © 2014 SAP (Schweiz) AG. All rights reserved. HANA HANA Parallel 32 Min. 6 Min. Load Parallel Activation 26 Min. DSO Load 3,7 Mio. records with HANA factor 36 for DS activation DSO Load 3,7 Mio. Records without HANA 36 Min. 45 Min. 6 Min. Activation Parallel 2 Min. Load HANA Load HANA Parallel 1 Min. < 1 Min. Activation Activation Parallel 11 Project schedule : SAP BW on HANA Projectplan – Milestones Migration BW on HANA Project Phases Initiation Proof of Concept Business Case Preparation Implementation 06 07 08 09 10 11 12 01 02 03 04 05 06 07 08 09 10 11 12 CW 45 Go-live 06/2012 Post Go-Live Support Deliverables: © 2014 SAP (Schweiz) AG. All rights reserved. Decision Provision BW Release Infrastructure Change (Prod) BW Release HANA Change / HANA (Test) Migration (Prod) 12 Customer results using SAP HANA on BW • Faster and more precise planning • Planning cycle down from 3hrs to 15 mins • Planning completion decreased by 2 weeks • New • 86 dimensions for liquidity management times faster reporting on accounts receivable • Previously • Efficiency provided weekly. Now provided several times per day. and IT cost reduction © 2014 SAP (Schweiz) AG. All rights reserved. 13 SAP In-Memory Computing - Out of Shelf Analysis Large Retail customer – 4 TB HANA Appliance Retailers use the SAP POS Data Management solution to verify, analyze and distribute Point of Sales data in the organization.. © 2014 SAP (Schweiz) AG. All rights reserved. 14 Smart Data Access Enhanced Business Flexibility by providing “the logical EDW” Query Data Federation in diverse EDW landscapes BW Virtualization Layer Composite Provider, Open ODS View Smart data access – read access to relational and non-relational sources via ODBC • Enables access to remote data access just like “local” table • BW based Analytic Services on external data Scenario • Make other DWHs transparent to HANA • Consolidating / rationalizing the DWH landscape • HANA Tables Virtual Tables HANA Smart Data Access Layer MSS Oracle Teradata Hadoop © 2014 SAP (Schweiz) AG. All rights reserved. SAP HANA ASE IQ 15 Big Data Analytics Platform with SAP HANA Large Retail customer HP AppSystem for Hadoop (192TB) Cloudera Enterprise Core © 2014 SAP (Schweiz) AG. All rights reserved. HP AppSystem for HANA 2TB Scale-Up 16 SAP Business Suite on HANA Test System 1 (any DB) Update to Suite on HANA 1.0 SP1 EHP616 SP0 • ERP 6.16 SP1, NW ABAP 7.40 SP1 App Server Traditional SAP ERP system DB Server Timely independent from each other Test System 2 (HANA DB) EHP616 SP0 App Server Update to Suite on HANA 1.0 SP1 • ERP 6.16 SP1, NW ABAP 7.40 SP1 • HANA SP5, Latest Revision Level 48 HANA Solution DB Server © 2014 SAP (Schweiz) AG. All rights reserved. 17 Results with SAP Business Suite on HANA Key customer messages • HANA solution over all much faster than on the original database The Peformance in some improved areas is quiete impressive. Nevertheless some transactions are slower then in the traditional system. • How to deal with Customer Code • HANA appliance is working well, stable, no disruption © 2014 SAP (Schweiz) AG. All rights reserved. 18 SAP Suite on HANA with HP Serviceguard for automated Fail-over • SAP Suite on HANA • Production System replicates data to a Stand-By Server in DC 2 using SAP System Replication • HP Serviceguard delivers automatic fail-over capabilities HP Serviceguard for Linux HP Serviceguard Extension for SAP HANA Network Data volume Log volume © 2014 SAP (Schweiz) AG. All rights reserved. HP ProLiant DL980 G7 8 CPU´s - 1 TB Memory Production Stand-by HP ProLiant DL980 G7 8 CPU´s - 1 TB Memory Production: SAP System Replication Synchronou s mirorred redo log writing Data volume Log volume 19 Real-time information on sales and cost price inflation Challenges Approach Results • • Joint invest by Kingfisher, SAP and HP. • Real-time information on sales and cost price inflation • Joint client workshops in Palo Alto Labs • • Solution will be available for Retail clients Understand historical trends and improve revenue forecasting on a daily basis! • RDS planned • • No visibility to sales and margins across operating segments and geographies No measurement of inflation on sales and cost prices Understand external factors : weather and demographic information to sales and margins © 2014 SAP (Schweiz) AG. All rights reserved. 20 HP- IT runs SAP HANA Use Case Business Innovation Description Consumption Impacts 1 Real-Time Supply Chain Analytics HANA-powered Supply Chain Business Warehouses Accelerated self service analytic modeling to drive real-time visibility on demand, fulfillment and improved inventory leveling. HANA: 7-10 TB BI Suite Users: 1,500 Reduced upgrade time/cost 2 Financial Planning HANA-powered SAP Business Planning Drive accelerated and sophisticated scenario planning in real-time and engage end users with near instant returns on simulations and what-if scenarios. HANA: 1-2 TB BI Suite Users: 500 First HP HANA implementation 3 Quote-to-Cash HANA-powered Quote-to-Cash Acceleration of core ECC processes in key areas such as order management administration, month/quarter/fiscal year end processing and live operational reporting. HANA: 13 TB ECC Users: 2,000 BI Suite Users: 1,000 HANA-based ECC processing Real-time analytics From >2 hours to 88 seconds improved runtime results © 2014 SAP (Schweiz) AG. All rights reserved. Previous query time of over 1.5 hours runs in 1.02 seconds on HANA 21 Summary Technical feasible System Architecture stable – Technology works Performance Improvements Performance Improvements in most areas Business Case What is the benefit of faster processing ? How to define the Business case ? © 2014 SAP (Schweiz) AG. All rights reserved. 22 Ihre Meinung ist uns wichtig! Bitte geben Sie uns über unsere Event App Feedback zu der soeben besuchten Session sowie zum gesamten Event. Unsere Event App ist in folgenden Stores kostenlos verfügbar: Bewerten Sie: -Session Inhalt -Speaker -Event Allgemein Geben Sie uns Ihren Feedback und gewinnen Sie 1 von 10 offiziellen «brazuca» Matchbällen mit original Unterschrift von Ottmar Hitzfeld © 2014 SAP (Schweiz) AG. All rights reserved. 23 Thank you Contact information: Jürgen Karnstädt SAP Senior Consultant SAP HP Competence Center Walldorf [email protected] © 2014 SAP (Schweiz) AG. All rights reserved.
© Copyright 2024 ExpyDoc
