How do you populate a .net drop down list using MDX?

I'm looking to build a web application using an SSAS cube as the data platform.

As such, I would like开发者_StackOverflow to list the dimensions in drop down lists. For example, I have a dimension called Dim Company.

How do I populate the drop down list with these individual companies?

Any examples or pointers greatly appreciated.

---

ADOMD allows you to query the cube's structure as well as the data. You don't need any MDX; you can get it to list the dimensions on a certain cube, or list the members in a certain level of a certain dimension. Here's a very old ASP example:

Set oCat = Server.CreateObject("ADOMD.Catalog")
Set oCat.ActiveConnection = oCon
Set oDim = oCat.CubeDefs("CubeName").Dimensions("DimName")
Set oMembers = oDim.Hierarchies(0).Levels(2).Members
'then loop oMembers and get their .Caption property

If you do know MDX, you can write a query to list the members you want, without returning any data, and just use part of the results to populate the dropdown. For example:

SELECT {[Location].[All Location].children} ON ROWS, 
{} ON COUMNS 
FROM [CubeName]

You could even issue this from SQL using OPENROWSET if you want to.

---

You can also have a look at CellSetGrid source code.

CellSetGrid is an Open Source ASP .Net (c#) control, which offers pivot table like functionality for SSAS Cubes.

[This used to be available for download in this site: www.SQLServerAnalysisServices.com Now the site does not host this control anymore]

So I have uploaded the source of the control - CellSetGrid here.

http://www.box.net/shared/6gi0n79q6t