a
Case Study Utilities SAP Planning Real-Time Consolidation

Decision Inc. Helps Yorkshire Water Overhaul
an Underperforming SAP Planning RTC Solution

Client
Yorkshire Water
Industry
Utilities
Location
Yorkshire, United Kingdom
Solution
SAP Planning Real-Time Consolidation, Optimised for S/4HANA

The Requirement

Performance of the SAP Planning Optimised for S/4HANA system degraded badly at production data levels, impacting other SAP systems.

The Solution

A focused System Review, then a short tactical engagement re-architecting views, calculations, reports, audit data and housekeeping.

The Impact

Report and input refresh speeds improved by 75 to 95%, calculations that timed out now complete, and data volume fell by roughly 60%.

01 · Client Overview

About Yorkshire Water

Yorkshire Water is a regulated water and waste company that provides some of life’s most essential services.

Customers
Over 5 million customers
Business Premises
140,000 business premises
Employees
Over 3,000 employees
Network
Over 30,000km of water network

Decision Inc. enabled Yorkshire Water to overcome performance degradation of their SAP Planning Optimised for S/4HANA system. A focused System Review uncovered key configuration issues which meant that, with production levels of data, the system performed badly and impacted other SAP systems.

Yorkshire Water
02 · The Requirement

The Requirement

In 2020 Yorkshire Water engaged Decision Inc. to remediate existing components which were not functioning correctly, and to perform a focused system review of the performance of their SAP Planning Optimised for S/4HANA reporting and consolidation solution.

The key challenge was that Consolidation and Planning methodologies had been simply migrated from the incumbent SAP Planning Standard system to the new SAP Planning Optimised system, without detailed consideration of the opportunities and limitations of BPC Optimised for S/4HANA.

Key areas of focus to enhance performance:

  • Technical set-up and the use of versioning
  • Configuration of views and calculations: performance tuning to take advantage of the HANA database architecture
  • Application design, including a reduction in the usage of unnecessary S/4HANA dimensionality
  • Housekeeping activities: developing, scheduling and handover
  • Tactical re-building of forecasting components
03 · The Solution

A Balanced Team, Targeted Fixes

Utilising a balanced team of functional and technical delivery experts, Decision Inc. made the following system adjustments:

  • System architecture improvements, including better use of HANA views, Real-Time cubes and reducing the usage of the ACDOCC table
  • Re-write of calculations, including the use of AMDP
  • Enhancement and re-writes of Reports and Input Forms
  • Remodel of the approach to Audit Data
  • Design and development of Housekeeping activities

“The Optimisation workstream delivered significant performance improvements. Before the work simple processes took tens of minutes rather than tens of seconds and other Finance and HR users experienced system performance issues. The work the Decision Inc. team undertook addressed all these issues and gave us the confidence to go-live with the new system.”

Mark HydesSenior Project Accountant, Yorkshire Water
04 · The Result

Measurable Performance Gains

The project was delivered in two sprint steps, with most enhancements delivered in an initial 2 month engagement. Following the performance improvement the scope was broadened, and additional enhancements were delivered in a 6 week follow-on engagement.

Reports & Inputs
Refresh speeds improved by 75 to 95%
Calculations
Calculations that previously timed out now complete: broadly 70 to 80% improvement
Data Volume
Data in the solution reduced by roughly 60%
Delivery
An initial 2 month engagement and a 6 week follow-on

Overall system performance gave the finance team the confidence to go fully live with the SAP Planning Optimised for S/4HANA system and cease duplicate parallel run activity in the incumbent system.

“The Decision Inc. team impressed us from the moment they engaged with us. A key differentiator was the team’s mix of skills, with experienced consolidation accountants who understood our finance business processes and how best to conceive them in the system, and technical experts who were able to diagnose the problems with our system and identify and execute fixes or an alternative approach.

Above and beyond the skill and experience the Decision Inc. team demonstrated was the speed and cohesion with which they worked. The leadership was not afraid to put difficult conversations on the table; we were quickly able to trust that the questions posed and the advice given were balanced and focused on getting the best outcomes for Yorkshire Water.”

Mark Hydes
Mark Hydes
Senior Project Accountant, Yorkshire Water