Drilldown on BLANK() Values in OLAP Data Source Throws Error

Hi,

When I use the Drilldown (expand/collapse) on an OLAP data source on the Pivot Table control where at least one of the rows is an empty string in the dimension, trying to expand the dimension with an empty string as a name throws a javascript error. The error is " Uncaught TypeError: can't access property "toString", B[((m * r) + S)] is undefined "

In Excel, this would normally just result in the row being expanded appropriately (even if the data isn't necessarily meaningful), but in ASP.net Core, this results in a hard crash that makes the pivot table unusable until I refresh the entire page.

Can someone verify that this is a bug or if I'm doing something wrong on my end?

The code I am using is pretty basic:

<ejs-pivotview id="PivotView1" height="600px" showGroupingBar="true" showFieldList="true">

        <e-datasourcesettings catalog="<removed>" cube="Model" url="<removed>" providerType="SSAS" enableSorting="false">

        </e-datasourcesettings>

    </ejs-pivotview>



1 Reply

AP AngelinFaithSheeba PaulvannanRajadurai Syncfusion Team July 27, 2022 03:01 PM UTC

Hi Garrett,


We are unable to reproduce the reported problem at our end. If the problem persists, please share your cube with garbage values or share the sample along with the cube that replicates the reported problem. This would allow us to investigate the reported problem at our end and provide a solution as soon as possible. 


Regards,

Angelin Faith Sheeba


Loader.
Up arrow icon