Start of Content Area

Trade Promotions: Scoring: Uplift Factor  Locate the document in its SAP Library structure

Technical Name: 0CP_UPLI_FCT

Based on the queries: Trade Promotion: Scoring: Uplift Factor (Training) (0CP_SLSC6_Q0001), Trade Promotion: Scoring: Uplift Factor (Prediction) (0CP_SLSO1_Q0001).

Data mining method: Scoring

Use

You use this data mining model to determine uplift factors that you can use in the SEM planning application Sales and Promotion Planning for the Consumer Products Industry. For more information on the planning application, please see the SAP Library under Business Planning and Simulation -> Planning Applications -> Customer Relationship Analytics -> Sales and Promotion Planning for the Consumer Products Industry.

You train the valuation functions first on historical data, then apply them to other datasets within the context of a prediction. In this way, you can determine what influence the category, tactic, and price reduction have on the uplift factor. You can then apply the trained function to a potential category, tactic, and price reduction to calculate possible uplift factors.

Model Fields

Info Object

Description

Key Field

Prediction Field

0CRM_MKTELM

CRM Marketing element

X

  

0CRM_PROD

Product

X

  

0CRM_TACTIC

Tactic

    

0PRICE_RED

Price Reduction

    

0PR_CAT_SAL

Category

    

0UPLI_FCT

Uplift factor

  

X

Since the model field Price Reduction should be filled with a calculated key figure from the query Trade Promotion: Scoring: Uplift Factor (Training) (0CP_SLSC6_Q0001), an InfoObject (0PRICE_RED) was used as a dummy when the model was created. The query field with the calculated key figure is assigned to the model field when the data source is defined.

Model Parameters

The minimum number of data records has been set to zero. Otherwise the standard settings have been retained.

Data Sources

Data Source Training: Trade Promotion: Scoring: Uplift Factor (Training) (0CP_SLSC6_Q0001)

Data source prediction: Trade Promotion: Scoring: Uplift Factor (Prediction) (0CP_SLSO1_Q0001)

Data Targets

Extraction: ODS object Promotion Knowledge Base Consolidation (0CP_SLSO1). The required DataSource is not delivered. Carry out the following steps to generate the DataSource and assign it to the InfoSource Promotion Knowledge Base Result 0CP_UPLI_RESU.

Generate and assign DataSource

  1. From the Data Mining Workbench screen, choose Data Mining ® Classification ® Scoring ® Trade Promotions: Scoring: Uplift Factor ® Data Source Prediction ® 0CP_UPLI_PRED.
  2. In the 0CP_UPLI_PRED context menu, choose Maintain Data Source.
  3. A dialog box appears in which you can set flags for individual options. To activate the requested options and generate the DataSource, choose Create.
  4. To assign the generated DataSource to the InfoSource Promotion Knowledge Base Result (0CP_UPLI_RESU), choose Source Systems from the Administrator Workbench: Modelling screen. Choose Replicate DataSources in the context menu of the system in which you are working.
  5. From the Administrator Workbench: Modelling screen, choose InfoSources. Then choose Assign DataSource in the context menu of the InfoSource Promotion Knowledge Base Result.
  6. The Transaction Data InfoSource: Assign Source System screen appears. Enter the system in which you are currently working as the source system, and choose Continue.
  7. The Available DataSources screen appears. Choose the DataSource you generated in step 3 and confirm your selection.
  8. The Change InfoSource 0CP_UPLI_RESU screen appears. Make the following assignment on this screen:
    1. Assign the InfoObject 0DM_EXDATE the DataSource field DATEFROM.
    2. Assign the InfoObject 0UPLI_FCT the DataSource field SCORE.
  9. Choose This graphic is explained in the accompanying text Save, then choose This graphic is explained in the accompanying text Save active.
End of Content Area