data mining | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

data mining

I’ve defined a cube and now I would like to apply a mining model to it, but I don’t find where I can define a training sample on which the model will be constructed and the test sample.(the only thing I’ve seen is to slice the cube but it’s not exactly what I want) Another thing, is it possible to copy the relational diagramm of the cube? Thank you for your help.
Ophélie
To define mining model, i feel you can right click your cube in analysis manager
and select new mining model and in that after selecting mining technique screen appears to select training data.
thank you for your response but I don’t understand….[:I]
When I right click on new mining structure (in Microsoft Visual Studio 2005), a wizard appears then I have to choose the algorithm, the source cube dimension,the case key, the case level columns, specify mining model column usage (and add nested tables),specify columns’content and data type, slice source cube (which is not exactly what I want because i want to select randomly a part of the cube to be my training data and the rest to be my testing data),then completing the wizard by giving the name I want to the structure and the model. So I don’t know where I can define my testing and training data…
quote:Originally posted by ranjitjain To define mining model, i feel you can right click your cube in analysis manager
and select new mining model and in that after selecting mining technique screen appears to select training data.

]]>