1. Home
  2. Forum
  3. ASP.NET Core - EJ 2
  4. Can't create PivotView

Can't create PivotView

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

12 Replies
SN Sivamathi Natarajan Syncfusion Team April 8, 2020 09:16 AM UTC

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(); 
        } 
 
 
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.

RZ Riccardo Zucchetto April 8, 2020 03:23 PM UTC

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

MM Manikandan Murugesan Syncfusion Team April 9, 2020 10:27 AM UTC

Hi Riccardo, 
 
We have prepared sample as per your requirement. 
 
 
Kindly refer the following UG document for more details. 
 
Please let us know if you need any further assistance. 

Thanks, 
Manikandan. 


RZ Riccardo Zucchetto April 9, 2020 12:32 PM UTC

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

SN Sivamathi Natarajan Syncfusion Team April 10, 2020 11:46 AM UTC

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. 
  
  
Sample:  
  
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. 
  
  
  
Please let us know if you need any further assistance. 
  
Regards, 
Sivamathi. 


RZ Riccardo Zucchetto April 10, 2020 12:23 PM UTC

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

SN Sivamathi Natarajan Syncfusion Team April 13, 2020 10:01 AM UTC

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. 
 
We appreciate your patience until then. 
Regards,
Sivamathi. 


RZ Riccardo Zucchetto April 14, 2020 06:59 AM UTC

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

SN Sivamathi Natarajan Syncfusion Team April 15, 2020 12:34 PM UTC

Hi Riccardo Zucchetto, 
 
Yes, we consider both the platforms. 
 
Regards, 
Sivamathi. 


RZ Riccardo Zucchetto April 15, 2020 12:36 PM UTC

Hi Sivamathi,
Perfect, thank you very much again!

Riccardo

SN Sivamathi Natarajan Syncfusion Team April 16, 2020 05:08 AM UTC

Hi Riccardo Zucchetto, 
 
Thanks for the reply. And we appreciate your patience until then. 
 
Regards, 
Sivamathi. 


SN Sivamathi Natarajan Syncfusion Team April 29, 2020 06:11 AM UTC

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. 


Loader.
Up arrow icon