コード例 #1
0
        private void Page_Load(object sender, System.EventArgs e)
        {
            // Put user code to initialize the page here


            connStr = "Provider=msolap; Data Source=ntech32; Initial Catalog=FoodMart 2000;";

            //mdx = "with member [Measures].[Total Store Sales] as 'Sum(YTD(),[Measures].[Store Sales])'select ";
            //mdx += "{[Measures].[Total Store Sales]} on columns, {TopCount([Product].[Product Department].members,5, [Measures].[Total Store Sales])} on rows ";
            //mdx += "from Sales where ([Time].[1997].[Q2].[4])";


            mdx  = "select filter({{[Measures].[Ta Units]},{[Measures].[Ta wrkload]}},[Measures].[Ta Amount]>0 ";
            mdx += " and [Measures].[Ta Units]>0 ) on rows, ";
            mdx += "{filter(toggledrillstate({[AgeRange].[All AgeRange]}, ";
            mdx += "{[AgeRange].[All AgeRange]}),[Measures].[Ta Amount]>1000000 and [Measures].[Ta Units]>5000)} on columns ";
            mdx += " from [Claims cube]";

            Olap1  = new SoftwareFX.ChartFX.Olap.Server.OlapExtension();
            AdoMD1 = new SoftwareFX.ChartFX.Olap.Server.AdoMultiDimensionalData();
            AdoMD1.Connect(connStr, mdx);
            Olap1.DataSource = AdoMD1;

            Chart1.Extensions.Add(Olap1);

            //Must set MainClinet to False to use client events
            Chart1.MainClient = false;


            Chart1.HtmlTag = ".NET";
            Chart1.ToolBar = true;
        }
コード例 #2
0
ファイル: WebForm1.aspx.cs プロジェクト: rags/playground
 private void Page_Load(object sender, System.EventArgs e)
 {
     // Put user code to initialize the page here
     connStr = "Provider=msolap; Data Source=localhost; Initial Catalog=FoodMart 2000;";
       mdx = "select filter({{[Measures].[Ta Units]},{[Measures].[Ta Wrkload]}},[Measures].[Ta Amount]>1000000 and [Measures].[Ta Units]>5000 ) on rows," +
     "{filter(toggledrillstate({[AgeRange].[All AgeRange]},{[AgeRange].[All AgeRange]}),[Measures].[Ta Amount]>1000000 and [Measures].[Ta Units]>5000)} on columns" +
     " from [Claims cube]";
     Olap1 = new SoftwareFX.ChartFX.Olap.Server.OlapExtension();
     AdoMD1 = new SoftwareFX.ChartFX.Olap.Server.AdoMultiDimensionalData();
     AdoMD1.Connect(connStr, mdx);
     Olap1.DataSource = AdoMD1;
     Chart1.Extensions.Add(Olap1);
     //Must set MainClinet to False to use client events
     Chart1.MainClient = false;
     Chart1.HtmlTag = ".NET";
     Chart1.ToolBar = true;
 }
コード例 #3
0
 private void Page_Load(object sender, System.EventArgs e)
 {
     // Put user code to initialize the page here
     connStr = "Provider=msolap; Data Source=localhost; Initial Catalog=FoodMart 2000;";
     mdx     = "select filter({{[Measures].[Ta Units]},{[Measures].[Ta Wrkload]}},[Measures].[Ta Amount]>1000000 and [Measures].[Ta Units]>5000 ) on rows," +
               "{filter(toggledrillstate({[AgeRange].[All AgeRange]},{[AgeRange].[All AgeRange]}),[Measures].[Ta Amount]>1000000 and [Measures].[Ta Units]>5000)} on columns" +
               " from [Claims cube]";
     Olap1  = new SoftwareFX.ChartFX.Olap.Server.OlapExtension();
     AdoMD1 = new SoftwareFX.ChartFX.Olap.Server.AdoMultiDimensionalData();
     AdoMD1.Connect(connStr, mdx);
     Olap1.DataSource = AdoMD1;
     Chart1.Extensions.Add(Olap1);
     //Must set MainClinet to False to use client events
     Chart1.MainClient = false;
     Chart1.HtmlTag    = ".NET";
     Chart1.ToolBar    = true;
 }