User Defined Functions on the server

[Shab]

I have a dll file that I generated using VB 6.0. It has a user defined function in it. One I register the dll on my computer I can use the "USE LIBRARY <file Path> command in MDX Sample App to register it for the session and I can use the functions in the file in my MDX.

Is there a way that I can add this library to the server so that I can use the function in the calculated members in the cubes?

I tried registering it by pushing the resgister button in "Calculated Member" designer however I get an error saying there are no libraries in the file.

Any ideas?

Shabnam

 

[MDXer]

if you or anyone else figures this one out you'll get a big star from me as I haven't gotten this to work either.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[Shab]

I know it seems to be tough if not impossible. This article makes it sound like it is possible:

http://www.windowsitpro.com/SQLServer/Article/ArticleID/6115/6115.html

But of course it didn't work.

Thanks for the reply anyways.