(Observe the Rules)
(Sort on Lift and observe)
Save
a. Into the same directory as the spreadsheets
b. File Name: RULES_FROM_II.txt
Statistical Reports
a. Observe the calculations
Result:
The Rules are now ready to be loaded into SAP Hana for subsequent queries.
Loading Product Recommendation Rules into SAP HANA
Launch Excel
a. Open the previously created RULES_FROM_II.txt file
b. Save it as a CSV file: RULES_FROM_II.csv
Launch SAP HANA studio and logon to your SAP HANA instance
Go to the
Quick Launch
page for SAP HANA
Modeler
Truncate or Delete all rows in the SAP_RDS_PA_CRM.RULES_FROM_II table
Under
File
, select
Import
Choose Data from Local File and choose Next
Choose
Source File Browse
and select the RULES_FROM_II.csv file
Header Row = 1, Start Line = 3
Choose
Target Table Existing
Find SAP_RDS_PA_CRM.RULES_FROM_II
Choose
Next
To the right of
Proposed Table Structure
, select
Map 1 to 1
. Or, if using the existing table, drag the
Source Columns
to the
Target Columns
to complete the mapping
Next
Verify that the data lines up on the
Summary Screen
Finish
Expose the tables within SAP_RDS_PA_CRM
Open
Data Preview
of the RULES_FROM_II table
Verify that the data lines up and is correct
Result
: This set of
Product Recommendation Rules
has been loaded into a table in SAP HANA
Retrieving Product Recommendations
In the
Content
area of the SAP HANA studio:
a.
sap → rds-pan → crm → Calculation Views
b. Right-click CA_PREC_PROD
c. Select Data Preview
d. Enter a Product for P_PROD
Display the Raw Data
Up to two
Product Recommendations
will be made based upon the highest
Lift
factor calculated
in the
Rules.
Result
:
Product Recommendations
have been dynamically retrieved for a given
Product
.
