Trouble creating Sequence Clustering sample model
Hi group,
While playing around with the MSAS tool, i have tried creating the
sequence cluster sample in 'Adventure Works DW' as suggested in the
tutorial.
Though i followed the steps given in the tutorial, I could not create the model. Deploying the model fails with an error saying "key is not defined"!
Can some one tell me what I can do to avoid that?
thanks in advance for your help.
[428 byte] By [
-pk] at [2008-2-26]
[copying my response from the other thread]
The Microsoft_Sequence_Clustering algorithm requires the sequence
information to be modeled as a nested table so you can only have a nested table column with Content=Key Sequence (right-click on the column in the Mining Structure tab and look at the Properties pane).In the above case, you will have a case level key that uniquely identifies a sequence set (modelled as multiple nested table rows) and you'll need to mark that with Content=Key and IsKey=True.
