Cut Cycle Times and Improve Service Levels w/ Hybrid Aggregation

Ron Moore and Brian Brockway

May 8th, 2017

Suez owns and operates 16 water and waste utilities and operates 90 municipal water and wastewater systems. They had a very large Planning cube and aggregations could take three hours or more. They had to choose carefully which aggregations they did and when. Administration was arduous. This put severe limits on what Suez could do to improve service levels to users.

Suez partnered with TopDown Consulting to optimize the application. TopDown performed a series of tests on more than a dozen optimization techniques. The results provided two good options. FixParralel could reduce aggregation times to about 20 minutes. And even though Suez was on, the application appeared to be a good candidate for Hybrid Aggregation which would eliminate the aggregation.

Brian Brockway, Manager – IT Applications and Support at Suez and Ron Moore, Solution Architect, described this case study in their blog post, Transforming Planning at Suez with Hybrid Aggregation.

In this session, Brian and Ron will present the case study, including details such as:

  • the tests performed to identify the best optimization options
  • the steps to determine if the cube was a candidate for Hybrid Aggregation
  • the trade-offs between FixParallel and Hybrid Aggregation and how Suez decided which option to pursue
  • the step by step process (including code samples) of converting the cube to hybrid, including cross-dimensional operators, time balances, MDX WITH clauses, and other challenges
  • how Suez addressed the effects of some of Hybrid’s disadvantages

Finally, we will describe how Hybrid transformed service levels for users and list the benefits of the conversion.

We look forward to seeing you on Tuesday, June 27 at 8:30 am.

Don’t forget that TopDown’s experts are presenting seven other sessions at Kscope17. We’re covering the gamut of topics:

Extreme Calc Manager – Ludovic De Paz and Ron Moore

Elevating Your Workforce Planning Solution to the Cloud – Nick Blazosky and Ludovic De Paz

Case Study: How Suez slashed cycle times and improved service levels with Hybrid Aggregation  – Ron Moore and Brian Brockway, Suez

DRG – Creating Workflows in DRMSteve Davis

Handling Textual Data in Planning and Essbase—A Starbucks Case Study – Juan Porter and Rhonda Brigham, Starbucks

Hybrid Cloud – A Solution for a Business ProblemPaul Hoch and Steve Davis

Agile/Scrum, a new way to manage your project development and deliveryR. Michael Smith

How to Get the Most Out of Essbase in the Cloud –  Paul Hoch and Ludovic De Paz

Ron Moore and Brian Brockway

About Ron Moore and Brian Brockway

Ron Moore, TopDown Consulting Solutions Architect. Brian Brockway, Manager, IT Applications and Support, Suez (North America)

Leave a Reply

Your email address will not be published. Required fields are marked *