Problems with input columns for mining models

Hi, all experts here,

Thank you very much for your kind attention.

I got a strange problem with SQL Server 2005 data mining models though. I have selected the input columns for my mining model (which are different from the input columns for its mining structure, since I ignored some of the columns for the selected model). But the mining model still used all input columns from the mining structure rather than those I chose for the mining model.

Would please any one here give me any guidance and advices for that. Really need help for that.

Thanks a lot in advance for any help.

With best regards,

Yours sincerely,

Are the remaining columns marked as Ignore in the designer, and yet used in the model? Is it possible that the model was not re-deployed? Or the viewer was not refreshed?|||

Hi, bogdan, thank you very much for your advices. Yes, I have marked those remaining columns as ignored and the whole mining structure and the mining models are redeployed and processed. I really find it strange as this problem did not occur before when I processed the mining models in this way. Really need help and further guidance for that.

Thanks a lot.

With best regards,

Yours sincerely,

|||

Hi, Bogdan thank you very much, have got it done. But as the same way though, but it is working now.

Thank you very much.

With best regards,

Yours sincerely,

|||You can use this tip http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/3652.aspx to inspect the structure and models to ensure that they are as you expect them to be.|||

Hi, Jamie, thank you very much for your advanced guidance. That's very helpful in a way.

With best regards,

Yours sincerely,