how to call a UDF in an Action defined at the server level?

#1

Hi,

I've created a custom VB.Net DLL which provide some custom functions.
These functions will be used to generate URL and HTML content for my actions
in my cubes.

How to load my library at the server side?
I can't execute "USE Library" before executing any MDX command, so my
library MUST be loaded by my server "at startup".

How to do this?

I've trie to create an action which is set to "On open" invocation which
execute the USE Library statement (action type=Instruction), but nothing
changes.

I've setup my DLL has this:
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

thanks for your help.

Jerome.

#2

one point: my function works fine under the MDX Sample aplication...
so my DLL works fine...

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

Quote:

Hi,

I've created a custom VB.Net DLL which provide some custom functions.
These functions will be used to generate URL and HTML content for my
actions in my cubes.

How to load my library at the server side?
I can't execute "USE Library" before executing any MDX command, so my
library MUST be loaded by my server "at startup".

How to do this?

I've trie to create an action which is set to "On open" invocation which
execute the USE Library statement (action type=Instruction), but nothing
changes.

I've setup my DLL has this:
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

thanks for your help.

Jerome.

#3

Bring up the cube in the cube editor.
Add a calculated measure. Register the UDF in the calculated measure wizard.
Cancel out of the calculated measure wizard, but save the cube.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

Quote:

Hi,

I've created a custom VB.Net DLL which provide some custom functions.
These functions will be used to generate URL and HTML content for my
actions
in my cubes.

How to load my library at the server side?
I can't execute "USE Library" before executing any MDX command, so my
library MUST be loaded by my server "at startup".

How to do this?

I've trie to create an action which is set to "On open" invocation which
execute the USE Library statement (action type=Instruction), but nothing
changes.

I've setup my DLL has this:
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

thanks for your help.

Jerome.

#4

when I try to register my DLL through the "register" button, I get an error
Unable to add library reference
E:\SampleLibrary\bin\Debug\SampleLibrary.tlb.
The operation has failed because of an error in the COM component -
unknown error The system cannot find the file specified.

I've followed some google's article and other article on the web to create
my component.
and the component works fine using the MDX sample application.

any idea?

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> a écrit dans le
message de news: OR4wYmL3EHA.1152 (AT) TK2MSFTNGP14 (DOT) phx.gbl...

Quote:

Bring up the cube in the cube editor.
Add a calculated measure. Register the UDF in the calculated measure
wizard.
Cancel out of the calculated measure wizard, but save the cube.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no
rights.

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote in message
news:O69rfJL3EHA.936 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Hi,

I've created a custom VB.Net DLL which provide some custom functions.
These functions will be used to generate URL and HTML content for my
actions
in my cubes.

How to load my library at the server side?
I can't execute "USE Library" before executing any MDX command, so my
library MUST be loaded by my server "at startup".

How to do this?

I've trie to create an action which is set to "On open" invocation which
execute the USE Library statement (action type=Instruction), but nothing
changes.

I've setup my DLL has this:
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

thanks for your help.

Jerome.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

how to call a UDF in an Action defined at the server level?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

how to call a UDF in an Action defined at the server level? - 12-07-2004 , 05:15 PM

Re: how to call a UDF in an Action defined at the server level? - 12-07-2004 , 05:20 PM

Re: how to call a UDF in an Action defined at the server level? - 12-07-2004 , 06:05 PM

Re: how to call a UDF in an Action defined at the server level? - 12-07-2004 , 06:44 PM