Who to make a DLL in Visual Basic.Net to use as a User
Defined Function. (UDF)?

I create a new Class Library project and then a new Com
Class and put a function inside, compile the project and
when I try to register in OLAP the following error occurs:
Unable to add library reference xxxxxxxxx the file
contains no libraries.

I did it with Visual Basic 6.0 successfully but now I want
to use VB.Net 2003

Were you registering the dll with Analysis Manager? If so, this is a known
bug about failing to register UDF (in VS.Net) by Analysis Manager.

Here is the workaround you can try:
(1) Write a function with <ComClass> attribute
(2) Build with "Register for COM Interop"
(3) If move the dll/tlb from one machine to another, use RegAsm to register
the dll at new location.
Example C:\> regasm g:\udftest\classlibr ary1.dll
/tlb:g:\udftest\classlibrary.tlb /codebase
(4) With MDX Sample Application:
USE LIBRARY "D:\share\ClassLibrary1\ClassLibrary1\bin\ClassLib rary1.tlb"

Thanks

Wei Zhang
Microsoft OLAP PSS
This posting is provided "AS IS" with no warranties, and confers no rights.