How to: Bind a PivotGrid to an OLAP Cube with the OLE DB Data Provider

  • 2 minutes to read

The following example demonstrates how to bind a PivotGridControl to an MS OLAP cube.

For this, it is required to set the PivotGridControl.OlapConnectionString property value, and add the necessary fields to the PivotGridControl.Fields collection.

<Window xmlns:dxpg="" 
        Title="MainWindow" Loaded="Window_Loaded"
        Height="350" Width="525">
        <dxpg:PivotGridControl HorizontalAlignment="Left" VerticalAlignment="Top" 
                               Name="pivotGridControl1" />