Need Help with Timeseries

Question

Hi,

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

PurchaseDate

CustomerID

PurchasedItem

Amount

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?