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.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Possible bug in PivotGrid Paging

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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


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.
 
https://www.syncfusion.com/account/login?ReturnUrl=/support/directtrac/incidents

Regards,

Ramesh G.


CONFIRMATION

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.

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

;