dbTalk Databases Forums  

User Defined Functions - where to register?

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


Discuss User Defined Functions - where to register? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
 
Posts: n/a

Default User Defined Functions - where to register? - 04-01-2005 , 04:16 PM






Hello,

If I want to use a user defined function inside an MDX statement - does the
dll that contain the function have to be registered on the analysis server,
on the client or both?

Thanks.



Reply With Quote
  #2  
Old   
Tom McLeod
 
Posts: n/a

Default Re: User Defined Functions - where to register? - 04-02-2005 , 08:27 PM






As best I understand it, since the UDF is executed server-side, the dll
would be registered on the analysis server machine only. The clearest
explanation I've seen is on the first two links under "Dimension
Security" on Mosha's page here:

http://www.mosha.com/msolap/security.htm

-Tom McLeod

Howwy wrote:
Quote:
Hello,

If I want to use a user defined function inside an MDX statement -
does the
dll that contain the function have to be registered on the analysis
server,
on the client or both?

Thanks.


Reply With Quote
  #3  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: User Defined Functions - where to register? - 04-05-2005 , 12:53 AM



That is true for UDFs used as part of dimension security. They must be
registered on the server.
For UDFs called as part of a query, those must be defined on the client.
--
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.

"Tom McLeod" <tmcleod3 (AT) gmail (DOT) com> wrote

Quote:
As best I understand it, since the UDF is executed server-side, the dll
would be registered on the analysis server machine only. The clearest
explanation I've seen is on the first two links under "Dimension
Security" on Mosha's page here:

http://www.mosha.com/msolap/security.htm

-Tom McLeod

Howwy wrote:
Hello,

If I want to use a user defined function inside an MDX statement -
does the
dll that contain the function have to be registered on the analysis
server,
on the client or both?

Thanks.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.