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.
there is a way to debug/trace OlapXmlaDataSource calls ? It seems to stop querying olap/msmdpump.dll after Cube selection.
PivotGrid is certified to run with SQLServer 2014 ?
I am also using 2140 and IE11 and did not experience any issue. However I noticed a slight delay until the measures dropdown is populated with items. Maybe you can see if this is the case with you. IF issue still persists please feel free to send us a sample for investigation.
i attach two video to show you my issue:
var dataSource = new $.ig.OlapXmlaDataSource({ serverUrl: 'http://ftrprw-ftk/olap/msmdpump.dll'//catalog: 'AdventureWorks2014',//cube: 'Adventure Works'
var dataSource = new $.ig.OlapXmlaDataSource({serverUrl: 'http://ftrprw-ftk/olap/msmdpump.dll',catalog: 'AdventureWorks2014',cube: 'Adventure Works'
Unfortunately I am not able to access a dataSource at the specified serverURL. This makes it impossible for me to investigate. To help determine the nature of the issue, please spscify if such issues occurs using
serverUrl: 'http://sampledata.infragistics.com/olap/msmdpump.dll'
It would be also appreciated if you could provide a working url for your datasource to enable me investigate this. 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.
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.