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 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.
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.
there is a way to trace/debug traffic between OlapXmlaDataSource and my SSAS services ?
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.