Microsoft Analysis Server 2005 and .NET 1.1

Hi,

Firstly, I had to post this query here since I did not find any other place relating to Microsoft SQL Analysis Server 2005 and that it is related to SQL server 2005.

I am using Microsoft SQL analysis server 2005 and .NET 1.1 for Asp.NET (C#)

I need to programmatically create Measures, Dimensions and Cubes using .Net 1.1 (C#) in an Asp.NET page, and then I need to access the measures, dimensions and cubes again from another Asp.Net page.

My querys are:

1. To create and manipulate the SQL Analysis server objects like Dimensions, Cubes what should I use? The documentation for Analysis server 2005 says we can use (Analysis Management Objects)AMO. but I am not sure if we can use it with .NET 1.1?

2. If AMO is possible, then what to use? There is one more technology we can use called as (Deciscion Suport Objects) DSO. but they are COM based and were for Analysis services 2000.

3. To query the data, what technology can I use? Microsoft says we can use ADOMD.NET. Microsoft also gives many other technologies that I think do similar work, like XMLA, ASSL.

Can somebody help me in this.

Also please do give me some links that have code samples for the same.

Thanks and Regards

Vijay R

Analysis service in SQL Server 2005 is on the calculus end of the relational model and Microsoft is compliant with all the Calculus algorithms. When I tested SQL Server 2005 in beta 2 there is a management studio for Analysis service if you don't have it installed I suggest you do so because you can get sample ADOMD.NET code from the templates. I dont think you can use DSO(decision support object) with your web application because your database must be Denormalized and the tables read only which was required in SQL Server 2000 because Microsoft had only two Calculus algorithms and one was flawed.

But SQL Server 2005 comes with something that let you strip the algebra and move to Calculus in one step called UDM(unified dimension modeling).
Try the links below for more info and the last link is the site of the person who created the Calculus end of the relational model. Hope this helps.

http://www.microsoft.com/sql/solutions/bi/default.mspx

http://www.mosha.com/msolap/yukon.htm

http://www.rkimball.com/