Transcription
Experiences of Implementing SAPBW on HANA at Boots UKPhil Creek and Jamie Flaxman – SAP Centre of Expertise22 March 2015
Who We ArePhil CreekJamie FlaxmanLead SAP Business AnalystLead SAP Functional Consultant2
Walgreens Boots Alliance Presence in more than 25* countries Over 370,000* employees the largest retail pharmacy, health and daily living destination in theUSA and Europe the global leader in pharmacy-led, health and wellbeing retail withover 12,800* stores in 11* countries the largest global pharmaceutical wholesale and distribution networkwith over 340* distribution centres delivering to more than 180,000†pharmacies, doctors, health centres and hospitals each year in 19*countries the world’s largest purchaser of prescription drugs and many otherhealth and wellbeing products3* As at 30 November 2014 including equity method investments on a pro-forma basis† For year ended 30 November 2014 including equity method investments on a pro-forma basis
Boots UK 2,511* stores, 600* Boots Opticianspractices, 430* Boots Hearingcarelocations 16* doctors’ surgeries located in store 90%* of population within a 10 minutedrive of a Boots store Growing omni-channel offer, boots.comrevenue increased by 30%* year on yearwith significant increase to Boots Order &Collect c.60,000* Boots UK colleagues with around6,500* pharmacists 17.8m* Boots Advantage Card members 3.5m* visits a month to BootsWebMD.com4* As at 30 November 2014 including equity method investments on a pro-forma basis4
SAP BW at Boots signerBexAnalyserAnalysisfor OfficeBOBJ (4.0)WebiBILaunchpadBO Mobile5
Drivers of ChangeReduce run costsAdd system capacityFaster, cheaperchangeRemove batchlimitationsReal-time reporting6
The OptionsReallocatefailover bladesRemove dataand reduce datagrowthInvest in moreBWA capacityInvest in HANAtechnology withNLSPurchase secondhand bladesInvest in HANAtechnology7
Options AnalysisCapacityStrategicinvestmentServiceReal timereportingBase costModellingcomplexityBatch scheduleDevelopment cost8
Options AnalysisSatisfies projectedcapacity growthImpact on system SLAImpact on base costRemove datareduce datagrowthReallocatefailoverbladesPurchasesecond handbladesInvest in moreBWA capacityInvest in Hana technologyInvest in Hanatechnology with NLSX Should meet shortterm capacitytargets. Notscalable for futuregrowth Should meet shortterm capacitytargets. Notscalable for futuregrowth. Should meet shortterm capacity targets.Not scalable. Meets the projected two years offuture data growth and will also bescalable to meet the demands offuture projects Meets the projected two years offuture data growth and will also bescalable to meet the demands offuture projects using cheaperstorage.XX failoverremovedXXNo change Faster recovery of data Faster recovery of dataNo change2nd SLA ashandblades notsupportedNo changeXXXXNo change Higher licensing Higher licensing Higher licensing Net saving Higher licensing Support Costs Net saving Higher licensing Support Costs Complexity reduced Complexity reduced Simplified architecture, less dataobjects, reducing design, build andtesting costs and timescales. Simplified architecture, less dataobjects, reducing design, build andtesting costs and timescales. Enhanced loading capability speedsup batch processing, providesopportunity to move to a more realtime update process reducing thedependency on overnight batch. Enhanced loading capability speedsup batch processing, providesopportunity to move to a more realtime update process reducing thedependency on overnight batch. Provides a stable robust platform forreal-time reporting. Provides a stable robust platform forreal-time reporting. Aligns SAP’s EDW Strategy. Optionto add Sysbase NLS could bedelivered later as additionalinvestment. Aligns SAP’s EDW Strategy . NLS canbe used rather than holding all datain HANA appliance.Reduce systemmodelling complexityXXXXNo changeNo changeNo changeNo changeFaster, cheaper deliveryof changeXXXXNo changeNo changeNo changeNo changeBatch schedulelimitations reducedXXXXNo changeNo changeNo changeNo changeSolution set-up tosupport real-timereportingStrategic investmentXXXXNo changeNo changeNo changeNo changeXBWA mainstreamsupport ends Dec2015.XBWA mainstreamsupport ends Dec2015.XBWA mainstreamsupport ends Dec2015.Not aligned with SAP’sEDW strategy.XOption chosen
The Plan at Boots UKMonth12345678910111213141516BW data model change freezeApply SP9MobiliseBW on HANA goliveNLS go liveDesignH/WinstallHANA migrationsNLSData model consolidation17
Infrastructure11
What Actually HappenedMobilisation and prerequisitesGo-liveHardware and databasemigrationResults12
What Actually HappenedResultsSizingPerformance 1) Batch processing of the basic Sales Model (the one that 90% of our reportsuse) used to take over 4 hours. This now completes in less than an hour. 2) Generation of the BOBJ reports used to take an hour. Now completes in5 minutes 3) MI Team budget upload. Used to take 1 ½ hours now completes in 5minutes13
Key Lessons tTestingChange freezeMigrationOptimisation14
The FutureData model consolidationNear line storageReal-time reportingFurther exploitation15
Thank you for listeningDo you have any questions?16
Contact DetailsPhil CreekE-mail: phil.creek@boots.co.ukTel: 0115 968 7282Jamie FlaxmanE-mail: jamie.flaxman@boots.co.ukTel: 0115 968 702817
Experiences of Implementing SAP BW on HANA at Boots UK Phil Creek and Jamie Flaxman - SAP Centre of Expertise 22 March 2015 . Who We Are Phil Creek Lead SAP Business Analyst 2 . NLS go live Data model consolidation . Infrastructure 11 . What Actually Happened Mobilisation and pre-requisites Hardware and database migration
