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
I am glad you have managed to resolve your issue. Please let me know if you have any further questions on the issue.
Hi Hristo,
moving IgniteUI samples under IIS it works fine.
I can access SSAS Cubes from IE, Chrome, Firefox from a different Pc than the SSAS Server.
Hello,
Thank you for the information. This is strange.
Are you sure that http://ftrprw-ftk/olap/msmdpump.dll is accessible ?
Also IE is known to experience issues when loading references from the CDN. Please test if the sample behaves the same way if IgniteUI references are loaded from the CDN and when loaded from the local machine.
Also you can test how it will behave if you use another IgniteUI and/or jQuery version.
now we have the following scenario:
PivotGrid works well only using Chrome and 'localhost' in place of the server name.
Previous call:
$(function () { var dataSource = new $.ig.OlapXmlaDataSource({ serverUrl: 'http://ftrprw-ftk/olap/msmdpump.dll' }); Actual call:
$(function () { var dataSource = new $.ig.OlapXmlaDataSource({ serverUrl: 'http://localhost/olap/msmdpump.dll' }); Internet Explorer 11 still does not work, it shows an empty measures combo box without errors.
What do you think ?
Hello Marco,
I am not able to reproduce this behavior. Did you try the dataSourceInitialized event as suggested ?
Attach to the event and use ui.error to see if an error has occured during initialization:
$("#pivotGrid").igPivotGrid({ dataSourceInitialized: function(evt, ui) { console.log(ui.error); }});
This may reveal helpful information.