I am here going to demonstrate how to use Data Mining Model of SAP BW to operate Assocation Analysis.
In order to complete this tutorial, data source CSV file which contains relevant data is needed for data extraction. Also you can create your own like this:
Access the Data Mining Workbench. Use TCODE RSDMWB or Double Click Data Mining Model
The Data Mining Workbench screen appears as follows:
The workbench includes a list of Data Mining methods that can be used to analyze data, commonly stored in business applications.These methods include classification (decision trees), clustering, association analysis, approximation, and further analyses techniques such as ABC classification.
Phase 1 — Creating an Association Model
The Create Model dialog screen appears as follows:
2. Name Model and Description, select Radio button: Manul, and accept the entry.
The Create Model XXX screen will appear as follows:
You now need to select the fields (InfoObjects) needed for your model. The fields selected will need to match those identified in the data source file shoppingdataset.csv.
Notice that properties (data type and length) of the InfoObject are automatically populated. The Content Type option defines how each field is to be treated within the model. There are three possible options; transaction, item and transaction weight.
After completing this step the field assignment for the Association Model show appear as follows;
5. Click Parameters tab to set the following parameters.
Support can be used to help determine how useful a product association rule is.
Confidence (or predictability) measures how dependent a particular item.
Lift helps to identify and eliminate rules that are only generated because some of the items naturally occur very frequently, although there is no actual association between the set of leading and depending items.
The Association Model uses Leading and Dependent items. If a leading item has been purchased, what is the likelihood the following dependent items is also purchased. If a customer purchases milk (leading item) what is the likelihood they will also purchase bread (dependent item). The relationship between leading and dependent items is not limited to one to one. The parameter Leading Depth can be set to identify the number of products to be considered together as leading items and the parameter Dependent Depth can be used to set the number of dependent items to be considered in the model’s analysis.
Leading Items Dependent Items
milk, spread bread
6. Put value in the Maximum Leading Depth field, Tand in the Maximum Dependent Depth field.
A message appears in the Status Bar.
Next, I am going to use SAP GUI and run Phase 2 & 3 — Training and Execution of the Assocation Model :
Thanks, I hope you enjoy it !