Drillthrough on working on Blazor Server Project OLAP

[Garrett]

Hi,

I'm not able to drillthrough to the detail data using the Pivot Table control on my Blazor Server application when using the OLAP connection.

Adding and adjusting measures and dimensions using an OLAP connection indeed works fine, but any time I try to drillthough I get the following error:

 Unhandled exception rendering component: Object reference not set to an instance of an object.

      System.NullReferenceException: Object reference not set to an instance of an object.

         at Syncfusion.Blazor.PivotView.Internal.Drillthrough`1.TriggerDrillThroughEvent(String valueCaption, String aggregateType, Object rawData, AxisSet cellData, DOM element)

         at Syncfusion.Blazor.PivotView.Internal.Drillthrough`1.ExecuteDrillThrough(Int32 rowIndex, Int32 colIndex, DOM element)

         at Syncfusion.Blazor.PivotView.Internal.PivotCell`2.DblClickHandler(Object columnIndex, Object rowIndex)

         at Syncfusion.Blazor.PivotView.Internal.PivotCell`2.<BuildRenderTree>b__22_2()

         at Microsoft.AspNetCore.Components.ComponentBase.CallStateHasChangedOnAsyncCompletion(Task task)

         at Microsoft.AspNetCore.Components.RenderTree.Renderer.GetErrorHandledTask(Task taskToHandle, ComponentState owningComponentState)

Unfortunately the error is quite generic and I'm not sure how to go about figuring out what the issue could be. i know my C# Class for MainDetail is essentially empty but I wasn't sure how that impacted the pivot table at all since it's technically an OLAP data source and I can't define every field in a class.

<div style="display: flex;">

<div id="DashboardLayout1Wrapper">

<SfDashboardLayout ID="DashboardLayout1" CellSpacing="@(new double[]{10 ,10 })" AllowResizing="true" CellAspectRatio="2" Columns="5" ShowGridLines="true">

<DashboardLayoutPanels>

<DashboardLayoutPanel SizeX=2 SizeY=3>

<ContentTemplate>

<SfPivotView TValue="MainDetail" ID="PivotView1" @ref="PivotView1" ShowToolbar="true" Toolbar="@toolbar" AllowDrillThrough="true">

<PivotViewEvents TValue="MainDetail" EnginePopulated="_PivotEnginePopulated"></PivotViewEvents>

<PivotViewDataSourceSettings TValue="MainDetail"

 ProviderType="ProviderType.SSAS"

 Catalog="Data Model"

 Cube="Model"

 Url="<link>"

 LocaleIdentifier="1033"

 EnableSorting="true">

</PivotViewDataSourceSettings>

</SfPivotView>

</ContentTemplate>

</DashboardLayoutPanel>

</DashboardLayoutPanels>

</SfDashboardLayout>

</div>

<SfPivotFieldList TValue="MainDetail" ID="PivotFieldList1" @ref="PivotFieldList1" RenderMode="Mode.Fixed">

<PivotFieldListEvents TValue="MainDetail" EnginePopulated="_EnginePopulated"></PivotFieldListEvents>

<PivotFieldListDataSourceSettings TValue="MainDetail"

 ProviderType="ProviderType.SSAS"

 Catalog="Data Model"

 Cube="Model"

 Url="<link>"

 LocaleIdentifier="1033"

 EnableSorting="true">

</PivotFieldListDataSourceSettings>

</SfPivotFieldList>

</div>

@code {

    SfPivotView<MainDetail> PivotView1;

    SfPivotFieldList<MainDetail> PivotFieldList1;

    public List<Syncfusion.Blazor.PivotView.ToolbarItems> toolbar = new List<Syncfusion.Blazor.PivotView.ToolbarItems> {

        Syncfusion.Blazor.PivotView.ToolbarItems.Grid,

        Syncfusion.Blazor.PivotView.ToolbarItems.Chart,

        Syncfusion.Blazor.PivotView.ToolbarItems.Export,

        Syncfusion.Blazor.PivotView.ToolbarItems.SubTotal,

        Syncfusion.Blazor.PivotView.ToolbarItems.GrandTotal,

        Syncfusion.Blazor.PivotView.ToolbarItems.ConditionalFormatting,

        Syncfusion.Blazor.PivotView.ToolbarItems.FieldList

    };

public class MainDetail

{

public int In_Stock { get; set; }

}

public void _PivotEnginePopulated(EnginePopulatedEventArgs args)

{

this.PivotFieldList1.UpdateAsync(this.PivotView1);

}

public void _EnginePopulated(EnginePopulatedEventArgs args)

{

this.PivotFieldList1.UpdateViewAsync(this.PivotView1);

}

}

Any help you can provide is appreciated.

[Manikandan Murugesan]

Hi Garrett,

We can be able to reproduce the problem at our end. We have considered this as a bug “Exception occurred while using drillthrough with OLAP data source” and logged a defect report in our database. And the fix will be available in our first weekly patch release after 2022 Volume 2 main release which is estimated to be rolled out at the mid of July 2022. You can track the same by using below link. 

https://www.syncfusion.com/feedback/35572/exception-occurred-while-using-drillthrough-with-olap-data-source

Please let us know if you have any concerns. 

Regards,

Manikandan

[AngelinFaithSheeba PaulvannanRajadurai]

Hi Garrett,

The reported issue has been resolved, and we are now testing with other feature combinations. However, this fix will be available in our upcoming weekly release which is estimated to be rolled out at July 19, 2022.

Please let us know if you have any concerns.

Regards,

Angelin Faith Sheeba.

[AngelinFaithSheeba PaulvannanRajadurai]

Hi Garrett,

We are glad to announce that our Essential Studio weekly release V20.2.39 is rolled out and fix for the issue “Exception occurred while using drillthrough with OLAP data source” has been included in this release. Please refer to the following sample.

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/ServerApp-1244802482

We thank you for your support and appreciate your patience in waiting for this release. Please contact us if you require any further assistance.

Regards,

Angelin Faith Sheeba.