How to used the OLAP Extension

[ehuynh]

I am new to the ChartFx OLAP and i'm trying to build an OLAP viewer where user can connect to the cube then select which dimensions and measures they wish to view. I looked at the quickstart guide which gave me the code below. However, I'm not sure how to set up the datasource (ds) to work. Any help would be appreciated.

connStr = "Provider=msolap; Data Source=**YourServerName**;Initial

Catalog=FoodMart 2000;"

ds = "SELECT {[store].[store Country].[uSA].Children} ON

COLUMNS,{CROSSJOIN(Descendants([Gender]),

Descendants([Time].[1997]))} ON ROWS From [sales]"

ADOMD1.Connect(connStr, ds)

Olap1.DataSource = ADOMD1

Chart1.Extensions.Add(Olap1)

Olap1.Refresh()

[ehuynh]

So I figured out how to use the OLAP wizard. My problem now is there a way of exposing the wizard in an application. i.e. Let the user chose the dimenions and measure at run time instead of writing a MDX query.

 Please and Thank you

[Frank]

We do not include an MDX creation UI for the end user.