Can I modify my input data set in using DMX in mining structure?

Hi, all here,

I have a questioin-is it possible to modify input data set in mining structure using DMX?

Also, what else SQL systax staments are supported in DMX besides SELECT statement?

Thanks a lot in advance for any help.

You can have calculated expressions in the input query for prediction and training (if you're using DMX INSERT-INTO). Also, you can modify the input data set by introducing named calculations in the data source view used by a mining structure. Is this what you're looking to do?

DMX supports a very limited form of SQL for its SELECT statement. See http://msdn2.microsoft.com/en-us/library/ms132025(SQL.90).aspx for a full reference of DMX statements. Note that DMX is designed to be SQL-like, not SQL-compliant, meaning that the semantics of statements like INSERT differ somewhat from the corresponding relational SQL operations.