Modern analytics are way more than just insights into a given situation. They're about using those insights to create and tune business planning models. They're also about using insights to combine them into simulations: What would happen if I change this "key influencer" or "that metric"? These simulations---or what-if analyses---are a simple necessity to modern analytics, if you ask me.
In SAP Analytics Cloud, they have answered this need in various ways, including:
A formula-based slider: Basically, this is an input control in SAP Analytics Cloud that is driven by a formula and an input driving it. This input can either be an existing dimension or a list of values. The input is a parameter part of the formula, where the formula calculates the output. An example is an input list going from -15% to +15% where that is made part of a formula to calculate the effect on margin: ((rev*[input])-cost/cost) to calculate what an increase/decrease on revenue would implicate to the margin.
The value driver tree (VDT): This is a more advanced feature that leverages the interdependencies of metrics onto a driver for final output.
The value driver tree is a physical representation of interdependencies in measures that is used to generate a simulated effect of changing an underlying measure onto its parent. SAP Analytics Cloud allows for slider inputs to change metrics and recalculates the whole model on its outcome. Very, very powerful and extremely helpful for simulation and planning purposes.
The key to the VDT is the correctness of the underlying SAP Analytics Cloud model. First, this model needs to be a planning model. Next, the model should have defined hierarchies in its accounts (metrics).
In the following video, I demonstrate step by step how to create a VDT in a very simple---and semi-automated---way.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
36 | |
25 | |
17 | |
13 | |
8 | |
7 | |
7 | |
6 | |
6 | |
6 |