I have the following table:

Create table Sales (ID int not null, DateOfSale SmallDateTime not null,
CustomerID int not null, ProductID int not null)

Now I want to create a mining model that allows me to generate cross
sales suggestions to a customer.

How do I do this?

I create the mining model defining the sales table both as case and
nested table.

I use CustomerID as a key, and ProductID (in the nested table) as key,
input and prediction.

The model is created, but how can I afterward get for example the top 3
possibilities for a certain ID?

I found some DMX queries for that but they fail to work.


--
Thanks in advance,

Stijn Verrept.