Calling .Net assemblies (AS SProcs) from Calculated Measure MDX

Hi,

Okay I am desperately stuck again. This topic gives a lot of search results but none seem to help me. I have a .Net assembly (class library) that I have registered in Analysis Server 2005. I can now see it in the Assemblies Folder of SSAS.

I want to call a method in this assembly in the MDX expression of a calculated measure in my cube!

Is this possible?

I checked this article from microsoft:

http://msdn2.microsoft.com/en-us/library/ms176113.aspx

but it does not work. It gives me an error saying that the function does not exists.

Please do guide me or give me steps to do the same. If this is not possible how else can i compliement .NET functions in my calculted measure's MDX expression.

Regards

Vijay R

Hi Vijay,

The source code for the Analysis Services Stored Procedure project includes a complete set of MDX queries showing how to call sprocs:

http://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=ASStoredProcedures

So it is possible to do what you want to do!

HTH,

Chris