devexpress-examples/winforms-pivotgrid-bind-to-an-olap-cube-via-xmla

This example demonstrates how to add connection settings to the Adventure Works cube on the OLAP server.

Pivot Grid for WinForms - Bind to an OLAP Cube with the XMLA Data Provider

This example demonstrates how to add connection settings to the Adventure Works cube on the OLAP server.

To bind the Pivot Grid control to an OLAP cube, follow the steps below.

1. Set the PivotGridControl.OLAPDataProvider property to Xmla.
2. Specify connection settings in the PivotGridControl.OLAPConnectionString property. The following connection string is used in this example:

   OLAPConnectionString = Data Source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll;" +
               "Initial Catalog=Adventure Works DW Standard Edition;Cube Name=Adventure Works";
   

   Note that a valid connection string should include the following parameters: Provider, Data Source, Initial Catalog, and Cube Name.

Files to Review

• Form1.cs (VB: Form1.vb)

Documentation

• OLAP Mode
• Binding to Data

More Examples

• Pivot Grid for WinForms - How to Connect the Pivot Grid to an OLAP Data Source
• Pivot Grid for WinForms - Bind to an OLAP Cube with the ADOMD.NET Data Provider
• WPF Pivot Grid - Bind a PivotGrid to an OLAP Cube (.NET 6.0)
• ASP.NET Pivot Grid - Bind a Pivot Grid to an OLAP Cube at Design Time