Trade Promotion: Scoring: Uplift Factor
(Training)
Technical Name: 0CP_SLSC6_Q0001
Use
This query defines the data source for the training of the data mining model Trade Promotions: Scoring: Uplift Factor (0CP_UPLI_FCT). To do this, the query selects the data records and parameters that are used for the training of the data mining model from the InfoCube Sales and Trade Promotions (Planned+Actual) (0CP_SLSC6).
Filters
|
Element |
InfoObject, Restrictions, Formula |
|
Fiscal year variant |
0FISCVARNT restricted to the value ‘K4’ |
|
Fiscal year/period |
0FISCPER restricted to selection variable 0I_PRFY2 |
|
Promotion phase |
0PERIOD_TYP restricted to the value ‘50’ |
|
Request ID |
0REQUID restricted to the selection variable 0S_RQMRC |
|
Life cycle status |
0CRM_MKTELM__0STAMKTSYS0 restricted to the value 30 |
Rows
|
Element |
InfoObject, Restrictions, Formula |
|
Sales category |
0PR_CAT_SAL |
|
Product |
0CRM_PROD |
|
Tactic |
0CRM_TACTIC |
|
CRM Marketing element |
0CRM_MKTELM |
Columns
|
Structure of prediction parameters |
|
|
Elements |
InfoObject, Restrictions, Formula |
|
Actual promotion price reduction (%) |
0CP_SLSC6_CK001 restricted to the value ‘10’ |
|
Actual billing quantity (base UoM) |
0BILL_QTY restricted to the value ‘10’ (actual) |
|
Planned base sales quantity (base UoM) |
0CP_SLSC6_CK002 restricted to plan version change 1 and the value ‘20’ |
|
Uplift factor (actual/planned) |
(Actual billing quantity (base UoM) – planned base sales quantity (base UoM)) / planned base sales quantity (base UoM) |