Lesson 2 - Bind a Pivot Grid to an OLAP Cube

• May 14, 2024
• 3 minutes to read

A cube is a multidimensional structure defined by its measures and dimensions. You can think of a measure as a data field in PivotGridControl, while a dimension can be represented by a column field or a row field. This tutorial will help you learn how to bind a pivot grid to an existing OLAP (OnLine Analytical Processing) cube. In this example, we will use the Adventure Works cube.

Note

This tutorial is based on the .NET Framework. For the .NET tutorial, refer to the following topic: Bind a Pivot Grid to an OLAP Cube (.NET)

Documentation: Migrate WPF Applications to .NET

To display data from an OLAP cube, do the following.

Specify a connection string to an OLAP cube.

1. Run MS Visual Studio. Create a new WPF Application project and add PivotGridControl as you did in Lesson 1.

2. Click the smart tag icon ( ) displayed at the top-right of the pivot grid to invoke the Pivot Grid Control Tasks popup window.

3. In the invoked wizard, select OLAP Cube technology and click Next.

4. Select the ADOMD.NET as a data provider and click Next.

5. In the next window, select the MSOLAP provider and specify the Server Name as https://demos.devexpress.com/Services/OLAP/msmdpump.dll. Then, click the Retrieve Schema button.

Create Fields

1. Click the pivot grid’s smart tag and use the Add Data Area Field menu item to add a new field to the Data Header Area. In a similar manner, add two fields both to the Column Header and Row Header areas.

2. To associate created fields with OLAP measures/dimensions, click the field’s smart tag icon. In the invoked menu, click the FieldName property ellipsis button to see existing data source fields.

Result

Run the project and see the result.

See Also

Tutorial: Printing and Exporting a Pivot Grid

Lesson 2 - Bind a Pivot Grid to an OLAP Cube (.NET)