Data mining & CLR UDTs

[Efstathios Mantadakis]

Hello,

I would like to ask if it possible to perform data mining on Clr Udt data. If the answer is yes please give me some more information because it is urgent for my project.

Thank you,
ST

[Dejan Sarka]

Post by Efstathios Mantadakis
I would like to ask if it possible to perform data mining on Clr Udt data.
If the answer is yes please give me some more information because it is
urgent for my project.

I do not think you can use an UDT directly in a mining structure. You can
create a named query in your data source view and refer to UDT properties
and methods that return scalar values from the column of the UDT type, like
SELECT MyUDTcol.Property1, MyUDTcol.Property2...
You can also use the default ToString method, if it returns string that
makes sense for your mining model. If you refer to UDT directly, without an
explicit property, like
SELECT MyUDTcol,
SQL Servr returns binary string (the serialized UDT), and I do not think
SSAS can cast it to UDT, as it does not have access to the code of the UDT.