WIXLIB

Leading the Way in ElectricitySouthern California EdisonUnleashes the Power of SAP HANARon Grabyan, Manager Business Intelligence Services, Southern California EdisonMeyyappan Meyyappan, Principal Consultant, Infosys, Ltd.Ranjeet Panicker, Practice Manager, SAP AmericaMay 15, 2012SOUTHERN CALIFORNIA EDISON

Leading the Way in ElectricityAgendaDecision maker obtainingbusiness intelligenceSAP HANA Appliance Software What Is It?SAP HANA StrategyThe Southern California Edison SAP HANA Story Business DriversBusiness Intelligence JourneySAP HANA Program Pilot Plan Pilot Results Production ImplementationTechnical HighlightsTotal Cost of OwnershipSAP HANA – The Game ChangerSAP HANAIn-memory analyticsData in enterprisebusiness applicationsSouthern California Edison Unleashes the Power of HANA-2-SOUTHERN CALIFORNIA EDISON

Leading the Way in ElectricitySAP HANA – What Is It?Conceptual SAP HANASAP ApplicationsConceptual SAP HANA Data modeling and data management Real-time data replication SAP Data Services software for ETL Analyze information at high speeds Create flexible analytical models Foundation for new category ation andPlanning EngineModelingStudioReal-time ReplicationServicesDataServicesSAP NetWeaverBusiness WarehouseNon-SAPThird PartyPhysical SAP HANAPhysical SAP HANA Large memory footprint (1m faster than disk) Multi-core CPUs (computational power) Row and column store (column fast aggregation) Compression (5x , 1 TB 200 GB) Non-materialized views (flexible modeling, nodata duplication)Multi-core direct memory data loading(fast data loads) ODBCIn-memory DatabaseSAPBusiness Suite SAPIBM512 GB Memory40 Processor Cores640 GB Solid-State Disk4.7 TB Hard DiskPersistent StoragePartitioning (analyze large data sets; complexcomputations)Scale-out ClustersSouthern California Edison Unleashes the Power of HANA-3-SOUTHERN CALIFORNIA EDISON

Leading the Way in ElectricitySAP HANA Strategy“Transformation”Longer-term n-memory AnalyticsNext-gen ApplicationsStand-alone SAP HANA 2014 One Store for Data andAnalyticsIntegrated SAP HANASAP NetWeaver BW on SAP HANA, SAP ECC onSAP HANA, SAP CRM on SAP HANA .SAP HANA real-timeoperational analyticsComplete BI 4.0 suite runson SAP HANA SAP NetWeaver Business Warehouse (SAPNetWeaver BW) runs on SAP HANA databaseSAP HANA platform for in-memory applicationsSAP Business Suite runs on SAP HANAIndustry and LOB analytic applicationsSAP HANA primary persistencelayer for SAP Business SuiteapplicationsSAP Business Suite optimizedfor in-memory ucts cificDevelopmentReports re-built on SAPHANA using a BI front endSpeed up existing SAPBusiness Suitefunctionality/applicationsthrough a side-by-sidescenario with SAP HANAExisting applications andstrategic investment areasthat may be disruptiveNew applications notdelivered before andnative in-memoryapplications.e.g., Operational reportinge.g., CO-PA; materialledger; general ledgere.g., SAP NetWeaver BW7.3 on SAP HANAe.g., CRM; FERCSouthern California Edison Unleashes the Power of HANA-4-e.g. ,Smart meter analytics;outage management; andenergy procurementSOUTHERN CALIFORNIA EDISON

Leading the Way in ElectricitySouthern California Edison Business Drivers d-alone SAP HANASAP NetWeaver BW running onSAP HANA databaseFaster analyticsModeling flexibilityNear real-time datareplicationCalculation engine andbuilt-in functionsBig Data footprintNew applications –potential examples: Faster reportingFaster data loadingLower TCOReduced maintenance costsReduced development costsSmart meter analyticsPower outage managementPower procurementPredictive analyticsSouthern California Edison Unleashes the Power of HANASOUTHERN CALIFORNIA EDISON -5-

Leading the Way in ElectricityThe Southern California Edison Business Intelligence JourneyOperational Improvement (SAP NetWeaver BW Running on SAP HANA)Analytics (New Capabilities)SAP NetWeaver BW2007 (1)SAP NetWeaver BW BWA2009 (2)SAP NetWeaver BW BWA2011 (3)SAP NetWeaver BWRunning on SAP HANA2012 (4)Stand-alone SAPHANA2012 (5)Integrated SAP HANA2014 Legacy DBWithoutBWA or SAP softwareLegacy DB - BWAWithSAP BusinessObjects BISP2Legacy DB - BWAWithSAP BusinessObjects BISP4SAP HANAWithSAP BusinessObjects BI4.0 FP3Calc EnginesSAP ECC, SACRM,SAP NetWeaver BW,and Stand-aloneIntegrationBaselineFaster Report SpeedFaster Report SpeedLegacy DB repl withSAP HANASAP HANA Stand-aloneDatabaseSAP HANA Stand-aloneDatabase No SAP NetWeaverBW Accelerator No SAPBusinessObjects BI SAP NetWeaver BWAccelerator 2.5x fasterreporting Early version of SAPBusinessObjects BInot stable SAP BusinessObjectsBI SP4 very stable Reports are faster:Avg (20%) CRM(7x) Reports are faster5.0 times Delta Data Loads aremuch faster (3.2x) Optimized calculationengines with parallelprocessing Radical Improvement SAP HANAenvironments virtuallyor physically merge Reports: Avg CRM Data Loads Reports: Avg CRM Data Loads Reports: Avg CRM Data Loads Reports: Avg6.4 sec CRM4.6 sec Data Loads4.6 hrsBased on Pilot Results Analytics: Telecom CRM Smart MeterAnalytics More agile Seamless Less costlydevelopment90 sec400 sec15 hrs40 sec161 sec15 hrs32 sec23 sec15 ementsProjected12Southern California Edison Unleashes the Power of HANA34-6-5ReportsDataRelative estimateSOUTHERN CALIFORNIA EDISON

Leading the Way in ElectricitySAP HANA at SCE – k Name1/9/2012 1/16/2012 1/23/2012 1/30/2012 2/6/2012 2/13/2012 2/20/2012 2/27/2012 3/5/2012 3/12/2012 3/19/2012 3/26/2012 4/2/2012 4/9/2012 4/16/2012 4/23/2012 4/30/2012SAP HANA Pilot ProgramProject ManagementPilot PlanningProduction PlanningSystem SetupHardwareSoftwareData MigrationSAP NetWeaver BWRunning on SAP HANASAP HANA Stand-aloneSAP NetWeaver BWRunning on SAP HANAEnhancementSAP NetWeaver BW Runningon SAP HANA OptimizationData ModelingDesignBuildMigrate and ValidateSecurity SetupSAP NetWeaver BWRunning on SAP HANASAP HANA Stand-aloneReport Development & TestSAP NetWeaver BWRunning on SAP HANASAP HANA Stand-aloneExplorer TestingSAS ValidationSLT ValidationBackup RestoreValidate: Compression Data loading speed Report response time Back-up and restore SecuritySouthern California Edison Unleashes the Power of HANA-7-SOUTHERN CALIFORNIA EDISON

Leading the Way in ElectricityPilot ResultsComparingSAP NetWeaver BW Running on SAP HANA vs.SAP NetWeaver BW Running on Legacy Database with SAP NetWeaver BW AcceleratorData Compression (column store)HANA7.5 xLegacy DB050100Cube150DSO200Projected for Production 5.7 x250Master DataData Loading - FullData Loading - DeltaDSO to Cube1000DSO to DSODSO Activation500PSA to DSO0LegacySAP HANADSO to Cube60DSO to DSO40DSO Activation20PSA to DSO0Source to PSALegacySAP HANA3.2 x5.2 xResponse Time (Simple)4020Response Time0BW BW BWSAwith HANA HANA HANABWA Cube DSOSouthern California Edison Unleashes the Power of HANAResponse Time (Complex)403020100Response TimeBW with BWBWSABWA HANA HANA HANACube DSO5x-8-Source to PSA2xSOUTHERN CALIFORNIA EDISON

Leading the Way in ElectricitySAP HANA at SCE – 27W29W31W335/1/2012 5/15/2012 5/29/2012 6/12/2012 6/26/2012 7/10/2012 7/24/2012 8/7/2012 8/21/2012 9/4/2012 9/18/2012 10/2/2012 10/16/2012 10/30/2012 11/13/2012 11/27/2012 12/11/2012PlanningProject ManagementPre-TrialDevelopment/ Unit TestReg Testing Cycle 1Reg Testing Cycle 2User AcceptancePerformance TestingProduction CutoverPost ProductionStabilizationGoals: Migrate all of SAP NetWeaver BW legacy DB into SAP NetWeaver BWrunning on SAP HANA Incorporate BCS and IP into SAP NetWeaver BW running on SAP HANA Reduce nightly batch loading Improve reporting performance Migrate the enterprise SAP BusinessObjects BI from 3.1 to 4.0 (FP 3) Create the ability to handle “Big Data” analytics Leverage built-in calculation engines Create one or more new applications in stand-alone SAP HANASouthern California Edison Unleashes the Power of HANA-9-SOUTHERN CALIFORNIA EDISON

Leading the Way in ElectricityBusiness Intelligence Development ProcessCurrent Environment – SAP NetWeaver BW Legacy DB, SAP BusinessObjects BI 3.1 SP4,SAP Data Services 3.2SourcesEDWINT 1INT 2Data MartPCSAP SRMDSOPCDSODSOPCDSODSOMulti ProvidersSAP CRMExtractorsSAP Crystal ReportsUnvXcelsiusBExMDXBExBExDSODSODSOCubeSAP NetWeaverBW AcceleratorBICSLegacy DBNew 2012 Environment – SAP NetWeaver BW running on SAP HANA, BI 4.0 FP 3, and SAPData Services 4.0EDWINT 1INT ti stal ReportsUnxXcelsiusBExMDXBExBExDSODSODSOBICSSAP HANA-10-SOUTHERN CALIFORNIA EDISON

Leading the Way in ElectricityBusiness Intelligence Development ProcessEDWData MartT1T1T2TransformSAP CRMExtractSAP ECCExtractorsSourcesT2LoadSAP CRMT3T3TeradataT4T4OracleSAP Data ServicesSAP HANA ModelerSAP HANA Stand-alone Environment – Stand-alone SAP stal ReportsUnxXcelsiusAnalyticalViewCalculationViewSAP HANASOUTHERN CALIFORNIA EDISON

Leading the Way in ElectricityTechnical HighlightsAreaFocusSizingValidate compressionWatch your growth forecastSize based on peak usageUpgrade andMigrationSoftware add-onsData volumesSwitch off SAP NetWeaver BW Accelerator beforemigrationPost MigrationPost migration programsSource system connectionsDB memory parameters for data loadsDTP package settingPackage size for SAP HANA optimized activationABAP routines to be optimized for SAP HANA (few casesonly)SAP integrationConnection protocolsAuthenticationLatest fix pack and patch-12-SOUTHERN CALIFORNIA EDISON

Leading the Way in ElectricityStorage Sizing – ProjectionObject TypeTightenSAP NetWeaver BWHousekeepingCurrent Sizein Legacy DBClean UpDecommissionSystem Tables Unused ObjectsReduceLayersNear-lineOld DataPSA5,842100100100100100Legacy DBOverhead6,141-----Change em Master 0102,7752,6072,1573,3226465024624343596xSAP HANA DBCompressionSouthern California Edison Unleashes the Power of HANA* All numbers are in GB-13-SOUTHERN CALIFORNIA EDISON

Leading the Way in ElectricitySAP NetWeaver BW Running on SAP HANA – Total Cost ofOwnership (TCO)One-time Costs / SavingsOngoing Costs / Savings SAP HANA software license Software license Near-line storage software and hardware Growth software license SAP HANA hardware Hardware maintenance SAP NetWeaver app servers Growth hardware purchases (SAN, servers) SAP BusinessObjects BI servers Growth SAP HANA hardware purchases- Potential SAP NetWeaver BW Acceleratorlicense credit- Labor maintenance- Repurposed hardware (SAN, servers)- Labor development costs- savingsCostTimeSouthern California Edison Unleashes the Power of HANA-14-SOUTHERN CALIFORNIA EDISON

Leading the Way in ElectricityStand-alone SAP HANA – Potential OpportunitiesSmart Meter Analytics Improve customer energy efficiency Improve campaign effectiveness Understand consumption behaviorPower Procurement Lower short-term power purchasesBetter forecastingIntroduce new pricing optionsOutage Management Reduce response time and outage costsIncrease customer satisfactionQuickly analyze up-to-date outage informationPredictive Analysis Forecast outages, usage patterns, and costModel customer segmentationRapidly analyze advanced statistical modelsSouthern California Edison Unleashes the Power of HANA-15-SOUTHERN CALIFORNIA EDISON

Leading the Way in ElectricitySAP HANA – The Game Changer Much faster analytics and reporting for significant business value Total cost of ownership favoring the investment Real-time solutions for business problems Providing business results for new opportunities Increasing productivity and profitabilitySouthern California Edison Unleashes the Power of HANA-16-SOUTHERN CALIFORNIA EDISON

SAP Data Services 3.2 -10 Sources EDW SAP ECC SAP CRM SAP SRM Others s DSODSO DSO DSO DSO DSO INT 1 INT 2 Data Mart PC PC PC PC Cube Cube Cube Xcelsius s BeX Universe Unv Unv Unv BEx BEx BEx MDX Reports Crystal Reports WebI BICS SAP NetWeaver BW Accelerator Legacy DB New 2012 Environment - SAP NetWeaver BW running on SAP HANA, BI 4.0 FP 3 .