SQL Server Performance

CLR UDT and BI

Discussion in 'SQL Server 2005 Analysis Services' started by stathis30_2000, Jun 9, 2007.

  1. stathis30_2000 New Member

    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
  2. satya Moderator

    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.
  3. satya Moderator

    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.
  4. stathis30_2000 New Member

    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 .
  5. satya Moderator

    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.

Share This Page