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.