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.
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 ?
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,
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
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.
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.
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 ?