Get Analysis Services Version string in c#.net 2.0

Hi

I want to get the version string for AS 2000 and 2005 in c#. Can I use the same object model to connect to both or do I need one for each. I saw a reference to DSO 8.5 which implied you could.

Either way could you let me know what DDL I should reference in Visual Studio.

Thanks

Steve

If you are using Microsoft.AnalysisServices.AdomdClient then you can use AdomdConnection.ServerVersion property to obtain textual representation of the version. If you use System.Runtime.InteropServices.Version object then you can construct one to parse such things like major and minor numbers.

It works for AS2005 and AS2000.|||Works a treat Andrew thanks

genetics data as cubes

Dear all,

Has anyone used Analysis Services on Genetics Data? I would like to communicate with someone who is implementing or has implemented analysis services on this kind of data.

Thanks

Ashish

I recently worked on a project to take BLASTN and TBLASTN results and record HSP results into an OLAP cube for further analysis. It was kind of fun but it's utility is dependent upon what kind of information you can gather on the dimensions.|||

Dave,

Have you worked with designing cubes for genetic data mining?

Thx

|||No. Sorry.sql

genetics data as cubes

Dear all,

Has anyone used Analysis Services on Genetics Data? I would like to communicate with someone who is implementing or has implemented analysis services on this kind of data.

Thanks

Ashish

I recently worked on a project to take BLASTN and TBLASTN results and record HSP results into an OLAP cube for further analysis. It was kind of fun but it's utility is dependent upon what kind of information you can gather on the dimensions.|||

Dave,

Have you worked with designing cubes for genetic data mining?

Thx

|||No. Sorry.

genetics data as cubes

Dear all,

Has anyone used Analysis Services on Genetics Data? I would like to communicate with someone who is implementing or has implemented analysis services on this kind of data.

Thanks

Ashish

I recently worked on a project to take BLASTN and TBLASTN results and record HSP results into an OLAP cube for further analysis. It was kind of fun but it's utility is dependent upon what kind of information you can gather on the dimensions.|||

Dave,

Have you worked with designing cubes for genetic data mining?

Thx

|||No. Sorry.

Generate report that link to analysis services

Is there any samples to download that show how to create matrix report that
link to microsoft sql server 2000 analysis services? I understand that user
can use the mdx query (Analysis Services) to generate a report..But is there
an easy way just link to datasource (cube) that is created in analysis
services (same as table)? For example, I have create a cube name sales in
the analysis services and i try to create report by using the report wizard,
build a query at reporting services by using sql statement "select * from
sales"... It give me a funny field name which are found at report wizard
(under Design the table stage).
Thank You.The current release of SQL Server Reporting Services 2000 allows you to
execute MDX queries against Analysis Services cubes. A very good MSDN
article with samples about the integration of RS 2000 and AS 2000 is
provided at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
A graphical query designer for creating MDX queries will be available in the
RS 2005 release.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"alvin" <alvinleo@.time.net.my> wrote in message
news:uxvnmp1XEHA.2940@.TK2MSFTNGP09.phx.gbl...
> Is there any samples to download that show how to create matrix report
that
> link to microsoft sql server 2000 analysis services? I understand that
user
> can use the mdx query (Analysis Services) to generate a report..But is
there
> an easy way just link to datasource (cube) that is created in analysis
> services (same as table)? For example, I have create a cube name sales in
> the analysis services and i try to create report by using the report
wizard,
> build a query at reporting services by using sql statement "select * from
> sales"... It give me a funny field name which are found at report wizard
> (under Design the table stage).
> Thank You.
>