how can connect to sql server the pivot grid view, is this possible?, I'm using php connection :)
Thanks
J.
Hello Joan,
If you have only SQL Server (and not SQL Server Analysis Services) then your option is to serialize the data in JSON using PHP and then feed the igPivotView. Here is a sample that demonstrates this scenario: http://www.igniteui.com/pivot-grid/binding-to-flat-data-source.
If you have SQL Server Analysis Services instance you can configure msmdpump.dll for http access. Then wire up the igPivotView to use the msmdpump.dll as demonstrated in this sample: http://www.igniteui.com/pivot-grid/binding-to-xmla-data-source.
Hope this helps,Martin PavlovInfragistics, Inc.
Thank you Martin, following step by step the documentation, I have set the configuration for the msmdpump.dll, but I try load the file index.html by browser and this shows this message:
uncaught exception: Exception occurred during task execution
and this doesn't work :(
my script is as follow:
$.support.cors = true;
$(function () { $("#pivotView").igPivotView({ dataSourceOptions: { xmlaOptions: { serverUrl: 'http://pbip.paradigma.com/OLAP/msmdpump.dll', catalog: 'PBI_0000_AS', cube: 'PMM Cube' } } }); });
I use the same script with your cube example then this works!
$(function () {$("#pivotView").igPivotView({dataSourceOptions: { xmlaOptions: { serverUrl: 'http://sampledata.infragistics.com/olap/msmdpump.dll', catalog: 'Adventure Works DW Standard Edition', cube: 'Adventure Works' } }});});
however, if I try connect with Microsoft SQL Server Management Studio by http://pbip.paradigma.com/OLAP/msmdpump.dll this works fine, and I can browsing it!
can you help me please?
regards.