sql server data mining: how to find version of the analysis services? -- sql server data mining

Re: how to find version of the analysis services?

light_wt
11/2/2007 11:09:01 AM

that is great.

is there a step by step guide on build and register the assembly? thanks.

[quoted text, click to view]

Re: how to find version of the analysis services?

Dejan Sarka
11/2/2007 11:44:50 AM

[quoted text, click to view]

I created myself a CLR procedure. Here is the main part you need:

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using AMO = Microsoft.AnalysisServices;
using ADOMD = Microsoft.AnalysisServices.AdomdServer;
namespace ServerProcs
{
public class ASProcs
{
public static string GetSrvVersion()
{
AMO.Server currSvr = new AMO.Server();
currSvr.CaptureXml = false;
currSvr.Connect("DataSource=" + ADOMD.Context.CurrentServerID + ";");
return currSvr.Version;
}
}
}

After you build and register the assebly, you can call this from DMX
language:

SELECT ServerProcs.GetSrvVersion()
FROM [Customer Clusters];

--
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/

Re: how to find version of the analysis services?

Dejan Sarka
11/3/2007 12:00:00 AM

[quoted text, click to view]

Yes - take a look at the "Creating Stored Procedures (Analysis Services)"
chapter in BOL (http://msdn2.microsoft.com/en-us/library/ms175340.aspx).

--
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server data mining group.