SAP BW-on-HANA Business Approach @Cflex 05-2014 Agenda Company Presentation Project ‘Figures & Facts’ Summary & Outlook Page 2 Our Mission 1 We are a global company. We produce flexible packaging and labels. We make daily goods available. For everybody. Everywhere. 2 Together with our customers we create superior solutions. 3 Consumers sense the difference. 4 We live packaging. With passion. Every day. Page 3 Facts and Figures 1.7 billion € sales (pro forma)* over 3,000 customers 42 production plants in 18 more than 8,000 employees countries Our products are sold in 115 countries #2 #4 * Pro forma Sales 2013 are adjusted for full year revenues of acquisitions (sales impact: EUR 57 million) Page 4 in Europe globally Our Divisions Page 5 Complete Range of Solutions Dairy Die-Cut Lids, Reel-fed, Foil-/Film based Wrappers, Banderole Confectionery & Processed Food Foil-/Film based Wrappers, Twist Film, Portion Pack Capsules, Bags & Pouches Processed Meat Alu-container Systems Bags & Pouches Laminates Pharma Coldform Foil Sachet Foil Blister Lidding Foil Home & Personal Care Sachet Foil, Bag-on-Valve Laminate Beer Paper labels, Pressure Sensitive Labels, Aluminum foil bottle neck Softdrinks & Water Aluminum lid labels for beverage cans, Paper label, Wrap around labels In-Mould In-Mould decoration In-Mould with functionality Page 6 Global Production Network 42 Plants – 18 Countries Food Focus Pharma / HPC Focus Labels Page 7 Agenda Company Presentation Project ‘Figures & Facts’ Summary & Outlook Page 8 Motivation for BW-on-HANA Starting point (System environment) • BW 7.31 SP05 3-Tier (Production, Quality, Development) including BCS & BI/BO 4.0 • BWA in place for test purposes (Leasing contract with Cubeserv) • Frontend: BEX Querydesigner, BEX Analyzer, BEX WAD Templates, BI Crystal Reports ISSUE - Monthly Closing / Data delivery • 30 Minutes schedule for Meta process chains (FI, CO, Treasury, ..) • 15 Minutes schedule for consolidation reporting (BCS) process chain Only possible with optimization workarounds but running out of ideas! ISSUE – Excel Reporting (BEX Analyzer workbooks) • Partly complex and huge workbooks in place Slow performance (runtime > 10 minutes) ISSUE – Web Reporting (WAD & Crystal Reports) • WAD dashboards with several queries (only sequential processing possible) • Implementation of BO objects (Crystal) within portal incredible slow (BICS interface) Performance not acceptable Project ‚On Hold‘ DECISION: • • Page 9 Start BW-on-HANA Project with Proof-of-concept phase Implementation partner: CubeServ Phase I - Proof-of-Concept Systems (for comparison) • BW 7.31 SP05 with accelerator (BWA) • BW 7.31 SP05 without accelerator SB3 7.31 SP09 (HANA enabled sandbox) Process Chains BCS Monitor Queries Integrated Planning Workbooks CIS Reporting (Dashboards) Locations • Headquarter Vienna (Rivergate) • Hueck Germany LAN & Citrix access scenarios Choosen processes • ABAP Stack – Process chains, Integrated Planning, BCS (Consolidation Monitor) • JAVA Stack – Sales Cockpits (WAD Templates), Crystal Reports • Frontend – Workbooks, Queries, Integrated Planning, File Upload IT and Business test cases! Page 10 Phase I - Proof-of-Concept Performance Improvement Process Chains BEX Queries ~ 30 - 200% ~20 – 90 % Workbooks CIS Reporting (Only Dashboards) ~10 – 100 % > 100 % + BW-on-HANA PoC sucessfully tested! + Visible Performance improvement + Positive Feedback from Business too *) In some cases tested results were not 100% traceable. Behaviour due to HANA or to different Hardware? NEED to be clarified! BCS Monitor > Faster Integrated Planning > Faster (but no issue so far) (but reason unclear *) Page 11 Known performance lacks still remain BCS reporting with virtual provider access FrontEnd issues like workbooks with macros BI Portal embedded BO objects like Crystal reports (BICS interface) Citrix/Network Overall Project Plan 2014 10 11 2015 12 CW43 01 CW50 02 03 04 05 CW19 CW09 CW20 06 CW22 CW23 CW25 PHASE I: Proof-Of-Concept PoC Sandbox HANA Prepare &Install PoC Sandbox Testscenarios Year-End Closing PHASE II: HANA-Migration BW environment Project Sandbox Prepare&Install Project Sandbox Testscenarios Project Rescheduled (Finance) PRODUCTION HANA Migration ~3 days Downtime DEVELOP HANA Migration QUALITY HANA Migration Development Stop Transport Stop Page 12 SANDBOX HANA Migration Overall Project - Findings Testcases (Sandbox) • Nearly 100 IT and 50 Business testcases defined and executed • Around 20 reported issues during test phase with sandbox system But major part of errors due to system copy or service pack upgrade DWH processes (RSA1) • HANA optimized infocubes working fine for all datamodels with one exception Not possible for BCS reporting dataflow as 3.x ETL process still obligatory • BWA in usage Delete all BWA indices in advance Otherwise query execution error (report RSDDB_LOGINDEX_CREATE helpful) ETL processes (RSPC/RSPCM) • Depending on used items within process chains minor modifications are necessary • Especially custom process steps with ABAP jobs (e.g. build aggregates) need to be checked • Partly also ABAP coding for master data extraction needed to be adjusted • Transformations: Expert routines need to be checked and modified (RSADMIN parameter) Page 13 Overall Project - Findings Reporting processes (BEX) • Nearly all identified issues were due to Service Pack SP09 or SAPGUI Patch Upgrade (FEP600) Adhoc reporting: Usage of filter not working, currency conversion not working, … Verify query and/or multiprovider settings for property ‚SAP HANA/BWA Ops‘ Misc • In advance reorganization of tables strongly recommended (e.g. UCL2040 if BCS used) • Shortdump issue with planning sequences with certain number of planning functions Some recommended OSS notes (beside HANA related ones) • 2022169 • 1851875 • 1901095 • … Page 14 Agenda Company Presentation Project ‘Figures & Facts’ Summary & Outlook Page 15 Project Summary + HANA Migration for BW Production • + • • Within 3 days without any major issue • • Move to BW 7.40 was too risky due to unclear situation related to BCS support Reporting performance Very good results for nearly all workbooks and web reports (dashboards) E.g. workbook with more than 80 queries executed in 4 minutes (we started 2012 with 20 minutes) • • + ETL performance • Next BW Upgrade project in scope Process chain execution with excellent performance E.g. monthly process chain for COPA rebuild procedure needs 1 instead of 2 days. Page 16 HANA Migration for BW Development Topic ‚Systemcopy‘ seems to be the main challenge within Cflex environment Mainly caused by slow NFS (Network file system) configuration and several issues Project Summary Base IT driven project • Project workload between base team & application team ~ 70:30 • High-availability scenario due to HANA (1.0 SP7 Rev 73) cluster setup • Connection to Solution Manager (monitoring) in place • HANA ‚enabled‘ software for backup & restore (full/incremental) • Backup and restore configuration vs. Cluster replication procedure • Administration and monitoring with HANA Studio • … Page 17 Outlook Short-Term topics Redesign of current datamodels New planning solution Datamodel Redesign • Further optimization of process chains • DWH optimization foreseen • • • Design of new reporting solutions FrontEnd Tools Reduce amount of infocubes Reduce DWH layer (Historical, U&T, Reporting, Information) Best Practice cases for new BI projects FrontEnd Tools • Rollout of Advanced Analysis Office • Maybe prototype of DesignStudio depending on 1.3 functionality • • Page 18 DesignStudio 1.2 promising (compared to other BO tools) but not ready yet Maybe testcases with Workspaces and/or Information composer Outlook Mid-Term topics Redesign of current datamodels Design of new reporting solutions New planning solution FrontEnd Tools New planning solution • Business not satisfied with integrated planning processes • CFO driven project for software evaluation • HANA represents 1 of 3 preconditions for ‚Unified Planning‘ (BPC, PAK, …). Design of new solutions • Usage of HANA datamodel components to allow e.g. complex file upload scenarios • Usage of HANA datamodel components to allow topics like KPI reporting (based on BCS source) Page 19 www.cflex.com Page 20
© Copyright 2024 ExpyDoc
