i want to query different data sources to solve permission issues.
so i use mdx(ms sqls erver)to query data source,how to binding the data source to pivotgrid ?
Hello,
In this case you should use igOlapXmlaDataSource. Here you can find more information: http://help.infragistics.com/Help/Doc/jQuery/2013.2/CLR4.0/html/igOlapXmlaDataSource_Overview.html
And this is an online sample: http://igniteui.com/pivot-grid/binding-to-xmla-data-source
Please let me know if you have any questions.
I'm just checking if you have other questions regarding the matter.
thank u for your answer.
my data source use .net:
string conn = @"Provider=MSOLAP.4;User ID=test;Password=123456;Initial Catalog=多维数据分析;Data Source=192.168.3.68"; string cmd = @"SELECT {[Measures].[销售金额]} ON Columns, ({[时间].[销售日期].Members}, {[产品].[产品名称].Members}) ON Rows FROM [美好食品]";
using (AdomdConnection aconn = new AdomdConnection(conn)) { aconn.Open(); AdomdCommand acmd = new AdomdCommand(cmd, aconn); var obj = acmd.ExecuteXmlReader(); using (FileStream fs = File.Open(path, FileMode.OpenOrCreate, FileAccess.Write)) { string content = obj.ReadOuterXml(); fs.Write(Encoding.UTF8.GetBytes(content), 0, content.Length); } }
i want to this data source to binding the pivotgrid.
I am just checking if you need further assistance on this matter.