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.

Possible bug in PivotGrid Paging

Thread ID:

Created:

Updated:

Platform:

Replies:

121914 Feb 8,2016 08:35 AM Feb 9,2016 04:16 AM JavaScript 1
loading
Tags: ejPivotGrid
olegl
Asked On February 8, 2016 08:35 AM

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 04:16 AM

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.

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.

;