Can't create PivotView

[Riccardo Zucchetto]

Hi,

We are using Blazor for an application. Originally it was a WASM project, now it is rendered server-side, but the .Server, .Client and .Shared projects still exists.

We want to use the ASP.NET core PivotView component to connect to a SSAS cube both using table view and chart view. When we use:

<e-displayOption view="Table"></e-displayOption>

or

<e-displayOption view="Chart"></e-displayOption>

it works fine, but when we use

<e-displayOption view="Both"></e-displayOption>

it doesn't render the page properly.

Moreover, it seems that, with any of the tree display options, the filter is not applied correctly, giving an error too. I think this is related to the problem stated before.

It seems that some kind of function is called before the component is rendered.

To further detail our situation, the cshtml page is on the .Server project, the js are in the .Client project, in a wwwroot subfolder, and all the files are read fine, and also the connection with the cube is done correctly, since we can use it. We have this problem only when we want to use the "Both" option in the display option (and when we want to set a filter).

I attach some files:

- Page.cshtml: the page code

- _OLAPLayout.cshtml: the layout code

- error.txt: the generated js error.

- filterError.txt: the generated js error for the filter.

- SituationAfterError.jpg: the situation after the display option error.

Best regards,

Riccardo Zucchetto

Attachment: Files_91cce961.zip

[Sivamathi Natarajan]

Hi Riccardo Zucchetto, 

 

Thanks for contacting Syncfusion support. 

 

We have checked the reported problem at our end. But we are unable to reproduce the problem. Meanwhile, we have prepared a sample for your reference in ASP.Net core. Kindly check the below sample link. 

 

Code Example: 

Index.cshtml 

 

<div class="control-section"> 

    <ejs-pivotview id="pivotview" allowExcelExport="true" allowConditionalFormatting="true" allowPdfExport="true" showToolbar="true" allowCalculatedField="true" showFieldList="true" showGroupingBar="true" width="100%" height="600" toolbar="@(new List<string>() {"New", "Save", "SaveAs", "Rename", "Remove", "Load", 

        "Grid", "Chart", "MDX", "Export", "SubTotal", "GrandTotal", "ConditionalFormatting", "FieldList" })" saveReport="saveReport" loadReport="loadReport" fetchReport="fetchReport" renameReport="renameReport" removeReport="removeReport" newReport="newReport" toolbarRender="beforeToolbarRender"> 

        <e-datasourcesettings catalog="Adventure Works DW 2008 SE" cube="Adventure Works" url="https://bi.syncfusion.com/olap/msmdpump.dll" providerType="SSAS" enableSorting="true"> 

            <e-rows> 

                <e-field name="[Customer].[Customer Geography]" caption="Customer Geography"></e-field> 

            </e-rows> 

            <e-columns> 

                <e-field name="[Date].[Fiscal]" caption="Date Fiscal"></e-field> 

                <e-field name="[Measures]" caption="Measures"></e-field> 

            </e-columns> 

            <e-values> 

                <e-field name="[Measures].[Customer Count]" caption="Customer Count"></e-field> 

                <e-field name="[Measures].[Internet Sales Amount]" caption="Internet Sales Amount"></e-field> 

            </e-values> 

            <e-filtersettings> 

                <e-field name="[Date].[Fiscal]" items="@ViewBag.filterMembers" levelCount=3></e-field> 

            </e-filtersettings> 

        </e-datasourcesettings> 

        <e-gridSettings columnWidth="160"></e-gridSettings> 

        <e-displayOption view="Both"></e-displayOption> 

        <e-chartSettings title="Sales Analysis" load="onChartLoad"></e-chartSettings> 

    </ejs-pivotview> 

</div> 

 

HomeController.cs 

public IActionResult Index() 

        { 

            ViewBag.filterMembers = new string[] { "[Date].[Fiscal].[Fiscal Quarter].&[2002]&[4]", "[Date].[Fiscal].[Fiscal Year].&[2005]" }; 

            return View(); 

        } 

 

Sample Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/EssentialJS2WebApplication22107801689 

 

Please check the below screenshot of displaying both Table and chart view with filtered option in [Date].[Fiscal] dimension. 

 

 

 

If still the problem exists, kindly reproduce the problem in the provided sample and revert us (or) send your sample that replicating the problem.  

 

Regards, 

Sivamathi.

[Riccardo Zucchetto]

Hi Sivamathi,

I attach a project that shows the first error, related to the "Both" option.

It is a Blazor project, not an asp.net core project, with a normal razor page.

One question: on the IIS server with the msmdpump.dll is there any particular setting I need to do in order to make it work?

Thank you,

Riccardo

Attachment: AspNetCoreBlazorSample_9fea857.zip

[Manikandan Murugesan]

Hi Riccardo, 

 

We have prepared sample as per your requirement. 

 

Sample: https://www.syncfusion.com/downloads/support/forum/153093/ze/PivotTable710135869 

 

Kindly refer the following UG document for more details. 

https://blazor.syncfusion.com/documentation/pivot-table/olap/?no-cache=1 

 

Please let us know if you need any further assistance. 

Thanks, 

Manikandan. 

[Riccardo Zucchetto]

Hi Manikandan,

This example uses the Blazor component; please, is it possible to have one working with ASP.NET Core inside a Blazor application, as in the example I send you?

Thank you,

Riccardo

[Sivamathi Natarajan]

Hi Riccardo, 

  

Please find the response below. 

  

S.No	Query	Comments
1.	This example uses the Blazor component; please, is it possible to have one working with ASP.NET Core inside a Blazor application, as in the example I send you?	We have modified the provided sample as you mentioned. But we are unable to reproduce the problem at our end. Please refer the following video and sample.     Video: https://www.syncfusion.com/downloads/support/forum/153092/ze/SCREEN~1377972827     Sample:   https://www.syncfusion.com/downloads/support/forum/153092/ze/AspNetCoreBlazorSample1976676201     Kindly reproduce the issue in the above sample and revert us or send us your applicable to us. This would be helpful for us to proceed further.
2.	One question: on the IIS server with the msmdpump.dll is there any particular setting I need to do in order to make it work?	Kindly refer below link to configure the msmdpump.dll.     https://docs.microsoft.com/en-us/analysis-services/instances/configure-http-access-to-analysis-services-on-iis-8-0

  

  

Please let us know if you need any further assistance. 

  

Regards, 

Sivamathi. 

[Riccardo Zucchetto]

Hi Sivamathi,

I managed to reproduce the problem while connecting to your cube.

The component works fine only when rows, columns and values (at least) are specified directly in the code.

It does not work when I do not specify anything on rows, columns and values or I set fields on one or two of the fields (so rows and columns, rows only, values only, etc) in the code.

Consider that, in my case, I will connect to the cube without any measure or dimension pre-set.

I attach the modified example and a video.

I think this issue may affect also the blazor component.

Thank you,

Riccardo

Attachment: Example_485c9667.zip

[Sivamathi Natarajan]

Hi Riccardo, 

 

Thanks for the sample. 

 

We can reproduce the issue at our end. So, we consider it as a bug and logged a defect report in our data base. The fix will be available in a weekly patch release which is estimated to be rolled out at the last week of this month (April). Kindly track the task in the following link. 

 

https://www.syncfusion.com/feedback/13378 

We appreciate your patience until then. 

Regards,
Sivamathi. 

[Riccardo Zucchetto]

Hi Sivamathi,

Thank you very much.

I have seen that the bug report refers only to the Blazor version; will it be fixed also in the EJ2 - ASP.NET Core version?

Thank you again,

Riccardo

[Sivamathi Natarajan]

Hi Riccardo Zucchetto, 

 

Yes, we consider both the platforms. 

 

Regards, 

Sivamathi. 

[Riccardo Zucchetto]

Hi Sivamathi,

Perfect, thank you very much again!

Riccardo

[Sivamathi Natarajan]

Hi Riccardo Zucchetto, 

 

Thanks for the reply. And we appreciate your patience until then. 

 

Regards, 

Sivamathi. 

[Sivamathi Natarajan]

Hi Riccardo, 

Thanks for the patience.  

 

The reported issue has been fixed in the weekly release (v18.1.0.46) and it is available in nuget.org (https://www.nuget.org/). So, kindly use the updated version. 

 

Regards, 

Sivamathi.