Mirror of Oracle documentation
Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.
Select Calendar
| 1. Forec | ast Results | |||||
|---|---|---|---|---|---|---|
| w A | Calendar | # | ||||
| ie | Measure(De | faul | t) + £ | |||
| Measure | Cale | ndar | ? T | 4/13/2019 —Ss T | 4/20/2 | 019 t |
| Adjusted For | ecast | 153.46 | 159.64 | 184.57 | ||
| Adjusted Bas | eline | 1535.36 | 139.84 | 184.57 | ||
| Approved Fo | recast | 753.36 | 139.84 | 164.57 | ||
| Approved Sy | stem Forecast | 154.456 | 149.84 | 184.57 | ||
| Preprocesse | d Sales | 0.00 | 0.00 | 0.00 | ||
| LastYear Sal | es | 163.96 | 154.00 | 136.00 | ||
| Event | ||||||
| Discount | 0.00 | 0.00 | 0.00 | |||
| Last LastYea | r Sales | 0.00 | 0.00 | 0.00 | ||
| System Fore | cast | 153.36 | 139.84 | 184.57 | ||
| System Base | line | 153.36 | 139.84 | 184.57 | ||
| What-lf Base | line | 0.00 | 0.00 | 0.00 | ||
| Adjusted Cur | nint | 46.01 | 62.76 | 83.32 | ||
| ApprovedCu | mint | 46.07 | a2276 | 43.32 |
-
Changes to the Adjusted Baseline are automatically approved. The Approval view updates with the date of the adjustment and the name of the user who made the adjustment.
-
Demand transference is selected as the adjustment method in forecast setup and significant demand transference effects are available.
Approved Forecast
The Approved Forecast is the forecast quantity that was approved at the time of the task build. The values contained in this measure are read-only. If changes are made to the Adjusted Forecast, then click Calculate to show the new value in the Approved Forecast.
Approved System Forecast
The Approved System Forecast is populated with the last System Forecast approved for a time series:
1. Approval Method set to Automatic Approval
2. Approval Method set to a Forecast Approval Alert and the alert is not triggered
3. Update Last Weeks Forecast is set to Use Forecast
Promo Demand
This read-only measure is the demand data used to generate the forecast. This allows you to compare Actuals to forecast values. The Promo Demand is based on the historical sales which are undergoing several rounds corrections.
Last Year Sales
Event
This measure displays at the item, location, and week level if one or more offers were active. This usually goes together with the Discount measure.
Discount
This is the discount from the full price for which a product was sold at a given location for a given time period.
Last Last Year Sales
System Forecast
This is a read-only measures that equals the system baseline plus the system peaks.
System Baseline
The System Baseline displays the system generated baseline forecast. The values contained in this field are read-only. The system baseline incorporates level, trend, seasonality, but no causal-related information.
What-if Baseline
In the What-if Parameters view you can change some forecast parameters and see how they impact the forecast. The resulting forecast is stored in this measure. If you like the change, you can run the Copy What-if custom menu, and the forecast is copied in the Adjusted Forecast measure
Adjusted Cumint
Cumulative Intervals are used in safety stock calculation within allocation and replenishment systems. Its value is similar to a running total of a percentage of the actual forecast and is read-only.
Weighted Absolute WAPE =~ 12droday-1lF today—n — Ael Percentage Error n todaytoday—n —1 A, today—n Mean 1 Absolute Error MAE =—” ». |F. — A;| teday—1 Root Mean eeetaday— C2 — A,)? Squared Error RMSE = |——~ Forecast 1 today—-n Bias BIAS = —” >. (F, — A,) today—1
This measure displays the adjustment method used to programmatically adjust the system forecast. The options are:
- No Adjustment
No adjustment is made to the system generated forecast
- Keep Last Change
If any adjustments were done to the forecast in the previous runs, they are reflected in the Adjusted Forecast measure. In this use case, the total forecast is retained.
- Keep Last Baseline
If any adjustments were done in the Adjusted Baseline in the previous runs, they are retained. In this use case. the system calculated peaks are applied on the Adjusted Baseline
- Keep Last Peak
If any adjustments were done in the Adjusted Peak measure in the previous runs, they are retained. In this use case, the adjusted peaks are applied on the system calculated baseline.
Approve By
Approved By is a read-only field that displays the name of the user to approve forecasts for an item/location. This field may be populated with Sys if the system was set to automatically approve forecasts during the batch forecast process.
Approval Comment
Approval Comment is a field in which notes may be entered regarding the forecast values or any pertinent information for specified Product/Location combinations.
Violated Exceptions
This field displays which (if at all) approval exception business rule was violated.
Approval Date
Approval Date is a read-only field that displays the date that the forecast quantity is approved either automatically during the batch forecast process or when changes are made to the Adjusted Forecast. This information is necessary for IPOCS-Demand Forecasting to carry out any subsequent processes, such as replenishment procedures.
Approve
This field may be selected if you want to accept the System Forecast quantity for a time series that has yet to be approved. The flag is also activated when a change is made to the Adjusted Forecast and Calculate occurs. When this flag is activated, the time series for an item/location are approved and both the Approval Date and Approved By fields are updated.
Active Forecast Items
This field indicates if an item/store qualifies to have a forecast generated.
Error Metrics
To assist the forecast analyst in deciding which forecasts to review, there are several error metrics that can be reviewed.
When the accuracy is good with only a small error, the analyst may decide to move on and review other forecasts. When an item performs poorly, the analyst may want to spend some time to adjust the forecast values.
- Forecast Results Chart > |S [eee in) [aaoimensions} [ tocstonoes a7]SRA) L[_Proa e t e7 1D | Measure (Default) + a| [ < 1006 Chicago @ > < 1254768 - PL - 100% Columbian Non-Flavored Regu… @ > @mEf) ws
350
x0
=
20 sis a Fy
1 Adjusted Forecast 1 Adjusted Baseline |® Approved Forecast @ Approved System Forecast ® Preprocessed Sales Last Year Sales @ Last Last Year Sales I@ SystemEvent Forecast @ Discount I System Baseline I Adjusted Cumint I Approved Cumint
° e38 o3 28 oSs o3 o3 o3 o8 r=oo5 o8 8 8 Ss 8 S 3° 3 8 8 3 =ga S$8s2a PaSNgQa &amg “0g=g 3sBePy82 PaPa8QS PagS& &sg> S$ga2+ Ss8gg+ 8S8g+ g=xa aa=== ga2<a gaaSa PS8=S PyRSgg aa253 gS8qa2 FS=&gSs
3. Update Last Weeks Forecast is set to Use Forecast
Preprocessed Sales
This read-only measure is the demand data used to generate the forecast. This allows you to compare Actuals to forecast values. The preprocessed sales are based on the historical sales which are undergoing several rounds corrections.
Last Year Sales
Event
This measure displays at the item, location, and week level if one or more offers were active. This usually goes together with the Discount measure.
Discount
This is the discount from the full price for which a product was sold at a given location for a given time period.
Last Last Year Sales
System Forecast
This is a read-only measures that equals the system baseline plus the system peaks.
System Baseline
The System Baseline displays the system generated baseline forecast. The values contained in this field are read-only. The system baseline incorporates level, trend, seasonality, but no causal-related information.
What-if Baseline
In the What-if Parameters view you can change some forecast parameters and see how they impact the forecast. The resulting forecast is stored in this measure. If you like the change, you can run the Copy What-if custom menu, and the forecast is copied in the Adjusted Forecast measure
Adjusted Cumint
Cumulative Intervals are used in safety stock calculation within allocation and replenishment systems. Its value is similar to a running total of a percentage of the actual forecast and is read-only.
Approved Cumint
Cumulative Intervals are used in safety stock calculation within allocation and replenishment systems. Its value is similar to a running total of a percentage of the actual forecast and is read-only.
What-if Parameters View
The What-if Parameters view allows you to adjust some forecast parameters and immediately view the effects on the forecast in the Forecast Results view.
If you like the new adjusted forecast, you first have to Approve the forecast to get the forecast in the approved forecast measure. Next you have to Commit to update the database with the approved forecast as well as with the What-if forecast parameters settings. These parameters are used the next time the forecast batch is run.
Parameters that can be adjusted will affect base demand as well as total forecast.
-
What-if Forecast Start Date
-
What-if History Length
If the What-if flag is on, you can run it by clicking on the What-if custom menu.
What-if Base Demand
This measure displays the value for the base demand based on the new history length.
What-if Forecast Length Requested
This measure displays the requested forecast length. This is useful, because after running the What-if custom menu, the What-if Forecast Length measure will be blanked out. It is this measure where you keep track of the latest forecast length used.
What-if Forecast Start Date Requested
This measure displays the requested forecast start date. This is useful, because after running the What-if custom menu, the What-if Forecast Start Date measure will be blanked out. It is this measure where you keep track of the latest forecast stare date used.
What-if History Length Requested
This measure displays the requested history length. This is useful, because after running the What-if custom menu, the What-if History Length measure will be blanked out. It is this measure where you keep track of the latest history length used.
Copy to Adjusted
After you finish adjusting the parameters, you can either return to reviewing the forecast or you can apply the changes. Enable this measure by selecting the Boolean measure value to true.
Preprocessing Details View
The Preprocessing Details view shows all necessary information to determine how the loaded sales were transformed into unconstrained demand. You can review the numbers after each step, and also have the possibility to override the total demand. Unconstrained demand is what an item would have sold at a location without the influence of any outside factor. These factors can include:
-
Out of stock situations where an item would have likely sold more
-
Outliers like fatty fingers or Software bugs
-
Promotions that can boost sales
-
Weather that can boost or lower sales. Examples include hurricanes for water bottles, or rain for barbecue items.
For details on how the corrections are made refer to the Oracle Retail AI Foundation Cloud Service User Guide .
| 5. Preprocessing Det | ails | |||||||
|---|---|---|---|---|---|---|---|---|
| w 8 Calendar | f | f | AllDimensions | Location | ||||
| [1[Measuree | tou | t) ~Z | <1006Chi | cago @> | ||||
Cal Measure | enda | r 2/9/2019 | Tt | 2/16/2019 tT | 2/23/2019 | T | 5/2/2019 tT | 3/9/2019 Tt |
| Depromote Adjustment | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
| Outage Adjustment | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
| OutlierAdjustment | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
| Outage Indicator | oO | o | oO | oO | ||||
| Promotion Indicaor | 0 | 0 | 0 | 0 | 0 | |||
| Baseline Sales | 212.00 | 225.00 | 192.00 | 156.00 | 180.00 | |||
| Historical Discount | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
| Historical Event | ||||||||
| Outher Indicator | oO | oO | oO | oO | oO | |||
| Raw Sales | 212.00 | 225.00 | 192.00 | 156.00 | 180.00 | |||
| Preprocessed Sales | 212.00 | 2275.00 | 192.00 | 156.00 | 180.00 | |||
| UserOverride | -1.00 | -1.00 | -7.00 | -1.00 | -1.00 |
This measure represents the demand that was sold at a location without the influence of any outside factor.
Historical Discount
This measure displays the units that were removed from the historical sales, because they were caused by the lift in demand due to one or more offers.
When the Historical Discount or Historical Event measures are not blank, it is likely that the Promotion Indicator is On, and the Depromote Adjustment will also have a non-zero value.
Historical Event
When the Historical Discount or Historical Event measures are not blank, it is likely that the Promotion Indicator is On, and the Depromote Adjustment will also have a non-zero value.
Outlier Indicator
This measure is either loaded or calculated by the rules in the custom menu. It is used during the pre-processing run that corrects the sales for outliers.
Raw Sales
This measure is loaded and it represents the historical sales at a Product/Location/calendar period level. It is different from demand because it may be constrained by stockouts, outliers, weather, and so on.
Promo Demand
This measure represents the demand – including promotion and offer data that was sold at a Product/Location/calendar. If configured properly, the stockout and outliers impact is removed.
User Override
After reviewing all the above measures, this is the place to override the demand at the Product/ Location/calendar level. This can be useful for special cases (introduction of key items) as well as extreme situations when entire departments were hurt by natural events, like a pandemic.