publishing cubes with udfs   

hello I have a few questions:

1. am i right in thinking that using as 2000 and adomd i have to
register udf dll on all of my client machines?  Is there no way around
this?

2. if i use xmla and a cube on a web server, do my client apps need to
have udf dlls installed?

3. in xmla can i use xsl natively to generate docs (pdf? svg?)

also how would this work on sql server 2005?

4. can i write udf dlls in .net (vs 2005) for as 2000 yet? (i don't
think so)

thanks in advance, toby

date: 28 Aug 2005 09:37:14 -0700   author:   toby

Re: publishing cubes with udfs   

1. Yes

2. No, the XMLA SDK will be loading PTS and the UDFs. Although I believe we
disallow unsafe UDFs for the middle tier, so you may find that this will
also not work...

3. XMLA is not a platform for hosting xsl -- but your client application can
use any code to manipulate the XML returned by the provider

4. No, AS2000 does not support .NET UDFs.

Thanks,
Akshai

-- 
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"toby"  wrote in message
news:1125247034.305763.121350@g14g2000cwa.googlegroups.com...
> hello I have a few questions:
>
> 1. am i right in thinking that using as 2000 and adomd i have to
> register udf dll on all of my client machines?  Is there no way around
> this?
>
> 2. if i use xmla and a cube on a web server, do my client apps need to
> have udf dlls installed?
>
> 3. in xmla can i use xsl natively to generate docs (pdf? svg?)
>
> also how would this work on sql server 2005?
>
> 4. can i write udf dlls in .net (vs 2005) for as 2000 yet? (i don't
> think so)
>
> thanks in advance, toby
>

date: Mon, 29 Aug 2005 18:12:40 -0700   author:   Akshai Mirchandani [MS]

Re: publishing cubes with udfs   

Hi There - thanks very much for your reply - of course i now have some
follow-up questions...:-)

1. ok

2. No, the XMLA SDK will be loading PTS and the UDFs. Although I
believe we
disallow unsafe UDFs for the middle tier, so you may find that this
will
also not work...

PTS? not sure what you  mean, also can I register my dll's as safe?  -
basically i want to put my cubes on a web server and serve calculated
data as xml (or html or something) to the clients - how do I do this???
 The environment is all microsoft and it is my server.

3. ok

To me this doesn't sound unreasonalbe?

4. No, AS2000 does not support .NET UDFs.

Can i not write a COM object in c# and use that?

I am right at the design stage and am very open to your suggestions - I
am very grateful for your help, thanks, toby

date: 5 Sep 2005 03:19:01 -0700   author:   toby

Re: publishing cubes with udfs   

PTS is the OLE DB for OLAP provider (aka Pivot Table Service or PTS). In AS
2000, a lot of the work is actually done by this component on the client
side. Therefore it is the component that actually loads and executes UDFs.

In AS 2000 only a few COM libraries are considered "safe", for example the
VBA library. But custom libraries are considered unsafe. You can implement
the IObjectSafety interface to mark your custom library as safe (see
articles http://support.microsoft.com/kb/q182598/ and
http://msdn.microsoft.com/library/default.asp?url=/workshop/components/com/reference/ifaces/iobjectsafety/iobjectsafety.asp
and others on the topic).

In AS 2005, the architecture has changed. Firstly, the COM libraries are
only needed on the server and PTS does not need access to them. Secondly,
you will deploy assemblies (COM libraries) to the server and can mark them
additionally as safe or unsafe.

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"toby"  wrote in message
news:1125915541.443858.144100@z14g2000cwz.googlegroups.com...
> Hi There - thanks very much for your reply - of course i now have some
> follow-up questions...:-)
>
> 1. ok
>
> 2. No, the XMLA SDK will be loading PTS and the UDFs. Although I
> believe we
> disallow unsafe UDFs for the middle tier, so you may find that this
> will
> also not work...
>
> PTS? not sure what you  mean, also can I register my dll's as safe?  -
> basically i want to put my cubes on a web server and serve calculated
> data as xml (or html or something) to the clients - how do I do this???
>  The environment is all microsoft and it is my server.
>
> 3. ok
>
> To me this doesn't sound unreasonalbe?
>
> 4. No, AS2000 does not support .NET UDFs.
>
> Can i not write a COM object in c# and use that?
>
> I am right at the design stage and am very open to your suggestions - I
> am very grateful for your help, thanks, toby
>

date: Wed, 7 Sep 2005 12:09:37 -0700   author:   Akshai Mirchandani [MS]