From
Generation Options
, select
Decision
for the
Generation Options
Leave
Apply
as the
Mode
Select where the generated output is stored by making the following entries in the
Results Generated
by the Model
section:
a. Select
Database
b.
Browse
and populate the dialog box with your SAP HANA instance
c. Logon to the <DOMAIN USER> account.
d.
Browse Data
and in the resulting dialog box, select
SAP_RDS_PA_BANK.CUST_ATTRITION_RESULTS
The correct SAP_RDS_PA_BANK.CUST_ATTRITION_RESULTS table is all upper case
Select the
Apply
button to execute the
Model
Choose the
Delete
option for the
Update will attempt to merge the runs together
dialog box, to remove
output rows from the previous run. When the cycle is complete, SAP Predictive Analytics returns
statistical information available under the
Display
bar.
Result:
The predicted data is written back to the SAP HANA schema SAP_RDS_PA_BANK as a table
CUST_ATTRITION_RESULTS. To view the results in SAP Predictive Analytics, select the VW_
CUST_ATTRITION_RESULTS
View
, which joins the results with the original data.
Expert Analytics (using the second approach)
Training the Model
Select the LUMS for Banking_Customer_Attrition_Analysis - Train
a. Launch Expert Analytics in SAP Predictive Analytics. Open menu File and choose Import to
folder and import or if the LUMS file is already imported browse through the Documents list for
Banking_Customer_Attrition_Analysis - Train.lums file.
b. In the dialog box, enter the SAP HANA server details, your user name, and password
Verify the data
a. Choose
Prepare
panel to ensure that the data has loaded properly.
Switch to the
Predict
panel to view the predictive model
Adjust the
HANA C4.5 - 4 independent cols
Algorithm Component
a. Choose
Configure Settings
b. Select the
Properties/Output Information/Output Mode
to
Trend
c. Select
Properties/Column Selection/Features
for the independent columns (variables) for
analysis. By default, the following are enabled:
Average Tenure
Average Income
Average Savings Amt
Average Investment Amt
d. Choose
Properties/Column Selection/Target Variable
for the dependent column (variable) for
analysis. By default
Attrition
is enabled
e. Select
Advanced/Tree Pruning/Minimum Split
and enter the value
10.
f.
Select
Done
At this point, run the
Algorithm Component
(
Run Till Here
) before continuing the analysis. Choose
Yes
to switch to the
Results
view for verifying the execution results
Adjust the
HANA C4.5 - 3 independent cols
Algorithm Component
a. Choose
Configure Settings
b. Select
Properties/Output Information/Output Mode
to
Trend
