SQL Server Performance

data mining

Discussion in 'Analysis Services/Data Warehousing' started by Ophélie, Jul 5, 2005.

  1. Ophélie New Member

    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
  2. ranjitjain New Member

    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.
  3. Ophélie New Member

    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.

Share This Page