Home > Archive > MS SQL Server OLAP > December 2005 > user defined function doesn't work -- please help!









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author user defined function doesn't work -- please help!
charles

2005-12-22, 8:25 pm

Hi all,

I start to try define one user defined function called CumROR using C#
as follows:


namespace APA
{
public class APA
{
public Double CumROR()
{
return 100;
}
}
}


Then add it into assembly in server. try MDX get following message

The '[APA].[APA].[CumROR]' function does not exist.

Can any expert let me know what step I missed? I've used user defined
function in AS2K without any problem.


Charles

Jéjé

2005-12-23, 3:24 am

do you use AS2000 or 2005?

"charles" <CharlesYY@gmail.com> wrote in message
news:1135301618.054693.141910@g43g2000cwa.googlegroups.com...
> Hi all,
>
> I start to try define one user defined function called CumROR using C#
> as follows:
>
>
> namespace APA
> {
> public class APA
> {
> public Double CumROR()
> {
> return 100;
> }
> }
> }
>
>
> Then add it into assembly in server. try MDX get following message
>
> The '[APA].[APA].[CumROR]' function does not exist.
>
> Can any expert let me know what step I missed? I've used user defined
> function in AS2K without any problem.
>
>
> Charles
>



charles

2005-12-23, 3:24 am

AS2005!

J=E9j=E9 wrote:[color=darkred
]
> do you use AS2000 or 2005?
>
> "charles" <CharlesYY@gmail.com> wrote in message
> news:1135301618.054693.141910@g43g2000cwa.googlegroups.com...

Jéjé

2005-12-23, 3:24 am

have you try to call the procedure like:
<name>.[APA].[APA].[CumROR]

where <name> is the name (or alias) of the assembly on the server.
When you deploy the assembly on the server a name is asked, try to put this
name in front of the namespace.
because the same namespace can be found in 2 different assemblies, this name
allow you to sepcify which one you want to access.

"charles" <CharlesYY@gmail.com> wrote in message
news:1135311323.643090.164600@o13g2000cwo.googlegroups.com...
AS2005!

Jéjé wrote:[color=darkred
]
> do you use AS2000 or 2005?
>
> "charles" <CharlesYY@gmail.com> wrote in message
> news:1135301618.054693.141910@g43g2000cwa.googlegroups.com...


charles

2005-12-23, 3:24 am

Thank you very much for your help, It works! Merry Xmas and happy new
year!

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com