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.