Hi all,
i am trying to use IgniteUI Pivot Grid trial version with my SSAS Cube (SQL Server 2014 BI edition).
I made the following updates to your 'binding-to-xmla-data-source' sample page:
$(function () {var dataSource = new $.ig.OlapXmlaDataSource({serverUrl: 'http://ftrprw-ftk/olap/msmdpump.dll'//catalog: 'Corso',//cube: 'FBI'//rows: "[DimClienti].[COD CAN]",//columns: "[Tempo].[ANNO]",//measures: "[Measures].[QTA SU],[Measures].[FAT NETTO]"});
var promise = dataSource.initialize();promise.fail(function(error) {console.log(error);alert(error);});
promise.done(function(rootMetadataitem) {});
I load the page using IE, it populates Catalog and Cube fields but no rows under MeasureGroup combo.
Have you any ideas ?
Thanks
Marco
Hi,
after modify security privacy in internet options (accept all cookies) we get the error in the attached file.
We are using the following configuration:
$(function () { var dataSource = new $.ig.OlapXmlaDataSource({ serverUrl: 'http://ftrprw-ftk/olap/msmdpump.dll' });
The error is generated after Cube selection.
Tnx
Hello,
You can try to handle the dataSourceInitialized event of the igPivotGrid and dig into ui.dataSource. From ui.dataSource you will be able to get the cube, the measures, and so on. If something has failed then these will return nulls. I hope this helps
Hi Hristo,
there is a way to trace/debug traffic between OlapXmlaDataSource and my SSAS services ?
Hello Marco,
The online session are an option if all other options to help did not work out. Considering this it will be highly appreciated if you could prepare some junk data to reproduce the issue with and not expose your original ds. However, since all is working fine with 'http://sampledata.infragistics.com/olap/msmdpump.dll' then I believe issue lies in your ds and I cannot assume what this issue is without investigating it.
Looking forward to hearing from you.
it's not possible for me to expose my server on internet.
If you want i can organize a TeamViewer session.