Rolling forecasts in healthcare are challenging because Key Performance Indicators (KPIs) are unique to each organization and market conditions are ever changing. MD Anderson Cancer Center (MDACC) needed a standard forecasting process, while still offering choice-based budgeting and forecasting for the various divisions and institutes.Perficient implemented a driver based rolling forecast planning application that is standardized to calculate a base model while still allowing the planners to make adjustments to the calculated model.
Working with the client we identified key driver inputs which form the basis of the calculated base model. We identified global versus local adjustments for a few of the driver inputs and the calculated outputs.With MD Anderson’s long history of using Oracle Hyperion for enterprise performance management processes, integrating with various other original Hyperion applications and OBIEE dashboards was significant. The new rolling forecast model delivers several advantages:
- Flexible, driver based calculations.
- Allows for auditing adjustments made to the base calculated model.
- Several versions of the forecast can be saved.
- Integration with global reporting cubes – which MD Anderson has been using for a while now.
To hear more about the design and the project, come hear us at KSCOPE 18.
KSCOPE18 Session: Case Study: Implementing one of its kind driver based rolling forecast model at MD Anderson Cancer Center using Hyperion Planning with ASO integration
Presenter: Nandini Nehru, Perficient
Co-Presenter: Janet Kloves, University of Texas MD Anderson Cancer Center
When: June 11, 2018, Session 3, 2:30 PM – 3:30 PM
If you are unable to attend, but would like to get a copy of any one of the session slides, please leave a comment, and we’ll ensure you get the slides after the show.