Mining Model Predicts Same Set Of Products For All Cases

Hi

I have developed a product
basket mining model as follows



DSV



SELECT C.CustomerId,C.CustomerIdName,P.ProductId,P.ProductIdName

FROM Customer INNER
JOIN CustomerProduct

ON C.OpportunityId
= P.OpportunityId



Mining Structure



CREATE MINING MODEL ProductBasket

(

CustomerId
TEXT KEY,

CustomerIdName
PREDICT,

ProductId
PREDICT,

ProductRecommend
TABLE PREDICT

(


ProductId TEXT KEY


ProductIdName PREDICTONLY

)

)

USING Microsoft_Association_Rules







Prediction Query


Since I want the output in the following format



Product
ID
Items (nested Table)

Product
A
product B

Product C



Product
B
Product A

Product C





I have written the prediction query as follows



SELECT


t.[ProductId],


PredictAssociation([Association].[ ProductId],3)

From


[Association]

PREDICTION JOIN


OPENQUERY([Adventure Works Cycle MSCRM],


'SELECT DISTINCT

[ProductId]

FROM

(SELECT ProductId FROM ProductBase)
as [Product]

') AS t

ON



[Association].[Product Id] = t.[ProductId]




The model is predicting the
same set of products for every case. Even changes in the algorithm parameter
value do not have any impact on the result.

What is the reason for this and
how can u rectify it?