Skip to Content
avatar image
Former Member

Creating association rules reference data set

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 07, 2016 at 02:17 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 07, 2016 at 01:27 PM

    Including Former Member @Marc DANIAU for comments.

    Thanks,

    Debraj

    Add comment
    10|10000 characters needed characters exceeded