Demand group and Base level

The forecast consumption calculation can be performed at a group level or for individual demand points (base level). This section defines the business process considerations and the options for defining these levels and the default configurations.

Aggregate Demand

The forecast is consumed at an aggregate level and you must determine the required level. For example:

  • Is it across all warehouses?
  • Is it at product family?
  • Is it at customer or customer group?

After determining the level, all forecasts and open customer orders are aggregated to that level. You can now determine the process to consume the forecast and spread the remaining forecast down to the base level using basic parameters.

Demand Group level

The demand group level is the level at which Forecast Consumption process is executed. The level is determined based on the Item and Location Hierarchies used. By default, demand group level is at the base level in the item hierarchy and the 1st parent in the location hierarchy.

Variable Name Variable Description Default Value
scv_fcst_consump_profile SCV Profile for data filtering of Forecast Consumption DPLS_BASE
scv_fcst_consump_cycle_period_id SCV Cycle Period for Forecast Consumption Base
scv_fcst_consump_scenario_id SCV Scenario for Forecast Consumption Base
scv_fcst_consump_location_hierarchy SCV Location Hierarchy to use for Forecast Consumption DPLS_BASE_LOCATION_HIERARCHY
scv_fcst_consump_item_hierarchy SCV Item Hierarchy to use for Forecast Consumption DPLS_BASE_ITEM_HIERARCHY

Base level

The base level is the level at which you can import the published demand plan from the Demand Planning module and the customer orders from SCV. The final results of Forecast Consumption (the 'remaining forecast') are also published at this level. The application variables to control this level are the same as the Demand Group Level.

It is possible to limit the number of valid entries at this base level. You can only create valid base nodes as described in the table below based on the application variable.

Variable Name Variable Description Default Value
fcst_consump_reset_create_combinations_item_sales Create Base Level nodes from Item Sales (SC_ITEM_SALES) 0
fcst_consump_reset_create_combinations_item_npi Create Base Level nodes from Item NPI (SC_ITEM_NPI) 0
fcst_consump_reset_create_combinations_item_customer Create Base Level nodes from Item Customers (SC_ITEM_CUSTOMER) 0
fcst_consump_reset_create_combinations_demand_plan Create Base Level nodes from Published Demand Plan (SC_DEMAND_PLAN_AGGR) 1
Note: If you modify the default Demand Group level, you must also modify the 'FC - SCV - FC - Import Customer Allocations - Group' interface service and the demand_group field to match the new Demand Group.