SQL Server Performance Forum – Threads Archive

CLR UDT and BI

Hi all, I am new to analysis services and I have a question. Can I use a udt written in .NET with olap and data mining? When designing the cube will I have access to the methods of my object? I will probably need to define some custom measures. Has anyone worked with OLAP and udt? I need some advice on that.. Thank you ,
ST

Yes you can achieve that, as CLR UDT is implemented as a class in a .NET Framework assembly. Identify a CLR UDT by annotating the class that implements the UDT with the SqlUserDefinedType attribute, which indicates that a class should be registered as a UDT. For more information refer to the Programming SQL 2005 book by Bill Hamilton. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Thank you very much for your reply ! I read some articles concerning CLR UTD that really put me off, but I must admit that until now they seem really convenient to me. I hope they will be convenient to the the bi part too. Thank you .

CLR UDT is more reliable or somewhat comfortable to use in BI (as I have seen). Take more from the book reeference above. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

]]>