SECTIONSUsing the Plan Scenario Comparison Dashboard
The Plan Scenario Comparison dashboard enables you to compare two plan scenarios that belong to the same or different plans from Extended Planning and Analysis. You can compare plan scenarios that include any type of data. For example, you can compare scenarios that include financial data or operational data.
Source Dataset
The Plan Scenario Comparison dashboard is populated with the data from the dataset that you select in the Extended Planning and Analysis Analytics configuration wizard when you create your app. The dataset must include data from plans in Extended Planning and Analysis, meaning that it must include the Plan Name and Plan Scenario Name fields.
Customizable Dashboard Title
You can customize the title of your dashboard in the Extended Planning and Analysis Analytics configuration wizard when you create your Extended Planning and Analysis Analytics app. This enables you to name your dashboard according to the nature of the plans included in the dataset that the dashboard uses. For example, you can enter Financial Budget H1 2025 if the dataset selected includes financial data, or Workforce Plans 2025 by Projects if the dataset includes data related to your projects.
Dashboard Selectors
You can customize your data using the following selectors.
| Chart |
Selector |
Description |
|---|---|---|
| Plan Scenario Comparison Chart | Chart type selector |
The type of chart used to display the data. The possible values are:
|
| Plan Scenario Comparison Chart and Plan Scenario Comparison Table | Group By |
The dimensions used to group your data. |
| Measure | The measure that defines the values displayed on the y-axis of the chart. | |
| Plan A | The plan to compare to the plan selected in Plan B. By default, this and the Plan B selector display the same plan. | |
| Plan B | The plan to compare to the plan selected in Plan A. By default, this and the Plan A selector display the same plan. | |
| Scenario A | The scenario that belongs to plan A and is compared to a scenario that belongs to plan B. The scenario that you select here is the point of reference in the comparison, meaning that the scenario B is compared to the scenario A. | |
| Scenario B | The scenario that belongs to plan B and is compared to a scenario that belongs to plan A. |
Managing Selectors
To start comparing, select your values as follows:
- Select a plan in the Plan A selector.
- Select a scenario for plan A.
- In the Plan B selector, do one of the following:
- If you want to compare scenarios that belong to the same plan, select the same plan as plan A.
- If you want to compare scenarios that belong to different plans, select a different plan.
- Select a scenario for the plan previously selected.
- Select the dimensions that you want to group your data by in the Group By selector. You can then select the dimensions values for the selected dimensions in the filters panel. More information about how to manage filters is provided below.
- Select a measure in the Measure selector.
Managing Filters
By default, the filters panel is displayed in this dashboard. You can toggle between hiding and displaying the filters panel by clicking 
. To change a filter selection, ensure the filter panel is displayed in the dashboard.
The number of filters available depends on the number that you select in the question "How many filters do you require for your Plan Scenario Comparison dashboard?" in the configuration wizard when you create your Extended Planning and Analysis Analytics app. In the filters panel, you can then select the values for each dimension that you have previously selected in the Grouped By selector. For example, if you select "3" in the configuration wizard question, three filters are available in the filters panel. In the Grouped By selector, you then select the following dimensions in this order:
- Trial Balance 1
- Financial Period
- Financial Year
In the filters panel, each filter displays the values for each dimension as follows:
- The first filter displays the values for Trial Balance 1.
- The second filter displays the values for Financial Period.
- The third filter displays the values for Financial Year.
Using Dashboard Charts
The Plan Scenario Comparison dashboard contains the following charts.
Plan Scenario Comparison Chart
View the comparison of the dimension values selected for the plan scenarios specified and according to the measure selected.
If this chart isn't displayed, click 
.
By default, this chart is displayed as a column chart, but you can also display it as a bar chart or a line chart with the chart type selector.
You can hover over a bar or a line to view the following details:
- Dimension
- Dimension value
- Plan
- Scenario
- Value
Plan Scenario Comparison Table
This table displays the difference between the dimension values compared as absolute values and as percent variance.
If this chart isn't displayed, click 
.
The table contains the following columns:
- Dimensions - this column shows the values selected for the dimension selected in the Group By selector. The selected dimension is displayed in the column header.
- Plan - Scenario - this column shows the measure value for the plan and the scenario selected in the Plan A and Scenario A selectors.
- Plan - Scenario - this column shows the plan and the scenario selected in the Plan B and Scenario B selectors.
- Variance - this column shows the difference between the values as absolute values. The variance is calculated as follows:
Value of the measure value for scenario A - Value of the measure value for scenario B.
-
Percent Variance - this column shows the difference between the values as percentages. The percent variance is calculated as follows:
((Value of the measure value for scenario A - Value of the measure value for scenario B) / Value for scenario B) x 100
Depending on the resulting value, it is displayed as follows:
- When the percent variance is positive, the value is displayed in green text along with an arrow pointing up.
- When the percent variance is negative, the value is displayed in red text along with an arrow pointing down.
- When the percent variance is zero, the value is displayed in gray text along with two arrows pointing to the sides.