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
Hello Marco,
I have not been able to reproduce this issue using the dataSource from the original sample. After selecting a value in the first dropdown the next gets populated and so on , in fact they are working like cascading dropdowns.
Please let me know if you are using a different dataSource and if you are experiencing the same issue if measures are defined in advance like //measures: "[Measures].[QTA SU],[Measures].[FAT NETTO]"
Hi Hristo,
using a different dataSource (example: local Adventure Works cube) i have the same results : Measures combo is empty.
Setting Cube name directly on the html page the browser seems to freeze showing a circular cursor without results.
I am glad you have managed to resolve your issue. Please let me know if you have any further questions on the issue.
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 ?
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.