Before you start
For history corrections, high-value combinations may require manual intervention when you work through history corrections. Low-value combinations may require little or no manual intervention. The automation feature in D1120- History Correction can be used for low-value combinations.
C-VaR measure context selector and table
The context selector above the table displays a list of C-VaR measures. To change the C-VaR measure, select a measure from the context selector. When you change the C-VaR measure, the data displayed in the table changes.
Parameters
| Parameter | Value |
| C-VaR (Mean) | A system-calculated value for the selected product. It's calculated based on the C-VaR defined as standard deviation divided by the mean of pure history. |
| C-VaR (Trend) | A system-calculated value for the selected product. It's calculated based on the C-VaR defined as standard error divided by the mean of the trendline. |
| C-VaR (Residual) | A system-calculated value for the selected product. This value is the difference in standard deviations of values versus the predicted values. |
View Settings
In the Additional insights panel, use the the View Settings card to adjust or view these parameters:
Parameters
| Parameter | Value |
| Hide Product Level | Select this checkbox to hide the lower-level product data (product leaf) and display P1/finished products on the columns of the product/customer C-VaR values table. |
| Hide Customer Level | Select this checkbox to hide the specific customer data (customer leaf) and display L3/country and regional data on the rows of the product/customer C-VaR values table. |
| View Years History | You can specify how many previous years you want to view in the forecast chart. If you enter more than the maximum previous years available, only years for which there is data display. |
| View Years Future | You can specify how many future years you want to view in the forecast chart. If you enter more than the maximum future years available, only years for which there is data display. |
| View Period Type | To change the period type, select the cell next to View Period Type and select either:
|
C-VaR Coloring
In the Additional insights panel, you can use the C-VaR Coloring card to set conditional formatting for the product/customer C-VaR values table that identifies high C-VaR values.
The parameters you can set are as follows:
Parameters
| Parameter | Value |
| C-VaR Yellow | C-VaR values that are equal to or greater than this value are highlighted in yellow in the table. Note: Values that are lower than the C-VaR Yellow value are highlighted in green. |
| C-VaR Red | C-VaR values that are equal to or greater than this value are highlighted red in the table. Values that are lower than this value, but higher than the C-VaR Yellow value are highlighted in yellow. |
Forecast chart
The forecast chart displays a range of calculated forecasts for a specified product-customer combination. The chart data changes based on the product-customer C-VaR value you select in the table.
The chart displays this data:
- Effective Adjusted History
- Best Fit Forecast (Formula)
- Best Fit Forecast (Sum)
- User Selected Forecast
- Final Forecast
The forecast chart in the Additional insights panel displays the same data as the larger forecast chart.
