locked
Using Stored Procedures without registering dll to Server Assembly. RRS feed

  • Question

  • Hi,

    I wanted to know if its possible to implement a stored procedure in MSAS 2005 without registering the Stored Procedure on a server or on a database?

    I was able to do this in MSAS 2000 using custom UDFs and "USE LIBRARY" mdx functions.

    Thanks and Regards,
    Santosh.

    Tuesday, December 19, 2006 11:54 AM

Answers

  • No, I don't believe this is possible any more.

    The architecture of the 2000 and 2005 products are very different. In 2000 this was possible because a lot of the MDX code was executed on the client side, so you could take advantage of UDFs on the client machines. In 2005 all the MDX is evaluated on the server and only the result set is returned to the client.

    Tuesday, December 19, 2006 12:57 PM