Scenario Analysis by Node

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:

1. Trend

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.

Chart Element

Representation

Hover the mouse over the chart to get the simulation details for the individual periods on the tooltip.

Click on the table icon at the top right corner to switch to the table view.

Find below the table view of the trend of Total Net Profit.

1.1. Variance Charts

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.

2. Variance Breakdown

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).

3. Simulation Impact

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.

4. Calculation Components

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.

5. Node Values and Variances

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.

6. Open Other Nodes

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.

7. Table View

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.

8. View Node Details

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.

9. Add Note

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.