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()