Extreme Essbase Calcs : What-if, Goal Seeking and Sensitivity Analysis
Please join Ron Moore online for a presentation of Extreme Essbase Calcs: What-if, Goal Seeking and Sensitivity Analysis.
DATE: Thursday, November 2, 2017
TIME: 9 a.m. PDT/12 p.m. EDT
Doing what-if isn’t new. As long as I can remember everyone talked about it and the goal-seeking functionality using LOOP has been around for decades. But do most of our calculations use causal drivers or are they “type it in and agg it up” type databases. And how much what-if-ing can you really do if the database takes an hour to aggregate? Today more and more companies are using driver-based designs and recent improvements such as Hybrid Aggregation, new calculation functions and bigger hardware mean that there are new possibilities. Profit opportunities don’t usually follow simple linear patterns. Well-designed driver-based models capture complex patterns and help identify risks and opportunities that would otherwise be missed. Goal-seeking can significantly reduce the time it takes to set and distribute targets. Sensitivity analysis can help set priorities by identifying the most important drivers. It can also help compare a range of options to identify sweet spots.
First we will examine the business logic behind some useful what-if calculations that help uncover financial dynamics that make a difference in business results. Then we will examine the outline and business rule considerations and options. Then we will dig into the code.
We will show examples of outlines and business rule code for:
- Pushing down top-side budget adjustments
- Driver based what-if calculations
- Goal-seeking for target setting
- Prioritization and range comparison with sensitivity analysis
Last we will show some examples of using these techniques in real world applications.