Jump to content
Software FX Community

ehuynh

Members
  • Posts

    4
  • Joined

  • Last visited

Posts posted by ehuynh

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

×
×
  • Create New...