Loading S&OP Approved Forecast Measure to Demand Plan
SummaryLoading S&OP Approved Forecast Measure to Demand Plan
We have S&OP Cloud where we run S&OP plan on monthly basis and generate Shipment Forecast. During the S&OP cycle, planners adjust marketing/sales forecast and finally Consensus forecast is derived. This consensus forecast is a custom measure (Non Editable) based on following expression -
Nvl(Adjusted Consensus Forecast,nvl(Final Sales Forecast,nvl(Final Marketing Forecast, nvl(Final Shipments Forecast,0))))*(1+Nvl(Change to Consensus Forecast Percentage,0))
Our requirement is to load this S&OP approved forecast to Demand Plan (which runs on weekly basis) as a reference for the demand planners.