We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Possible bug in PivotGrid Paging

Thread ID:





121914 Feb 8,2016 01:35 PM UTC Feb 9,2016 09:16 AM UTC JavaScript 1
Tags: ejPivotGrid
Asked On February 8, 2016 01:35 PM UTC


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");

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

Ramesh Govindaraj [Syncfusion]
Replied On February 9, 2016 09:16 AM UTC

Hi Olegl,

Thank you for contacting Syncfusion support.

We have created an incident to log a issue report on behalf of you. Our support engineer will assist you through incident. We request you to follow with the incident for further details.


Ramesh G.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon