Use PivotTable for SSAS without TValue

[Riccardo Zucchetto]

Hi,

I have seen that the Blazor PivotView supports the connection to SSAS.

However, it always requires a TValue to work.

Is there a way to not explicit a TValue, since I don't need it? The cube is very big and the end user may use any kind of dimension and measure in it, so I cannot know the fields of an hypotetical TValue while developing.

Otherwise, is it possible to specify a "fake" class that is not the real TValue, but it lets me to use the cube?

Thank you,

Riccardo

[Sivamathi Natarajan]

Hi Riccardo Zucchetto, 

 

Thanks for contacting Syncfusion support. 

 

We have provided generic type support to component property. So we should mention TValue in the component tag. But for OLAP data source, no need to create the exact class to replicate the cube properties. And the component can be worked with the TValue mentioned with single class. So, we suggest you to do the same. 

 

Regards, 

Sivamathi. 

[Riccardo Zucchetto]

Hi Sivamathi,

I tried using a dummy class, but I get the error attached when I open the page. The pivot grid doesn't show up at all. I have copied and pasted the code in this page (changing only the class name):
https://blazor.syncfusion.com/demos/pivot-table/olap?theme=bootstrap4

Do I need more settings in other files? Or is there something missing? Because I followed the getting started tutorial and I have something right.

Thank you,

Riccardo Zucchetto

Attachment: Error_69cb849.zip

[Riccardo Zucchetto]

Hi,

When I don't get the error I get in my previous answer (which I please you to check), I get another error, the same I get in this other thread:

https://www.syncfusion.com/forums/153092/cant-create-pivotview

I attach an example of a full blazor app, showing that error (in the homepage there should be a pivot view, instead in the console I get "Uncaught TypeError: Cannot read property 'style' of null" error).

I am quite sure it is something related to the site settings, in fact I don't get the error when I connect to your URL and cube, but I get it when I connect to other sources.

My project is not configured to https, and neither IIS; but from WPF I can correctly access the remote cube without https.

Thank you,

Riccardo

Attachment: PivotView_fb3d4637.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,

The example only works when I connect to https:/bi.syncfusion.com/olap/msmdpump.dll.

If I try to connect to any other cube (which is correctly accessible) I get the error "Uncaught TypeError: Cannot read property 'style' of null".

Moreover, I cannot get any other error detail in any console (Visual Studio or browser), just the one above.

I attach the project. I am using a cube publicly accessible, since the one I use cannot be reached by you because of a VPN.

Thank you,

Riccardo

Attachment: PivotTable_41c94127.zip

[Sivamathi Natarajan]

Hi Riccardo, 

 

Thanks for the sample. 

 

We have checked the sample where the mentioned members to filter aren’t available in the bound cube. This is the root cause of the reported problem. 

 

Codes you have used to filter, 

 

[index.razor] 

 

<PivotViewFilterSettings> 

    <PivotViewFilterSetting Name="[Date].[Fiscal]" Items="@Items" LevelCount="3"></PivotViewFilterSetting> 

</PivotViewFilterSettings> 

 

 

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

 

 

 

But the available members are, 

 

 

 

So, kindly mention only the available members to filter to solve the issue. 

 

Meanwhile, we made the provided sample runnable which is available in below link. 

 

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/7z/PivotTable863189771  

 

Regards, 

Sivamathi. 

[Riccardo Zucchetto]

Hi Sivamathi,

Yes, that was the problem, thank you.

In any case, when I do not set any measure or dimension explicitly, it does not work. I need to specify rows, columns and values to see anything; in my case, I will not explicitly set anything, since the user will be able to start from an empty cube to create his own reports.

I attach the example.

Riccardo

Attachment: PivotTable_60e12482.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 for your patience and your help!

I will wait for the bugfix.

Thank you,

Riccardo

[Sivamathi Natarajan]

Hi Riccardo, 

  

Thanks for response. And we appreciate your patience untill 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. 

[Riccardo Zucchetto]

Hi Sivamathi,

I have downloaded and installed the new version and now I can use the PivotTable correctly.

However, there is still one issue: if I have both views (chart and table) enabled, at the opening the charts appears above the table. When I put anything on the axis, it correctly disappears.

I have already commented the feedback ticket with a project reproducing the issue; however, I attach the sample also to this thread.

Moreover, in the same project, you can see that the LocaleIdentifier parameter is not used, since every call to the remote OLAP endpoint has 1033 as LocaleIdentifier parameter. I have opened a different feedback for this issue.

Having this two bugs fixed is very important for us since the PivotTable needs to be localized and needs to be opened correctly. In any case, your component is very powerful and we really want to use it, because it has a lot of stunning functionalities.

Kind regards,

Riccardo

Attachment: PivotView_6d8e23c2.zip

[Sivamathi Natarajan]

Hi Riccardo, 

Please find our response. 

Query	Response
if I have both views (chart and table) enabled, at the opening the charts appears above the table. When I put anything on the axis, it correctly disappears.	We are unable to reproduce the issue in the provided sample. Please check the below video for your reference.  Video Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/Blazor_Olap_toolbar1-1907873423    So, kindly provide us the exact replication steps to reproduce the same?  Also, check the following,  We suspect that the reported problem may be occurred due to the existing browser cache which will override the styles. So, can you clear the browser cache then check the same.  To clear the browser cache click, Ctrl+F5 which will refresh the page.  (Or)  Run the sample in “incognito” mode.  If the above things won’t fix the problem then provide us below information,  Operating system. Machine resolution. Browser and its version. Browser resolution (zoom). The above information would be helpful for us to proceed further.
Moreover, in the same project, you can see that the LocaleIdentifier parameter is not used, since every call to the remote OLAP endpoint has 1033 as LocaleIdentifier parameter.	We consider this as a bug and we have logged a defect report in our data base. And the fix will be available in upcoming service pack release which is estimated to be rolled out by the mid of May, 2020.  Meanwhile, you can set the locale identifier in connection string as well.    Code example:  [PivotTableOlap.razor]    Url="https://bi.syncfusion.com/olap/msmdpump.dll;locale=1036"    Until then kindly use the above option to meet your requirement.
Having this two bugs fixed is very important for us since the PivotTable needs to be localized and needs to be opened correctly. In any case, your component is very powerful and we really want to use it, because it has a lot of stunning functionalities.	Thanks for the words and we surely provide the fix in the promised timeline.  Also, few issues (reported in your other forums, portals) couldn’t be reproduced at our end. So, we asked few information in that. So, provide those information which would be helpful for us to proceed further.

Regards,
Sivamathi. 

[Riccardo Zucchetto]

Hi Sivamathi,

The workaround for the LocaleIdentifier is working well; as for the chart problem, in order to avoid duplicated threads, I will just follow this thread:

https://www.syncfusion.com/forums/153746/button-and-save-issues

You can close this one.

Thank you for all your support!

Riccardo

[Sastha Prathap Selvamoorthy]

Hi Riccardo Zucchetto, 

 

Thank you for your response. Please let us know if you need any further assistance. 

 

Regards, 

Sastha Prathap S.