cancel
Showing results for 
Search instead for 
Did you mean: 

Creating association rules reference data set

Former Member
0 Kudos

I have a table of customer transactions that I would like to use to generate association rules.  The table is stored in HANA (SPS 11) as a column table and contains columns for the transaction number (TRANSNUMBER) and item purchased (UPC).  I understand that this table will be used as the events/transactions data set.  What is the best way to use this table to create the reference data set?  I tried using PA's toolkit (Predictive Analytics 3.0 client/server) to extract the unique values, but for my table (30K rows), the extraction took 17 minutes.  I thought about using a HANA view, but only see ways to count distinct values, but not to return them.  Thank you for your help.

Accepted Solutions (1)

Accepted Solutions (1)

marc_daniau
Advisor
Advisor
0 Kudos

The answer may come too late but one option is to run the following on HANA:

create view CUSTOMERS_V as ( select distinct CUSTOMER_ID from TRANSACTIONS ) ;

And use CUSTOMERS_V as the reference table in SAP Predictive Analytics.

Answers (1)

Answers (1)

former_member192417
Active Participant
0 Kudos

Including for comments.

Thanks,

Debraj