Scenario Analysis by Node
Last updated
Last updated
Scenario analysis by node helps in further investigation of scenarios along with the node details and its breakdown. It helps you to visualize the trend, variance breakdown and the simulation impact for the desired nodes and its calculation components with the help of charts.
To open the Analysis window, click on any node in the tree view or any cell on the Table View that needs to be analyzed.
For example, clicking on the US node from Scenario 2 of the Simulate window opens the below pop-up where you can see the values, charts, details and notes specific to the US node in Scenario 2.
At the bottom of the window, you have an option (+) to open other nodes and switch between the opened nodes.
The information available on this window is explained below.
We will take up an example with the following simulation summary:
Scenario Name
Scenario 2
Baseline Series
Sum of 2022
Comparison Series
Sum of 2021
Simulated Nodes with change%
Revenue (8%) and Expense (-6%) nodes of US
A line chart along with a clustered column chart is used to quickly compare the simulated value, baseline value and comparison value in a period-wise distribution.
Blue-green trendline represents the scenario (simulated values)
Column chart in blue represents Baseline Values
Column chart in orange represents Comparison Values
Hover the mouse over the chart to get the simulation details for the individual periods on the tooltip.
Find below the table view of the trend of Total Net Profit.
In the Trend chart, you can choose to include variance charts for Simulation Impact, Variance and the original variance to be displayed. Each shows their respective variance. To choose, click on the dropdown menu at the top right corner of the window in the Trend tab.
The below image shows the trend chart along with the simulation impact variance chart as Sim.Impact option has been chosen from the dropdown list.
Hover over the chart to get period-wise details on the tooltip. In table view, the same chart appears as shown below.
Similarly, the Variable and Original variance charts can be presented in graph and table views.
Refer to this section to learn the difference between simulation impact, variance and original variance.
A Waterfall chart shows the variance breakdown for any chosen node.
For a node with no simulation, the variance between the baseline and the comparison series is shown with a breakdown of all its immediate child nodes/calculation components.
The image below shows the variance breakdown of the baseline series (Sum of 2022) versus the comparison series (Sum of 2021) for the Asia node.
For a simulated node, the variance between the Scenario (simulated values) and the comparison values are shown with a breakdown of all its immediate child nodes/calculation components.
For example, in the below image, the variance breakdown of the Total Net Profit node is shown for Scenario 2 versus the comparison series (Sum of 2021).
A waterfall chart that visually breaks down the simulation impact is shown for the selected node i.e. it shows all the simulated inputs that add up to create the new scenario value.
In the below image, the simulation impact on Total Net Profit is shown when Revenue and Expense values were simulated for Scenario 2.
In table view, the chart appears as shown below.
This shows the trend and comparison (line and clustered column charts) for the selected node with its calculation component nodes that make up the selected node.
The example below shows the calculation components of Total Net Profit through trellis charts.
All the charts of calculation components can be individually downloaded or pinned using the icons available beside each of them. For larger models, the Search option can be used to search for any calculation components. Clicking on the pop-up icon next to each component name opens the node scenario analysis of the selected component node.
At the top of the window under the node title, you can view the Scenario value (simulated value), baseline value, comparison value and their simulation impact, variance and original variance.
Original Variance shows the difference between the baseline value and the comparison before simulation.
Simulation Impact shows the difference between the simulated value and the baseline value.
Variance shows the difference between the simulated value and the comparison value.
To include other nodes for similar analysis, click on + Add node details icon on the bottom panel.
From the pop-up window, select the desired node for which you want to view the trend and analysis charts.
It will be added as a new tab to view and compare the charts.
Toggle between table view and graph view by clicking on the table/chart icon at the top right corner of the window. Use the variance dropdown menu beside it to view the required data.
On the right, under the Details section, you can view the node details such as its lineage, type, configuration, time aggregation, simulation method, desired trend, and the node description if added.
On the right, under the Notes section, you can add new notes or view added notes. You can also add notes in the tree or table view which is explained in detail here.
The Download option on the chart lets you download the charts in PDF format.
Use the Split screen option in the top right corner to view the tree/table model and simulation analysis window simultaneously.
The split screen also offers all the above options available in full-screen mode.
You can switch between full-screen mode and split-screen mode. To close the analysis window click close.
Click on the table icon at the top right corner to switch to the table view.
