1
Download Levels - Oracle Documentation
Transcript
Parameter Name Purpose GOAL_FOCUS Specifies if Promotion Optimization should optimize from the manufacturer's perspective (0; recommended) or the retailer's perspective (1). COEFFICIENT_RANGE_FACTOR Controls the range of possible coefficient values to be searched. For any given causal factor, Promotion Optimization by default tests a discrete set of coefficient values, ranging from 0 to the largest value observed in history. This parameter specifies the additional percentage to add to that range of values. For example, to allow Promotion Optimization to search values 20% larger than historically seen, set this parameter to 0.20. DEFAULT_RET_MARGIN SQL expression that returns the default retailer margin. DEFAULT_MAN_MARGIN SQL expression that returns the default manufacturer margin. RETAILER_LEVEL_ID ID of the level (from group_tables) that corresponds to the retailers. OPTI_BUYDOWN_COLUMN Defines which column the optimized buydown is written to. Refers to a column on the promotion_data table. OPTIMIZATION_RANGE_START SQL expression that returns the start of the date range which is considered by optimization. Expression references promotion table. OPTIMIZATION_RANGE_END SQL expression that returns the end of the date range which is considered by optimization. Expression references promotion table. BUYDOWN_EXPRESSION SQL expression that returns the actual buydown for promotion being optimized. Expression references promotion_data table. As a default, it incorporates bill back, off invoice and scan values. Configuring Promotion Optimization for Predictive Trade Planning 34-7
