on 08-30-2016 6:54 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.