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,
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.
Hi Hristo,
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'
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.
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 ?
HI Hristo,
i have the following versions:
IgniteUI version: igniteui.14.2.20142.2140 (using your original Xmla page, connected to your Olap server, all works fine)
Internet Explorer 11
SQL Server 2014