I'm new to the SQL server data mining and analysis services. I've been trying to create a mining model to predict customer-wise purchases patterns using SQL server analysis services Time series. In my
Purchases table I have columns
PurchaseID as primary Key
When I create a time series model using SQL server analysis services 2012 using
purchaseID and CustomerID as keys and PurchasedItem
as the Input and Prediction .
But Im not getting separate time series for each customer.
Is there any way of doing this with my existing table structure?
Do I need to have separate columns in my table for each of the customers purchases?