devexpress-examples / how-to-bind-pivot-grid-to-olap-in-net6

This example demonstrates how to bind Pivot Grid to an MS OLAP cube.

Pivot Grid for WPF - Bind the Pivot Grid to an OLAP Cube

This example demonstrates how to bind the Pivot Grid to an MS OLAP cube.

Files to Look at

• MainWindow.xaml (VB: MainWindow.xaml)
• MainWindow.xaml.cs (VB: MainWindow.xaml.vb)

Example Overview

1. Create a data connection. For this, specify the OlapConnectionString property.
2. Create Pivot Grid fields and bind them to data. For this, use DataSourceColumnBinding.
3. Add the created fields to the PivotGridControl.Fields collection.

Documentation

• OLAP Mode

More Examples

• WPF Pivot Grid - Getting Started - Bind a Pivot Grid to an OLAP Cube