Hello,
It seems PivotGrid paging has a bug
1. Use JavaScript\olapsamples\sample_2015.sln from downloaded samples
2. add to PagingService.svc in CreateOlapReport
DimensionElement dimensionElementRow1 = new DimensionElement() { Name = "Customer", HierarchyName = "Customer" };
dimensionElementRow1.AddLevel("Gender", "Gender");
olapReport.SeriesElements.Add(dimensionElementRow1);
before
MeasureElements measureElementColumn = new MeasureElements();
3. open PivotGrid Paging sample in browser (azure/pivotgrid/olap/paging)
Empty grid will be shown
---------
It seems it because olapReport has 2 series element with same Name or HierarchyName
Using Sql Trace we found some problem in generated query ( query generated from samples will be different but we assume problem is same)
..
[4d3bfd6d-d89a-487a-b5a9-348689f2db58] as SUBSET({ NONEMPTY( VISUALTOTALS( ({{({ [Rated Driver].[Age].[Age].CHILDREN })}}) ) VISUALTOTALS( ({{({ [Rated Driver].[Sex].[Sex] })}})
...
Run query on analysis services
and get error 'Query (3, 393) The CHILDREN function expects a member expression for the 1 argument. A level expression was used.'
[Rated Driver].[Age].[Age] , it seems [Age] is generated twice
Sorry for bad english
