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.
I didn't notice that you're using igPivotView so I send you code snippet for igPivotGrid. Try with this code:
$($("#pivotView").igPivotView("pivotGrid").grid().element).igGridResizing("resize", 1, "60px");
Best regards,Martin PavlovInfragistics, Inc.
Hi Martin,
I did try your script, but I have this error message:
Error: cannot call methods on igGridResizing prior to initialization; attempted to call method 'resize'
I attach my code for you, I am sure that I'm doing this wrong.
Hello Joan,The correct configuration is:$("#pivotView").igPivotView({ pivotGridOptions: { gridOptions: { features: [ { name: "Resizing", allowDoubleClickToResize: true } ] } }});
I'm attaching a working sample.
Hi Martin, I did try your file, and this works fine. however, in your same file I comment your script and copy and past bellow, then I've change the params for my cube, and this crash! my data don't display, so I decided try use the igPivotGrid, then I check an example in fiddle and I colaborate to implement the resizing columns and this works! http://jsfiddle.net/joankent/goagv0zh/ but when I try use the same script to implement my cube the same thing happens, the data doesn't display, I attach the scripts files for you can check this. you think that I have something wrong in my cube? What can it be?
Thanks.
Regards.
I don't see a problem where the data doesn't display. What I see is that the resizing of the column does not happen, because the data source is remote and the data fetch is asynchronous so the API call should be delayed until after the data is rendered in the grid. I modified your fiddle to use the igPivotGrid.pivotGridRendered event and call the API there.
Here is the result: http://jsfiddle.net/goagv0zh/1/