Extreme Essbase Calcs: What-if, Goal Seeking and Sensitivity Analysis

Ron Moore

June 8th, 2017

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?

What Are Companies Doing Today?

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.

What-if, Goal Seeking, and Sensitivity Analysis

For Kscope17, we’ve put together a presentation that will walk you through the ins and outs of what if, goal seeking, and sensitivity analysis.

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.

Next, we will examine the outline and business rule considerations and options.

Then, we will dig into the code and 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.

Join me online for a deep dive into Extreme Essbase Calcs.

TopDown’s experts presented all of their Kscope17 during our Kscope17 Encore Series. We covered the gamut of topics. You can find all the recordings here.

How to Get the Most Out of Essbase in the Cloud –  Paul Hoch

Elevating Your Workforce Planning Solution to the Cloud by Juan Porter

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

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

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



Ron Moore

About Ron Moore

Ron Moore, TopDown Consulting Solutions Architect, has more than 19 years of experience with Essbase, versions 3x through 11x, with an extensive background in finance and economics. He is certified in Essbase and Planning, and was one of the first Essbase Certified Consultants in the world. He founded Marketing Technologies Group, which specialized in Essbase and Planning training, consulting, and collaborative development. He has led many full-cycle projects, from requirements gathering and design through implementation, training, and rollout. He also received 19 Oracle University Quality Awards.

Leave a Reply

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