Wednesday, March 7, 2012

Regressor Flag

I am trying to build a decision tree algorithm with multiple regressors. I am having trouble changing the properties for the input variables to regressors (the only multiple flag choice is "not null"). I created a mining model using the DMX query thinking I could change the code to include multiple regressors, however I get a syntax error when trying to execute the model. Also, I am wondering if you can view the dmx code for a model built using the mining wizard.

My query is as follows:

CREATE MINING MODEL BVRSlotq1052

(Machine Long Key,

[Banksize] LONG CONTINUOUS REGRESSOR ,

[Cabinet] Text Discrete,

[CUID] Long Continuous PREDICT_ONLY,

[Denom] Text Discrete,

[Gametype] Text Discrete,

[Max Coins] Text Discrete,

[Par] Long Continuous,

[Pos] Text Discrete,

[Progressive] Text Discrete,

[Type]Text Discrete)

Using Microsoft_Decision_Trees

You need to change the one line to

[Banksize] LONG REGRESSOR CONTINUOUS ,

That is, putting REGRESSOR before CONTINUOUS.

The following tip shows a sproc for generating a CREATE MINING MODEL statement from a server model
http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/3352.aspx

This tip shows a sproc for generating CREATE MINING STRUCTURE and ALTER statements for server structures
http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/3652.aspx

|||thanks!

No comments:

Post a Comment