how to find version of the analysis services?

[light_wt]

i know how to find the database version liked using tsql

select serverproperty('ProductVersion')
or
select @@version

how can i find the version of the cube or the analysis services? thanks.

[Dejan Sarka]

Post by light_wt
i know how to find the database version liked using tsql
select serverproperty('ProductVersion')
or
how can i find the version of the cube or the analysis services? thanks.

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];

[light_wt]

that is great.

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

Post by Dejan Sarka

Post by light_wt
i know how to find the database version liked using tsql
select serverproperty('ProductVersion')
or
how can i find the version of the cube or the analysis services? thanks.

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
SELECT ServerProcs.GetSrvVersion()
FROM [Customer Clusters];
--
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/

[Dejan Sarka]

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

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

[light_wt]

thanks,

i'll try it. :)