Hi

I've written a COM component containing user defined functions for analysis
services. It works fine client-side, however I want to execute my queries
on the analysis services server using 'Execution Location=3' in the connection
string. However, it doesn't appear to be happening server-side and I'm trying
to understand why.

1). Is it possible to use UDFs server-side?
2). If so, is it possible to specify calculated members in the MDX (using
'with member') that reference UDFs and have them execute server-side. I
need to do this since I want to be able to supply extra params to the udf
function when I build the MDX query.

Any help would be appreciated!

Thanks

Will Muldrew

If I understand what you're saying correctly I think you'll find you
have to register your component on the server and the client if you
want a client to be able to use it and have calc members referring to
it.

Try that and see you you get the result you're after, I'm not sure but
I don't think execution location is rellevant with UDFs.

Steve

Hello Steve,

We've been happily using our UDF registered only on the client side (excel)
without having it on the server, but I'd like it only to have to be on the
server so I can avoid having to deploy it to all the client machines. I'd
like to be sure that this is possible before I try it because it would involve
porting the UDF lib to 64bit which is particularly involved since it's written
in C++ with ATL7.

Will