1 / 0

Supercharging BPC: A Performance Story at PG&E JS Irick, TruQua Darin Lemos, PG&E

Supercharging BPC: A Performance Story at PG&E JS Irick, TruQua Darin Lemos, PG&E. LEARNING POINTS. Inconsistent performance can place a shadow over great functionality BPC Performance is sensitive to many design decisions

lida
Download Presentation

Supercharging BPC: A Performance Story at PG&E JS Irick, TruQua Darin Lemos, PG&E

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Supercharging BPC: A Performance Story at PG&E JS Irick, TruQua Darin Lemos, PG&E
  2. LEARNING POINTS Inconsistent performance can place a shadow over great functionality BPC Performance is sensitive to many design decisions Performance testing BPC requires expertise beyond standard Loadrunner knowledge
  3. PG&E OVERVIEW General 70,000 square-mile service area in northern and central California. Approximately 20,000 employees Electric System 123,054 circuit miles of electric distribution lines 18,610 circuit miles of interconnected transmission lines 5.1 million electric customer accounts. 4.6 million electric SmartMeters™ installed Gas System 40,123 miles of natural gas distribution pipelines 6,136 miles of transportation pipelines 4.2 million natural gas customer accounts 4 million gas SmartMeters™ installed Power Generation 3 natural gas plants generating 1,400 megawatts 68 hydro powerhouses generating 3,896 megawatts 2 nuclear units generating 2,200 megawatt 15.9% of electricity supplied from renewable energy sources
  4. SAP LANDSCAPE BOBJ Licensed 2007/08 Enterprise Query Reporting and Analysis 4.0 Business Planning and Consolidations (BPC) Netweaver 7.5 Disclosure Management SAP implemented in 1996 Single production instance of ECC 6.0 Enhancement pack 5 FI, CO, SD, MM, SRM, HR, WM, FERC, PPM, EWM SAP BW 7.02 with BWA
  5. BPC APPLICATIONS Provider Cost Center Planning – Labor, Non-Labor and Billable Capacity Target Setting – Planning order amounts Order Detail Planning – Planning order cost elements Corporate Item Planning – Corporate cost elements FERC Translation – Regulatory view Financial Consolidation Budget Transfer Actual Order Planning Unit based Planning
  6. BPC PERFORMANCE ISSUES Template Refresh (Query from Server) PCC planning with response times ranging from 1.5 to 3 minutes. Template Submit (Submit to Server, Calculations in background) PCC planning with response times ranging from 2 to 6 minutes. Report Refresh (Query from Server) Baseline testing performed in TST with insignificant user load
  7. BPC PCC Template Performance
  8. STABILIZATION OBJECTIVES & CHANGES Performance – consistent performance < 30 seconds Automated roll-up every 50,000 records Data Archiving Consolidated BADI for writing labor records Break out of planning into multiple worksheets Reliability – system up and no data loss BWA index rebuilt daily Roll-up only closed requests Sustainability – maintain performance & reliability Develop Support Procedures Require business sign-off on all changes Restrict changes to formal releases Implement support ticket process (SMC Remedy)
  9. ENDURANCE TEST RESULTS ON OLD TEMPLATES Original performance results
  10. RESPONSE TIME RESULTS ON NEW TEMPLATES m:ss.ss;l Expected Response Times for 1 CC (seconds) Seconds
  11. BEST PRACTICES Build performance requirements into design Test performance before deployment
  12. KEY LEARNINGS Don’t overload templates Breaking templates into worksheets gives feel of single template while spreading performance between them Data maintenance is critical to sustaining performance BADI design needs to look at big picture to gain synergies in processing Performance testing requires thorough diagnostic process
  13. Performance Assessment Deep Dive Description of Performance Assessment Strategy Performance Assessment and Optimization techniques as applied to BPC 7.5 “Play by Play” of PG&E Assessment Lessons Learned from previous assessments Conclusion Q&A
  14. THANK YOU FOR PARTICIPATING For ongoing education on this area of focus,visit ASUG.com
More Related