I am trying to deploy my assembly. I have followed the example that
Mosha has posted at
http://sqljunkies.com/WebLog/mosha/a...x_ranking.aspx
and create a simple test function.

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.AnalysisServices.AdomdServer;

namespace SqlTestAssembly
{
public class MyClass
{
public static int myValue()
{
return 5;
}
}
}



Next I deployed the compiled dll to the Server and the Database using
the Register Assembly Pages.

Next I add my dll to the GAC.

When I run "select SqlTestAssembly.MyClass.myValue() on 0 from
[Adventure Works]"

I get the error

Executing the query ...
Query (1, 9) The '[SqlTestAssembly].[MyClass].[myValue]' function does
not exist.
Execution complete

Any Ideas?

prefix the function call:
select [Name of the assembly].SqlTestAssembly.MyClass.myValue() on 0 from
[Adventure Works]

[Name of the assembly] is the name assigned to the assembly into AS
(when you insert a new assembly, you have to provide a name.)

So, if you publish 2 times the same assembly using 2 different names, you
can access each one separatly:
select [Name of the assembly1].SqlTestAssembly.MyClass.myValue() on 0 from
[Adventure Works]
select [Name of the assembly2].SqlTestAssembly.MyClass.myValue() on 0 from
[Adventure Works]



"MikeP" <MPeverill (AT) gmail (DOT) com> wrote

Jeje is right. It is the name that you give to the assembly when you
deploy it that is important. From the testing I have done the only other
syntax that appears to work is:

[Name of the assembly].myValue()

BOL says that you can call an AS Stored Proc just using the function
name, but this appears to be incorrect (I have sent BOL feedback on
this)

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <uBOcx1spGHA.4960 (AT) TK2MSFTNGP04 (DOT) phx.gbl>, willgart (AT) hotmail (DOT) com
says...