DevExtreme Pivot Grid - Load local cube

0
0

Hi!

I have the following code in Windows Forms to load a local cube:

PivotGridControl1.OLAPDataProvider = OLAPDataProvider.Adomd
PivotGridControl1.OLAPConnectionString = “provider=MSOLAP.8;data source=C:\Test\Cube.cub;initial catalog=Test;cube name=Cube Test”
PivotGridControl1.RestoreLayoutFromXml(“C:\Test\Layout.xml”, PivotGridOptionsLayout.FullLayout)

The code is working fine, but I’m not able to convert it for use in Wisej. May you help me, please?

Thank you so much,

Ulisses.

General
Share
  • You must to post comments
Filter
Sort by: Recently Active
0
0

Hi Ulisses,

I’m attaching a small sample that demonstrates using the dxPivotGrid with an OLAP data source.

There are differences between the WinForms version and the Wisej version since the Wisej version of the control is based on the HTML5 JS DevExtreme control set.

You can find information on the dxPivotGrid XmlaStore configuration here: https://js.devexpress.com/Documentation/ApiReference/Data_Layer/XmlaStore/Configuration.

Note, when specifying the URL of the OLAP server, it should include the MSMDPUMP.dll url: “This should be the MSMDPUMP.dll URL and usually has the following format: http://<servername>/OLAP/msmdpump.dll.”

HTH,

Levie

Attachment
Wisej.DxPivotGridSample.zip
  • Ulisses
    Thanks for your help, Levie! Unfortunately I need to open a local cube (.cub file) and I think the DevExtreme Pivot Grid doesn’t have this feature (Adomd provider). I got it using AspNetWrapper. Thanks again!
  • You must to post comments
Showing 1 result
Your Answer

Please first to submit.